buildtables.java

来自「Java Classic Examples是我买的两本书：《JAVA经典实例》和」· Java 代码 · 共 44 行

import java.sql.*;

public class BuildTables
{
  public static void main(String[] args)
  {
    try
    {
      String username = "guest";
      String password = "guest";
      String url = "jdbc:odbc:technical_library";
      String driver = "sun.jdbc.odbc.JdbcOdbcDriver";

      String[] SQLStatements = {
      "CREATE TABLE online_resources (pub_id int, name char(48), url char(80))",
      "INSERT INTO online_resources " +
                           "VALUES(1, 'Wrox Home Page', 'http://www.wrox.com')",
      "INSERT INTO online_resources " +
                   "VALUES(2, 'JavaSoft Home Page', 'http://www.javasoft.com')",
      "INSERT INTO online_resources " +
                  "VALUES(3, 'Imaginary Home Page','http://www.imaginary.com')"
                               };

      Class.forName(driver);
      Connection connection = DriverManager.getConnection(url, username, password);
      Statement statement = connection.createStatement();

      for (int i = 0; i < SQLStatements.length; i++)
      {
        statement.executeUpdate(SQLStatements[i]);
        System.out.println(SQLStatements[i]);
      }
    }
    catch (ClassNotFoundException cnfe)
    {
      System.err.println(cnfe);
    }
    catch (SQLException sqle)
    {
      System.err.println(sqle);
    }
  }
}