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);
没有合适的资源?快使用搜索试试~ 我知道了~
NTsky新闻发布(提供JavaBean)v1.0.zip
共455个文件
gif:130个
jsp:116个
java:79个
需积分: 5 1 下载量 179 浏览量
2024-05-14
21:54:37
上传
评论
收藏 1.23MB ZIP 举报
温馨提示
NTsky新闻发布(提供JavaBean)v1.0
资源推荐
资源详情
资源评论
收起资源包目录
NTsky新闻发布(提供JavaBean)v1.0.zip (455个子文件)
title.jsp.bak 9KB
ubbaddarticle.jsp.bak 5KB
Search.java.bak 3KB
UserSearch.java.bak 2KB
insertarticle.jsp.bak 1KB
Jdbc_conn.java.bak 1KB
AdminSearch.java.bak 1KB
copyleft.jsp.bak 1KB
11.bmp 2KB
Develop.class 5KB
ListArticle.class 4KB
Database.class 4KB
Server.class 4KB
DBConnect.class 4KB
Personal.class 3KB
UBBUpdateArticle.class 3KB
UpdateArticle.class 3KB
Index.class 3KB
SryDefend.class 3KB
StmSecurity.class 3KB
Base.class 3KB
UpArticle.class 3KB
Reply.class 3KB
UBBInsertArticle.class 3KB
InsertArticle.class 3KB
Apply.class 3KB
Search.class 3KB
SecurityII.class 2KB
DatabaseII.class 2KB
DevelopII.class 2KB
BaseII.class 2KB
ServerII.class 2KB
UserSearch.class 2KB
AddAdminGo.class 2KB
FetchPwd.class 2KB
InsArticle.class 2KB
UPAdmin.class 2KB
CheckUser.class 2KB
UpUser.class 2KB
EditArticle.class 2KB
Jdbc_conn.class 2KB
EditArticle.class 2KB
UpdateKind.class 2KB
UBBAddArticleIo.class 2KB
EditArticleIo.class 2KB
AddArticleIo.class 2KB
Kind.class 2KB
User.class 2KB
CheckLogin.class 2KB
UserArticle.class 2KB
EditKind.class 2KB
UpdateColumn.class 2KB
AddAdmin.class 2KB
Pagination.class 2KB
InsertColumn.class 2KB
AdminSearch.class 2KB
RegisterIO.class 2KB
AddArticle.class 2KB
EditUserIO.class 2KB
EditColumn.class 2KB
SHArticle.class 2KB
DelArticle.class 1KB
DelArticle.class 1KB
Format_io.class 1KB
BackUser.class 1KB
DelBackUser.class 1KB
DelAdmin.class 1KB
Article.class 1KB
DelUser.class 1KB
ShowMan.class 1KB
Column.class 1KB
DelColumn.class 1KB
CodeFilter.class 1KB
Counter.class 1KB
UBBCodeFilter.class 1KB
UPArticle.class 1KB
Default.class 1KB
DelKind.class 1KB
InsertKind.class 1KB
UserArticleIO.class 1KB
UserArticleIO.class 1KB
EditAdmin.class 1KB
EditUser.class 1KB
ColumnIO.class 872B
CheckIO.class 652B
KindIO.class 581B
Register.class 201B
text.css 2KB
text.css 938B
admin.css 524B
Thumbs.db 138KB
Thumbs.db 19KB
Thumbs.db 13KB
.DS_Store 6KB
.DS_Store 6KB
linux_network.gif 28KB
linux_setup.gif 24KB
linux_network_2.gif 22KB
linux_network_4.gif 21KB
linux_network_3.gif 21KB
共 455 条
- 1
- 2
- 3
- 4
- 5
资源评论
趙兴晨
- 粉丝: 1371
- 资源: 224
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功