1、加载驱动
Class.forName(“com.mysql.jdbc.Driver”);
2、创建连接
Connection cnn=DriverManager.getConnection(url,user,password);
3、预编译sql命令
connection.setAutoCommit(false);
PrepareStatement ps=conn.prepareStatement(sql);
4、执行命令
//查询
ResultSet rs=ps.excuteQuery();
while (rs.next()) {
……
}
connection.commit();
5、关闭连接
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
log.error(e.getMessage(), e);
}
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
log.error(e.getMessage(), e);
}
}
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
log.error(e.getMessage(), e);
}
}
}
常用的JDBC驱动名称和数据库URL
RDBMS | JDBC驱动程序名称 | URL格式 |
MySQL | com.mysql.jdbc.Driver | jdbc:mysql://hostname/databaseName |
ORACLE | oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:@hostname:portNumber:databaseName |
PostgreSQL | org.postgresql.Driver | jdbc:postgresql://hostname:port/dbname |
DB2 | com.ibm.db2.jdbc.net.DB2Driver | jdbc:db2:hostname:port Number/databaseName |
Sybase | com.sybase.jdbc.SybDriver | jdbc:sybase:Tds:hostname: portNumber/databaseName |