第 1 页 共 24 页
1
NtSky BBS 系统
姚君林
NtSky BBS 系统.........................................................................................................................................................1
第一章: 介绍 ..............................................................................................................................................................1
第二章: 系统设计 ......................................................................................................................................................2
2.1、流程分析 ....................................................................................................................................................2
2.1.1 全站基本流程.............................................................................................................................3
2.1.2 主题模块....................................................................................................................................3
2.1.3 用户登陆模块............................................................................................................................5
2.1.4 回复主题模块............................................................................................................................6
2.1.5 用户注册模块............................................................................................................................7
2.1.6 模块管理....................................................................................................................................8
2.1.6 论坛安装....................................................................................................................................9
2.2、数据库设计 ................................................................................................................................................9
2.2.1、论坛模块表 (t_board)“ * ”代表主键 ..................................................................................10
2.2.2、论坛主题表 (t_topic) “ * ”代表主键...................................................................................10
2.2.3、论坛主题回复表 (t_reply) “ * ”代表主键 ..........................................................................11
2.2.4、后台用户管理表(t_admin)..............................................................................................11
2.2.5、用户表 ( t_user ) ..................................................................................................................12
2.2.6、用户权限表...........................................................................................................................13
2.2.7、用户角色表(t_roles) ........................................................................................................13
2.2.8、全球的 IP 地址库(t_address) ..........................................................................................14
2.2.9、统计信息...............................................................................................................................14
2.3、开发&发布环境设置 ...............................................................................................................................14
2.3.1、JDK 安装和设置...................................................................................................................14
2.3.2、Jboss 相关设置 .....................................................................................................................15
2.3.3、Struts 相关设置.....................................................................................................................17
2.3.3、MYSQL 的安装和设置........................................................................................................17
2.3.4、开发工具 Jbuilder X 的集成 ................................................................................................18
2.3.5、页面中文处理方案...............................................................................................................22
2.3.6、界面国际化问题(Tiles) &内容国际化问题(RBManager)..................................................22