1、直接在Java代码内部Access数据库
2、使用ODBC建立WINDOW数据源的方法
开始-控制面板-性能和维护-管理工具-数据源 (ODBC)-用户DSN或系统DSN-添加(D)...
"Microsoft Access Driver (*.mdb)"-完成
配"数据源名"如'hxq'-确定
package me.cjx.example;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.util.Properties;
public class ReadMDB {
public static void main(String[] args) {
try {
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=F://Database.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Properties prop = new Properties();
prop.put("charSet", "gb2312");
Connection conn = DriverManager.getConnection(url, prop);
System.out.println("log:" + conn);
Statement sta = conn.createStatement();
ResultSet resu = sta.executeQuery("select * from USER");
ResultSetMetaData rsd = resu.getMetaData();
while (resu.next()) {
for (int i = 1, length = rsd.getColumnCount(); i <= length; i++) {
System.out.print(rsd.getColumnName(i) + "\t");
System.out.println(resu.getString(i));
}
}
System.out.println("log:exit");
} catch (Exception e) {
e.printStackTrace();
}
}
}
2、使用ODBC建立WINDOW数据源的方法
开始-控制面板-性能和维护-管理工具-数据源 (ODBC)-用户DSN或系统DSN-添加(D)...
"Microsoft Access Driver (*.mdb)"-完成
配"数据源名"如'hxq'-确定
package me.cjx.example;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
public class ReadMDB {
public static void main(String[] args) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Properties prop = new Properties();
prop.put("charSet", "gb2312");
Connection conn = DriverManager
.getConnection("jdbc:odbc:hxq", prop);
System.out.println(conn);
Statement sta = conn.createStatement();
ResultSet resu = sta.executeQuery("select * from USER");
if (resu.next()) {
System.out.println(resu.getString("username"));
}
System.out.println("exit");
} catch (Exception e) {
e.printStackTrace();
}
}
}