仿yeeyoo 网运行说明文档截图+说明

仿yeeyoo 网运行说明文档截图+说明

 

详细截图请下载：
http://download.csdn.net/source/655775
源码将在近期服务器稳定后发布，供大家免费下载

 

此说明只是大略的介绍下本项目涉及到的知识和应运
1.密码MD5加密
2.注册验证码生成
3.ajax无刷新技术,主要有页面刷新和二级菜单联动和文本提交等
4.注册成功后生成自己相对应的个问文件夹,路径在${tomcat }/webhaps/yeeyoo/users/文件下
5.在对自己的个性图象可以加以上传修改
6.对自己的个人空间域名的修改,这样,就涉及到自己的那个注册生成的相对应的文件夹的名称修改
7.密码找回功能.需要联网支持,根据本用户的注册邮箱把修改密码的连接发送到改用户的邮箱中,然后再点击该连接进行修改
自己的密码,防止别人盗链
8.跨邮箱登陆功能.http://222.131.15.247:223/yeeyoo/jsp/login/email.jsp 支持多邮箱
9.session,cookie等储存用户信息技术
10.个人资料信息管理
11.个人站内信息管理，发送等
12.个人相册管理
13.个人日记管理
………没有一一列出了

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

接下来把最后次修改的SQL 数据库脚本粘上:
****yeeyoo 网站sql 脚本2.0 版
--create database yeeyoo
use yeeyoo
'--地区
create table diqu
(
d_id int identity primary key,
d_sheng varchar(20),
d_city varchar(20),
d_grade int default 0
)'
--摸板
create table moban
(
m_id int identity primary key,
m_name varchar(20),
m_grade int default 0,
)
仿yeeyoo 网运行说明文档截图
第28 页共53 页
--自定义摸板
create table moban_geren
(
mg_id int identity primary key,
mg_name varchar(20),
mg_text text,
mg_u_id int,
mg_grade int default 0
)
'--交友目的
create table jiaoyoumudi
(
jm_id int identity primary key,
jm_name varchar(20),
jm_grade int default 0
)
--职业
create table zhiye
(
zy_id int identity primary key,
zy_name varchar(20),
zy_grade int default 0
)
--个性
create table gexing
(
gx_id int identity primary key,
gx_name varchar(20),
gx_grade int default 0
)
--兴趣
create table xingqu
(
xq_id int identity primary key,
xq_name varchar(20),
xq_grade int default 0
仿yeeyoo 网运行说明文档截图
第29 页共53 页
)'
--
**************************************************************************************************************
*
--用户资料块
--
**************************************************************************************************************
**
--用户表
--drop table users
create table users
(
u_id int identity primary key,
u_email varchar(100) unique,
u_name varchar(20) unique,
u_pwd varchar(35),
u_sex bit default 0,
u_birthday datetime,
u_addr_sheng varchar(20),
u_addr_city varchar(20),
u_image varchar(200),
u_jifen int default 5,--每次登陆一次加5 分每增加一个好友1 分发表一篇日志3 分添加一首音乐2 分相册2 分获得
留言1 分
u_grade int default 0,
u_zaixian int,
u_fangsaorao int default 0 , --0 为无限制1 为防骚扰2 为不允许其他
u_time datetime default getdate()
)
--用于基本资料
create table users_all
(
ua_id int identity primary key,
ua_nicheng varchar(20),
ua_u_id int,
ua_jm_id int,
ua_zy_id int,
ua_yueshouru int,--数字代表收入等级
ua_xueli int,
ua_hunyin int,
ua_guxiang_sheng varchar(20),
ua_guxiang_city varchar(50),
ua_shengao int,
仿yeeyoo 网运行说明文档截图
第30 页共53 页
ua_tixing varchar(10),
ua_gx_id int,
ua_grade int default 0
)
--用户高级资料
create table users_all_fujia
(
uaf_id int identity primary key,
uaf_u_id int,
uaf_haoshi varchar(200),
uaf_huaishi varchar(200),
uaf_xingyun varchar(200),
uaf_taoyan varchar(200),
uaf_xinyuan varchar(200),
uaf_grade int default 0
)
--用户兴趣爱好
create table users_xq
(
uz_id int identity primary key,
ux_u_id int,
ux_xq_id int,
ux_yinyue varchar(50),
ux_dianying varchar(50),
ux_youxi varchar(50),
ux_shu varchar(50),
ux_mingxing varchar(50),
ux_difang varchar(50),
ux_yundong varchar(50),
ux_caiyao varchar(50),
ux_grade int default 0
)
--用户择友条件
create table users_zy
(
uz_id int identity primary key,
uz_u_id int,
uz_jm_id int,
uz_sex bit default 0,--表示要寻找的的朋友的性别
仿yeeyoo 网运行说明文档截图
第31 页共53 页
uz_min_age int default 1,
uz_max_age int default 200,
uz_hunyin int default 0,
uz_addr_sheng varchar(20),
uz_addr_city varchar(20),
uz_gx_id int,
uz_grade int default 0
)
--个性域名
create table gexingyuming
{
gy_id int identity primary key,
gy_name varchar(20) unique,
gy_u_id int,
gy_grade int default 0
}
--
**************************************************************************************************************
*
--用户空间块
--
**************************************************************************************************************
**
--日记分类
create table riji_fenlei
(
rf_id int identity primary key,
rf_name varchar(30),
rf_pwd varchar(35),
rf_u_id int,
rf_grade int default 0
)
--日记
create table riji
(
r_id int identity primary key,
r_title varchar(100),
r_rf_id int,
r_name text,
r_u_id int,
仿yeeyoo 网运行说明文档截图
第32 页共53 页
r_pinlun bit default 1,--
r_grade int default 0
)
--相册分类
create table xiangce_fenlei
(
xf_id int identity primary key,
xf_name varchar(30),
xf_pwd varchar(35),
xf_u_id int,
xf_grade int default 1
)
--相册
create table xiangce
(
x_id int identity primary key,
x_name varchar(50),
xf_lujing varchar(50),
x_xf_id int,
x_u_id int,
)
--音乐分类
create table yinyue_fenlei
(
yf_id int identity primary key,
yf_name varchar(20),
yf_pwd varchar(35),
yf_u_id int,
yf_grade int default 0 --1 为空间背景音乐
)
--音乐
create table yinyue
(
y_id int identity primary key,
y_name varchar(20),--歌名
y_addr varchar(100),
y_musicname varchar(10),--歌手名
y_yf_id int,
y_u_id int,
y_grade int default 0
)
仿yeeyoo 网运行说明文档截图
第33 页共53 页
--留言
create table liuyan
(
l_id int identity primary key,
l_d_u_id int,--留言对象用户的ID
l_name text,
l_u_id int,
l_grade int default 0
)
--日记留言
create table riji_liuyan
(
rl_id int identity primary key,
rl_d_u_id int,
rl_name text,
rl_u_id int,
rl_r_id int,
rl_grade int default 0
)
--相册留言
create table xiangce_liuyan
(
xl_id int identity primary key,
xl_d_u_id int,
xl_name text,
xl_u_id int,
xl_x_id int,
xl_grade int default 0
)
--???????????????????????????????????????????????????????????????????????????????????????????????????????
--剩下的设计：《我的站内信》《我的好友》《我的关注》《我的帐户》《我的互动》《友情连接》
--??????????????????????????????????????????????????????????????????????????????????????????????????????
--我的站内信
仿yeeyoo 网运行说明文档截图
第34 页共53 页
create table xinjian
(
xj_id int identity primary key,
xj_fajianren_id int,
xj_zhuti varchar(50),
xj_data datetime default getdate(),
xj_shoujianren_id int,
xj_grade int default 0 --0 为已经读1 为未读
)
--好友分组
create table haoyou_group
(
hg_id int identity primary key,
hg_name varchar(20),
hg_u_id int,
hg_grade int default 0
)
--好友表
create table haoyou
(
h_id int identity primary key,
h_u_id int,--用户ID
h_u_duiying_id int,--对应好友ID
h_grade int default 0 --0 为无限制1 为防骚扰2 为黑名单
)
--关注新鲜事设置
create table guanzhu_xinxian
(
gzxx_id int identity primary key,
gzxx_name varchar(20),
gzxx_u_id int,
gzxx_grade int default 0 -- 0 为默认关注1 为不关注
)
--发布征友启事
create table zhengyou
(
zy_id int identity primary key,
zy_zhuti varchar(50),
zy_text text,
仿yeeyoo 网运行说明文档截图
第35 页共53 页
zy_u_id int,
zy_date datetime default getdate(),
zy_grade int default 0
)
--友情连接
create table youqing
(
y_id int identity primary key,
y_name varchar(40),
y_url varchar(100),
y_leibie bit , ---0 为文字连接1 为图片连接
y_tupian_url varchar(100),
y_grade int default 0
)
select * from moban
select * from moban_geren
select * from jiaoyoumudi
select * from zhiye
select * from gexing
select * from xingqu
select * from users
select * from users_all
select * from users_all_fujia
select * from users_xq
select * from users_zy
select * from riji_fenlei
select * from riji
select * from xiangce_fenlei
select * from xiangce
select * from yinyue_fenlei
select * from yinyue
select * from liuyan
select * from riji_liuyan
select * from xiangce_liuyan
select * from xinjian
select * from haoyou_group
select * from haoyou
仿yeeyoo 网运行说明文档截图
第36 页共53 页
select * from guanzhu_xinxian
select * from zhengyou
select * from youqing
drop table xingqingimg
create table xingqingimg
(
xqi_id int identity primary key,
xqi_addr varchar(30),
xqi_grade int
)
--insert into xingqingimg values('whatchutalkingabout_smile.gif',0)
select * from xingqingimg
drop table beijingyinyue
create table beijingyinyue
(
by_id int identity primary key,
--by_name varchar(20),
by_lujing varchar(100),
by_u_id int,
by_grade int --0 为不为背景音乐，1 为背景音乐
)
select * from beijingyinyue
drop table liaotian
create table liaotian
(
l_id int identity primary key,
l_send varchar(20),
l_con varchar(6000),
l_get varchar(20) default '大家',
l_date datetime default getdate(),
l_grade int ,
)
select * from liaotian
仿yeeyoo 网运行说明文档截图
第37 页共53 页
create table bug
(
b_id int identity primary key,
b_name varchar(20),
b_text text,
b_date datetime,
b_grade int
)
select * from bug
-------共28 张表--------
*****yeeyoo
网站sql
脚本3.0
版
create database yeeyoo
use yeeyoo
CREATE TABLE [dbo].[beijingyinyue] (
[by_id] [int] IDENTITY (1, 1) NOT NULL ,
[by_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[by_lujing] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[by_u_id] [int] NULL ,
[by_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[bug] (
[b_id] [int] IDENTITY (1, 1) NOT NULL ,
[b_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[b_text] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[b_date] [datetime] NULL ,
[b_grade] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[diqu] (
[d_id] [int] IDENTITY (1, 1) NOT NULL ,
[d_sheng] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[d_city] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[d_grade] [int] NULL
仿yeeyoo 网运行说明文档截图
第38 页共53 页
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[gexing] (
[gx_id] [int] IDENTITY (1, 1) NOT NULL ,
[gx_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[gx_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[gexingyuming] (
[gy_id] [int] IDENTITY (1, 1) NOT NULL ,
[gy_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[gy_u_id] [int] NULL ,
[gy_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[guanzhu_xinxian] (
[gzxx_id] [int] IDENTITY (1, 1) NOT NULL ,
[gzxx_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[gzxx_u_id] [int] NULL ,
[gzxx_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[haoyou] (
[h_id] [int] IDENTITY (1, 1) NOT NULL ,
[h_u_id] [int] NULL ,
[h_u_duiying_id] [int] NULL ,
[h_hg_id] [int] NULL ,
[h_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[haoyou_group] (
[hg_id] [int] IDENTITY (1, 1) NOT NULL ,
[hg_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[hg_u_id] [int] NULL ,
[hg_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[jiaoyoumudi] (
仿yeeyoo 网运行说明文档截图
第39 页共53 页
[jm_id] [int] IDENTITY (1, 1) NOT NULL ,
[jm_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[jm_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[liaotian] (
[l_id] [int] IDENTITY (1, 1) NOT NULL ,
[l_send] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[l_con] [varchar] (6000) COLLATE Chinese_PRC_CI_AS NULL ,
[l_get] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[l_date] [datetime] NULL ,
[l_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[liuyan] (
[l_id] [int] IDENTITY (1, 1) NOT NULL ,
[l_d_u_id] [int] NULL ,
[l_name] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[l_u_id] [int] NULL ,
[l_grade] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[moban] (
[m_id] [int] IDENTITY (1, 1) NOT NULL ,
[m_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[m_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[moban_geren] (
[mg_id] [int] IDENTITY (1, 1) NOT NULL ,
[mg_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[mg_text] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[mg_u_id] [int] NULL ,
[mg_grade] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[riji] (
[r_id] [int] IDENTITY (1, 1) NOT NULL ,
[r_title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
仿yeeyoo 网运行说明文档截图
第40 页共53 页
[r_rf_id] [int] NULL ,
[r_name] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[r_u_id] [int] NULL ,
[r_pinlun] [bit] NULL ,
[r_grade] [int] NULL ,
[r_data] [datetime] NULL ,
[r_jishu] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[riji_fenlei] (
[rf_id] [int] IDENTITY (1, 1) NOT NULL ,
[rf_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[rf_pwd] [varchar] (35) COLLATE Chinese_PRC_CI_AS NULL ,
[rf_u_id] [int] NULL ,
[rf_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[riji_liuyan] (
[rl_id] [int] IDENTITY (1, 1) NOT NULL ,
[rl_d_u_id] [int] NULL ,
[rl_name] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[rl_u_id] [int] NULL ,
[rl_r_id] [int] NULL ,
[rl_grade] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[test] (
[tid] [int] IDENTITY (1, 1) NOT NULL ,
[tname] [varchar] (5000) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[users] (
[u_id] [int] IDENTITY (1, 1) NOT NULL ,
[u_email] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[u_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[u_pwd] [varchar] (35) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[u_sex] [bit] NOT NULL ,
[u_birthday] [datetime] NULL ,
[u_addr_sheng] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[u_addr_city] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
仿yeeyoo 网运行说明文档截图
第41 页共53 页
[u_image] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[u_jifen] [int] NULL ,
[u_grade] [int] NULL ,
[u_fangsaorao] [int] NULL ,
[u_time] [datetime] NULL ,
[u_fangwen] [int] NULL ,
[u_zaixian] [bit] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[users_all] (
[ua_id] [int] IDENTITY (1, 1) NOT NULL ,
[ua_nicheng] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ua_u_id] [int] NULL ,
[ua_jm_id] [int] NULL ,
[ua_zy_id] [int] NULL ,
[ua_yueshouru] [int] NULL ,
[ua_xueli] [int] NULL ,
[ua_hunyin] [int] NULL ,
[ua_guxiang_sheng] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ua_guxiang_city] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ua_shengao] [int] NULL ,
[ua_tixing] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ua_gx_id] [int] NULL ,
[ua_jieshao] [varchar] (6000) COLLATE Chinese_PRC_CI_AS NULL ,
[ua_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[users_all_fujia] (
[uaf_id] [int] IDENTITY (1, 1) NOT NULL ,
[uaf_u_id] [int] NULL ,
[uaf_haoshi] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[uaf_huaishi] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[uaf_xingyun] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[uaf_taoyan] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[uaf_xinyuan] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[uaf_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[users_xq] (
[uz_id] [int] IDENTITY (1, 1) NOT NULL ,
[ux_u_id] [int] NULL ,
仿yeeyoo 网运行说明文档截图
第42 页共53 页
[ux_xq_id] [int] NULL ,
[ux_yinyue] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ux_dianying] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ux_youxi] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ux_shu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ux_mingxing] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ux_difang] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ux_yundong] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ux_caiyao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ux_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[users_zy] (
[uz_id] [int] IDENTITY (1, 1) NOT NULL ,
[uz_u_id] [int] NULL ,
[uz_jm_id] [int] NULL ,
[uz_sex] [bit] NULL ,
[uz_min_age] [int] NULL ,
[uz_max_age] [int] NULL ,
[uz_hunyin] [int] NULL ,
[uz_addr_sheng] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[uz_addr_city] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[uz_gx_id] [int] NULL ,
[uz_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[xiangce] (
[x_id] [int] IDENTITY (1, 1) NOT NULL ,
[x_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[xf_lujing] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[x_xf_id] [int] NULL ,
[x_u_id] [int] NULL ,
[x_jishu] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[xiangce_fenlei] (
[xf_id] [int] IDENTITY (1, 1) NOT NULL ,
[xf_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[xf_pwd] [varchar] (35) COLLATE Chinese_PRC_CI_AS NULL ,
[xf_u_id] [int] NULL ,
[xf_grade] [int] NULL ,
仿yeeyoo 网运行说明文档截图
第43 页共53 页
[md5] [char] (32) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[xiangce_liuyan] (
[xl_id] [int] IDENTITY (1, 1) NOT NULL ,
[xl_d_u_id] [int] NULL ,
[xl_name] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[xl_u_id] [int] NULL ,
[xl_x_id] [int] NULL ,
[xl_grade] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[xingqingimg] (
[xqi_id] [int] IDENTITY (1, 1) NOT NULL ,
[xqi_addr] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[xqi_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[xingqu] (
[xq_id] [int] IDENTITY (1, 1) NOT NULL ,
[xq_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[xq_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[xinjian] (
[xj_id] [int] IDENTITY (1, 1) NOT NULL ,
[xj_fajianren_id] [int] NULL ,
[xj_zhuti] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[xj_neirong] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
[xj_data] [datetime] NULL ,
[xj_shoujianren_id] [int] NULL ,
[xj_grade] [int] NULL ,
[xj_fajsq] [int] NULL ,
[xj_shjsq] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[yinyue] (
[y_id] [int] IDENTITY (1, 1) NOT NULL ,
[y_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
仿yeeyoo 网运行说明文档截图
第44 页共53 页
[y_addr] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[y_musicname] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[y_yf_id] [int] NULL ,
[y_u_id] [int] NULL ,
[y_grade] [int] NULL ,
[y_jishu] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[yinyue_fenlei] (
[yf_id] [int] IDENTITY (1, 1) NOT NULL ,
[yf_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[yf_pwd] [varchar] (35) COLLATE Chinese_PRC_CI_AS NULL ,
[yf_u_id] [int] NULL ,
[yf_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[youqing] (
[y_id] [int] IDENTITY (1, 1) NOT NULL ,
[y_name] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[y_url] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[y_leibie] [bit] NULL ,
[y_tupian_url] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[y_grade] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[zhengyou] (
[zy_id] [int] IDENTITY (1, 1) NOT NULL ,
[zy_zhuti] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[zy_text] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[zy_u_id] [int] NULL ,
[zy_date] [datetime] NULL ,
[zy_grade] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[zhiye] (
[zy_id] [int] IDENTITY (1, 1) NOT NULL ,
[zy_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[zy_grade] [int] NULL
) ON [PRIMARY]
GO
仿yeeyoo 网运行说明文档截图
第45 页共53 页
select * from moban
select * from moban_geren
select * from jiaoyoumudi
select * from zhiye
select * from gexing
select * from xingqu
select * from users
select * from users_all
select * from users_all_fujia
select * from users_xq
select * from users_zy
select * from riji_fenlei
select * from riji
select * from xiangce_fenlei
select * from xiangce
select * from yinyue_fenlei
select * from yinyue
select * from liuyan
select * from riji_liuyan
select * from xiangce_liuyan
select * from xinjian
select * from haoyou_group
select * from haoyou
select * from guanzhu_xinxian
select * from zhengyou
select * from youqing
select * from liaotian
select * from bug
-------共28 张表--------
用户注册后生成文件核心代码:
Md5Code md5=new Md5Code();
仿yeeyoo 网运行说明文档截图
第46 页共53 页
pwd=md5.MD5Encode(pwd);
Date u_time=Calendar.getInstance().getTime();
String email=firsreamil+"@"+lastemail;
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
Date birthdar=null;
try {
birthdar = format.parse(yy+"-"+mm+"-"+dd);
} catch (ParseException e) {
// TODO 自动生成catch 块
e.printStackTrace();
}
//System.out.println("birthdar===="+birthdar);
Byte u_sex=Byte.parseByte(sex);
UsersBo ub=new UsersBo();
if(ub.addUsers(email,username,pwd,u_sex,birthdar,sheng,city,u_time))
{
//try {
//new File("../yeeyoo/users/"+username).mkdir();
String name="users";
String path1=request.getRealPath("/")+name+"/"+username+"/";
System.out.println(path1);
File aa=new File(path1);
if(!aa.exists())
{
boolean b=aa.mkdirs();
System.out.println(b);
}
String path2=path1+"image/temp";
File bb=new File(path2);
if(!bb.exists())
{
bb.mkdirs();
仿yeeyoo 网运行说明文档截图
第47 页共53 页
}
String path3=path1+"image/upload";
File bb2=new File(path3);
if(!bb2.exists())
{
bb2.mkdirs();
}
/*
String path2=path1+username+"/";
System.out.println(path2);
File bb=new File(path2);
if(!bb.exists())
{
boolean cc=bb.mkdir();
System.out.println(cc);
}
*/
//} catch (Exception e) {
// e.printStackTrace();
// TODO: handle exception
//}
FileInputStream in=null;
FileOutputStream out=null;
try {
in=new FileInputStream(request.getRealPath("/jsp/index/index.jsp"));
out=new FileOutputStream(request.getRealPath("/")+name+"/"+username+"/index.jsp");
byte buff[]=new byte[1024];
int len;
try {
while((len=in.read(buff))>-1)
{
out.write(buff,0,len);
}
} catch (IOException e) {
// TODO 自动生成catch 块
e.printStackTrace();
}
} catch (FileNotFoundException e) {
// TODO 自动生成catch 块
仿yeeyoo 网运行说明文档截图
第48 页共53 页
e.printStackTrace();
}
finally
{
try {
in.close();
out.close();
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}
}
ArrayList al=ub.ShowUsernameString(username);
Users u=(Users)al.get(0);
request.getSession().setAttribute("u_id",u.getUId()+"");
//System.out.println("u_id fhgjhgdfhgfjhgkjhlkj;==="+u.getUId());
request.getSession().setAttribute("u_name", username);
request.getSession().setAttribute("u_grade", u.getUGrade()+"");
request.getSession().setAttribute("u_jifen", u.getUJifen()+"");
UsersAllBo uab=new UsersAllBo();
uab.addUsersAll(u.getUId());
new UsersAllFujianBo().addUsersFujian(u.getUId());
new UsersXqBo().addUsersXq(u.getUId());
new UsersZyBo().addUsersZy(u.getUId());
new GexingyumingBo().addGexingyuming(u.getUId(),u.getUName());
new RiJiFenleiBo().addrijifenlei("默认分类", u.getUId());
new YInyueFenleiBo().AddyinyueFenleiStringnameUid("默认分类", u.getUId());
new HaoyouGroupBo().AddHaoyouGroupUidShting("我的好友", u.getUId());
ub.updateUsersZiaxian(u.getUId());
上传文件核心代码:
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String geter = "";
String title = "";
String content = "";
仿yeeyoo 网运行说明文档截图
第49 页共53 页
String md5 = "";
this.request = request;
this.response = response;
response.setContentType(CONTENT_TYPE);
hs = request.getSession(true);
u = (Users) hs.getAttribute("myinfo");
//System.out.println("realPath===========" + request.getRealPath("/"));
DiskFileUpload dfu = new DiskFileUpload();
// 设置允许上传文件的大小
dfu.setSizeMax(100 * 1024 * 1024);
// 设置在内存中存储数据的大小
dfu.setSizeThreshold(4096);
// 如果文件超过Threshold 的值,就将它存放的d:/charSystem/file/temp/ 文件夹里
dfu.setRepositoryPath(request.getRealPath("/") + "inc/temp/");
// 开始读取上传信息
List fileList = null;
try {
fileList = dfu.parseRequest(this.request);
} catch (FileUploadException ex) {
System.out.println("转换request 异常!");
ex.printStackTrace();
}
// 迭代器
// java.util.Iterator it=fileList.iterator();
Iterator it = fileList.iterator();
System.out.println("11");
while (it.hasNext()) {
System.out.println("22");
FileItem fi = (FileItem) it.next();
// 说明是文件
String filename = fi.getName().substring(
fi.getName().lastIndexOf("//") + 1);
System.out.println("filename11111111111======" + filename);
仿yeeyoo 网运行说明文档截图
第50 页共53 页
String lastfilename = filename
.substring(filename.lastIndexOf(".") + 1);
System.out.println("lastfilename============"+lastfilename);
if (lastfilename.equals("jpg") || lastfilename.equals("gif")
|| lastfilename.equals("jpeg") || lastfilename.equals("JPG")
|| lastfilename.equals("GIF") || lastfilename.equals("JPEG")
|| lastfilename.equals("PNG") || lastfilename.equals("png")) {
System.out.println("lastfilename1============"+lastfilename);
//request.setAttribute("wenjianerr", "false");
//response.sendRedirect("/yeeyoo/jsp/users/right_index2_top.jsp");
//} else {
// System.out.println("lastfilename2============"+lastfilename);
md5 = RandomGUID.newGuid();
long size = fi.getSize();
System.out.println("size===========" + size);
try {
if (filename != null && !filename.equals(" ")) {
// System.out.println("filename222222222222==========="+filename);
fi.write(new File(request.getRealPath("/")
+ "inc/upload/" + md5+"."+lastfilename));
}
System.out.println("上传成功");
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
System.out.println("上传失败");
}
int uid = Integer.parseInt((String) request.getSession()
.getAttribute("u_id"));
UsersBo ub = new UsersBo();
ub.updateUsersU_image(md5+"."+lastfilename, uid);
Users u=(Users)((ArrayList)ub.ShowUsersUIDALL(uid)).get(0);
ub.updateUsersJifen(u.getUJifen()+1,uid);
request.getSession().setAttribute("wenjianerr", "true1");
//response.sendRedirect("/yeeyoo/jsp/users");
}
else
仿yeeyoo 网运行说明文档截图
第51 页共53 页
{
System.out.println("lastfilename2============"+lastfilename);
request.getSession().setAttribute("wenjianerr", "false1");
}
}
response.sendRedirect("/yeeyoo/jsp/users");
/*
* String name=request.getParameter("filename");
* System.out.println("name======"+name);
*
* Iterator it=fileList.iterator(); while(it.hasNext()) {
* System.out.println("44"); FileItem fi=(FileItem)it.next(); String
* filename=fi.getName().substring(fi.getName().lastIndexOf("/")+1);
* //name.substring(name.lastIndexOf("/")+1);
* System.out.println("filename============"+filename); long
* size=fi.getSize(); try { if(filename!=null || !filename.equals(" ") &&
* size!=0) { fi.write(new File("D://charSystem//file//3//"+filename));
*
* System.out.println("上传成功"); } else { System.out.println("上传失败1"); } }
* catch (Exception e) { // TODO: handle exception
*
* e.printStackTrace();
*
* System.out.println("上传失败2"); } }
*/
}
项目运行说明
下载地址：http://www.jsharer.com/file/848478.htm
这是仿亿友网项目
发布和配置注意：
1.将压缩包解压
2.将项目导入eclipse
3.把数据库启动，并把相对应的安全性全改了，密码为空[MS SQL2000 数据库]
4.将%yeeyoo%/data 下的数据库备份文件附加到数据库中，中里一个SQL 脚本，提供参考，因为有些测试数据没加到脚本中
5.配置tomcat 服务器的server.xml 的一个编码数据：(路径是在:%tomcat%/conf/server.xml)其中一段:
-------------------------------------------------------------------------------------------------------
仿yeeyoo 网运行说明文档截图
第52 页共53 页
原文:
<Connector
port="223" maxHttpHeaderSize="8192"
maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true"/>
改后:(添加URIEncoding="gbk")
<Connector
port="223" maxHttpHeaderSize="8192"
maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true" URIEncoding="gbk" />
---------------------------------------------------------------------------------------------------
6.根据第2 步,可能出现一些红叉,这样先确定此项目属性下的Java 编辑器对应的属性:
->启用特定于项目的设置(勾选上)->JDK 一致性->编译器一致性设置(I):是否为你当前最高的,建议使用6.0 编译器.
这样,还可能会有些网页上的红叉,那个可不用担心,估计是网页HTML 标签代码小问题,要解决也可以,找到相对应的界面,
在此页面内任意位置打个空格再保存下就可以消除错误.
7.再配置tomcat 服务器和JDK,发布此项目,并启动tomcat 服务器
8.这时,这个项目在浏览器中输入"http://localhost:port/yeeyoo"--(其中port 是你的tomcat 服务器的端口号)--,是可以浏
览此项目.但是,你会觉得现在有些图片访问不了,或其他用户空间不能正确访问,这是由于还有些在服务器端运行的数据没有导
入,因为我们的代码是在编译器端写的,所以,还得手动覆盖下那些文件.
9.对于上一步的问题,大家已经可以看到那压缩包里的另2 个文件夹,就是那2 个文件夹的测试数据.覆盖很简单:
1);把%yeeyoo-1.0-beta 版本%下的users 文件夹复制到%tomcat%/webapps/yeeyoo/目录下,覆盖就OK
2);把%yeeyoo-1.0-beta 版本%下的inc 文件夹复制到%tomcat%/webapps/yeeyoo/目录下,覆盖就OK
10.接下来刷新下首页,就可看到效果.最后,管理员的帐号是:admin,密码:admin,其他用户:(格式密码):
aa aa
coy coy1234
.....
11.最后说明下:这是1.0 的beta 版本,界面不是很好看,但功能还是比较全,估计都是有的功能.
*****************************************************************************************************
至于更新:以后可能会继续抽时间更新升级它的版本和运行过程所出现问题以及代码优化等
我对本版本的缺陷:(以后更新...)
/////////////////////////////////////////////////////////////////////////////////////////////////////////
1.界面不是很好看
2.部分小功能由于时间关系,没去实现.
3.邮件删除没做到好的保存
4.后台简陋,虽然,管理功能都有之.
5.部分异常捕获可能存在缺陷
6.其他的未知漏洞
仿yeeyoo 网运行说明文档截图
第53 页共53 页
以上6 点,以后会在更新版本中补充!!!!!!!!!
相信我!!!!!

 

 

项目联系邮件:[e-mail]
E-mail:[e-mail]