1註冊驅動,根據不同的數據庫註冊不同的驅動。
class . forname(" Oracle . JDBC . driver . Oracle driver ");//oracle數據庫
//(mysql數據庫)class . forname(" com . MySQL . JDBC . driver ");
new Oracle . JDBC . driver . Oracle driver();
2通過驅動器管理器獲得連接:
connection conn = driver manager . get connection(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通過連接生成壹個語句對象。
statement stmt = conn . create statement();
//prepared statement pstmt = conn . prepare statement(SQL);
傳遞語句對象並返回結果。
string SQL = " select * from e table 2 where id = 2或id = 3 ";
ResultSet RS = stmt . execute query(SQL);
//ResultSet RS = prepare stmt . execute query();
//int n = stmt . execute update(SQL);
while(rs.next()){
string id = RS . getstring(1);
string word = RS . getstring(2);
......
//這裏的id和word就是妳想要的結果。
}
5發布資源
RS . close();
stmt . close();
conn . close();