Herong's Tutorial Examples: JDBC

Ethereum Tutorials - Herong's Tutorial Examples
This book is a collection of tutorial examples on Ethereum and blockchain. Topics include include: What is Ethereum; What is blockchain; Ethereum market value; What is Go Ethereum (Geth); Running a private Ethereum network with Geth; What is Ethereum Mist wallet; What is MetaMask wallet; Ethereum mi... 2022-07-10, 3470👍, 4💬

<< < 1 2 3 4 > Sort: Rank

JDBC-ODBC - Inserting Data Rows to MS Access Database
This section describes how to insert new data rows into MS Access database through the JDBC-ODBC driver. 2017-03-17, 12904👍, 5💬

💬 2016-03-06 Morn: My Testing

💬 2015-08-10 ramya: this website is very useful

Loading JDBC Driver Class - ojdbc16.jar
This section describes how to load the Oracle JDBC driver class - ojdbc14.jar. 2017-03-07, 7953👍, 3💬

💬 2017-03-07 yuguohui: study and work

💬 2016-08-02 Herong: mukesh, Which test code are you running? The test code in this tutorial is just to test how to load the JDBC driver JAR file. Yo...

💬 2016-08-01 mukesh: Do not connect to DB - Error:java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:lis...

JDBC-ODBC - Connecting to a DSN
This section describes how to connect to a DSN (Data Source Name) with JDBC-ODBC Bridge. 2017-02-28, 12830👍, 3💬

💬 2017-02-28 Munna Shaw: My name is Munna Shaw

💬 2016-04-27 Anish Goel: Thanks a lot!

💬 2015-10-08 manoj soni: satisfied

mysqladmin - MySQL Admin Tool
This section describes how to use MySQL admin tool to check server status and other admin tasks. 2017-02-16, 706👍, 2💬

💬 2017-02-16 Herong: Jack, thanks for sharing the information about dbForge Studio.

💬 2017-02-14 Jack: There is also a good mysql admin tool -dbForge Studio for MySQL (https://www.devart.com/dbforge/mysq l/studio/features.html).I l...

Calling createStatement() and executeQuery
This section describes how to run a SELECT query statement with createStatement() and executeQuery(). 2017-02-08, 280👍, 2💬

JDBC-ODBC Bridge Driver - MS Access
This chapter provides tutorial notes on using the JDBC-ODBC Bridge driver with MS Access database. Topics include creating MS Access database file; creating DSN for MS Access database files; inserting rows to and retrieving rows from Access database. 2016-12-22, 11866👍, 11💬

💬 2016-12-22 nhat: need jdbc

💬 2016-12-04 Herong: Sumon, Stay with JDK 7. It has a built-in JDBC=ODBC bridge driver to connect to Access database.

💬 2016-12-03 sumon: To run my access database

💬 2016-05-20 djamo: thenk you

💬 2016-01-11 Mars Chen: thanks for your providing this jar lib

(More comments ...)

MySQL Connector/J - Download and Installation
This section describes how to download and install MySQL Connector/J (JDBC driver). 2016-12-09, 11182👍, 8💬

💬 2016-12-09 esma: HELLO

💬 2016-09-06 Bittan: I am a student.

💬 2016-01-06 Amir: Let Me go

💬 2015-09-23 Herong: Hi Kpl, if you don't have the \local\lib folder, you can create it first. Then copy mysql-connector-java-5.1.36-bin.jar to that ...

💬 2015-09-22 KpL: -------- MySQL JDBC Connection Testing ------------ Where is your MySQL JDBC Driver? java.lang.ClassNotFoundException: com.mysql...

(More comments ...)

Instance Name Better than Port Number
This section describes how SQL Server support JDBC client applications to use instance name instead of port number to connect to a specific instance. 2016-11-26, 1027👍, 1💬

💬 2016-11-26 Bill: Great explanation on. Better than Microsoft website!

"INSERT INTO" Statements
This section describes how to insert data rows with INSERT INTO statements. 2016-11-08, 138👍, 1💬

Loading Driver Class Automatically
This section provides a tutorial program to show how JDK 1.7 and 1.8 automatically loads JDBC driver classes from JAR files specified in the classpath. 2016-10-15, 1237👍, 3💬

💬 2016-10-13 Herong: Matthew, can you try to run the above test program with "javac" and "java" commands in a command window first? Using Eclipse, yo...

💬 2016-10-12 Matthew: my apologies i thought you deleted my comments without responding to them. its hard to find where i put my question

💬 2016-10-12 Matthew: Sorry to be so burdensome, i am running the specified code however i am getting no drivers listed. i moved the sqljdbc42 to the ...

Overview of CallableStatement Objects
This section provides overview information on CallableStatement Objects for stored procedures. 2016-10-05, 319👍, 1💬

💬 2016-10-05 Mohammadali(VIRUS2): Thank you for describing

Closing the Database Connection - con.close()
This section describes how to close database connections. 2016-09-28, 122👍, 1💬

DriverManager.getConnection() and Connection URL
This section describes how to use DriverManager.getConnection() and connection URL for the Microsoft JDBC driver. 2016-09-27, 146👍, 1💬

JDBC (Java Database Connectivity) Introduction
This chapter provides a quick introduction about JDBC (Java Database Connectivity). Topics include overview of JDBC; versions of JDBC; JDBC driver types; database connection with DriverManager and DataSource; JDBC driver class and connection URL for DriverManager. 2016-08-31, 114👍, 1💬

"DROP TABLE" Statements
This section describes how to drop a table in the current database. 2016-07-27, 1247👍, 2💬

💬 2016-07-27 XYZ1: HGTYGHTY

💬 2016-07-27 XYZ: HI HELLO

MySQL - JBDC CallableStatement
This chapter provides tutorial notes on JDBC CallableStatement objects for stored procedures. Topics include CallableStatement overview; creating stored procedures with parameters and multiple result sets; using place holders in CallableStatement objects; register output parameters; retrieving multi... 2016-07-21, 123👍, 1💬

"CREATE PROCEDURE" - Creating a Simple Procedure
This section describes how to create a simple procedure that runs a simple query. 2016-07-20, 146👍, 1💬

deleteRow() - Deleting Rows through ResultSet Objects
This section describes how to delete rows from target tables through ResultSet objects. 2016-07-13, 11870👍, 2💬

💬 2016-07-13 rahul krishna: good work

"CREATE SCHEMA" Statements
This section describes how to create a schema in the current database. 2016-06-08, 102👍, 1💬

Performance of Inserting Rows with a PreparedStatement
This section describes how to measure the performance of inserting rows using a PreparedStatement object. 2016-05-27, 1594👍, 1💬

💬 2016-05-27 TC: MySQL 5.5 engine InnoDB MySQL 5.0 engine MyISAM

JDBC-ODBC - MS Access Database and Driver Info
This section describes how to get some basic info about the Access database and the driver through the JDBC DatabaseMetaData object. 2016-05-20, 1034👍, 1💬

💬 2016-05-20 djamo: thenk

Inserting BLOB Values with setBinaryStream() Method
This section describes how to insert BLOB values with the PreparedStatement.setBinaryStr eam()method. 2016-04-08, 8146👍, 2💬

💬 2016-04-08 Herong: Saqib, you are welcome!

💬 2016-04-06 Saqib Ayub: Just want to thank you so much. You made my day.

SQL Server CLOB (Character Large Object) - TEXT
This chapter provides tutorial notes on CLOB (Character Large Object) data types, TEXT, with SQL Server JDBC Driver. Topics include creating tables to store CLOB values in SQL Server server; inserting CLOB values with direct SQL INSERT statements, or PreparedStatement with setString(), setCharacterS... 2016-04-07, 12312👍, 1💬

💬 2016-04-07 kuchbhi: OK. Thank you................................. .................................... .................................... .............

Create Tables with CLOB Columns
This section describes how to create tables with CLOB (VARCHAR(MAX)) columns in SQL Server server. 2016-03-17, 5503👍, 2💬

💬 2016-03-17 Herong: Hi Maddy, you can read the Retrieving CLOB Values with getString() Method tutorial.

💬 2016-03-15 maddy: how to retrieve data from clob datatype(varchar(MAX)) in sql server 2008.

<< < 1 2 3 4 > Sort: Rank