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;
}
}
更多精彩
赞助商链接