Java访问Access的一般方法

来源：互联网发布：word怎样添加图表数据编辑：程序博客网时间：2024/05/16 14:45

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;
}
}