jdbctest.java

java 北大青鸟 java 北大青鸟

import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;

/** 这个类演示访问数据库需遵循的各个步骤.
 * @author Ben
 */
class Jdbctest {

  /**
   *  构造方法. 
   */
  protected Jdbctest() {
  }

  /** 这是 main 方法.
   * 它演示访问数据库的各个步骤
   * @param args 被传递至 main 方法的参数
   */
  public static void main( String[] args) {

    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (ClassNotFoundException ce) {
      System.out.println(ce);
    }
    try {
      String url = "jdbc:odbc:test";
      Connection con = DriverManager.getConnection(url,"sa","");
      Statement s = con.createStatement();
      ResultSet rs = s.executeQuery("select * from Friends");
      while (rs.next()) {
        System.out.print(rs.getString(1) + "\t");
        System.out.print(rs.getString(2) + "\t");
        System.out.print(rs.getDate(3)+ "\t");
        System.out.print(rs.getInt(4) + "\t");
    
        System.out.println(" ");
      }

      rs.close();
      s.close();
      con.close();
    }
    catch (SQLException ce) {
      System.out.println(ce);
    }
  }
}