List select(String sql) throws Exception { //执行sql查询操作 //将结果存放到可变长度的ayyaylist数组中 String sql_str=sql; String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D://demo.mdb"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn=DriverManager.getConnection(strurl) ; Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery(sql_str); List list = new ArrayList(); ResultSetMetaData md = rs.getMetaData(); int columnCount = md.getColumnCount(); while (rs.next()) { Map rowData = new HashMap(); for (int i = 1; i <= columnCount; i++) { rowData.put(md.getColumnName(i),rs.getObject(i)); } list.add(rowData); } //for(int i=0;i<list.size();i++) //{ // // System.out.println(list.get(i)); //} return list; }