public static void main(String[] args) { Connection aon=null; //连接 Statement sql=null; //发送sql 语句 ResultSet rs=null; //结果集 try { Class.forName("sun.jdbc.odbc.jdbcOdbcDriver"); } catch (ClassNotFoundException e1){ e1.printStackTrace(); } try { con=DriverManager.getConnection("jdbc:odbc:aaa","sa",""); sql=con.createStatement(); rs=sql.executeQuery("select * from chengjibiao"); while(rs.next()) { String number=rs.getString(1); String name=rs.getString(2); Date date=rs.getDate(3); int math=rs.getInt(4); int physics=rs.getInt(5); int english=rs.getInt(6); System.out.println("学号"+number); System.out.println("姓名"+name); System.out.println("出生"+date); System.out.println("数学"+math); System.out.println("物理"+physics); System.out.println("英语"+english); System.out.println("!!!!!!!!!!!!!!!!!!!!!!!!!!!"); } } catch(SQLException e) { e.printStackTrace(); } finally{ try{ rs.close(); sql.close(); con.close(); }catch(SQLException e){ e.printStackTrace(); } } }}