drop table memberspace;
drop table memberinfo;
drop table graderecord;
drop table pointrecord;
drop table pointaction;
drop table messagerecord;
drop table blackrecord;
drop table friendrecord;
drop table provinces;
create table graderecord(
id number primary key,
minpoint number not null,
maxpoint number not null,
gradename varchar2(20) not null,
iconpath varchar2(50) not null
);
create table memberinfo (
id number primary key,
nickname varchar2(20) unique not null,
password varchar2(50) not null,
gender varchar2(10) not null,
age number not null,
email varchar2(100) not null,
provincecity varchar2(20),
address varchar2(200),
phone varchar2(50),
passwordquestion varchar2(200),
passwordanswer varchar2(200),
recommender varchar2(20),
point number default 0,
registerdate date,
latestdate date,
status number default 0,
isonline number default 0,
gradeid number,
constraint info_grade foreign key(gradeid) references graderecord(id)
);
create table memberspace(
id number primary key,
opinion varchar2(200),
runtime varchar2(20),
runplace varchar2(20),
runstar varchar2(50),
runhabit varchar2(50),
cellphone varchar2(50),
icon varchar2(200),
memberid number,
constraint space_info foreign key(memberid) references memberinfo(id)
);
create table pointaction(
id number primary key,
actionname varchar2(20),
point number not null,
description varchar2(200)
);
create table pointrecord(
id number primary key,
nickname varchar2(20) not null,
receivedate date not null,
pointactionid number ,
constraint record_action foreign key(pointactionid) references pointaction(id)
);
create table messagerecord(
id number primary key,
sender varchar2(20) not null,
receiver varchar2(20) not null,
senddate date not null,
title varchar2(100) not null,
content varchar2(300) not null,
senderstatus number default 0,
receiverstatus number default 0,
status number default 0
);
create table friendrecord(
id number primary key,
selfname varchar2(20) not null,
friendname varchar2(20) not null
);
create table blackrecord(
id number primary key,
selfname varchar2(20) not null,
blackname varchar2(20) not null
);
create table provinces(
id number primary key,
province varchar2(20) not null
);
create sequence SEQ_COMMON increment by 1 start with 1;
create sequence SEQ_RECORD increment by 1 start with 1;
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(1,'REGISTER',50,N'注册会员');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(2,'RECOMMEND',20,N'推荐会员');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(3,'LOGIN',3,N'登录');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(4,'LOGINDESKHELPER',3,N'登录桌面助手');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(5,'CREATEPERSONALSPACE',25,N'创建个人空间');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(6,'SENDSTICK',25,N'发帖');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(7,'REPLYSTICK',25,N'回帖');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(8,'GOODSTICK',30,N'精华贴');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(9,'SUPERGOODSTICK',60,N'超级精华贴');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(10,'BBSMANAGER',200,N'成为版主');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(11,'REPLYSTICK',5,N'每10个回复帖子楼主+5');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(12,'EDM',10,N'成为版主');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(13,'JOINRUNNING',500,N'参加都市跑活动');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(14,'WINRUNNING1',5000,N'都市跑活动得名次');
INSERT INTO PointAction
(id,ActionName,Point,Description) Values(15,'WINRUNNING2',4000,N'都市跑活动得名次');
INSERT INTO GradeRecord VALUES(1,0,300,'业余爱好者','/images/face1.gif');
INSERT INTO GradeRecord VALUES(2,300,700,'跑步小将','/images/face2.gif');
INSERT INTO GradeRecord VALUES(3,700,1200,'跑步健将','/images/face3.gif');
INSERT INTO GradeRecord VALUES(4,1200,1800,'专业运动员','/images/face4.gif');
INSERT INTO GradeRecord VALUES(5,1800,2500,'顶级运动员','/images/face5.gif');
insert into provinces values(1,'北京');
insert into provinces values(2,'上海');
insert into provinces values(3,'天津');
insert into provinces values(4,'重庆');
insert into provinces values(5,'辽宁');
insert into provinces values(6,'广东');
insert into provinces values(7,'浙江');
insert into provinces values(8,'江苏');
insert into provinces values(9,'山东');
insert into provinces values(10,'四川');
insert into provinces values(11,'黑龙江');
insert into provinces values(12,'湖南');
insert into provinces values(13,'湖北');
insert into provinces values(14,'福建');
insert into provinces values(15,'陕西');
insert into provinces values(16,'河南');
insert into provinces values(17,'安徽');
insert into provinces values(18,'河北');
insert into provinces values(19,'吉林');
insert into provinces values(20,'江西');
insert into provinces values(21,'广西');
insert into provinces values(22,'山西');
insert into provinces values(23,'内蒙古');
insert into provinces values(24,'甘肃');
insert into provinces values(25,'贵州');
insert into provinces values(26,'新疆');
insert into provinces values(27,'云南');
insert into provinces values(28,'宁夏');
insert into provinces values(29,'海南');
insert into provinces values(30,'青海');
insert into provinces values(31,'西藏');
insert into provinces values(32,'港澳台');
insert into provinces values(33,'海外');
insert into provinces values(34,'其他');
commit;
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
跑步运动社区网站源码 (166个子文件)
MemberDaoImpl.class 15KB
MessengerDaoImpl.class 9KB
MD5.class 8KB
MemberServiceImpl.class 7KB
Memberinfo.class 6KB
SearchFriendServlet.class 5KB
DelFriendServlet.class 4KB
MessengerServiceImpl.class 3KB
RegisterServlet.class 3KB
ModifyServlet.class 3KB
FindPassword.class 3KB
Messagerecord.class 3KB
SpaceServlet.class 3KB
SendServlet.class 3KB
Memberspace.class 3KB
LoginServlet.class 2KB
FriendServlet.class 2KB
FindMessStatus.class 2KB
Graderecord.class 2KB
ModifySpace.class 2KB
ViewServlet.class 2KB
Pointaction.class 2KB
DelMessServlet.class 2KB
Pointrecord.class 2KB
Test.class 2KB
IMemberDao.class 2KB
ConnectDBFactory.class 2KB
SessionListener.class 2KB
DelBlackServlet.class 2KB
IMessengerDao.class 1KB
ExitServlet.class 1KB
IMessengerService.class 1KB
IMemberService.class 1KB
ConnectionTransation.class 1KB
TestFilter.class 1KB
Friendrecord.class 1KB
Blackrecord.class 1KB
Page.class 905B
MessengerServiceException.class 841B
MemberServiceException.class 832B
Provinces.class 767B
TransationManager.class 699B
MessengerFactory.class 639B
MemberDaoImplFactory.class 633B
Transaction.class 194B
.classpath 550B
style.css 5KB
style1.css 4KB
Thumbs.db 59KB
face2.gif 17KB
top.gif 15KB
logo.gif 8KB
face4.gif 6KB
face1.gif 5KB
tab01.gif 4KB
error.gif 3KB
face3.gif 3KB
face5.gif 2KB
topcenter02.gif 1KB
icon03.gif 1KB
icon05.gif 1KB
icon04.gif 1024B
icon13.gif 1022B
icon15.gif 1013B
icon01.gif 1006B
bottomright.gif 951B
bottomleft.gif 949B
button_delete.gif 676B
topright.gif 663B
topleft.gif 613B
delete.gif 609B
icon06.gif 597B
icon12.gif 592B
icon14.gif 562B
search.gif 546B
bg02.gif 401B
icon07.gif 355B
bottomcenter.gif 284B
icon16.gif 282B
icon17.gif 281B
bg01.gif 273B
topcenter.gif 259B
top_bg.gif 157B
centerleft.gif 128B
centeright.gif 124B
icon09.gif 111B
icon10.gif 105B
classes12.jar 1.35MB
standard.jar 384KB
jstl.jar 20KB
MemberDaoImpl.java 17KB
MessengerDaoImpl.java 8KB
MD5.java 8KB
MemberServiceImpl.java 7KB
Memberinfo.java 5KB
MessengerServiceImpl.java 3KB
SearchFriendServlet.java 3KB
Messagerecord.java 3KB
RegisterServlet.java 3KB
Memberspace.java 2KB
共 166 条
- 1
- 2
资源评论
- liuxiong09012013-07-05运行不了,求解决
jlxy527
- 粉丝: 20
- 资源: 7
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Screenshot_20240427_031602.jpg
- 网页PDF_2024年04月26日 23-46-14_QQ浏览器网页保存_QQ浏览器转格式(6).docx
- 直接插入排序,冒泡排序,直接选择排序.zip
- 在排序2的基础上,再次对快排进行优化,其次增加快排非递归,归并排序,归并排序非递归版.zip
- 实现了7种排序算法.三种复杂度排序.三种nlogn复杂度排序(堆排序,归并排序,快速排序)一种线性复杂度的排序.zip
- 冒泡排序 直接选择排序 直接插入排序 随机快速排序 归并排序 堆排序.zip
- 课设-内部排序算法比较 包括冒泡排序、直接插入排序、简单选择排序、快速排序、希尔排序、归并排序和堆排序.zip
- Python排序算法.zip
- C语言实现直接插入排序、希尔排序、选择排序、冒泡排序、堆排序、快速排序、归并排序、计数排序,并带图详解.zip
- 常用工具集参考用于图像等数据处理
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功