public static void main(String[] args) { Connection aon=null;//连接 Statement sql=null;//发送sql 语句 ResultSet rs=null;//结果集 try { Class.forName("sun.jdbc.odbc.jdbcO... 展开
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();} } }} 收起