JSP实训指导书—简单论坛制作一、需求分析与功能模块设计1.学生自行参考教材相关内容完成需求分析2.学生自行参考教材进行概要设计（功能模块划分）二、创建数据库1.设计数据库学生根据前一阶段分析与设计，完成数据库的设计，要求在报告中绘制数据库信息表以及采用E R图表述数据信息。
2.完成数据库创建按照要求实现数据库并使用相关软件创建数据库。
提供以下参考脚本/*论坛项目所使用的数据库b bs的建库脚本*/CREATE DATABASE `bbs` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;USE `bbs`;/*Table structure for table `users`用户信息表*/DROP TABLE IF EXISTS `users`;CREATE TABLE `users` (`uid` int(11) NOT NULL AUTO_INCREMENT,`uname` varchar(20) NOT NULL,`upw` varchar(12) NOT NULL,`usex` char(2) DEFAULT '密',`udate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,`uemail` varchar(50) DEFAULT NULL,`ulevel` smallint(6) DEFAULT '1',`ulogo` varchar(50) DEFAULT NULL,PRIMARY KEY (`uid`),UNIQUE KEY `uname` (`uname`),KEY `name` (`uname`)) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;/*Table structure for table `posts`主题帖表*/DROP TABLE IF EXISTS `posts`;CREATE TABLE `posts` (`pid` bigint(20) NOT NULL AUTO_INCREMENT,`pTitle` varchar(50) NOT NULL,`pContent` varchar(500) NOT NULL,`pAuthor` varchar(16) NOT NULL,`pDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,`pReplies` int(11) NOT NULL DEFAULT '0',`pClicks` int(11) NOT NULL DEFAULT '0',`pLastUpdate` char(20) DEFAULT NULL,`pLastAuthor` varchar(16) DEFAULT NULL,PRIMARY KEY (`pid`),KEY `author` (`pAuthor`),CONSTRAINT `author` FOREIGN KEY (`pAuthor`) REFERENCES `users` (`uname`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;/*Table structure for table `reply`回复帖表*/DROP TABLE IF EXISTS `reply`;CREATE TABLE `reply` (`rId` int(11) NOT NULL AUTO_INCREMENT,`pid` bigint(20) NOT NULL,`rTitle` varchar(50) DEFAULT NULL,`rContent` varchar(500) NOT NULL,`rAuthor` varchar(20) NOT NULL,`rDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`rId`),KEY `pid` (`pid`),KEY `rAuthor` (`rAuthor`),CONSTRAINT `reply_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `posts` (`pid`) ON DELETE CASCADE ON UPDATE CASCADE,CONSTRAINT `reply_ibfk_2` FOREIGN KEY (`rAuthor`) REFERENCES `users` (`uname`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;/*创建视图`p ost_user`和r eply_user，在显示帖子详情时使用到视图*/CREATE VIEW `reply_user`AS SELECT * FROM users AS u,reply AS r WHERE r.rAuthor=u.uname;CREATEVIEW `post_user`AS(SELECT * FROM users AS u,posts AS p WHERE p.pAuthor=u.uname);/*Table structure for table `section`版块信息表，如果添加板块信息才使用下面内容*/ DROP TABLE IF EXISTS `section`;CREATE TABLE `section` (`sno` int(11) NOT NULL AUTO_INCREMENT,`sname` varchar(30) COLLATE utf8_unicode_ci NOT NULL,`uname` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,`sdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY (`sno`)) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;三、创建通用类访问数据库1.创建属性文件属性文件d bconn.properties（文件路径：src目录），文件内容参照如下driver = com.mysql.jdbc.Driverurl = jdbc:mysql://localhost:3306/bbs?useUnicode=true&characterEncoding=utf8username = rootpassword =1234562.创建通用类Conn.java参考内容如下：package dbUtil;import java.io.InputStream;import java.sql.*;import java.util.Properties;import dbUtil.Conn;public class Conn {private Connection con;private Statement st;//构造函数，在创建Conn类的对象时自动调用public Conn() throws Exception {Properties pros = new Properties();InputStream in;in=Conn.class.getResourceAsStream("/dbconn.properties"); //加载属性文件，该文件应存放于项目的源包下(src/java)pros.load(in);in.close();String driver = pros.getProperty("driver");String url = pros.getProperty("url");String username = pros.getProperty("username");String password = pros.getProperty("password");Class.forName(driver);con =DriverManager.getConnection(url,username,password);st =con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);}//executeQuery--执行查询语句public ResultSet executeQuery(String sql) {ResultSet rs = null;try {rs = st.executeQuery(sql);} catch (Exception e) {e.printStackTrace(System.err);}return rs;}//executeUpdate方法--执行对数据库的更新的SQL语句public int executeUpdate(String sql) {try {return st.executeUpdate(sql);} catch (Exception e) {e.printStackTrace(System.err);return 0;}}//创建预编译对象的方法public PreparedStatement prepareStatement(String sql) { try {return con.prepareStatement(sql);} catch (SQLException e) {e.printStackTrace(System.err);return null;}}/***关闭各项资源的方法*/public void close() {try {if (st!=null) st.close();} catch (Exception e) {e.printStackTrace(System.err);}try {if (con!=null) con.close();} catch (Exception e) {e.printStackTrace(System.err);}}}四、各功能模块1用户注册模块1）设计并完成相关B ean的制作Users.java/*** Document : Users.java* Created on : 2010-6-9, 0:19:28* Author : sunny*/package bean;public class Users {private String uname,upw,upw2,usex,udate,uemail,ulogo; private int ulevel;public String getUname() {return uname;}public void setUname(String uname) {this.uname = uname;}public String getUpw2() {return upw2;}public void setUpw2(String upw2) {this.upw2 = upw2;}public String getUdate() {return udate;}public void setUdate(String udate) {this.udate = udate;}public String getUemail() {return uemail;}public void setUemail(String uemail) {this.uemail = uemail;}public int getUlevel() {return ulevel;}public void setUlevel(int ulevel) {this.ulevel = ulevel;}public String getUlogo() {return ulogo;}public void setUlogo(String ulogo) { this.ulogo = ulogo;}public String getUpw() {return upw;}public void setUpw(String upw) {this.upw = upw;}public String getUsex() {return usex;}public void setUsex(String usex) {ex = usex;}}UserBean.javapackage bean;import dbUtil.Conn;import java.sql.PreparedStatement; import java.sql.ResultSet;import java.sql.SQLException;public class UsersBean {private Users user;public Users getUser() {return user;}public void setUser(Users u) {er = u;}public String basicCheck() {String uname, upw, upw2;uname = user.getUname();upw = user.getUpw();upw2 = user.getUpw2();String msg = "";if (uname == null || uname.equals("") || upw == null || upw.equals("")) {msg = "请填写用户名和密码.";} else if (!upw.equals(upw2)) {msg = "两次输入的密码不一致!";}return msg;}public String uniqueName() {String uname = user.getUname();Conn conn = null;ResultSet rs = null;String msg = "";try {conn = new Conn();String sql = "select * from users where uname='" + uname + "'";rs = conn.executeQuery(sql);if (rs != null)if (rs.next())msg = "用户名<b> " + uname + " </b>已被使用，请改用其它名字.";} catch (Exception ex) {ex.printStackTrace(System.err);} finally {try {if (rs != null)rs.close();} catch (SQLException ex) {ex.printStackTrace(System.err);}conn.close();}return msg;}public boolean insert() {boolean success = false;Conn conn = null;PreparedStatement pt = null;if (user==null) return false;try {conn = new Conn();String sql = "insert intousers(uname,upw,usex,uemail,ulogo) values(?,?,?,?,?)";pt = conn.prepareStatement(sql);pt.setString(1, user.getUname());pt.setString(2, user.getUpw());pt.setString(3, user.getUsex());pt.setString(4, user.getUemail());pt.setString(5, user.getUlogo());success = pt.executeUpdate() > 0;} catch (Exception ex) {ex.printStackTrace(System.err);} finally {try {if (pt != null)pt.close();} catch (SQLException ex) {ex.printStackTrace(System.err);}conn.close();}return success;}}2）界面制作与前端验证程序在j s目录里确认有以下j s文件用于进行前段验证：以下是注册页面参考代码reg.jsp<%--Document : reg.jsp用户注册页面Created on : 2015-04-19, 16:31:45Author : sunnyDescription:通过jQuery库实现的Ajax用户名检测--%><%@page contentType="text/html" pageEncoding="UTF-8" import="java.util.Vector"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01Transitional//EN""/TR/html4/loose.dtd"><%//先退出登录状态Vectorvisitors=(Vector)application.getAttribute("namelist");if(visitors!=null&&session.getAttribute("username")!=null) visitors.remove(session.getAttribute("username")); session.removeAttribute("username");//从检测到填写错误的页面转回时，先恢复上一次填写的内容String msg = "", uname = "", uemail = "", ulogo = "";if (request.getParameter("msg") != null) {msg = request.getParameter("msg");uname = request.getParameter("uname");uemail = request.getParameter("uemail");ulogo = request.getParameter("ulogo");}%><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>学习论坛--注册</title><style type="text/css"><!--@import url("css/common.css");-->img{cursor:hand;}</style><!--common.js中包含常用的Javascript代码--><script src="js/common.js"></script><!--reg.js中包含本页面使用的JS检测函数--><script src="js/reg.js"></script><!--添加对jQuery库的引用--><script src="js/jquery-1.11.0.min.js"></script> <script>var jq = $.noConflict(); //使用jq代替默认的$符号jq(function(){jq('#uname').blur(function(){var uname=jq('#uname').val();//if (uname == null || uname == "") {alert("请输入用户名.");jq("#uname").focus();return;}jq.get('chkUniqueName.jsp?uname='+encodeURI(uname),null, function(data){if (data != "OK") { //若在服务器端检测后用户名重复，则返回的结果信息不为OKjq("#unameinfo").html('<imgsrc="images/check_error.gif" width="13" height="13"> 已被使用');jq("#uname").focus(); //光标重新定位在用户名输入框} else {jq("#unameinfo").html('<imgsrc="images/check_right.gif" width="13" height="13">可用');}}); //end of jq.get});});</script></head><body id="reg"onload="$('uname').focus()"> <!--页面加载时，光标自动定位到用户名输入框--><div id="container"><div id="logo"></div><div id="nav"><div id="welcome">欢迎进入JSP学习论坛</div><ul><li><a href="index.jsp">首页</a></li><li><a href="login.jsp">登录</a></li><li><a href="reg.jsp">注册</a></li><li><a href="mailto:neujspbook@">与我联系</a></li></ul></div><!--下面是内容层，主要显示一个表单--><div id="content"><div class="warning" ><%=msg%></div><form action="chkReg.jsp" method="post"onsubmit="return check()"><!--表单的各项内容用表格排列整齐--><table><tbody><tr><td colspan="2" id="title">请填写注册信息</td></tr><tr><td class="ltd">用户名* </td><td><input type="text"name="uname"id="uname" value="<%=uname%>" size="40" maxlength="20" /><span id="unameinfo"></span></td></tr><tr><td class="ltd">密码* </td><td><input type="password"name="upw"id="upw" size="40" maxlength="20" /></td></tr><tr><td class="ltd">确认密码* </td><td><input type="password" name="upw2"id="upw2" size="40" maxlength="20" /></td></tr><tr><td class="ltd">性别</td><td><input type="radio" name="usex"value="男"/> 男<input type="radio"name="usex"value="女"/>女<input type="radio" name="usex" value="密" checked />密</td></tr><tr><td class="ltd">Email</td><td><input type="text"name="uemail"size="40" value="<%=uemail%>" id="uemail"></td></tr><tr><td class="ltd">选择头像</td><td style="vertical-align:middle"><input type="hidden"name="ulogo"id="ulogo" value="<%=ulogo%>"/><img src="<%= ulogo.equals("") ?"images/head/space_noface.gif" : ulogo%>" id="hlogo" name="hlogo" /><br><input type="radio" name="s1"onclick="selectImg()"/>选择<input type="radio" name="s1"onclick="uploadImg()"/>上传</td></tr><tr><td class="regBottom"> </td><td class="regBottom" align="center"><input type="submit" value="确定" /> <input type="reset" value="重置" /></td></tr></tbody></table></form></div><div id="footer"><span>学习案例---《JSP实用教程》编写组</span> </div></div> <!--end of container--></body></html>chkReg.jsp<%--Document : chkReg.jspCreated on : 2015-10-23, 22:25:11Author : sunny说明：使用JavaBeabn完成注册处理--%><%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.*,dbUtil.Conn,ersBean"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><meta http-equiv="content-Type" content="text/html; charset=UTF-8"><title>保存注册信息</title></head><body><%request.setCharacterEncoding("utf-8");%><jsp:useBean class="ers" id="newuser" /><jsp:setProperty property="*" name="newuser" /> <%UsersBean ub=new UsersBean();ub.setUser(newuser);String msg = ub.basicCheck();if (msg.equals("")) msg=ub.uniqueName();if (msg.equals("")) {if (!ub.insert()) {msg = "Sorry,注册失败.";}}if (msg.equals("")) {out.println("恭喜！注册成功!");response.setHeader("refresh", "3;url=index.jsp"); } else {%><jsp:forward page="reg.jsp"><jsp:param name="msg" value="<%=msg%>" /></jsp:forward><%}%></body></html>2.用户登录模块● login_head.jsp<%@page contentType="text/html" pageEncoding="UTF-8"%><div id="logo"></div><div id="nav"><div id="welcome">欢迎进入JSP学习论坛</div><ul><li><a href="index.jsp">首页</a></li><li><a href="login.jsp">登录</a></li><li><a href="reg.jsp">注册</a></li><li><a href="mailto:neujspbook@">与我联系</a></li></ul></div>foot.jsp<%@page pageEncoding="utf-8" %><div id="footer"><jsp:include page="namelist.jsp" /><span>学习案例---《JSP实用教程》编写组</span></div>● exit.jsp<%--Document : exit.jspCreated on : 2010-5-15, 15:45:54Author : sunny--%><%@page contentType="text/html" pageEncoding="UTF-8"import="java.util.*"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>JSP学习论坛--退出登录</title></head><body><%Vectorvisitors=(Vector)application.getAttribute("namelist");if(visitors!=null&&session.getAttribute("username")!=null) visitors.remove(session.getAttribute("username"));session.removeAttribute("username");response.sendRedirect("login.jsp");%></body></html>namelist.jsp<%@page contentType="text/html" pageEncoding="UTF-8"%><%@page import="java.util.*" %><%String name = null, namelist = "";Vector visitors = (Vector)application.getAttribute("namelist");if (visitors != null) {Iterator it = visitors.iterator();while (it.hasNext()) {name = (String) it.next();namelist += name + " ";}if (!namelist.equals("")) {out.println("<p>在线会员：" + namelist+"</p>");}}%>login.jsp<%@page contentType="text/html"%><%@page pageEncoding="UTF-8"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>登录</title><link href="css/common.css" rel="stylesheet"type="text/css" /><style type="text/css">@import url("css/login.css");</style><script src="js/common.js"></script><script src="js/loginChk.js"></script></head><body onload="$('uname').focus()"><div id="container"><%@include file="login_head.jsp" %><!--下面是内容层，主要显示一个表单--><div id="content"><form action="chkLogin.jsp" method="post"onsubmit="return chkLogin()"><!--表单的各项内容用表格排列整齐--><table><tr><th colspan="2"> 请登录</th><th> </th></tr><tr style="padding-top:20px;"><td class="ltd">用户名<span class="warning">*</span></td><td> <inputtype="text" name="uname" size="20" onblur="chkName()"/></td><td class="gray"> 长度要求为3-20个字符.</td></tr><tr><td class="ltd">密码<spanclass="warning">*</span></td><td><input type="password"name="upw" size="20" onblur="chkPw()"/> </td><tdclass="gray"> 密码只能由数字或字母构成.</td></tr><tr><td>保存期限</td><td><input type="radio" name="limit" value="0" checked="checked">不保存<input type="radio" name="limit" value="30" /> 一个月<input type="radio" name="limit" value="180" /> 半年</td><td class="gray"> 在指定的期限内可自动登录</td></tr><tr><td class="bottom"> </td><td class="bottom" align="center"><input type="submit" value="确定"/> <input type="reset" value="重置" /></td></tr><tr><td> </td></tr><tr><td id="nameinfo" class="login_info"colspan="2"></td></tr><tr><td id="pwinfo" class="login_info"colspan="2"></td></tr></table></form></div> <!--end of content--><%@include file="foot.jsp" %></div> <!--end of container--></body></html>chkLogin.jsp<%@page contentType="text/html"import="java.sql.*,java.util.*,dbUtil.Conn"%><%@page pageEncoding="UTF-8"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>登录中...</title><link href="css/common.css" rel="stylesheet"type="text/css" /><script src="js/common.js"></script></head><body><%String uname, upw;request.setCharacterEncoding("utf-8");uname = request.getParameter("uname");upw = request.getParameter("upw");if (uname == null || uname.equals("")) {out.println("请输入用户名.");response.setHeader("refresh", "3;url=login.jsp");return;}if (upw == null || upw.equals("")) {out.println("请输入密码.");response.setHeader("refresh", "3;url=login.jsp");return;}boolean valid = false; //表示验证是否通过的标志Conn con = null;ResultSet rs = null;try {String sql = "select * from users where uname='" + uname + "'";con=new Conn();rs = con.executeQuery(sql);if (rs != null) {if (rs.next()) {valid = upw.equals(rs.getString("upw"));}}} catch (SQLException e) {e.printStackTrace(System.err);} finally {try {if (rs != null) {rs.close();}} catch (Exception e) {e.printStackTrace(System.err);}try {if (con != null) {con.close();}} catch (Exception e) {e.printStackTrace(System.err);}}if (valid) {session.setAttribute("username", uname);/*------开始：在线名单处理------*/Vector visitors = (Vector)application.getAttribute("namelist");if (visitors == null) {visitors = new Vector();application.setAttribute("namelist", visitors);}boolean unique = true;for (int i = 0; i < visitors.size(); i++) {if (((String) visitors.get(i)).equals(uname)) {unique = false;break;}}if (unique) {visitors.add(uname);}/*------结束：在线名单处理------*//*------开始：自动登录Cookie处理----*/int limit =Integer.parseInt(request.getParameter("limit"));Cookie c = new Cookie("username",.URLEncoder.encode(request.getParameter("uname"), "UTF-8"));c.setMaxAge(limit * 24 * 60 * 60);response.addCookie(c);/*------结束：自动登录Cookie处理----*/out.println("<br/>登录成功!正在自动转向网站首页...");response.setHeader("refresh", "3;url=index.jsp");} else {out.println("<br/>用户名或密码错误.");response.setHeader("refresh", "3;url=login.jsp");}%></body></html>3.帖子浏览模块head.jsp<%@page pageEncoding="UTF-8"%><!--link href="css/common.css" rel="stylesheet"type="text/css" /--><% String uname="游客";String pageName=request.getRequestURI();pageName=pageName.substring(stIndexOf("/")+1);if (!pageName.equals("login.jsp")) {uname= (String) session.getAttribute("username");if (uname == null) {Cookie ck[] = request.getCookies();if (ck != null) {for (int i = 0; i < ck.length; i++) {if (ck[i].getName().equals("username")) {uname =.URLDecoder.decode(ck[i].getValue(),"UTF-8");session.setAttribute("username", uname);break;}}}}if (uname == null) {response.sendRedirect(request.getContextPath()+"/login.js p");return;}}%><div id="logo"></div><div id="nav"><div id="welcome"><%=uname%>,欢迎进入JSP学习论坛</div><ul><li><a href="index.jsp">首页</a></li><% if (session.getAttribute("username") == null) { %><li><a href="login.jsp">登录</a></li><%} else {%><li><a href="exit.jsp">退出</a></li><%}%><li><a href="reg.jsp">注册</a></li><li><a href="mailto:neujspbook@">与我联系</a></li></ul></div><div style="display:none;" id="errorMsg"></div>index.jsp<%--Document : index.jspCreated on : 2015-5-22, 23:01:39Author : sunny--%><%@page contentType="text/html" pageEncoding="UTF-8" import="dbUtil.*,java.sql.*"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>JSP学习论坛---首页</title><link rel="stylesheet" href="css/common.css" /></head><body><% //确定搜索条件String searchStr = "",linkStr="";if (request.getParameter("keyValue") !=null&&!request.getParameter("keyValue").equals("")) { StringkeyField=request.getParameter("keyField");String keyValue = newString(request.getParameter("keyValue").getBytes("iso8859 -1"), "utf-8");searchStr="where"+keyField+"like'%"+keyValue+ "%'";linkStr="&keyValue="+keyValue+"&keyField="+keyField;}//获取页号String spageno = request.getParameter("pageno");if (spageno==null) spageno="1";int pageno = 1; //默认页号为1try {pageno = Integer.parseInt(spageno);} catch (Exception e) {e.printStackTrace(System.err);}//创建数据库连接Conn con=null;ResultSet rs = null;try {con=new Conn();} catch (Exception e) {e.printStackTrace(System.err);out.println("抱歉，网站出错，暂时无法提供服务.");return;}//计算页号导航int allpage = 0, allrec=0,pagesize = 10; //每页显示10条记录rs = con.executeQuery("select count(*) as total from posts " + searchStr);if (rs != null && rs.next()) {allrec = rs.getInt(1);}allpage=allrec%pagesize==0?allrec/pagesize:allrec/pagesiz e+1;int firstp = 1, lastp = allpage;if (pageno - 3 > 1) {firstp = pageno - 3;}if (pageno + 3 < lastp) {lastp = pageno + 3;}%><div id="container"><%@ include file="/head.jsp" %><div id="content"><div id="postlist"><div id="newPostLink"><a href="newPost.jsp"><img。
![[工学]JSP实验指导书](https://img.taocdn.com/s1/m/a750c48a9b6648d7c0c7466b.png)
