package ch03.section01;

import java.sql.*;

class DataBaseConTest {

  public static void main(String argv[]) {

    //數據庫驅動程序的名稱
    String drivers = "sun.jdbc.odbc.JdbcOdbcDriver";
    // Odbc數據源url
    String url = "jdbc:odbc:sample";
    //數據庫用戶名
    String username = "sa";
    //數據庫密碼
    String password = "sa";
    try {
      //注冊Odbc數據庫驅動
      Class.forName(drivers);
      // 連接數據庫
      Connection con = DriverManager.getConnection(url, username, password);
      // 建立數據庫statement對象
      Statement stmt = con.createStatement();
      //sql語句
      String sql = "select id,con1,con2 from ch03section01";
      // 使用Statement對象調用executeQuery()方法產生結果集
      ResultSet rs = stmt.executeQuery(sql);
      //循環打印數據庫中的數據
      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();
      //關閉數據庫連接
      con.close();
    }
    //try..catch捕獲異常
    catch (java.lang.Exception e) {
      e.printStackTrace();
    }
  }
}