createauthtab.java

来自「《Java程序设计入门教程》中国青年出版社 一书配套光盘」· Java 代码 · 共 32 行

//================== CreateAuthTab.java ====================
import java.sql.*;
public class CreateAuthTab
  {
  public static void main(String args[])
    {
    try
      {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      }
    catch (java.lang.ClassNotFoundException e)
      {
      System.out.println(e.getMessage());
      }
    try
      {
      Connection con =
        DriverManager.getConnection("jdbc:odbc:bookbase");
      Statement stmt = con.createStatement();
      stmt.executeUpdate("create table authTab (" +
        "auth char(10), " +
        "tel char(12) CONSTRAINT authIndex PRIMARY KEY)");
      stmt.close();
      con.close();
      }
    catch (SQLException ex)
      {
      System.out.println("SQLException: "+ex.getMessage());
      }
    }
  }