1 註冊驅動,根據不同數據庫註冊不同的驅動.
Class.forName("oracle.jdbc.driver.OracleDriver");//oracle數據庫
//(mysql數據庫)Class.forName("com.mysql.jdbc.Driver");
new oracle.jdbc.driver.OracleDriver();
2 通過驅動管理器獲得連接:
Connection conn = DriverManager.getConnection(url,用戶名,密碼)
(oracle)url = "jdbc:oracle:thin:@ip地址:1521:數據庫名(orcl)
jdbc:oracle:thin:@192.168.11.188:1521:orcl
(mysql) jdbc:mysql://127.0.0.1:3306/數據庫名
3 通過連接(Connection)生成語句(Statement)對象
Statement stmt = conn.createStatement();
//PreparedStatement pstmt = conn.prepareStatement(sql);
4 傳遞語句對象,並返回結果
String sql = "select * from e表2 where id = 2 or id = 3";
ResultSet rs = stmt.executeQuery(sql);
//ResultSet rs = prepareStmt.executeQuery();
//int n = stmt.executeUpdate(sql);
while(rs.next()){
String id = rs.getString(1);
String word = rs.getString(2);
......
//這裏邊的id 和word就是妳想要的結果
}
5 釋放資源
rs.close();
stmt.close();
conn.close();