import java.sql.*;
public class Zh
{ public static void main(String args[])
{ Connection con;Statement sql; ResultSet rs;
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{ System.out.println(""+e);
}
try
{
con=DriverManager.getConnection("jdbc:odbc:djd","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM zhanghui");
while(rs.next())
{ String number=rs.getString(1);
String name=rs.getString(2);
Date date=rs.getDate(3);
int math=rs.getInt("数学");
int physics=rs.getInt("物理");
int english=rs.getInt("英语");
System.out.println("学号:"+number);
System.out.print(" 姓名:"+name);
System.out.print(" 出生:"+date);
System.out.print(" 数学:"+math);
System.out.print(" 物理:"+physics);
System.out.print(" 英语:"+english);
}
con.close();
}
catch(SQLException e1) {}
}
}
public class Zh
{ public static void main(String args[])
{ Connection con;Statement sql; ResultSet rs;
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{ System.out.println(""+e);
}
try
{
con=DriverManager.getConnection("jdbc:odbc:djd","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM zhanghui");
while(rs.next())
{ String number=rs.getString(1);
String name=rs.getString(2);
Date date=rs.getDate(3);
int math=rs.getInt("数学");
int physics=rs.getInt("物理");
int english=rs.getInt("英语");
System.out.println("学号:"+number);
System.out.print(" 姓名:"+name);
System.out.print(" 出生:"+date);
System.out.print(" 数学:"+math);
System.out.print(" 物理:"+physics);
System.out.print(" 英语:"+english);
}
con.close();
}
catch(SQLException e1) {}
}
}
catch(SQLException e1) {
System.out.println(e1);
}