1.安装ACCESS数据库(省略)
2.配置数据源 :
(1)打开我的电脑,点击搜索(放大镜图标),包含文字栏栏输入“数据源”,点击搜索
(2)双击搜索结果中的“数据源” ,点击“系统DSN”选项卡 ,点击 “ 添加(按钮)”,选择“ Driver to Microsoft Access (*.mdb)” ,点击“完成(按钮)”
(3)输入数据源名称“myDS” ,点击数据库栏中的数据库下方的 “选择”,找到Access数据库的存放路径点击确认 即可 。
3.程序中使用Access数据库:
(1)连接Access 数据库助手类 :
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
public class AccessManger {
private static Connection conn = null;
private ResultSet rs = null;
private Statement st = null;
static Logger log = Logger.getLogger(AccessManger.class);
public static Connection getConn(){
String url = "jdbc:odbc:myDS"; //myDS 数据源名称
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url);
log.info("Access数据库连接成功");
} catch (Exception e) {
log.info("Access数据库连接失败");
}
return conn;
}
public static void close(ResultSet rs, Statement stmt, Connection conn) {
try {
if (rs != null)
rs.close();
} catch (Exception e) {
log.error("access rs 关闭异常",e);
} finally {
try {
if (stmt != null)
stmt.close();
} catch (Exception e2) {
log.error("access st 关闭异常",e2);
} finally {
try {
if (conn != null)
conn.close();
} catch (Exception e3) {
log.error("access conn 关闭异常",e3);
}
}
}
}
}
(2)读取access数据库数据实例代码 :
public void getZbstatList() throws SQLException {
String sql = "select log_id,wnd_id,time_call,time_leave,queue_id from zbstat where states = 4 ";
Connection conn = AccessManger.getConn();
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);
try {
while (rs.next()) {
System.out.println(rs.getInt("log_id"));
System.out.println(rs.getString("wnd_id"));
System.out.println(rs.getTimestamp("time_call"));
System.out.println(rs.getTimestamp("time_leave"));
System.out.println(rs.getString("queue_id"));
}
} catch (SQLException e) {
System.out.println("读取ACCESS数据库数据出错了,导致原因可能是 :"+e.getMessage());
}finally{
AccessManger.close(rs, st, conn);
}
}