jdbc1.java~17~

来自「关于ＪＤＢＣ的使用的简单的程序源码」· JAVA~17~ 代码 · 共 26 行

import java.sql.*;

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