import java.sql.*; public class DbManager{ public static void main(String [] args){ try{ String sourceURL="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase"; //DataBase是Access MDB文件的主文件名 //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch(Exception e){ e.printStackTrace(); } Connection conn=DriverManager.getConnection(sourceURL); Statement stmt=conn.createStatement(); ResultSet rset=stmt.executeQuery("select * from gz"); System.out.println("职工号 基本工资 效益工资"); while(rset.next()) System.out.println(rset.getString("ID")+" "+rset.getInt("jbgz")+" "+rset.getInt("xygz")); rset.close(); stmt.close(); conn.close(); } catch(SQLException sqle){ System.err.println(sqle); } } }