WEB开发网
开发学院WEB开发Jsp Java访问Access的一般方法介绍 阅读

Java访问Access的一般方法介绍

 2008-01-05 19:29:35 来源:WEB开发网   
核心提示:import java.sql.*;public class accessDB {String driver = "sun.jdbc.odbc.JdbcOdbcDriver";String url = "jdbc:odbc:Driver={MicroSoft Access Driver*.

  import java.sql.*;
  
  public class accessDB {
   String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
   String url = "jdbc:odbc:Driver={MicroSoft Access Driver *.mdb)};DBQ = Northwind.mdb";
   String user = "";
   String pwd = "";
   Connection conn;
   Statement stmt;
   ResultSet rs;
  
   public MyDB() {
    try {
     Class.forName(driver);
    } catch (Exception e) {
     System.out.PRintln(e);
    }
   }
  
   //创建不可滚动的连接
   public void connect() {
    try {
     conn = DriverManager.getConnection(url,user,pwd);
     stmt = conn.createStatement();
    } catch (Exception e) {
     System.out.println(e);
    }
   }
   //创建可以滚动的连接
   public void connect2() {
    try {
     conn = DriverManager.getConnection(url,user,pwd);
     stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
    } catch (Exception e) {
     System.out.println(e);
    }
   }
  
   //关闭连接
   public void close() {
    try {
     if (stmt != null) {
      stmt.close();
     }
     if (conn != null) {
      conn.close();
     }
    } catch (Exception e) {
     System.out.println(e);
    }
   }
  
   //查询语句
   public ResultSet executeQuery(String sql) {
    try {
     if (stmt == null) {
      connect();
     }
     rs = stmt.executeQuery(sql);
    } catch (Exception e) {
     System.out.println(e);
    }
    return rs;
   }
  }

Tags:Java 访问 Access

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接