JSP+sqlserver2008 留言管理系统

CREATE TABLE users ( UserID bigint identity(0,1) NOT NULL , UserName varchar(20) default NULL, UserPassword varchar(20) default NULL, PRIMARY KEY (UserID) ) ; CREATE TABLE words ( WordsID bigint identity(0,1) NOT NULL , WordsTitle varchar(100) default NULL, WordsContent text, WordsTime datetime default '0000-00-00 00:00:00', UserID bigint NOT NULL , PRIMARY KEY (WordsID) ) ; CREATE TABLE person ( UserID bigint identity(0,1) NOT NULL , UserName varchar(20) default NULL, UserPassword varchar(20) default NULL, PRIMARY KEY (UserID) ) ;