testaccess1.java

来自「学生信息管理系统,包括成绩查询,成绩排序,用ACCESS做数据库连接」· Java 代码 · 共 28 行

package Chapter1;
import java.sql.*;
public class TestAccess1
{
  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="INSERT INTO ClassesInformation VALUES(20053001151,'王利宾','男',19,'软件学院','软件工程','山东聊城莘县','2005年9月')";
            stmt.executeUpdate(SQLOrder);
            stmt.close();
            con.close();
            System.out.println("Success!");
      }

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

  }