天天看点

用java读取access文件中数据

import java.sql.*;
import java.util.HashMap;
import java.util.Map;

public class TestAccess {
	public static void main(String[] args) {
		Map<Integer, Object[]> map = new HashMap<Integer, Object[]>();
		String[] column ;
		try {
			 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			//DBTest.mdb是d盘下access文件
			String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=d:\\DBTest.mdb";
 			String user="";
			String password="";
 			Connection con=null;
			Statement st=null;
			 ResultSet rs=null;
			con=DriverManager.getConnection(url, user, password);
			st=con.createStatement();
		     
			 rs=st.executeQuery("select * from test");
			
			/ /读取字段名称
			ResultSetMetaData metaDate = rs.getMetaData();   
			int number = metaDate.getColumnCount();   
			column = new String[number];   
			for (int j = 0;j < column.length; j++){   
			    column[j] = metaDate.getColumnName(j + 1);   
			    System.out.print(column[j]+"\t");
			}   
			System.out.println();
			int a = 0;
			//输出数据
			while(rs.next()){
				a++;
				Object[] rss = new Object[number];
				for(int i = 0;i < rss.length; i++){
					rss[i] = rs.getString(i + 1);  
					System.out.print(rss[i]+"\t");
				}
				System.out.println();
				map.put(a, rss)	;				
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		catch (ClassNotFoundException e) {
			e.printStackTrace();
		}		
		
	}
}
           

继续阅读