你直接用JB--Database Pilot就可以了
解决方案 »
- dos系统下的上级步骤是什么啊??????????
- 在局域网内的电脑如何与外网的电脑建立Socket?
- 谁能回答这个问题啊
- 方法override的小问题(权限访问符对override的影响)
- 关于java实现打印的问题。
- 大家是在用1.4还是在用1.5(5.0)
- 我的JAVA JDK1.3.1_05 好像找不到CLASS,怎么解决?
- 请问哪里可以下载IP地址段对应城市的信息?高分回报!
- 关于SCJP
- The type EmpDao cannot be a superinterface of EmpDaoImpl; a superinterface must
- Jb中光标的位置很多时侯跑到输入的字符位置之前,怎样解决。。。
- 那里可以下载的到带搜索得JDK帮助文档(1.3,1.4都可)
创建数据库
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)]
[table_options] [select_statement]create_definition:
col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
[PRIMARY KEY] [reference_definition]
or PRIMARY KEY (index_col_name,...)
or KEY [index_name] (index_col_name,...)
or INDEX [index_name] (index_col_name,...)
or UNIQUE [INDEX] [index_name] (index_col_name,...)
or [CONSTRAINT symbol] FOREIGN KEY index_name (index_col_name,...)
[reference_definition]
or CHECK (expr)type:
TINYINT[(length)] [UNSIGNED] [ZEROFILL]
or SMALLINT[(length)] [UNSIGNED] [ZEROFILL]
or MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL]
or INT[(length)] [UNSIGNED] [ZEROFILL]
or INTEGER[(length)] [UNSIGNED] [ZEROFILL]
or BIGINT[(length)] [UNSIGNED] [ZEROFILL]
or REAL[(length,decimals)] [UNSIGNED] [ZEROFILL]
or DOUBLE[(length,decimals)] [UNSIGNED] [ZEROFILL]
or FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL]
or DECIMAL(length,decimals) [UNSIGNED] [ZEROFILL]
or NUMERIC(length,decimals) [UNSIGNED] [ZEROFILL]
or CHAR(length) [BINARY]
or VARCHAR(length) [BINARY]
or DATE
or TIME
or TIMESTAMP
or DATETIME
or TINYBLOB
or BLOB
or MEDIUMBLOB
or LONGBLOB
or TINYTEXT
or TEXT
or MEDIUMTEXT
or LONGTEXT
or ENUM(value1,value2,value3,...)
or SET(value1,value2,value3,...)index_col_name:
col_name [(length)]reference_definition:
REFERENCES tbl_name [(index_col_name,...)]
[MATCH FULL | MATCH PARTIAL]
[ON DELETE reference_option]
[ON UPDATE reference_option]reference_option:
RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULTtable_options:
TYPE = {ISAM | MYISAM | HEAP}
or AUTO_INCREMENT = #
or AVG_ROW_LENGTH = #
or CHECKSUM = {0 | 1}
or COMMENT = "string"
or MAX_ROWS = #
or MIN_ROWS = #
or PACK_KEYS = {0 | 1}
or PASSWORD = "string"
or DELAY_KEY_WRITE = {0 | 1}
or ROW_FORMAT= { default | dynamic | static | compressed }
CREATE TABLE System (
Typename varchar(255) NOT NULL default '',
Value varchar(255) default NULL,
PRIMARY KEY (Typename)
) ;
st.exeUpdate('create database @dbname');
Statement st=null;
try{
Class.forName("org.gjt.mm.mysql.Driver");
con=DriverManager.getConnection("jdbc:mysql://10.10.1.129:3306/fishgame","root","123456");
st=con.createStatement();
st.executeUpdate("create database System");
}catch(Exception ex){
System.out.println(ex.getMessage());
}