dbtest.java~3~

来自「java语言开发的数据库管理系统」· JAVA~3~ 代码 · 共 39 行

import java.sql.*;

public class DBTest {
  Connection con;
  Statement sta;
  ResultSet rs;
  String driver;
  String url;
  String user;
  String pwd;
  public DBTest() {
    driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    url =
        "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName =MyDB";
    user = "sa";
    pwd = "";
    init();
  }

  public void init() {
    try {
      Class.forName(driver);
      System.out.println("driver is ok");
      con = DriverManager.getConnection(url, user, pwd);
      System.out.println("conection is ok");
      sta = con.createStatement();
      rs = sta.executeQuery("select * from Person");
      while (rs.next()) System.out.println(rs.getInt(1));
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public static void main(String args[]) {
    new DBTest();
  }
}