Getting started with JDBC

The JDBC driver maps Java data type to appropriate JDBC type before interacting with the database. For example a Java string is converted to an SQL CHAR.

The JDBC Type and Java data mapping is as below:-

JDBC 3.0 supports CLOB, BLOB, REF and ARRAY. To manipulate data on server the ResultSet object has updateCLOB(),updateBLOB(),  updateRef() and updateArray() methods.

Date & time Data Types:

The java.sql.Date class matches to SQL DATE type, java.sql.Timestamp and java.sql.Time classes matches to SQL TIMESTAMP and SQL TIME data types.

import java.sql.Date;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.*;

public class SqlDateTime {
 public static void main(String[] args) {
 // date and time
 java.util.Date javaNewDate = new java.util.Date();
 long javaNewTime = javaDate.getTime();
 System.out.println("Current Java date:" + 
 javaNewDate.toString());
 java.sql.Date sqlNewDate = new java.sql.Date(javaTime);
 System.out.println("Current Date from SQL: " + 
 sqlDate.toString());
 }
}

Save the file as JavaDateTime.Java complie and run it

C:\>javac JavaDateTime.Java

C:\>java JavaDateTime

Current Java Date: Tue Mar 3 11:26:42 GMT+04:00 2015

Current Date from SQL: 2015-03-03