JAVA-EE模板方法模式保留405的形式实现页面效果------计算机网络经典

清疚 2024-02-22 03:03 28阅读 0赞

>     package com.bjpowernode.oa.web.action;
>     
>     import com.bjpowernode.oa.utils.DBUtil;
>     import jakarta.servlet.ServletException;
>     import jakarta.servlet.annotation.WebServlet;
>     import jakarta.servlet.http.HttpServlet;
>     import jakarta.servlet.http.HttpServletRequest;
>     import jakarta.servlet.http.HttpServletResponse;
>     
>     import java.io.IOException;
>     import java.io.PrintWriter;
>     import java.sql.Connection;
>     import java.sql.PreparedStatement;
>     import java.sql.ResultSet;
>     import java.sql.SQLException;
>     
>     //模板类
>     //@WebServlet({"/dept/list","/dept/save","/dept/edit","/dept/detail","/dept/delete","/dept/modify"})
>     //也可以使用模糊匹配,只要请求路径是/dept开始的,都在此处处理
>     //@WebServlet("/dept/*")
>     public class DeptAction extends HttpServlet
>     {
>         //模板方法
>         //因为我们的模板方法可能处理的是get或者post或者delete等等方法,所以我们只能去重写这个方法的上一层即Service方法
>         @Override
>         protected void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
>         {
>             String servletPath = request.getServletPath();
>             if("/dept/list".equals(servletPath))
>             {
>                 doList(request,response);
>             }
>             else if("/dept/detail".equals(servletPath))
>             {
>                 doDetail(request,response);
>             }
>             else if("/dept/delete".equals(servletPath))
>             {
>                 doDel(request,response);
>             }
>         }
>     
>         @Override
>         protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
>             String servletPath = request.getServletPath();
>             if("/dept/save".equals(servletPath))
>             {
>                 doSave(request,response);
>             }
>             else if("/dept/edit".equals(servletPath))
>             {
>                 doEdit(request,response);
>             }
>             else if("/dept/modify".equals(servletPath))
>             {
>                 doModify(request,response);
>             }
>         }
>     
>         private void doList(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
>         {
>             String contextPath = request.getContextPath();
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             response.setContentType("text/html;charset=UTF-8");
>             PrintWriter writer = response.getWriter();
>             writer.println("<!DOCTYPE html>");
>             writer.println("<html>");
>             writer.println("	<head>");
>             writer.println("		<meta charset='utf-8'>");
>             writer.println("		<title>部门列表</title>");
>             writer.println("	</head>");
>             writer.println("	<body>");
>             writer.println("\t<script type=\"text/javascript\">\n" +
>                     "\t\tfunction del(dno){\n" +
>                     "\t\t\tvar ok = window.confirm(\"是否确认删除该数据\");\n" +
>                     "\t\t\tif(ok)\n" +
>                     "\t\t\t{\n" +
>                     "\t\t\t\twindow.location.href = \"" + contextPath + "/dept/delete?deptno=\"+dno\n" +
>                     "\t\t\t}\n" +
>                     "\t\t}\n" +
>                     "\t</script>");
>             writer.println("		<h1 align='center'>部门列表</h1>");
>             writer.println("		<hr>");
>             writer.println("		<table align='center' border='1px' width='50%'>");
>             writer.println("			<tr>");
>             writer.println("				<th>序号</th>");
>             writer.println("				<th>部门编号</th>");
>             writer.println("				<th>部门名称</th>");
>             writer.println("				<th>部门位置</th>");
>             writer.println("				<th>操作</th>");
>             writer.println("			</tr>");
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 String sql = "select * from dept";
>                 statement = connection.prepareStatement(sql);
>                 resultSet = statement.executeQuery();
>                 int i = 0;
>                 while(resultSet.next())
>                 {
>                     String deptno = resultSet.getString("deptno");
>                     String dname = resultSet.getString("dname");
>                     String loc = resultSet.getString("loc");
>                     writer.println("			<tr>");
>                     writer.println("				<td>" + (++i) + "</td>");
>                     writer.println("				<td>" + (deptno) + "</td>");
>                     writer.println("				<td>" + (dname) + "</td>");
>                     writer.println("				<td>" + (loc) + "</td>");
>                     writer.println("				<td>");
>                     writer.println("					<a href=\"javascript:void(0)\"  onclick=\"del("+(deptno)+")\">删除</a>");
>                     writer.println("					<a href='" + (contextPath) + "/dept/edit?deptno=" + deptno +"'>修改</a>");
>                     writer.println("					<a href='" + (contextPath) + "/dept/detail?deptno=" + deptno +"'>详情</a>");
>                     writer.println("				</td>");
>                     writer.println("			</tr>");
>                 }
>             }
>             catch (SQLException e)
>             {
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>             writer.println("		</table>");
>             writer.println("		<hr>");
>             writer.println("		<a href='"+ contextPath + "/add.jsp'>新增部门</a>");
>             writer.println("	</body>");
>             writer.println("</html>");
>         }
>         private void doSave(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException
>         {
>             request.setCharacterEncoding("UTF-8");
>             Integer deptno = Integer.parseInt(request.getParameter("deptno"));
>             String dname = request.getParameter("dname");
>             String loc = request.getParameter("loc");
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             String contextPath = request.getContextPath();
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 connection.setAutoCommit(false);
>                 String sql = "insert into dept(deptno,dname,loc) values(?,?,?)";
>                 statement = connection.prepareStatement(sql);
>                 statement.setInt(1,deptno);
>                 statement.setString(2,dname);
>                 statement.setString(3,loc);
>                 int count = statement.executeUpdate();
>                 connection.commit();
>                 if(count == 1)
>                 {
>                     response.sendRedirect(contextPath + "/dept/list");
>                 }
>                 else
>                 {
>                     response.sendRedirect("/Error.html");
>     
>                 }
>             }
>             catch (SQLException e)
>             {
>                 if (connection != null) {
>                     try {
>                         connection.rollback();
>                     } catch (SQLException ex) {
>                         throw new RuntimeException(ex);
>                     }
>                 }
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>         }
>         private void doEdit(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException
>         {
>             String deptno = request.getParameter("deptno");
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             response.setContentType("text/html;charset=UTF-8");
>             PrintWriter out = response.getWriter();
>             String contextPath = request.getContextPath();
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 String sql = "select * from dept where deptno = ?";
>                 statement = connection.prepareStatement(sql);
>                 statement.setString(1,deptno);
>                 resultSet = statement.executeQuery();
>                 if(resultSet.next())
>                 {
>                     String dname = resultSet.getString("dname");
>                     String loc = resultSet.getString("loc");
>                     out.println("<!DOCTYPE html>\n" +
>                             "<html>\n" +
>                             "\t<head>\n" +
>                             "\t\t<meta charset=\"utf-8\">\n" +
>                             "\t\t<title>修改部门</title>\n" +
>                             "\t</head>\n" +
>                             "\t<body>\n" +
>                             "\t\t<h1>修改部门</h1>\n" +
>                             "\t\t<hr>\n" +
>                             "\t\t<form method=\"post\" action=\"" + contextPath +"/dept/modify\">\n" +
>                             "\t\t\t部门编号:<input type=\"text\" name=\"deptno\" value=\"" + deptno);
>                     out.println("\" readonly/><br>\n" +
>                             "\t\t\t部门名称:<input type=\"text\" name=\"dname\" value=\"" + dname + "\"");
>                     out.println("/><br>\n" +
>                             "\t\t\t部门位置:<input type=\"text\" name=\"loc\" value=\"" + loc + "\"");
>                     out.println("\"/><br>\n" +
>                             "\t\t\t<input type=\"submit\" value=\"保存\"/>\n" +
>                             "\t\t</form>\n" +
>                             "\t</body>\n" +
>                             "</html>");
>                 }
>             }
>             catch (SQLException e)
>             {
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>         }
>         private void doDetail(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException
>         {
>             response.setContentType("text/html;charset=UTF-8");
>             PrintWriter out = response.getWriter();
>             String deptno = request.getParameter("deptno");
>             Connection connection = null;
>             ResultSet resultSet = null;
>             PreparedStatement statement = null;
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 String sql = "select * from dept where deptno = " + deptno;
>                 statement = connection.prepareStatement(sql);
>                 resultSet = statement.executeQuery();
>                 if(resultSet.next())
>                 {
>                     String deptno1 = resultSet.getString("deptno");
>                     String dname = resultSet.getString("dname");
>                     String loc = resultSet.getString("loc");
>                     out.println("<!DOCTYPE html>\n" +
>                             "<html>\n" +
>                             "\t<head>\n" +
>                             "\t\t<meta charset=\"utf-8\">\n" +
>                             "\t\t<title>部门详情</title>\n" +
>                             "\t</head>\n" +
>                             "\t<body>\n" +
>                             "\t\t<h1>部门详情</h1>\n" +
>                             "\t\t<hr>");
>                     out.println("部门编号:" + deptno + "<br>");
>                     out.println("部门名称:" + dname + "<br>");
>                     out.println("部门位置:" + loc + "<br>");
>                     out.println("\t\t\n" +
>                             "\t\t<input type=\"button\" value=\"后退\" onclick=\"window.history.back()\"/>\n" +
>                             "\t</body>\n" +
>                             "</html>");
>                 }
>             }
>             catch (SQLException e)
>             {
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>         }
>         private void doModify(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException
>         {
>             request.setCharacterEncoding("UTF-8");
>             String deptno = request.getParameter("deptno");
>             String dname = request.getParameter("dname");
>             String loc = request.getParameter("loc");
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 connection.setAutoCommit(false);
>                 String sql = "update dept set dname = ?,loc = ? where deptno = ?";
>                 statement = connection.prepareStatement(sql);
>                 statement.setString(1,dname);
>                 statement.setString(2,loc);
>                 statement.setString(3,deptno);
>                 int count = statement.executeUpdate();
>                 connection.commit();
>                 if(count == 1)
>                 {
>                     response.sendRedirect(request.getContextPath() + "/dept/list");
>                 }
>                 else
>                 {
>                     response.sendRedirect("/Error.html");
>                 }
>             }
>             catch (SQLException e)
>             {
>                 if (connection != null) {
>                     try {
>                         connection.rollback();
>                     } catch (SQLException ex) {
>                         throw new RuntimeException(ex);
>                     }
>                 }
>                 throw new RuntimeException(e);
>             }
>             finally {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>         }
>         private void doDel(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException
>         {
>             String dno = request.getParameter("deptno");
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             response.setContentType("text/html;charset=UTF-8");
>             PrintWriter out = response.getWriter();
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 connection.setAutoCommit(false);
>                 String sql = "delete from dept where deptno = ?";
>                 statement = connection.prepareStatement(sql);
>                 statement.setString(1,dno);
>                 int count = statement.executeUpdate();
>                 connection.commit();
>                 //删除我们选择了转发而不是重定向
>                 if(count == 1)
>                 {
>                     request.getRequestDispatcher("/dept/list").forward(request,response);
>                 }
>                 else
>                 {
>                     request.getRequestDispatcher("/Error.html").forward(request,response);
>                 }
>             }
>             catch (SQLException e)
>             {
>                 if (connection != null) {
>                     try {
>                         connection.rollback();
>                     } catch (SQLException ex) {
>                         throw new RuntimeException(ex);
>                     }
>                 }
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>         }
>     }
> 
>     package com.bjpowernode.oa.web.action;
>     
>     import com.bjpowernode.oa.utils.DBUtil;
>     import jakarta.servlet.ServletException;
>     import jakarta.servlet.annotation.WebServlet;
>     import jakarta.servlet.http.HttpServlet;
>     import jakarta.servlet.http.HttpServletRequest;
>     import jakarta.servlet.http.HttpServletResponse;
>     
>     import java.io.IOException;
>     import java.io.PrintWriter;
>     import java.sql.Connection;
>     import java.sql.PreparedStatement;
>     import java.sql.ResultSet;
>     import java.sql.SQLException;
>     
>     //模板类
>     //@WebServlet({"/dept/list","/dept/save","/dept/edit","/dept/detail","/dept/delete","/dept/modify"})
>     //也可以使用模糊匹配,只要请求路径是/dept开始的,都在此处处理
>     //@WebServlet("/dept/*")
>     public class DeptAction extends HttpServlet
>     {
>         //模板方法
>         //因为我们的模板方法可能处理的是get或者post或者delete等等方法,所以我们只能去重写这个方法的上一层即Service方法
>         @Override
>         protected void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
>         {
>             String servletPath = request.getServletPath();
>             if("/dept/list".equals(servletPath))
>             {
>                 doList(request,response);
>             }
>             else if("/dept/detail".equals(servletPath))
>             {
>                 doDetail(request,response);
>             }
>             else if("/dept/delete".equals(servletPath))
>             {
>                 doDel(request,response);
>             }
>         }
>     
>         @Override
>         protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
>             String servletPath = request.getServletPath();
>             if("/dept/save".equals(servletPath))
>             {
>                 doSave(request,response);
>             }
>             else if("/dept/edit".equals(servletPath))
>             {
>                 doEdit(request,response);
>             }
>             else if("/dept/modify".equals(servletPath))
>             {
>                 doModify(request,response);
>             }
>         }
>     
>         private void doList(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
>         {
>             String contextPath = request.getContextPath();
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             response.setContentType("text/html;charset=UTF-8");
>             PrintWriter writer = response.getWriter();
>             writer.println("<!DOCTYPE html>");
>             writer.println("<html>");
>             writer.println("    <head>");
>             writer.println("       <meta charset='utf-8'>");
>             writer.println("       <title>部门列表</title>");
>             writer.println("    </head>");
>             writer.println("    <body>");
>             writer.println("\t<script type=\"text/javascript\">\n" +
>                     "\t\tfunction del(dno){\n" +
>                     "\t\t\tvar ok = window.confirm(\"是否确认删除该数据\");\n" +
>                     "\t\t\tif(ok)\n" +
>                     "\t\t\t{\n" +
>                     "\t\t\t\twindow.location.href = \"" + contextPath + "/dept/delete?deptno=\"+dno\n" +
>                     "\t\t\t}\n" +
>                     "\t\t}\n" +
>                     "\t</script>");
>             writer.println("       <h1 align='center'>部门列表</h1>");
>             writer.println("       <hr>");
>             writer.println("       <table align='center' border='1px' width='50%'>");
>             writer.println("          <tr>");
>             writer.println("             <th>序号</th>");
>             writer.println("             <th>部门编号</th>");
>             writer.println("             <th>部门名称</th>");
>             writer.println("             <th>部门位置</th>");
>             writer.println("             <th>操作</th>");
>             writer.println("          </tr>");
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 String sql = "select * from dept";
>                 statement = connection.prepareStatement(sql);
>                 resultSet = statement.executeQuery();
>                 int i = 0;
>                 while(resultSet.next())
>                 {
>                     String deptno = resultSet.getString("deptno");
>                     String dname = resultSet.getString("dname");
>                     String loc = resultSet.getString("loc");
>                     writer.println("          <tr>");
>                     writer.println("             <td>" + (++i) + "</td>");
>                     writer.println("             <td>" + (deptno) + "</td>");
>                     writer.println("             <td>" + (dname) + "</td>");
>                     writer.println("             <td>" + (loc) + "</td>");
>                     writer.println("             <td>");
>                     writer.println("                <a href=\"javascript:void(0)\"  οnclick=\"del("+(deptno)+")\">删除</a>");
>                     writer.println("                <a href='" + (contextPath) + "/dept/edit?deptno=" + deptno +"'>修改</a>");
>                     writer.println("                <a href='" + (contextPath) + "/dept/detail?deptno=" + deptno +"'>详情</a>");
>                     writer.println("             </td>");
>                     writer.println("          </tr>");
>                 }
>             }
>             catch (SQLException e)
>             {
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>             writer.println("       </table>");
>             writer.println("       <hr>");
>             writer.println("       <a href='"+ contextPath + "/add.jsp'>新增部门</a>");
>             writer.println("    </body>");
>             writer.println("</html>");
>         }
>         private void doSave(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException
>         {
>             request.setCharacterEncoding("UTF-8");
>             Integer deptno = Integer.parseInt(request.getParameter("deptno"));
>             String dname = request.getParameter("dname");
>             String loc = request.getParameter("loc");
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             String contextPath = request.getContextPath();
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 connection.setAutoCommit(false);
>                 String sql = "insert into dept(deptno,dname,loc) values(?,?,?)";
>                 statement = connection.prepareStatement(sql);
>                 statement.setInt(1,deptno);
>                 statement.setString(2,dname);
>                 statement.setString(3,loc);
>                 int count = statement.executeUpdate();
>                 connection.commit();
>                 if(count == 1)
>                 {
>                     response.sendRedirect(contextPath + "/dept/list");
>                 }
>                 else
>                 {
>                     response.sendRedirect("/Error.html");
>     
>                 }
>             }
>             catch (SQLException e)
>             {
>                 if (connection != null) {
>                     try {
>                         connection.rollback();
>                     } catch (SQLException ex) {
>                         throw new RuntimeException(ex);
>                     }
>                 }
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>         }
>         private void doEdit(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException
>         {
>             String deptno = request.getParameter("deptno");
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             response.setContentType("text/html;charset=UTF-8");
>             PrintWriter out = response.getWriter();
>             String contextPath = request.getContextPath();
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 String sql = "select * from dept where deptno = ?";
>                 statement = connection.prepareStatement(sql);
>                 statement.setString(1,deptno);
>                 resultSet = statement.executeQuery();
>                 if(resultSet.next())
>                 {
>                     String dname = resultSet.getString("dname");
>                     String loc = resultSet.getString("loc");
>                     out.println("<!DOCTYPE html>\n" +
>                             "<html>\n" +
>                             "\t<head>\n" +
>                             "\t\t<meta charset=\"utf-8\">\n" +
>                             "\t\t<title>修改部门</title>\n" +
>                             "\t</head>\n" +
>                             "\t<body>\n" +
>                             "\t\t<h1>修改部门</h1>\n" +
>                             "\t\t<hr>\n" +
>                             "\t\t<form method=\"post\" action=\"" + contextPath +"/dept/modify\">\n" +
>                             "\t\t\t部门编号:<input type=\"text\" name=\"deptno\" value=\"" + deptno);
>                     out.println("\" readonly/><br>\n" +
>                             "\t\t\t部门名称:<input type=\"text\" name=\"dname\" value=\"" + dname + "\"");
>                     out.println("/><br>\n" +
>                             "\t\t\t部门位置:<input type=\"text\" name=\"loc\" value=\"" + loc + "\"");
>                     out.println("\"/><br>\n" +
>                             "\t\t\t<input type=\"submit\" value=\"保存\"/>\n" +
>                             "\t\t</form>\n" +
>                             "\t</body>\n" +
>                             "</html>");
>                 }
>             }
>             catch (SQLException e)
>             {
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>         }
>         private void doDetail(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException
>         {
>             response.setContentType("text/html;charset=UTF-8");
>             PrintWriter out = response.getWriter();
>             String deptno = request.getParameter("deptno");
>             Connection connection = null;
>             ResultSet resultSet = null;
>             PreparedStatement statement = null;
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 String sql = "select * from dept where deptno = " + deptno;
>                 statement = connection.prepareStatement(sql);
>                 resultSet = statement.executeQuery();
>                 if(resultSet.next())
>                 {
>                     String deptno1 = resultSet.getString("deptno");
>                     String dname = resultSet.getString("dname");
>                     String loc = resultSet.getString("loc");
>                     out.println("<!DOCTYPE html>\n" +
>                             "<html>\n" +
>                             "\t<head>\n" +
>                             "\t\t<meta charset=\"utf-8\">\n" +
>                             "\t\t<title>部门详情</title>\n" +
>                             "\t</head>\n" +
>                             "\t<body>\n" +
>                             "\t\t<h1>部门详情</h1>\n" +
>                             "\t\t<hr>");
>                     out.println("部门编号:" + deptno + "<br>");
>                     out.println("部门名称:" + dname + "<br>");
>                     out.println("部门位置:" + loc + "<br>");
>                     out.println("\t\t\n" +
>                             "\t\t<input type=\"button\" value=\"后退\" οnclick=\"window.history.back()\"/>\n" +
>                             "\t</body>\n" +
>                             "</html>");
>                 }
>             }
>             catch (SQLException e)
>             {
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>         }
>         private void doModify(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException
>         {
>             request.setCharacterEncoding("UTF-8");
>             String deptno = request.getParameter("deptno");
>             String dname = request.getParameter("dname");
>             String loc = request.getParameter("loc");
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 connection.setAutoCommit(false);
>                 String sql = "update dept set dname = ?,loc = ? where deptno = ?";
>                 statement = connection.prepareStatement(sql);
>                 statement.setString(1,dname);
>                 statement.setString(2,loc);
>                 statement.setString(3,deptno);
>                 int count = statement.executeUpdate();
>                 connection.commit();
>                 if(count == 1)
>                 {
>                     response.sendRedirect(request.getContextPath() + "/dept/list");
>                 }
>                 else
>                 {
>                     response.sendRedirect("/Error.html");
>                 }
>             }
>             catch (SQLException e)
>             {
>                 if (connection != null) {
>                     try {
>                         connection.rollback();
>                     } catch (SQLException ex) {
>                         throw new RuntimeException(ex);
>                     }
>                 }
>                 throw new RuntimeException(e);
>             }
>             finally {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>         }
>         private void doDel(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException
>         {
>             String dno = request.getParameter("deptno");
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             response.setContentType("text/html;charset=UTF-8");
>             PrintWriter out = response.getWriter();
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 connection.setAutoCommit(false);
>                 String sql = "delete from dept where deptno = ?";
>                 statement = connection.prepareStatement(sql);
>                 statement.setString(1,dno);
>                 int count = statement.executeUpdate();
>                 connection.commit();
>                 //删除我们选择了转发而不是重定向
>                 if(count == 1)
>                 {
>                     request.getRequestDispatcher("/dept/list").forward(request,response);
>                 }
>                 else
>                 {
>                     request.getRequestDispatcher("/Error.html").forward(request,response);
>                 }
>             }
>             catch (SQLException e)
>             {
>                 if (connection != null) {
>                     try {
>                         connection.rollback();
>                     } catch (SQLException ex) {
>                         throw new RuntimeException(ex);
>                     }
>                 }
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>         }
>     }