reasaccess.java~2~

来自「利用JAVA实现对ACCESS文件的增加、删除、修改功能」· JAVA~2~ 代码 · 共 24 行

//Select.java

import java.sql.*;
class ReasAccess{
  public static void main(){
    try{
      String url = "jdbc:odbc:wombat";
      Connection conn = DriverManager.getConnection(url,"user","pwd");
      Statement stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery("SELECT * FROM Table1");
      System.out.println("Got ResultSet Now");
      rs.beforeFirst();
      while(rs.next()){
        System.out.println(rs.getString(1));
      }
      stmt.close();
      conn.close();
    }
    catch(Exception ex){
      ex.printStackTrace();
    }
  }
}