1 裝載數據庫的(de)JDBC驅動程序
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
2 建立與數據庫的(de)連接
Connection con=java.sql.DriverManager.getConnection(JDBC URL,用(yòng)戶名,密碼) ;
3 創建Statement或PrepareStatement對象
Statement stmt = con.createStatement();
PrepareStatement prepStmt =con.prepareStatement(selectStatement);
4 調用(yòng)SQL語句
String sql = “select id,name,title,price from books where=‘Tom’ and price=40”;
ResultSet rs=stmt.executeQuery(sql);
5 訪問ResultSet
while(rs.next())
{
 String col1 = rs.getString(1);
 String col2 = rs.getString(2);
 String col3 = rs.getString(3);
 float col4 = rs.getFloat(4);
}
6 依次關閉ResultSet,Statement,Connection對象
rs.close();
stmt.close();
con.close();