WEB课程设计bbs论坛

1、WEB课程设计基于JavaWeb技术开发的BBS论坛院（系）计算机科学与工程学院专班姓学业级名号软件工程X*x*x*x*x*x*x*X*x*x*x*x*x*2010/0刀25基于JavaWeb技术开发的BBS论坛模块介绍我承担的是BBS主页面处理这一部分内容：其功能主要是主页面功能的实现：包括最近浏览的显示，帖子标题显示，最后发表时间，更新，以及“登陆”和“注册”的显示等。1.运行效果截图如下：您尚未登录丨注册I论坛主题摄后发表.DIET技术吾s13怎么写的乘法表weijiahua2009-12-2223:55HitlForme1WinForms是什么技术？weijiahua2009-12-2

2、223:57AHO.NET1ADD.HET技术核必是什么7mateng2i：iLiy-12-2223:59ASP.NET1为何日历控f牛不能显示？本机可以服务器不行weijiahua2009-12-2300:02支术丁:沖在基础12怎样学Stjavaadmin2009-12-0800:45.JSf技#1初学T运行现有项目遇到的问题mateng2009-1-23.00:28Servlet技术1jspserver如何处理uheukbo咒类型的i现说隹过来的参数周涛2009-12-2300:28Eclipse应用3myEclipse快捷键（基本）.崗涛2009-12-2300:302.主页面HTML

3、框架代码如下：!DOCTYPEHTMLPUBLIC-/W3C/DTDHTML4.01Transitional/EN HYPERLINK /TR/1999/REC-html401-19991224/loose.dtd%22%e3%80%89 /TR/1999/REC-html401-19991224/loose.dtdTITLE欢迎访问青鸟学员论坛/TITLEMETAhttp-equiv=Content-Typecontent=text/html;charset=gbkBODY!-用户信息、登录、注册-您尚未ahref=login.jsp”登录|Ahref=reg.jsp注册|您好：|Ahref

4、=manage/doLogout.jsp退出/A|brDIV!-主体-DIVclass=tTABLEcellSpacing=0cellPadding=0width=100%TRclass=tr2align=centerTDcolSpan=2论坛/TDTDstyle=WIDTH:5%;主题/TDTDstyle=WIDTH:25%最后发表/TD/TR!-主版块_TRclass=tr3TDcolspan=4br/TD/TR!_子版块_TRclass=tr3TDwidth=5%/TDTHalign=leftIMGsrc=image/board.gif/THTDalign=centerbr/TDTHSP

5、AN/SPANBR/SPAN/SPANSPANclass=gray/SPAN/TH/TR/TABLE/BODY二.数据库表的设计数据库代码如下(简要分类说明)：1Tablestructurefortabletbl_board/board表DROPTABLEIFEXISTStbl_board;/*!40101SETsaved_cs_client=character_set_client*/;/*!40101SETcharacter_set_client=utf8*/;CREATETABLEtbl_board(boardIdint(4)NOTNULLauto_increment,boardName

6、varchar(50)NOTNULL,parentIdint(4)NOTNULL,PRIMARYKEY(boardId)ENGINE=InnoDBAUTO_INCREMENT=17DEFAULTCHARSET=gbk;/*!40101SETcharacter_set_client=saved_cs_client*/;-Dumpingdatafortabletbl_boardLOCKTABLEStbl_boardWRITE;2.Tablestructurefortabletbl_topic/topic表DROPTABLEIFEXISTStbl_topic;/*!40101SETsaved_cs_

7、client=character_set_client*/;/*!40101SETcharacter_set_client=utf8*/;CREATETABLEtbl_topic(topicIdint(11)NOTNULLauto_increment,titlevarchar(100)NOTNULL,contentvarchar(10000)NOTNULL,publishTimedatetimeNOTNULL,modifyTimedatetimeNOTNULL,uIdint(4)NOTNULL,boardIdint(4)NOTNULL,countint(4)defaultNULL,PRIMAR

8、YKEY(topicId)ENGINE=InnoDBAUTO_INCREMENT=30DEFAULTCHARSET=gbk;/*!40101SETcharacter_set_client=saved_cs_client*/;-Dumpingdatafortabletbl_topicLOCKTABLEStbl_topicWRITE;3.Tablestructurefortabletbl_user/user表DROPTABLEIFEXISTStbl_user;/*!40101SETsaved_cs_client=character_set_client*/;/*!40101SETcharacter

9、_set_client=utf8*/;CREATETABLEtbl_user(uIdint(4)NOTNULLauto_incrementCOMMENT1,uNamevarchar(20)NOTNULL,uPassvarchar(20)NOTNULL,headvarchar(100)NOTNULL,regTimedatetimeNOTNULL,gendervarchar(2)NOTNULL,PRIMARYKEY(uId)ENGINE=InnoDBAUTO_INCREMENT=8DEFAULTCHARSET=gbk;/*!40101SETcharacter_set_client=saved_cs

10、_client*/;-Dumpingdatafortabletbl_userLOCKTABLEStbl_userWRITE;.所涉及的DAO对象如上主JSP页面里所涉及的DAO对象如下：BoardDaoboardDao=newBoardDaoImpl();/得到版块Dao的实例TopicDaotopicDao=newTopicDaoImpl();/得到主题Dao的实例UserDaouserDao=newUserDaoImpl();/得到用户Dao的实例其具体文件所在目录：jspbbsWebRootWEB-INFclassescominterfacesimpl文件夹中。女口：UserDaoImp

11、l代码如下：/*s2jsp.lg.dao.impl.UserDaoImpl.java2007-7-18UserDao的实现类*/erfaces.impl;importjava.sql.*;importjava.text.SimpleDateFormat;importjava.util.Date;importcom.beans.User;erfaces.UserDao;importcom.util.ConnectionManager;publicclassUserDaoImplextendsBaseDaoimplementsUserDao/保存数据库连接/用于执行SQL语句/用户保存查询结果集p

12、rivateConnectionconn=null;privatePreparedStatementpstmt=null;privateResultSetrs=null;/*增加用户paramuserreturn增加条数*/publicintaddUser(Useruser)Stringsql=insertintoTBL_USER(uname,upass,gender,head,regTime)values(?,?,+user.getGender()+,?,?);Stringtime=newSimpleDateFormat(yyyy-MM-ddHH:mm:ss).format(newDate(

13、);/取得日期时间Stringparm=user.getUName(),user.getUPass(),user.getHead(),time;returnthis.executeSQL(sql,parm);/执行sql，并返回影响行数/*修改用户密码paramuserreturn更新条数*/publicintupdateUser(Useruser)Stringsql=updateTBL_USERsetupass=?whereuname=?;Stringparm=user.getUPass(),user.getUName();returnthis.executeSQL(sql,parm);/执

14、行sql，并返回影响行数/*根据用户名查找用户*paramuName*return根据用户名查询的用户对象*/publicUserfindUser(StringuName)Stringsql=select*fromTBL_USERwhereuName=?;Useruser=null;tryconn=ConnectionManager.getConnection();/取得数据库连接pstmt=conn.prepareStatement(sql);pstmt.setString(l,uName);rs=pstmt.executeQuery();/取得PreparedStatement对象/设置参

15、数/执行SQL取得结果集while(rs.next()user=newUser();user.setUId(rs.getInt(uId);user.setUName(rs.getString(uName);user.setUPass(rs.getString(uPass);user.setGender(rs.getInt(gender);user.setHead(rs.getString(head);user.setRegTime(rs.getString(regTime);catch(Exceptione)/处理异常e.printStackTrace();finallyConnectionM

16、anager.closeStatement(pstmt);ConnectionManager.closeConnection(conn);returnuser;/*根据用户id查找用户paramuIdreturn根据uid查询的用户对象*/publicUserfindUser(intuId)Stringsql=select*fromTBL_USERwhereuId=?;Useruser=null;try取得数据库连接conn=ConnectionManager.getConnection();pstmt=conn.prepareStatement(sql);pstmt.setInt(1,uId

17、);rs=pstmt.executeQuery();/取得PreparedStatement对象/设置参数/执行SQL取得结果集while(rs.next()user=newUser();user.setUId(rs.getInt(uId);user.setUName(rs.getString(uName);user.setUPass(rs.getString(uPass);user.setGender(rs.getInt(gender);user.setHead(rs.getString(head);user.setRegTime(rs.getString(regTime);catch(Ex

18、ceptione)e.printStackTrace();/处理异常finallyConnectionManager.closeStatement(pstmt);ConnectionManager.closeConnection(conn);returnuser;四.JSP页面及Servlet介绍%来实现。Transitional/EN本系统基于功能都是JSP的形式实现的.某些处理功能以欢迎访问青鸟学员论坛/TITLE您尚未登录l注册I您好：l退出IvDIVvTABLEcellSpacing=OcellPadding=Owidth=100%vTRclass=tr2align=center论坛主题最后发表v%=mainBoard.getBoardName()%0)topic=(Topic)listTopic.get(O);/取得最后发表的帖子user=userDao.findUser(topic.getUid();% ；v/TDvIMGsrc=image/board.gifAhref=list.jsp?page=1&boardId=v%=sonBoard.getBoardName()%v%=topicDao.findCountTopic(boardId)%vTHvSPAN&topicId=v%=topic.getTopicId()%v%=topic.get