createinfor.java

本软件是一个规模较大网上货物购买管理系统

 package data;

import java.sql.*;;

public class CreateInfor {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		//创建信息浏览模块的数据类
		InforData inforData=new InforData();
		//取得信息浏览模块的数据连接类
		Connection conn=inforData.setupConn();
		//创建sql语句执行类
		try{
			Statement stmt=conn.createStatement();
			//创建category数据表的创建代码
			String sql="CREATE TABLE category"+
			"(categoryId int(15) not null primary key,"+
			"CONSTRAINT CATE CHECK(categoryId IS NOT NULL),"+
			"cname varchar(65) not null default '',"+
			"description varchar(200) not null default '')";
			//执行创建数据表的sql语句
			stmt.execute(sql);
			System.out.println("成功创建数据表category.");
			//创建product数据表的创建代码
			sql="CREATE TABLE product"+
			"(pId int(15) not null primary key,"+
			"pname varchar(65) not null,"+
			"categoryId int(15) not null,"+
			"quantity int(25) not null,"+
			"price float(20,2) not null,"+
			"unitsInStock int(25) not null,"+
			"unitsOnOrder int(25) not null,"+
			"minUnitsInstock int(25) not null,"+
			"isUsed char(10) not null)";
			//执行创建数据表的sql语言
			stmt.execute(sql);
			System.out.println("成功创建数据表product.");
			//关闭sql语句执行类
			stmt.close();
			//关闭数据库联类
			conn.close();
		}
		catch(Exception ex){
			ex.printStackTrace();
		}
	}
}