createmysqltable.java~13~

jbuilder2006一书的所有源代码

package table;

import java.sql.*;

public class CreateMySQLTable {

  public static void main(String[] args) {
    //定义数据库连接的驱动程序
    String driver = "org.gjt.mm.mysql.Driver";
    //定义MySQL数据库的连接地址,作用是连接books数据库
    String url = "jdbc:mysql://localhost:3306/books?user=root;password=";
    //声明连接类
    Connection conn = null;
    try {
      //使用JDBC技术创建数据库连接
      Class.forName(driver);
      //使用DriverManager类的getConnection()方法建立连接,第一个字符参数定义用户名,
      //第二个字符参数定义密码
      conn = DriverManager.getConnection(url, "", "");
      if (conn != null) {
        System.out.println("成功连接JDBC数据源.");
      }
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    try {
      //创建SQL语句执行类
      Statement stmt = conn.createStatement();
      //创建booksCategory数据表创建代码
      String sql = "create table booksCategory (" +
          "id int NOT NULL PRIMARY KEY," +
          "categoryName varchar (100) NOT NULL," +
          "categoryDescription varchar (200) NOT NULL)";
      //执行创建数据表的SQL语句
      stmt.execute(sql);
      System.out.println("成功创建数据表booksCategory.");
      //创建books数据表创建代码
      sql = "create table books (" +
          "serialId varchar (20) NOT NULL PRIMARY KEY," +
          "categoryId int NOT NULL ," +
          "booksName varchar (100) NOT NULL ," +
          "author varchar (50) NOT NULL ," +
          "publisher varchar (50) NOT NULL ," +
          "content varchar (200) NOT NULL ," +
          "upperLimit int NOT NULL )";
      //执行创建数据表的SQL语句
      stmt.execute(sql);
      System.out.println("成功创建数据表books.");
      //关闭SQL语句执行类
      stmt.close();
      //关闭数据库连接
      conn.close();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }
}