讲义JDBC1.docVIP

讲义JDBC1 Module 1: JDBC Overview JDBC总览 JDBC: Java Database Connectivity ODBC: Open Database Connectivity C - ODBC - Database Java - JDBC - Database SQL: DDL: create table, drop table, DML: select, insert, update, delete type: char, varchar, int, date, time, decimal ------------------------------------------------ java.sql javax.sql API : application program interface GUI : Graphic user interface Application developer : focus: Business logic Driver developer ( which database): API: java.sql.*; javax.sql.*; XXX.jar (classes) MySQL: mysqlXXX.jar Oracle: ojdbcXX.jar ------------------------------------ JDBC API: Interfaces, classes Sun: java.sql.Driver(interface) MySQL: URL : jdbc:mysql://localhost:3306/test userName: root (default) password: Driver name: org.gjt.mm.mysql.Driver (class) or: com.mysql.jdbc.Driver Oracle: URL: jdbc:oracle:thin:@192.168.12.100:1521:ascent //127.0.0.1 or localhost userName: ascent password: ascent Driver name: oracle.jdbc.driver.OracleDriver (class) ------------------------------------------------------------- **************************************** **************************************** Module 2: Using JDBC Creating a Basic JDBC Application 生成JDBC应用的步骤: 1. Registering a driver 注册驱动: (Driver) 2. Establishing a connection to the database建立数据库连接: (DriverManager- Driver- Connection) 3. Creating a statement 生成Statement: (Connection - Statement) 4. Executing a SQL 执行SQL语句: (Statement -ResultSet) 5. Processing the results 处理结果: (ResultSet) 6. Closing down JDBC objects 关闭JDBC对象: (ResultSet, Statement, Connection) 1. Registering a driver 注册驱动 * Using the Class Loader Syntax: Class.forName(driverName); Example例子: Class.forName(org.gjt.mm.mysql.Driver); //MySQL 或者 Class.forName(com.mysql.jdbc.Driver); //MySQL 或者