?? databasecontest.java
字號:
package ch03.section01;
import java.sql.*;
class DataBaseConTest {
public static void main(String argv[]) {
//數(shù)據(jù)庫驅(qū)動程序的名稱
String drivers = "sun.jdbc.odbc.JdbcOdbcDriver";
// Odbc數(shù)據(jù)源url
String url = "jdbc:odbc:sample";
//數(shù)據(jù)庫用戶名
String username = "sa";
//數(shù)據(jù)庫密碼
String password = "sa";
try {
//注冊Odbc數(shù)據(jù)庫驅(qū)動
Class.forName(drivers);
// 連接數(shù)據(jù)庫
Connection con = DriverManager.getConnection(url, username, password);
// 建立數(shù)據(jù)庫statement對象
Statement stmt = con.createStatement();
//sql語句
String sql = "select id,con1,con2 from ch03section01";
// 使用Statement對象調(diào)用executeQuery()方法產(chǎn)生結果集
ResultSet rs = stmt.executeQuery(sql);
//循環(huán)打印數(shù)據(jù)庫中的數(shù)據(jù)
while (rs.next()) {
int id = rs.getInt(1);
String con1 = rs.getString(2);
String con2 = rs.getString(3);
System.out.println("id=" + id);
System.out.println("con1=" + con1);
System.out.println("con2=" + con2);
}
//關閉Statement對象
stmt.close();
//關閉數(shù)據(jù)庫連接
con.close();
}
//try..catch捕獲異常
catch (java.lang.Exception e) {
e.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -