网站论坛设计报告

网站类课程设计报告题目：论坛系统姓名：学号：指导教师：2011年11 月计算机科学与应用系一、系统分析1、需求分析对于本论坛系统来说用户可以发帖子，浏览帖子，包括三种权限分别是：管理者、版主、普通用户，不同权限的用户登录到系统后所看到的功能不同，具体分析参考功能分析等；2、功能分析该论坛体功能如下：用户设置模块：用来管理用户信息，包括新增用户，更新用户，删除用户等前台功能包括版块列表，主题列表，显示主题详细内容，发表主题，回复主题，主题管理，用户注册，用户登录模块。

版块列表模块：显示论坛的所有根版块及其下所有的子版块，还可显示子版块下的主题数目主题列表模块：显示指定版块下的所有主题信息及发帖者的信息和回复记录数显示主题详细内容模块：显示主题的详细信息机该主题下的所有回复信息。

二、系统模块划分论坛用户有三种权限：管理员，版主，普通用户。

管理员拥有最高权限；版主是每个版块的管理者，可以发表主题还可以对该板块的信息进行维护；普通用户只可以浏览帖子，在登录系统后可以发表帖子回复帖子；三、数据库设计1、用户表（user）2、版块信息表（model）3、主题信息表（theme）4、回复信息表（feedback）四、关键代码1、数据库连接代码（DataBaseConnection.java）public class DataBaseConnection {public static Connection getConnection(){Connection conn = null;try {Class.forName("com.mysql.jdbc.Driver");conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/bbs","root","123");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}public static void closeConnection(Connection conn){if(conn!=null)try {conn.close();} catch (SQLException e) {e.printStackTrace();}}public static void closeResultSet(ResultSet rs){if(rs!=null)try{rs.close();}catch(SQLException e){e.printStackTrace();}}public static void closePreparedStatment(PreparedStatement ps){if(ps!=null)try{ps.close();}catch(SQLException e){e.printStackTrace();}}}2、用户登录及注册处理代码(CheckDataBase.java)public class CheckDataBase {//判断数据库中是否存在该用户,如果存在则注册不成功public boolean isExist(String username) throws Exception{Connection con= DataBaseConnection.getConnection();String sql="select * from user where name=?";try {PreparedStatement statement= con.prepareStatement(sql);statement.setString(1, username);ResultSet set= statement.executeQuery();if(!set.next()){//如果无效则证明此用户名可用return true;}DataBaseConnection.closeResultSet(set);DataBaseConnection.closePreparedStatment(statement);}catch (SQLException e) {e.printStackTrace();}finally{DataBaseConnection.closeConnection(con);}return false;}//判断数据库中是否存在某个用户，若存在注册不成功，若不存在注册成功public void saveDataBase(UserBean user) throws Exception {Connection con= DataBaseConnection.getConnection();String sql="insert into user(name,password,mail,qq,problem,answer,photo,type) values(?,?,?,?,?,?,?,?)";try{PreparedStatement ps=con.prepareStatement(sql);ps.setString(1, user.getName());ps.setString(2, user.getPassword());ps.setString(3, user.getMail());ps.setString(4, user.getQq());ps.setString(5, user.getProblem());ps.setString(6, user.getAnswer());ps.setString(7, user.getPhoto());ps.setInt(8,user.getType());ps.executeUpdate();DataBaseConnection.closePreparedStatment(ps);}catch(SQLException e){e.printStackTrace();}finally{try {DataBaseConnection.closeConnection(con);} catch (Exception e2) {// TODO: handle exception}}}//按用户名查询public UserBean findByName(String name){UserBean user=null;Connection con=DataBaseConnection.getConnection();String sql="select * from user where name=?";try {PreparedStatement ps=con.prepareStatement(sql);ps.setString(1, name);ResultSet rs=ps.executeQuery();if(rs.next()){user=new UserBean();user.setName(rs.getString(1));user.setPassword(rs.getString(2));user.setMail(rs.getString(3));user.setQq(rs.getString(4));user.setAnswer(rs.getString(5));user.setProblem(rs.getString(6));user.setPhoto(rs.getString(7));user.setType(rs.getInt(8));}} catch (Exception e) {e.printStackTrace();}return user;}//得到用户的权限public String getLimit(int limit){String str = null;switch (limit){case 0:{ str="管理员";break;}case 1:{str="版主";break;}case 2:{str="普通用户";break;}}return str;}//用户登录public UserBean login(String username,String password) throws Exception{ UserBean user=null;Connection con= DataBaseConnection.getConnection();String sql="select * from user where name=? and password=?";try {PreparedStatement ps=con.prepareStatement(sql);ps.setString(1, username);ps.setString(2, password);ResultSet result=ps.executeQuery();if(result.next()){user=new UserBean();user.setName(result.getString(1));user.setPassword(result.getString(2));user.setMail(result.getString(3));user.setQq(result.getString(4));user.setAnswer(result.getString(5));user.setProblem(result.getString(6));user.setPhoto(result.getString(7));user.setType(result.getInt(8));}DataBaseConnection.closeResultSet(result);DataBaseConnection.closePreparedStatment(ps);} catch (Exception e) {// TODO: handle exception}finally{DataBaseConnection.closeConnection(con);}return user;}}3、发帖子页面PostTheme.jsp<%@ page language="java"import="java.util.*"pageEncoding="gbk"%><%@ page import="bean.*" %><%UserBean user=(UserBean) session.getAttribute("user"); %><table align="center"border="1"width="400"><tr><td>欢迎你！<%=user.getName() %></td></tr><tr><td><form name="form1"action = "PostTheme"method="post">主题：&nbsp; &nbsp;<input type="text"name="title"size=10/>[不超过20个字]<br/>选择版块：<select id="theme"name="theme"><option value="JavaSE">JavaSE</option><option value="JavaEE">JavaEE</option><option value="JSP">JSP</option><option value="Reading">Reading</option></select><br/>内容：<br><textarea rows="30"cols="50"name="text"style="margin-left: 10px"></textarea><br/><input type="submit"name="submit"value="提交"><input type="reset"name="reset"value="重置"></form></td></tr></table>4、查看详细帖子的页面：detail.jsp<%@ page language="java"import="java.util.*"pageEncoding="gbk"%><%@ page contentType="text/html; charset=gbk"%><%@ page import="bean.*"%><%@page import="daoFactory.DaoFactory"%><%@page import="login_regedit.CheckDataBase"%><% //获得某个主题帖子下的所有回复List<ReplyBean> list = (List<ReplyBean>) request.getAttribute("list");//获得回复的帖子的主题ThemeBean theme = (ThemeBean) request.getAttribute("theme");//获得回复帖子的权限CheckDataBase cdb=new CheckDataBase();int type=0;String str=null;int mid=0;int id=0;String uname=null;String title=null;if(theme!=null){type = cdb.findByName(theme.getU_name()).getType();str=cdb.getLimit(type);mid=theme.getM_id();//获得版块的iduname=(DaoFactory.getModelInstance().getModel(mid)).getMasterName();//获得该版块版主的昵称title=theme.getTitle();id=theme.getId();}int size=0;if(size!=0){//获得所有回复记录的个数size=(Integer)request.getAttribute("size");}%><table width="900"align="center"border="0"><tr><td colspan="2"><%@include file="banner.jsp" %></td></tr><tr bgcolor="#cccccc"><td colspan="2"><%=title%></td></tr><%if (theme != null) {%><tr height="200"><th width="200"><b>#1</b><br><img alt="头像" src="image/photo.gif" /><br>用户名：<%=theme.getU_name()%><br>组别：<%=str%></th><th><%=theme.getContent()%><br><br><br><div align="left">发贴时间[<%=theme.getDate()%>]</div></th></tr><%}%><%--显示回复的帖子--%><%int totalRecord=0;//回复的总次数int totalPage;//总页数int perCount=2;//每页有十条记录int nextPage;//下一页int per=0;String ss=request.getParameter("page");int currentPage;if(ss==null ||ss==""){ss="1"; }currentPage=Integer.parseInt(ss);if(currentPage<1)currentPage=1;if(list!=null){totalRecord=list.size();}totalPage=(totalRecord+perCount-1)/perCount;if(currentPage>totalPage)currentPage=totalPage;for(int i=0;i<totalRecord;i++){++per;if((per>=(currentPage-1)*perCount+1)&& per<=currentPage*perCount){int limit= (new CheckDataBase()).findByName(list.get(i).getUname()).getType() ;String quanxian=(new CheckDataBase()).getLimit(limit);%><tr><td colspan="2"><hr width="90%"align="center"/></td></tr><tr height="200"><td width="200"align="center"><b>#<%=i+2 %></b><br><img alt="头像"src="image/photo.gif"><br/>用户名：<%=list.get(i).getUname() %><br>权限：<%=quanxian %></td><td valign="top"><%=list.get(i).getContent() %><br/>回复时间：[<%=list.get(i).getPublishTime() %>]</td></tr><%} }%><tr><td height="40"colspan="2"align="center"><hr width="90%"align="center"/><a href="detail.jsp?page=<%=1 %>">首页</a><%if (currentPage>1){ %><a href="detail.jsp?page=<%=currentPage-1 %>">上一页</a><%}else{ %>上一页<%} %><%if (currentPage<totalPage){ %><a href="detail.jsp?page=<%=currentPage+1 %>">下一页</a><% }else {%>下一页<%} %><a href="detail.jsp?page=<%=totalPage %>">尾页</a>转倒<input onkeypress="if (event.keyCode==13) window.location='detail.jsp?page='+this.value;" maxlength="5"size="3"value="1" name="page">页共<%=currentPage %>/<%=totalPage %>页</td></tr><tr height="50"align="center"><td colspan="2"><font size="5"><b>你还没有登录！不能发帖、回复帖子！请先<a href="index.jsp">登录</a>或<a href="regedit.jsp">注册</a></b></font></td></tr><tr><td colspan="2"><%@ include file="bottom.jsp" %></td></tr></table>5修改密码的servlet（ModifyPassword.java）public class LoginServlet extends HttpServlet {protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String username=new String((request.getParameter("username")).getBytes("iso-8859-1"),"gbk");String password=new String((request.getParameter("password")).getBytes("iso-8859-1"),"gbk");CheckDataBase cdb=new CheckDataBase();if(username==null && password==null){request.setAttribute("error", "请输入用户名和密码");request.getRequestDispatcher("/index.jsp").forward(request, response);}else if(username==null || "".equals(username)){request.setAttribute("error", "请输入用户名");request.getRequestDispatcher("/index.jsp").forward(request, response);}else if(password==null ||"".equals(password)){request.setAttribute("error", "请输入密码");request.getRequestDispatcher("/index.jsp").forward(request, response);}else{try {UserBean user=cdb.login(username, password);if(user!=null){request.getSession().setAttribute("user", user);request.getRequestDispatcher("/LoadModel.jsp").forward(request, response);}else{request.setAttribute("error", "该用户不存在请核对后登陆");request.getRequestDispatcher("/error.jsp").forward(request, response);}}catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}11、注册的servlet（RegeditServlet.java）public class RegeditServlet extends HttpServlet {public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String username=request.getParameter("username");String password=request.getParameter("password");String mail=request.getParameter("mail");String qq=request.getParameter("QQ");String problem=request.getParameter("problem");String answer=request.getParameter("answer");String photo=request.getParameter("photo");CheckDataBase cdb=new CheckDataBase();if(username!=null && !username.isEmpty()){//判读数据库是否已存在这个名如果不存在则可以注册成功try {if(cdb.isExist(username)){UserBean user=new UserBean();user.setName(username);user.setPassword(password);user.setMail(mail);user.setQq(qq);user.setProblem(problem);user.setAnswer(answer);user.setPhoto(photo);user.setType(2);cdb.saveDataBase(user);request.setAttribute("info", "恭喜，注册成功！<br>");request.getRequestDispatcher("/message.jsp").forward(request, response);}else {request.setAttribute("info", "对不起，注册失败！");request.getRequestDispatcher("/message.jsp").forward(request, response);}} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}课程设计总结：经过了此次的课程设计，使自己真正的在实践中锻炼了自己的能力，从命题的选择，到任务的分配，以及自己任务的完成过程中都是个人能力以及对网络和资源利用的充分体现，也是自己学习能力的充分体现。