testaccess3.java~7~

学生信息管理系统,包括成绩查询,成绩排序,用ACCESS做数据库连接

package Chapter1;
import  java.sql.*;
public class TestAccess3
{
  public static void main(String[] args)
  {
    try
      {
        String url="jdbc:odbc:MySecondAccess";
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con=DriverManager.getConnection(url,"","");
        Statement stmt=con.createStatement();
        String  SQLOrder="SELECT * FROM BasicInformation ORDER BY 姓名";
        ResultSet resultSet=stmt.executeQuery(SQLOrder);
        System.out.println("学号"+"          姓名"+"       性别"+"      年龄"+"      院系"+"      专业"+"      籍贯"+"     入学时间");
        while(resultSet.next())
        {
              String  ID=resultSet.getString(1);
              String  name=resultSet.getString(2);
              String  sex=resultSet.getString(3);
              int age=Integer.parseInt(resultSet.getString(4));
              String  department=resultSet.getString(5);
              String  major=resultSet.getString(6);
              String  homeplace=resultSet.getString(7);
              String  timeOfEntering=resultSet.getString(8);

              System.out.println(ID+"   "+name+"     "+ sex+"       "+age+"     "+department+"    "+major+"    "+homeplace+"    "+timeOfEntering+"\t");


        }
        stmt.close();
        con.close();
      }
      catch(Exception ex)
      {
        System.out.println("Failure in connecting with the database!");
        System.out.println(ex.getMessage());
      }

  }
}