高清国产av一区二区三区_亚洲欧美日韩在线_无码熟妇人妻av在线影片免费_在线无码一级伊伊_爽好舒服高H自慰软件_亚洲熟女区偷拍区高清区_午夜福利影院啪啪_亚洲国产黄片在线播放_中文字幕日韩精品乐乐影院_久久国产亚洲日韩欧美精品

1 裝載數(shù)據(jù)庫的JDBC驅(qū)動程序
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
2 建立與數(shù)據(jù)庫的連接
Connection con=java.sql.DriverManager.getConnection(JDBC URL,用戶名,密碼) ;
3 創(chuàng)建Statement或PrepareStatement對象
Statement stmt = con.createStatement();
PrepareStatement prepStmt =con.prepareStatement(selectStatement);
4 調(diào)用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 依次關(guān)閉ResultSet,Statement,Connection對象
rs.close();
stmt.close();
con.close();