新技术天地JSP+JAVABEAN+MYSQL新闻发布v1.0

drop database nt; create database nt; use nt; create table admin(username varchar(20) NOT NULL, password varchar(20) NOT NULL, passwordValidate varchar(20) NOT NULL, purview int not null, primary key(username), ); create table class(classid int NOT NULL, content varchar(255) NOT NULL, primary key(classid), ); create table kind(id int NOT NULL auto_increment, content varchar(255) NOT NULL, classid int NOT NULL, primary key(id), ); create table article(articleid int NOT NULL auto_increment, myorothers int NOT NULL, classid int NOT NULL, id int NOT NULL, title varchar(255) NOT NULL, content text NOT NULL, connection varchar(255), author varchar(20) NOT NULL, editor varchar(20), articlefrom varchar(40), hits int default 0, top int, state int default 0, tag int NOT NULL, date date, time datetime, primary key(articleid), ); create table reply(id int not null auto_increment, articleid int not null, user varchar(20), content varchar(100), date date, time datetime, primary key(id), ); create table usr(user varchar(20) NOT NULL, passwd varchar(20) NOT NULL, passwdvalidate varchar(20) NOT NULL, sex int, question varchar(255), answer varchar(255), email varchar(50), qq varchar(10), http varchar(30), purview int, loadtime datetime, primary key(user), ); create table popedom(gradeid int not null, grade varchar(20), primary key(gradeid), ); create table common(counter int not null, ); insert into class(classid,content) values(1,'linux入门'); insert into class(classid,content) values(2,'服务器配置'); insert into class(classid,content) values(3,'应用开发'); insert into class(classid,content) values(4,'数据库应用'); INSERT INTO class(classid,content) VALUES(5,'系统安全'); insert into kind(id,content,classid) values(1,'windows',2); insert into kind(id,content,classid) values(2,'linux',2); insert into kind(id,content,classid) values(3,'unix',2); insert into kind(id,content,classid) values(4,'jsp',3); insert into kind(id,content,classid) values(5,'java',3); insert into kind(id,content,classid) values(6,'xml',3); insert into kind(id,content,classid) values(7,'delphi',3); insert into kind(id,content,classid) values(8,'.net',3); insert into kind(id,content,classid) values(9,'oracle',4); insert into kind(id,content,classid) values(10,'mysql',4); insert into kind(id,content,classid) values(11,'mssql',4); insert into kind(id,content,classid) values(12,'安全防护',5); insert into kind(id,content,classid) values(13,'漏洞攻击',5); insert into kind(id,content,classid) values(14,'linux教程',1); insert into kind(id,content,classid) values(15,'学习笔记',1); insert into popedom(gradeid,grade) values(3,'金牌会员'); insert into popedom(gradeid,grade) values(2,'银牌会员'); insert into popedom(gradeid,grade) values(1,'普通会员'); INSERT INTO admin(username,password,purview) VALUES('ntsky','ntsky',0); INSERT INTO admin(username,password,purview) VALUES('yao','junlin',0);