提示信息如下:
drop table User
drop table User3
drop table t_user2
create table User (id varchar(255) not null, name varchar(255) null, password varchar(255) null, createTime datetime null, expireTime datetime null, primary key (id))
18:51:41,265 ERROR SchemaExport:274 - Unsuccessful: create table User (id varchar(255) not null, name varchar(255) null, password varchar(255) null, createTime datetime null, expireTime datetime null, primary key (id))
18:51:41,265 ERROR SchemaExport:275 - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'User' 附近有语法错误。
create table User3 (id varchar(255) not null, name varchar(255) null, password varchar(255) null, createTime datetime null, expireTime datetime null, primary key (id))
create table t_user2 (user_id varchar(255) not null, name varchar(20) not null unique, password varchar(10) not null, create_time datetime null, expire_time datetime null, primary key (user_id))
18:51:41,421 WARN JDBCExceptionReporter:48 - SQL Warning: 0, SQLState:
18:51:41,421 WARN JDBCExceptionReporter:49 - [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to master
18:51:41,421 WARN JDBCExceptionReporter:48 - SQL Warning: 5701, SQLState: 01000
18:51:41,421 WARN JDBCExceptionReporter:49 - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]已将数据库上下文改为 'master'。
18:51:41,421 WARN JDBCExceptionReporter:48 - SQL Warning: 0, SQLState:
18:51:41,421 WARN JDBCExceptionReporter:49 - [Microsoft][SQLServer 2000 Driver for JDBC]Language changed to 简体中文
18:51:41,421 WARN JDBCExceptionReporter:48 - SQL Warning: 5703, SQLState: 01000
18:51:41,421 WARN JDBCExceptionReporter:49 - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]已将语言设置改为 简体中文。查看数据库中没有表存在,请大家解决下!
谢谢!加分!
drop table User
drop table User3
drop table t_user2
create table User (id varchar(255) not null, name varchar(255) null, password varchar(255) null, createTime datetime null, expireTime datetime null, primary key (id))
18:51:41,265 ERROR SchemaExport:274 - Unsuccessful: create table User (id varchar(255) not null, name varchar(255) null, password varchar(255) null, createTime datetime null, expireTime datetime null, primary key (id))
18:51:41,265 ERROR SchemaExport:275 - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'User' 附近有语法错误。
create table User3 (id varchar(255) not null, name varchar(255) null, password varchar(255) null, createTime datetime null, expireTime datetime null, primary key (id))
create table t_user2 (user_id varchar(255) not null, name varchar(20) not null unique, password varchar(10) not null, create_time datetime null, expire_time datetime null, primary key (user_id))
18:51:41,421 WARN JDBCExceptionReporter:48 - SQL Warning: 0, SQLState:
18:51:41,421 WARN JDBCExceptionReporter:49 - [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to master
18:51:41,421 WARN JDBCExceptionReporter:48 - SQL Warning: 5701, SQLState: 01000
18:51:41,421 WARN JDBCExceptionReporter:49 - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]已将数据库上下文改为 'master'。
18:51:41,421 WARN JDBCExceptionReporter:48 - SQL Warning: 0, SQLState:
18:51:41,421 WARN JDBCExceptionReporter:49 - [Microsoft][SQLServer 2000 Driver for JDBC]Language changed to 简体中文
18:51:41,421 WARN JDBCExceptionReporter:48 - SQL Warning: 5703, SQLState: 01000
18:51:41,421 WARN JDBCExceptionReporter:49 - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]已将语言设置改为 简体中文。查看数据库中没有表存在,请大家解决下!
谢谢!加分!
你还是用jdbc吧
User是sqlserver2000的关键字来的。