鸿 网 互 联 www.68idc.cn

当前位置 : 服务器租用 > 数据库 > Access > >

Java访问Access的一般方法介绍

来源:互联网 作者:佚名 时间:2015-09-07 11:44
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 s
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;

}

}
网友评论
<