这是第一块： drop database note; create database note; use note; CREATE TABLE admin (adminName char(20) NOT NULL, adminPasswd char(80) NOT NULL, ); create table guest(noteId int NOT NULL auto_increment, userName char(20) NOT NULL, sex int NOT NUll, email char(50), qq char(9), url char(50), headTitle varchar(60) NOT NULL, content text NOT NULL, image varchar(20), noteTime varchar(20), primary key(noteId) ); CREATE TABLE reply (replyId int not null auto_increment, noteId int(11) NOT NULL, content text, replyTime varchar(20), primary key(replyId) ); 下面是第二块： -- -- Table structure for table 'news' -- CREATE TABLE news ( newsId int(11) NOT NULL auto_increment, classId int(11) NOT NULL default '0', kindId int(11) NOT NULL default '0', myOther int(11) NOT NULL default '0', headTitle varchar(255) NOT NULL default '', content text NOT NULL, connect varchar(255) default NULL, author varchar(20) NOT NULL default '', editor varchar(20) default NULL, newsFrom varchar(40) default NULL, top int(11) default NULL, newsTime varchar(20) default NULL, hits int(11) default '0', state int(11) default '0', tag int(11) NOT NULL default '0', PRIMARY KEY (newsId) ) TYPE=MyISAM; -- -- Dumping data for table 'news' -- INSERT INTO news VALUES (1,3,6,0,'白鹰！非常感谢！','你的流言板原代码我用了！
因为没有高手指点。配置了好久！！
希望能和你成为朋友！！
我的邮箱是 qumingcheng@sohu.com
qq:12363871   目前我还是学生。对于建站不是很精通！
以后能否多多指教！！谢谢！！','null','darky','null','哈尔滨工业大学',0,'2003-10-02 11:08:53',2,0,0); - -- Table structure for table 'newsadmin' -- CREATE TABLE newsadmin ( userName varchar(20) NOT NULL default '', passWd varchar(20) NOT NULL default '', purview int(11) NOT NULL default '0', lastLogin datetime default NULL, lastLoginIp varchar(20) default NULL, PRIMARY KEY (userName) ) TYPE=MyISAM; -- -- Dumping data for table 'newsadmin' -- INSERT INTO newsadmin VALUES ('ntsky','ntskyyjl',0,'2003-12-04 22:59:21','10.0.2.99'); -- -- Table structure for table 'newsclass' -- CREATE TABLE newsclass ( classId int(11) NOT NULL default '0', content varchar(20) NOT NULL default '', PRIMARY KEY (classId) ) TYPE=MyISAM; -- -- Dumping data for table 'newsclass' -- INSERT INTO newsclass VALUES (1,'linux入门'); INSERT INTO newsclass VALUES (2,'服务器配置'); INSERT INTO newsclass VALUES (3,'应用开发'); INSERT INTO newsclass VALUES (4,'数据库应用'); INSERT INTO newsclass VALUES (5,'系统安全'); -- -- Table structure for table 'newscommon' -- CREATE TABLE newscommon ( counter int(11) NOT NULL default '0', ip varchar(20) NOT NULL default '' ) TYPE=MyISAM; -- -- Dumping data for table 'newscommon' -- INSERT INTO newscommon VALUES (3329,'218.71.13.165'); -- -- Table structure for table 'newskind' -- CREATE TABLE newskind ( kindId int(11) NOT NULL auto_increment, content varchar(255) NOT NULL default '', classId int(11) NOT NULL default '0', PRIMARY KEY (kindId) ) TYPE=MyISAM; -- -- Dumping data for table 'newskind' -- INSERT INTO newskind VALUES (1,'linux教程',1); INSERT INTO newskind VALUES (2,'学习笔记',1); -- -- Table structure for table 'newspopedom' -- CREATE TABLE newspopedom ( gradeId int(11) NOT NULL default '0', grade varchar(20) default NULL, PRIMARY KEY (gradeId) ) TYPE=MyISAM; -- -- Dumping data for table 'newspopedom' -- INSERT INTO newspopedom VALUES (3,'金牌会员'); INSERT INTO newspopedom VALUES (2,'银牌会员'); INSERT INTO newspopedom VALUES (1,'普通会员'); -- -- Table structure for table 'newsreply' -- CREATE TABLE newsreply ( replyId int(11) NOT NULL auto_increment, newsId int(11) NOT NULL default '0', user varchar(20) default NULL, content varchar(100) default NULL, replyTime varchar(20) default NULL, PRIMARY KEY (replyId) ) TYPE=MyISAM; -- -- Dumping data for table 'newsreply' -- INSERT INTO newsreply VALUES (1,5,'锦尘','不错，收获很大','2003-11-12'); INSERT INTO newsreply VALUES (2,12,'dfbhg','hdgfhbd','2003-11-30'); -- -- Table structure for table 'newsusr' -- CREATE TABLE newsusr ( userName varchar(20) NOT NULL default '', passWd varchar(20) NOT NULL default '', sex int(11) default NULL, question varchar(255) default NULL, answer varchar(255) default NULL, emailAddr varchar(50) default NULL, qq varchar(10) default NULL, http varchar(30) default NULL, purview int(11) default '1', regTime varchar(20) default NULL, PRIMARY KEY (userName) ) TYPE=MyISAM; -- -- Dumping data for table 'newsusr' -- INSERT INTO newsusr VALUES ('llj','123456',1,'who are you ?','sdfjsdf sd','fsd@ggdfg.dfd','','',1,'2003-10-02 18:16:36'); -- -- Table structure for table 'noteadmin' -- CREATE TABLE noteadmin ( adminName char(20) NOT NULL default '', adminPasswd char(20) NOT NULL default '', PRIMARY KEY (adminName) ) TYPE=MyISAM; -- -- Dumping data for table 'noteadmin' -- INSERT INTO noteadmin VALUES ('admin','ntskyyjl'); -- -- Table structure for table 'noteguest' -- CREATE TABLE noteguest ( noteId int(11) NOT NULL auto_increment, userName varchar(20) NOT NULL default '', sex int(11) NOT NULL default '0', email varchar(50) default NULL, qq varchar(9) default NULL, url varchar(50) default NULL, headTitle text NOT NULL, content text NOT NULL, image text, noteTime varchar(20) default NULL, PRIMARY KEY (noteId) ) TYPE=MyISAM; -- -- Dumping data for table 'noteguest' -- INSERT INTO noteguest VALUES (73,'admin',0,'redhatserver@tom.com','38998186','http://www.ntsky.com','欢迎大家测试！~','由于以前的留言本很乱，本人也不愿意将数据导入了。现在使用的是新版的，希望大家提出宝贵的意见！~~

旧版的javabean也完全提供给大家学习，希望大家能从中获益。

我的qq:  38998186和4932590','images/image/10.gif','2003-11-09 03:25:20'); -- -- Table structure for table 'notereply' -- CREATE TABLE notereply ( replyId int(11) NOT NULL auto_increment, noteId int(11) NOT NULL default '0', content text, replyTime varchar(20) default NULL, PRIMARY KEY (replyId) ) TYPE=MyISAM; -- -- Dumping data for table 'notereply' -- INSERT INTO notereply VALUES (1,76,'en','2003-11-12'); INSERT INTO notereply VALUES (2,79,'回家跟你好好说了，最近要做项目也许不会有很多的时间来这里。不过回家也不会有几天的。','2003-11-16');