JDBC Java database connection 2) API for JDBC Interface core

API for the JDBC interface core

　Java.sql.* and javax.sql.* (java2.0 later updated extensions)

　　|-Driver Interface : Represents Java driver interface. All of the specific database vendors are going to implement this interface.

|-Connect (URL, properties): a way to connect to a database.

URL: The URL of the connection database

　　　　　　　URL Syntax: jdbc protocol : Database Sub-protocol :// host : Port / database

　　　　　　　　User: Username for database

　　　　　　　　Password: Database user password

　　|-DriverManager class: Driver Manager class for managing all registered drivers

|-registerdriver (Driver): registering a Driver class object

|-connection getconnection (Url,user,password); Get Connection Object

　　|-Connection Interface: represents Java the Connection object for the program and database.

|-Statement createstatement () : Create Statement Object

|-PreparedStatement preparestatement (String sql) creating preparedstatement Objects

|-callablestatement preparecall (String sql) Creating CallableStatement objects

　　|-Statement interface: used to execute a static SQL statement

|-int executeupdate (String sql) : performs a static update of the SQL statement (DDL,DML )

|-ResultSet executeQuery (String sql) : Static query SQL statement executed (DQL)

　　|-preparedstatement Interface (subclass of statement Interface): Used to perform precompilation SQL Statement

|-int executeupdate () : Perform precompiled update SQL statements (DDL,DML )

|-resultset executeQuery () : execute a precompiled query SQL statement (DQL)

　　　　|-callablestatement Interface (subclass of PreparedStatement Interface): SQL statement for execution of stored procedures (callxxx)

|-resultset executeQuery () : methods for calling stored procedures

　　|-resultset interface : Used to encapsulate the data of the query

|-Boolean Next () : Move the cursor to the next line

|-getxx (): Gets the value of the column

JDBC Java database connection 2) API for JDBC Interface core