用Java怎么连接Access文件,并读取其中的数据??

来源:百度知道 编辑:UC知道 时间:2024/05/24 01:01:19
我还没学到那程度,请求支援。。。谢谢

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_INSENSITI