readaccess.java

利用JAVA实现对ACCESS文件的增加、删除、修改功能

//Select.java

import java.sql.*;

class ReadAccess{
  public ReadAccess(){
  }
  public static void main(String args[] ){
    String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
    String Conntr="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=d:\\Java-Program\\JavaAccess\\Employee.mdb";
    String sql="select * from Person";
    Connection conn=null;
    ResultSet rs=null;
    try{
      Class.forName(DBDriver);
      conn = DriverManager.getConnection(Conntr,"user","pwd");
      Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

      rs=stmt.executeQuery(sql) ;
      System.out.println("ID   Name Province Health");
      while(rs.next()){
        System.out.print(""+rs.getString("ID"));
        System.out.print("    "+rs.getString("Name"));
        System.out.print("    "+rs.getString("Province"));
        System.out.print("    "+rs.getString("Health"));
        System.out.println();
      }

      /*rs.last();
      rs.updateString(1, "暗暗");
      rs.updateString(2, "达到");
      rs.updateString(3, "达到");
      rs.updateString(4, "达到");
      rs.insertRow();

*/


  /*    //插入一条记录
     String insertstr="insert into Person (ID,Name,Province,Health) values (?,?,?,?)";
     PreparedStatement pstmt=conn.prepareStatement(insertstr);
     pstmt.setString(1,"1");
     pstmt.setString(2,"刘少奇");
     pstmt.setString(3,"31000");
     pstmt.setString(4,"32000");
     pstmt.executeUpdate();
     pstmt.close();

     //删除记录 删除编号1 的资料
     String delstr="delete from Person where ID=?";
     PreparedStatement pstmt=conn.prepareStatement(delstr);
     pstmt.setString(1,"1");
     pstmt.executeUpdate();
     pstmt.close();
*/
  //修改一笔资料
     String updatestr="update Person set Name=?,Province =? where ID=? ";
     PreparedStatement pstmt=conn.prepareStatement(updatestr);

     rs.first();
     pstmt.setString(1,"66");
     pstmt.setString(2,"68");
     pstmt.setString(3,"北京2");

     pstmt.executeUpdate();
     pstmt.close();
     rs.close();


      stmt.close();
      conn.close();
    }
    catch(Exception e){
       e.getMessage();
       e.printStackTrace();
    }
  }
}