jdbc1.java~36~

一个关于ＪＤＢＣ的简单的例子

import java.sql.*;

public class JDBC1 {
  //Main method
  public static void main(String[] args) {
    try{
      Connection conn=null;
      //装载驱动
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      //连接数据库
      //conn=DriverManager.getConnection("jdbc:odbc:Pubs","","");
      conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:2433;DatabaseName=Pubs");
      //查询准备
      Statement stmt=conn.createStatement();
      String qstr="select * from publishers";
      //查询
      ResultSet rs1=stmt.executeQuery(qstr);
      ResultSet rs=stmt.executeQuery(qstr);
      //处理结果
      while(rs.next()){
        System.out.println(rs.getString(1)+","+rs.getString("pub_name"));
      }
      while(rs1.next()){
        System.out.println(rs1.getString(1));
      }
      //关闭结果集、查询语句、数据库连接
      rs.close();stmt.close();conn.close();
    }catch(Exception ex){
      System.out.println(ex.getMessage());
    }
  }
}