testaccess2.java~9~

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

package Chapter1;
import java.sql.*;
public class TestAccess2
{
  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="DELETE  FROM BasicInformation WHERE 学号='124'";
         stmt.executeQuery(SQLOrder);
//          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+"\n"+"姓名:"+name+"\n"+"性别:"+ sex+"\n"+"年龄:"+age+"\n"+"院系:"+department+"\n"+"专业:"+major+"\n"+"籍贯:"+homeplace+"\n"+"入学时间:"+timeOfEntering);
//           }
           stmt.close();
           con.close();
        }
        catch(Exception ex)
        {
          System.out.println("Failure in connecting with the database!");
          System.out.println(ex.getMessage());
        }
  }
}