databasecontest.java

java编程百例

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