Windows中Java连接Access数据库
1、直接在Java代码内部Access数据库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();}}}
页:
[1]