testaccess2.java

学生信息管理系统,包括成绩查询,成绩排序,用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 籍贯='山东聊城莘县'";
        stmt.executeUpdate(SQLOrder);
        stmt.close();
        con.close();

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