java 连接 access 数据库

package com.cyberdak.util.access;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;

import sy.model.access.ReAdd;

/**
 * @author 亢伟楠
 *	时间:2015年3月9日下午4:23:48
 */
public class AccessDBUtil {
	
	static String accessFile = "d:\\a.accdb";
	
	public static void main(String[] args) throws SQLException {
		getReAddList();
	}

	public static  List<ReAdd> getReAddList() throws SQLException{
		Connection conn =  null;
		final String sql = "select * from `追加总表`";
		ResultSet rs = null;
		List<ReAdd> list = null;
		try{
			conn = getConnection();
			rs = conn.createStatement().executeQuery(sql);;
			while(rs.next()){
				ReAdd  reAdd = new ReAdd();
				reAdd.setColor(rs.getString("颜色"));
				System.out.println(reAdd.getColor());
				list.add(reAdd);
			}
		}finally{
			rs.close();
			conn.close();
		}
		return list;
	}

	public static Connection getConnection() throws SQLException{  
		Properties prop = new Properties();     
		prop.put("charSet", "gb2312");  //设置编码防止中文出现乱码  
		return DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb, *.accdb)};DBQ="+accessFile, prop);
	}


}