ITeye博客

Windows中Java连接Access数据库

cjx186 · 2012-09-16 12:00 · java · database · 编程语言 · Markdown

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();
		}
	}
}

评论(0)

暂无评论。

评论功能维护中,当前仅展示历史评论。