广东商学院 web开发实验项目六 Web数据库开发实验-Web-

实验报告课程名称Web开发技术实验项目名称实验项目六Web数据库技术开发实验班级与班级代码(2012-2013-1)-113283-11006-2实验室名称（或课室）实验楼403专业2010信息管理与信息系统1班任课教师傅清波学号：姓名：实验日期：2012 年 11 月 27 日广东商学院教务处制姓名实验报告成绩评语：指导教师（签名）年月日说明：指导教师评分后，实验报告交院（系）办公室保存。

实验项目六Web数据库技术开发实验论坛开发一、实验目的1、掌握JDBC技术开发方法；2、掌握JavaBean开发方法；3、掌握Servlet实际应用开发方法；4、熟悉JSP的技术应用。

二、实验内容参照书中第28章内容，开发一个简单的论坛系统。

三、实验原理JDBC基本操作原理、JavaBean原理和Servlet原理。

四、实验环境电脑主机CPU intel core i5-2450m、RAM 6G，操作系统Windows 7 64位，开发工具Myeclipse8.5，数据库SQL server 2005。

五、实验步骤1、建立一个web工程，工程名是“NMBBS2”；2、编写用于登录、发表新话题、发表新回复、显示论坛内容、对主题进行分页显示、过滤器以及servlet；3、调试本地数据库，创建相对应的数据库和数据表，配置对应的驱动包；4、编写相应的JSP页面，包括首页、注册、登录、查看帖子、帖子内容、发表及回复页面等。

5、配置web.xml文件，进行网站布局与美化；6、进行最终调试，发现问题并解决。

六、实验结果经过调试与修改，最终得到的实验结果如下：1、论坛首页：图1：论坛首页2、注册页面及注册成功页面：图2：注册页面图3：注册成功返回信息页面3、登录页面及登录成功后的首页：图4：登录页面图5：登录成功后的首页4、发表新话题页面图6：发表新话题页面5、论坛帖子列表界面：图7：论坛帖子列表界面图8：论坛帖子列表界面——分页效果图9：论坛帖子列表界面——删除一个话题后6、帖子内容界面：图10：帖子具体内容界面图11：帖子具体内容页面以及评论七、实验分析1、在本次实验中，用javabean和servlet来实现登录，主题和评论的发表、编辑、删除，控制分页。

●PageBusiness.java：控制分页●Forum.java：帖子列表读取●page.java：控制分页●Topic.java：帖子内容读取●TopicVO.java：帖子内容输入输出●DeleteTopicServlet.java：删除帖子●EditTopicServlet.java：编辑帖子●ForumServlet.java：帖子列表●LoginServlet.java：控制登录●NewTopicServlet.java：发表新话题●ReplyTopicServlet.java：添加评论2、通过EncodingFilter.java实现过滤器。

3、网站主要JSP页面及其功能如下：●editTopic.jsp：编辑帖子内容●error.jsp：出错信息返回页面●index.jsp：网站首页●Login.jsp：登录页面●login1.jsp：用户登录信息显示●logout.jsp：注销登录●MyJsp.jsp：处理登录请求●newTopic.jsp：发表新话题●pageman.jsp：控制分页●register.jsp：处理注册请求●register1.jsp：注册页面●reply.jsp：添加评论页面●trans.jsp：统一编码转换●viewDetail.jsp：帖子内容●viewForum.jsp：论坛帖子列表4、数据库采用SQL server 2005，主要设计一个数据库，三个数据表，其中数据库名为jspdev，三个数据表为userinf、reply、topic。

（1）topic表：用于存储帖子信息，其字段及数据类型如下：说明：●id——帖子ID●title——标题●author——作者●email——电子邮件●content——内容●pubtime——发表时间（2）topic：用于存储用户信息，其字段及数据类型如下：说明：●uname——用户名●upwd——用户密码●uemail——电子邮件●usex——性别●ubirthday——出生日期（3）reply表：用于存储帖子评论信息，其字段及数据类型如下：●id——评论ID●topicId：主题ID●title——标题●author——作者●email——电子邮件●content——内容●pubtime——评论时间5、对web.xml进行过滤器和servlet配置，如下图所示：6、包含的驱动程序有pager-taglib.jar和sqljdbc4.jar，其中pager-taglib.jar 用于分页，sqljdbc4.jar用于连接SQL server 2005数据库均放置于/WEB-INF/lib 文件夹下；7、在images文件夹和include文件夹里分别存放的是背景图片、javascript和css文件；8、网站总体结构图如下图所示：首页八、实验结论在本次实验中，遇到有不少的问题，整个论坛所涉及的知识比较多且比较难，通过不断的查阅资料和与他人交流最后才解决问题，其中我认为遇到比较棘手的问题有：1、web.xml文件的配置。

曾经在配置文件中打少了一个符号，导致整个网站都出错，最后逐一排查才发现此错误，时间浪费了不少；2、在数据库连接的方式上我选择了JDBC，对于这种连接方式，最重要的是驱动程序要对应，书本上的代码均基于SQL server 2000，其驱动程序为msbase.jar、mssqlserver.jar、msutil.jar，而对于SQL server 2005，其驱动程序仅需一个sqljdbc4.jar，同时在编程过程中，SQL server 2000对应的驱动类是com.microsoft.jdbc.sqlserver.SQLServerDriver，而SQLserver 2005的驱动类是com.microsoft.sqlserver.jdbc.SQLServerDriver；3、任何一个细节都要认真注意，在连接数据库的过程中，驱动已配置完成，程序运行却提示异常，最后发现是在某条SQL语句上写少了一个引号，可见在编程中一个小小的错误都能导致不可估量的错误；总的来说，本次实验是在不断地发现错误和不断地解决错误的过程中艰苦完成的过程，过程虽艰辛，但最后还是完成了整个论坛的实验，也学习和巩固了不少的知识。

附源代码：//PageBusiness.java(\NMBBS2\src\business)package business;import java.sql.*;import java.sql.ResultSet;import javabean.page;public abstract class PageBusiness {java.util.Vector v ;public abstract int getAvailableCount()throws Exception;public java.util.Vector getResult()throws Exception{return v;}protected final int getAvailableCountHelper(Connection conn,String tableName)throws Exception{// int re=0;Statement stmt=conn.createStatement();String strSql="select count(*) from "+tableName;ResultSet rs=stmt.executeQuery(strSql);while(rs.next()){re=rs.getInt(1);}return re;}public abstract page listDate(String page)throws Exception;}//EncodingFilter.java(\NMBBS2\src\filter)package filter;import javax.servlet.FilterChain;import javax.servlet.ServletRequest;import javax.servlet.ServletResponse;import java.io.IOException;import javax.servlet.Filter;import javax.servlet.http.HttpServletRequest;import javax.servlet.ServletException;import javax.servlet.FilterConfig;public class EncodingFilter implements Filter{protected FilterConfig filterConfig;private String targetEncoding = "gb2312";public void init(FilterConfig config) throws ServletException {this.filterConfig = config;this.targetEncoding = config.getInitParameter("encoding");}public void doFilter(ServletRequest srequest, ServletResponse sresponse, FilterChain chain) throws IOException, ServletException {HttpServletRequest request = (HttpServletRequest)srequest;request.setCharacterEncoding(targetEncoding);chain.doFilter(srequest,sresponse);}public void setFilterConfig(final FilterConfig filterConfig){this.filterConfig=filterConfig;}public void destroy(){this.filterConfig=null;}}//Forum.java(\NMBBS2\src\javabean)package javabean;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.Statement;import java.util.Vector;import .apache.regexp.internal.recompile;import business.*;import javabeanVO.*;import javabean.*;public class Forum extends PageBusiness{java.util.Vector v ;private Connection conn;public Forum()throws Exception{super();try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");}catch(ClassNotFoundException e){}conn=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jspdev","sa","" );v=new Vector();}public int getAvailableCount()throws Exception{return this.getAvailableCountHelper(conn,"topic");}public Vector getResult()throws Exception{return v;}@Overridepublic page listDate(String page) throws Exception {try {page pagebean=new page(this);int pageNum=Integer.parseInt(page);Statement stmt=conn.createStatement();ResultSet rs=stmt.executeQuery("select top "+pageNum*pagebean.rowsPerPage+" * from topic order by pubtime");int i=0;while(rs.next()){if(i>(pageNum-1)*pagebean.rowsPerPage-1){Object[] obj=new Object[4];obj[0]=rs.getString("title");obj[1]=rs.getString("author");obj[2]=rs.getString("pubtime");obj[3]=rs.getString("id");v.add(obj);}i++;}rs.close();stmt.close();conn.close();pagebean.curPage=pageNum;pagebean.data=v;return pagebean;}catch(Exception e){e.printStackTrace();throw e;}}}//page.java(\NMBBS2\src\javabean)package javabean;import java.sql.Connection;import java.sql.DriverManager;import java.sql.Statement;import java.util.Vector;import javabean.Forum;import business.PageBusiness;public class page {public int curPage;public int maxPage;public int maxRowCount;public int rowsPerPage=5;public java.util.Vector data;public page(){}public void countMaxPage(){if(this.maxRowCount%this.rowsPerPage==0){this.maxPage=this.maxRowCount/this.rowsPerPage;}else{this.maxPage=this.maxRowCount/this.rowsPerPage+1;}}public Vector getResult() throws Exception{return this.data;}public page(PageBusiness pageBusiness)throws Exception{ this.maxRowCount=pageBusiness.getAvailableCount();this.data=pageBusiness.getResult();this.countMaxPage();}}//Topic.java(\NMBBS2\src\javabean)package javabean;import java.util.*;import java.sql.*;import javabeanVO.TopicVO;public class Topic {Connection con;public Topic()throws Exception{super();}public TopicVO getTopic (String topicId)throws Exception{try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");}catch(ClassNotFoundException e){}/*if(con.isClosed())*/ con =DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jspdev","sa","");Statement stmt=con.createStatement();ResultSet rs=stmt.executeQuery("select * from topic where id='"+topicId+"'");TopicVO top=new TopicVO();if(rs.next()){top.setId(rs.getString("id"));top.setTitle(rs.getString("title"));top.setContent(rs.getString("content"));top.setEmail(rs.getString("email"));top.setAuthor(rs.getString("author"));top.setPubTime(rs.getDate("pubtime"));}rs.close();con.close();return top;}public TopicVO getReply(String replyId)throws Exception{try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");}catch(ClassNotFoundException e){}/*if(con.isClosed())*/ con =DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jspdev","sa","");PreparedStatement stmt=con.prepareStatement("select * from reply where id=?");stmt.setString(1, replyId);ResultSet rs=stmt.executeQuery();TopicVO top=new TopicVO();if(rs.next()){top.setId(rs.getString("id"));top.setTopicId(rs.getString("topicId"));top.setTitle(rs.getString("title"));top.setContent(rs.getString("content"));top.setEmail(rs.getString("email"));top.setAuthor(rs.getString("author"));top.setPubTime(rs.getDate("pubtime"));}rs.close();con.close();return top;}public Collection getReplys(String topicId)throws Exception{try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");}catch(ClassNotFoundException e){}/*if(con.isClosed())*/ con =DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jspdev","sa","");PreparedStatement stmt=con.prepareStatement("select * from reply where topicId=?");stmt.setString(1, topicId);ResultSet rs=stmt.executeQuery();Collection re=new ArrayList();if(rs.next()){TopicVO top=new TopicVO();top.setId(rs.getString("id"));top.setTopicId(rs.getString("topicId"));top.setTitle(rs.getString("title"));top.setContent(rs.getString("content"));top.setEmail(rs.getString("email"));top.setAuthor(rs.getString("author"));top.setPubTime(rs.getDate("pubtime"));re.add(top);}rs.close();stmt.close();con.close();return re;}}//TopicVO.java(\NMBBS2\src\javabeanVO) package javabeanVO;import java.util.Date;public class TopicVO implements java.io.Serializable{ private String id;private String title;private String author;private String content;private String email;private java.util.Date pubtime;private String topicId;public String getTopicId() {return topicId;}public void setTopicId(String topicId) {this.topicId = topicId;}public Date getPubTime() {return pubtime;}public void setPubTime(Date pubtime) {this.pubtime = pubtime;}public String getContent() {return content;}public void setContent(String content) {this.content = content;}public String getTitle() {return title;}public void setTitle(String title) {this.title = title;}public String getAuthor() {return author;}public void setAuthor(String author) {this.author = author;}public void setEmail(String email) {this.email = email;}public String getEmail() {return email;}public String getId() {return id;}public void setId(String id) {this.id = id;}}//DeleteTopicServlet.java(\NMBBS2\src\servlet)package servlet;import java.io.IOException;import java.io.PrintWriter;import java.sql.*;import javabean.Forum;import javabean.page;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import business.PageBusiness;public class DeleteTopicServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setCharacterEncoding("GBK");try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");}catch(ClassNotFoundException e){}try{String id=request.getParameter("id");String type=request.getParameter("type");String sql="";if(type.equals("reply"))sql="delete from reply where id='"+id+"'";elsesql="delete from reply where topicId='"+id+"';delete from topic where id='"+id+"'";Connectioncon=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jspdev","sa","");Statement stmt=con.createStatement();stmt.executeUpdate(sql);stmt.close();PageBusiness p=new Forum();page pageCtl=p.listDate("1");request.setAttribute("pageCtl", pageCtl);}catch(Exception e){e.printStackTrace();}javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("viewForum.jsp");dis.forward(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setCharacterEncoding("GBK");doGet(request,response);}}//EditTopicServlet.java(\NMBBS2\src\servlet)package servlet;import business.*;import javabean.Forum;import javabean.page;import javax.servlet.http.*;import java.sql.*;import java.io.*;public class EditTopicServlet extends javax.servlet.http.HttpServlet{public void doGet(HttpServletRequest request,HttpServletResponse response)throws javax.servlet.ServletException,java.io.IOException{ response.setCharacterEncoding("GBK");try{String type=request.getParameter("type");String id=request.getParameter("id");String title=request.getParameter("title");String author=request.getParameter("author");String email=request.getParameter("email");String content=request.getParameter("content");String sql="";if(type.equals("topic"))sql="update topic set title='"+title+"',author='"+author+"',email='"+email+"',content='"+content+"' where id='"+id+"'";elsesql="update reply set title='"+title+"',author='"+author+"',email='"+email+"',content='"+content+"' where id='"+id+"'";try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");}catch(ClassNotFoundException e){}Connection con =DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jspdev","sa","");Statement stmt=con.createStatement();stmt.executeUpdate(sql);stmt.close();con.close();PageBusiness pb=new Forum();page pageCtl = pb.listDate("1");request.setAttribute("pageCtl",pageCtl);}catch(Exception e){e.printStackTrace();}javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("viewForum.jsp");dis.forward(request,response);}public void doPost(HttpServletRequest request,HttpServletResponse response)throws javax.servlet.ServletException,java.io.IOException{ response.setCharacterEncoding("GBK");doGet(request,response);}}//ForumServlet.java (\NMBBS2\src\servlet)package servlet;import java.io.IOException;import java.io.PrintWriter;import javabean.Forum;import javabean.page;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import business.PageBusiness;public class ForumServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setCharacterEncoding("GBK");response.setContentType("text/html");PrintWriter out = response.getWriter();try{PageBusiness p=new Forum();page pageCtl=p.listDate((String)request.getParameter("jumpPage"));request.setAttribute("pageCtl", pageCtl);}catch(Exception e){e.printStackTrace();}javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("viewForum.jsp");dis.forward(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setCharacterEncoding("GBK");doGet(request,response);}}//LoginServlet.java (\NMBBS2\src\servlet)package servlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.sql.*;public class LoginServlet extends HttpServlet {public LoginServlet() {super();}public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setCharacterEncoding("GBK");response.setContentType("text/html");PrintWriter out = response.getWriter();String name = request.getParameter("name");String password=request.getParameter("password");Statement sql;ResultSet rs;try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");}catch(ClassNotFoundException e){}try{Connectioncon=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jspdev","sa","");sql=con.createStatement();System.out.print("bbs");rs=sql.executeQuery("SELECT * FROM userinf where name='"+name+"' and password='"+password+"'");int k=0;while(rs.next()){ k++;}con.close();if(k>0){request.setAttribute("uname",name );out.print("登录成功，进入主页！");response.sendRedirect("register1.jsp");}else{out.print("无此账号，返回<a href='index.jsp'>首页</a>，请先<a href='Login.jsp'>注册</a>"); }}catch(SQLException e){}}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setCharacterEncoding("GBK");doGet(request,response);}}//NewTopicServlet.java (\NMBBS2\src\servlet)package servlet;import business.*;import java.sql.*;import java.io.*;import javabean.Forum;import javabean.page;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;/***发布新的主题*/public class NewTopicServlet extends javax.servlet.http.HttpServlet{public void doGet(HttpServletRequest request,HttpServletResponse response)throws javax.servlet.ServletException,java.io.IOException{ response.setCharacterEncoding("GBK");response.setContentType("text/html");PrintWriter out = response.getWriter();try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");}catch(ClassNotFoundException e){}try{/***获得请求中的参数*/request.setCharacterEncoding("GBK");String title=request.getParameter("title");String author=request.getParameter("author");String email=request.getParameter("email");String content=request.getParameter("content");Connectioncon=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jspdev","sa","");Statement stmt=con.createStatement();/***执行数据库更新操作，把回复的信息保存到数据库中*/stmt.executeUpdate("insert into topic values('"+new java.util.Date().getTime()+"','"+title+"','"+author+"','"+email+"','"+content+"',getdate())");stmt.close();con.close();PageBusiness pb=new Forum();page pageCtl = pb.listDate("1");request.setAttribute("pageCtl",pageCtl);}catch(Exception e){e.printStackTrace();}/***把视图派发到viewForum.jsp*/javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("viewForum.jsp");dis.forward(request,response);}public void doPost(HttpServletRequest request,HttpServletResponse response)throws javax.servlet.ServletException,java.io.IOException{ response.setCharacterEncoding("GBK");doGet(request,response);}}//ReplyTopicServlet.java (\NMBBS2\src\servlet)package servlet;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.DriverManager;import java.sql.Statement;import javabean.Forum;import javabean.page;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import business.PageBusiness;public class ReplyTopicServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setCharacterEncoding("GBK");try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");}catch(ClassNotFoundException e){}try{String topicId=request.getParameter("topicId");System.out.println(topicId);String title=request.getParameter("title");String author=request.getParameter("author");String email=request.getParameter("email");String content=request.getParameter("content");Connectioncon=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jspdev","sa","");Statement stmt=con.createStatement();stmt.executeUpdate("insert into reply values('"+new java.util.Date().getTime()+"','"+topicId+"','"+title+"','"+author+"','"+email+"','"+content+"',getd ate())");stmt.close();con.close();PageBusiness p=new Forum();page pageCtl=p.listDate("1");request.setAttribute("pageCtl",pageCtl);}catch(Exception e){e.printStackTrace();}javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("viewForum.jsp");dis.forward(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setCharacterEncoding("GBK");doGet(request,response);}}//editTopic.jsp(\NMBBS2\WebRoot)<%@ page contentType="text/html;charset=GBK" language="java" errorPage="error.jsp"%><%@page import="javabeanVO.TopicVO"%><%@ include file="trans.jsp" %><%request.setCharacterEncoding("GBK");%><jsp:useBean id="topic" class="javabean.Topic" scope="page"/><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><script language="javascript"><!--Begin validation scriptfunction checkForm(){if(document.form1.title.value==""){alert("请输入标题！");return false;}if(document.form1.content.value==""){alert("请输入内容！");return false;}return true;}--></script><title>Untitled Document</title><meta http-equiv="Content-Type" content="text/html;charset=GBK"><%javabeanVO.TopicVO top=new javabeanVO.TopicVO();String type=request.getParameter("type");String id=request.getParameter("id");if(type.equals("topic")) top=topic.getTopic(id);else if(type.equals("reply")) top=topic.getReply(id);else out.println("error"); %></head><body><form name="form1" action="edittopic" method=post onSubmit="return checkForm()"><table align="center" bgcolor="#008800" width=80% border="0" cellpadding="5" cellspacing="2"> <tr bgcolor="#66FFFF"><td>标题</td><td><input type=text name="title" value=<%=trans(top.getTitle())%>></td></tr><tr bgcolor="#CCFFCC"><td>作者</td><td><input type="text" value=<%=trans(top.getAuthor())%> name=author></td></tr><tr bgcolor="#FFFFCC"><td>电子邮件</td><td><input type="text" value=<%=trans(top.getEmail())%> name=email></td></tr><tr bgcolor="#FFCC99"><td>内容</td><td><textarea cols=40 rows=9 name=content><%=trans(top.getContent()) %></textarea></td> </tr><tr bgcolor="#99FF66"><input type=hidden name=id value=<%=top.getId()%> ><input type=hidden name=type value=<%=type%> ><td>提交</td><td><input type=submit value=提交> </td></tr></table></form></body></html>//error.jsp(\NMBBS2\WebRoot)<%@ page contentType="text/html;charset=GBK" language="java" isErrorPage="true" %><%request.setCharacterEncoding("GBK");%><html><head><title>出错了！</title><meta http-equiv="Content-Type" content="text/html;charset=GBK"></head><body>出错了！<br>发生了以下的错误：<br><hr><font color=red><%=exception.getMessage()%></font></body></html>//index.jsp(\NMBBS2\WebRoot)<%@ page language="java" contentType="text/html;charset=GBK" %><%request.setCharacterEncoding("GBK"); %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html xmlns="/1999/xhtml"><head><title>book shop</title><meta http-equiv="Content-Type" content="text/html;charset=GBK"><link rel="stylesheet" type="text/css" href="include/style.css" /><style type="text/css"><!--#apDiv1 {position:absolute;width:200px;height:115px;z-index:1;left: 817px;top: 323px;font-size: 16px;color: #600;font-weight: bold;font-family: Arial, Helvetica, sans-serif;}--></style></head><body class="bg"><strong><font color="#008040"><font size="7"><br></font></font></strong><div id="navb"><font color="#008040"><a href="register1.jsp" class="be">注册</a><jsp:include。