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();
    }
  }
}