JDBC
Java SE 6.0 includes JDBC 4.0. The specification can be downloaded here:
http://jcp.org/aboutJava/communityprocess/final/jsr221/index.html
Although JDBC supports a wide range of data store types, it is most commonly used for accessing relational databases using SQL. Classes and interfaces are provided to simplify database programming, such as these:
| java.sql.DriverManager and javax.sql.DataSource can be used to obtain a connection to a database system.
|
| java.sql.Connection represents the connection that an application has to a database system.
|
| java.sql.Statement, PreparedStatement, and CallableStatement represent executable statements that can be used to update or query the database.
|
| java.sql.ResultSet represents the values returned from a statement that has queried the database.
|
| Various types such as java.sql.Date and java.sql.Blob are Java representations of SQL data types that do not have a directly equivalent primitive type in Java.
|