createauthtab.java

java程序设计入门教程 书上的源代码 学习JAVA非常好的入门教材代码推荐给大家

//================== 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());
      }
    }
  }