7,732
社区成员




String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\\ESS_part001.mdb";
String sql = "select id,ordernr,typenr,erpnr,description1,note from tblPart where producttopgroup=1";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url);
if(conn != null){
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while(rs.next())
{
System.out.print(rs.getString("id")+" ");
System.out.print(rs.getString("ordernr"));
System.out.println();
}
}