BBS数据字典

 

用户表 bbsuser
序号 字段名 数据类型 说明
1 userId int 主键、自增
2 userName Varchar2(20) 唯一、非空
3 userPwd Varchar2(20) 非空
4 gender Char(1) M或F，默认值M
5 headImg Varchar(20) 非空
6 userState int 3-超级管理员 2-管理员1-普通用户 0-已删除
贴子表 article
序号 字段名 数据类型 说明
1 articleId int 主键、自增
2 articleTitle Varchar2(50) 主题,非空
3 articleContent Varchar(100) 内容，非空
4 articlepublishTime Date 发表时间
5 articleupdateTime Date 更新时间
6 userId int 外键
7 sectionId int 外键
8 articleState int 0- 已删除
1-正常显示
回贴表 message
序号 字段名 数据类型 说明
1 messageId int 主键、自增
2 messageTitle Varchar2(50) 主题,非空
3 messageContent Varchar2(10
0)
内容
4 messagepublishTime Date 发表时间
5 messageupdateTime Date 更新时间
6 userId int 外键
7 articleId int 外键
8 messageState int 0-已删除
1-正常显示
版块 Section
序号 字段名 数据类型 说明
1 sectionId int 主键、自增
2 sectionName Varchar2(20)
3 supersectionId int 外键
4 sectionState int 0-已删除
1-正常显示

create table bbsuser(userId int primary key,userName varchar2(20),userPwd varchar2(20),gender char(1),headImg varchar2(20),userState int)alter table bbsuser add constraint nameunique unique (userName)insert into bbsuser values(1,'kandy','123','M','images/head/1.jpg',1)insert into bbsuser values(2,'itany','123','F','images/head/2.jpg',2)insert into bbsuser values(3,'wangkang','123','F','images/head/2.jpg',3)select * from bbsuser;create table section(sectionId int primary key,sectionName varchar2(20),supersectionId int,sectionState int)alter table section add constraint s_fk_ssid foreign key(supersectionId) references section(sectionId) on delete cascade;select * from section;insert into section values (1,'.NET技术',0,1)insert into section values (2,'JAVA技术',0,1)insert into section values (3,'数据库技术',0,1)insert into section values (4,'娱乐',0,1)insert into section values (5,'C#语言',1,1)insert into section values (6,'WinForms',1,1)insert into section values (7,'ADO.NET',1,1)insert into section values (8,'ASP.NET',1,1)insert into section values (9,'JAVA基础',2,1)insert into section values (10,'JSP技术',2,1)insert into section values (11,'Servlet技术',2,1)insert into section values (12,'Eclipse应用',2,1)insert into section values (13,'SQL Server基础',3,1)insert into section values (14,'SQL Server高级',3,1)insert into section values (15,'灌水乐园',4,1)create table article(articleId int primary key ,articleTitle varchar2(20),articleContent varchar2(100),articlepublishTime Date,articleupdateTime Date ,userId int ,sectionId int,articleState int)alter table article add constraint a_fk_userid foreign key(userId) references bbsuser(userId) on delete cascade;alter table article add constraint a_fk_sid foreign key(sectionId) references section(sectionId) on delete cascade;select * from articleinsert into article values(17,'myeclipse','C#语言是微软开发的语言',sysDate,sysDate,1,5,1);insert into article values(18,'sql 基础',' 以下代码为什么有问题',sysDate,sysDate,1,5,1);insert into article values(19,'sql 高级','ADO.NET 是什么东西',sysDate,sysDate,1,5,1);insert into article values(20,'灌水','ADO.NET是什么东西',sysDate,sysDate,1,5,1);create table message(messageId int primary key,messageTitle varchar2(20),messageContent varchar2(100),messagepublishTime Date ,messageupdateTime Date,userId int ,articleId int,messageState int)alter table message add constraint m_fk_userid foreign key(userId) references bbsuser(userId) on delete cascade;alter table message add constraint m_fk_aid foreign key(articleId) references article(articleId) on delete cascade;insert into message values(1,' 第一个回贴',' 不知道回什么?',sysdate,sysdate,2,13,1)insert into message values(2,' 第一个回贴',' 不知道回什么?',sysdate,sysdate,2,13,1)

分页代码

   服务器端

public String getallArticle(HttpServletRequest req, HttpServletResponse resp)     {        String sid=req.getParameter("sid");        ArticleDAO adao=new  ArticleDAO();        int pageSize=5;        int totalPages=adao.getTotalPages(Integer.parseInt(sid),pageSize);        int totalRecords=adao.getarticleCount(Integer.parseInt(sid));       String currentPage=req.getParameter("currentPage");       int cPage;       if(currentPage==null||currentPage=="")       {           cPage=1;       }       else        {           cPage=Integer.parseInt(currentPage);           if(cPage<=0)           {               cPage=1;           }           else if(cPage>=totalPages)           {               cPage=totalPages;           }       }       SectionDAO sdao=new SectionDAO();       Section section=sdao.getSection(Integer.parseInt(sid));        HttpSession session =req.getSession();         List<Article> aList=adao.getallArticle(Integer.parseInt(sid), cPage, pageSize);        session.setAttribute("aList",aList);        session.setAttribute("currentPage",cPage);        session.setAttribute("sid",sid);        session.setAttribute("totalPages",totalPages);        session.setAttribute("totalRecords",totalRecords);        session.setAttribute("sName",section.getSectionName());        return "asinfo";    }

 

客户端

<body>${sName}<br/><a href="post.jsp"><img src="images/post.gif"/></a><table  width="1200" border="1" align="center" id="tab">  <tr>     <td>文章</td>     <td>作者</td>     <td>回复</td> </tr>    <c:forEach items="${aList}" var="article">      <tr id="tr${article.articleId}" value="${article.userId}">            <td id=""><a href="bbsInfo5.do?aid=${article.articleId}">${article.articleTitle}</a></td>            <td id="td1${article.articleId}">${article.userId}</td>   <td id="td2${article.articleId}"></td>      <tr>        </c:forEach></table><center><a href="boardInfo1.do?currentPage=1&&sid=${sid}">首页</a><a href="boardInfo1.do?currentPage=${currentPage-1}&&sid=${sid}">上一页</a> <a href="boardInfo1.do?currentPage=${currentPage+1}&&sid=${sid}">下一页</a><a href="boardInfo1.do?currentPage=${totalPages}&&sid=${sid}">末页</a><br/>第${currentPage}页   共计${totalPages}页</center></body></html>