JDBC Tutorials - Herong's Tutorial Examples - v3.11, by Dr. Herong Yang
Downloading and Installing JDK on Windows
This section provides a tutorial example on how to download and install JDK 12 on a Windows system.
Downloading and installing JDK on Windows systems is also easy. Here is what I did to download and install JDK 12 on my Windows machine.
To test the installation, open a command window to try the java command. If you are getting the following output, your installation is good:
herong> \progra~1\java\jdk-12.0.1\bin\java -version java version "12.0.1" 2019-04-16 Java(TM) SE Runtime Environment (build 12.0.1+12) Java HotSpot(TM) 64-Bit Server VM (build 12.0.1+12, mixed mode, sharing)
Congratulations, you have successfully installed JDK on your Windows system!
Table of Contents
JDBC (Java Database Connectivity) Introduction
Downloading and Installing JDK
JDK Documentation Installation
►Downloading and Installing JDK on Windows
Adding JDK "bin" Directory to Path Setting
JDK Documentation Installation on Windows
Downloading and Installing JDK on Linux
-cp or -classpath Syntax on Different Systems
Installing and Running Java DB - Derby
Derby (Java DB) JDBC DataSource Objects
Java DB (Derby) - DML Statements
Java DB (Derby) - ResultSet Objects of Queries
Java DB (Derby) - PreparedStatement
MySQL JDBC Driver (MySQL Connector/J)
MySQL - Reference Implementation of JdbcRowSet
MySQL - JBDC CallableStatement
MySQL CLOB (Character Large Object) - TEXT
MySQL BLOB (Binary Large Object) - BLOB
Oracle Express Edition Installation on Windows
Oracle - Reference Implementation of JdbcRowSet
Oracle - JBDC CallableStatement
Oracle CLOB (Character Large Object) - TEXT
Oracle BLOB (Binary Large Object) - BLOB
Microsoft SQL Server Express Edition
Microsoft JDBC Driver for SQL Server
Microsoft JDBC Driver - Query Statements and Result Sets
Microsoft JDBC Driver - DatabaseMetaData Object
Microsoft JDBC Driver - DDL Statements
Microsoft JDBC Driver - DML Statements
SQL Server - PreparedStatement
SQL Server CLOB (Character Large Object) - TEXT
SQL Server BLOB (Binary Large Object) - BLOB
JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver
JDBC-ODBC Bridge Driver - Flat Text Files
JDBC-ODBC Bridge Driver - MS Access
JDBC-ODBC Bridge Driver - MS SQL Server
Summary of JDBC Drivers and Database Servers