setuptable.java

来自「远程电子考试系统」· Java 代码 · 共 35 行

package dbconnect;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class SetupTable {

	/**
	 * @param args
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws SQLException {
		// TODO 自动生成方法存根

		DbConnect dbcon=new DbConnect();
		dbcon.connect();
		Statement stmt;
			stmt = dbcon.getConnction().createStatement();

		/*	stmt.executeUpdate("create table test_paper("
					+ "TEST_NAME varchar(20) not null,"
					+ "LIMIT_TIME varchar(10)," + "TOTAL_NUM number(10),"
					+ "primary key(TEST_NAME))"); */// 执行插入命令
			stmt.executeUpdate("create table ExactResult("
					+ "CUSTOMER_NAME varchar(20) not null,DATE_TIME varchar(20),"
					+ "QUESTION_NO varchar(10)," + "ANSWER varchar(10),CORRECT_ANSWER varchar(10),"
					+ "JUDGE varchar(10))"); 
			System.out.println("表创建成功!");
		dbcon.disconnect();
	}

}