驱动包准备
加入到工程classpath中,建立一个java测试类,工程结构代码如下:
TestConn类的代码如下:
package com.hbk.test;
import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class TestConn {
public static void main(String[] args) throws SQLException, UnsupportedEncodingException {
// --Access 数据库路径
String dbpath = "D:\\news.mdb";
// --连接字符串
String url = "jdbc:ucanaccess://" + dbpath;
Properties properties = new Properties();
properties.setProperty("charSet", "gbk"); // 这里设置是为了防止查询的时候出现乱码
Connection conn = null;
try {
Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
conn = DriverManager.getConnection(url, properties);
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery("select * from News");
while (rs.next()) {
System.out.println(new String(rs.getString(1).getBytes(), "UTF-8")); // 1.查询的时候下标是从1开始的;2.
}
conn.close();
}
}