实现步骤

一、步骤

1.1 准备一张数据库表

  1. create table dept(
  2.                                 deptno int,
  3.                                 dname  varchar(255),
  4.                                 loc    varchar(255)
  5. );
  6. insert into dept(deptno,dname,loc)values(10,'销售部','北京'),
  7.                                                                                 (20,'研发部','上海'),
  8.                                                                                 (30,'技术部','广州'),
  9.                                                                                 (40,'媒体部','深圳');
  10. -- 提交
  11. COMMIT;
  12. select * from dept;

1.2 准备一套HTML页面

  • 新增页面：add.html
  • 修改页面：edit.html
  • 详情页面：detail.html
  • 欢迎页面：index.html
  • 部门列表页面：list.html（以列表页面为核心，展开操作）
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <title>欢迎使用oa系统</title>
  6. </head>
  7. <body>
  8. <a href="list.html">查看部门列表</a>
  10. </body>
  11. </html>
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <title>部门列表</title>
  6. </head>
  7. <body>
  8. <h1 align="center">部门列表</h1>
  9. <hr>
  10. <table border="1px" align="center" width="50%">
  11.     <tr>
  12.         <th>序号</th>
  13.         <th>部门编号</th>
  14.         <th>部门名称</th>
  15.         <th>操作</th>
  16.     </tr>
  17.     <tr>
  18.         <td>1</td>
  19.         <td>10</td>
  20.         <td>销售部</td>
  21.         <td>
  22.             <a href="javascript:void(0)" onclick="window.confirm('亲，确认删除该数据吗？')">删除</a>
  23.             <a href="edit.html">修改</a>
  24.             <a href="detail.html">详情</a>
  25.         </td>
  26.     </tr>
  27.     <tr>
  28.         <td>2</td>
  29.         <td>20</td>
  30.         <td>研发部</td>
  31.         <td>
  32.             <a href="javascript:void(0)" onclick="window.confirm('亲，确认删除该数据吗？')">删除</a>
  33.             <a href="edit.html">修改</a>
  34.             <a href="detail.html">详情</a>
  35.         </td>
  36.     </tr>
  37.     <tr>
  38.         <td>3</td>
  39.         <td>30</td>
  40.         <td>运用部</td>
  41.         <td>
  42.             <a href="javascript:void(0)" onclick="window.confirm('亲，确认删除该数据吗？')">删除</a>
  43.             <a href="edit.html">修改</a>
  44.             <a href="detail.html">详情</a>
  45.         </td>
  46.     </tr>
  47.     <tr>
  48.         <td>4</td>
  49.         <td>40</td>
  50.         <td>媒体部</td>
  51.         <td>
  52.             <a href="javascript:void(0)" onclick="window.confirm('亲，确认删除该数据吗？')">删除</a>
  53.             <a href="edit.html">修改</a>
  54.             <a href="detail.html">详情</a>
  55.         </td>
  56.     </tr>
  57. </table>
  59. <hr>
  60. <a href="add.html">新增部门</a>
  62. </body>
  63. </html>
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <title>部门详情</title>
  6. </head>
  7. <body>
  8. <h1>部门详情</h1>
  9. <hr>
  10. 部门编号<br>
  11. 部门名称<br>
  12. 部门位置<br>
  14. <form action="list.html">
  15.     <input type="button" value="后退" onclick="window.history.back()">
  17. </form>
  19. </body>
  20. </html>
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <title>修改部门</title>
  6. </head>
  7. <body>
  8. <h1>修改部门</h1>
  9. <hr>
  10. <form action="list.html" method="post">
  11.     部门编号<input type="text" name="deptno" value="20" readonly><br><!--readonly只读-->
  12.     部门名称<input type="text" name="dname" value="销售部"><br>
  13.     部门位置<input type="text" name="loc" value="北京"><br>
  14.     <input type="submit" value="修改"><br>
  16. </form>
  18. </body>
  19. </html>
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <title>新增部门</title>
  6. </head>
  7. <body>
  8. <h1>新增部门</h1>
  9. <hr>
  10. <form action="list.html" method="post">
  11.     部门编号<input type="text" name="deptno"><br>
  12.     部门名称<input type="text" name="dname"><br>
  13.     部门位置<input type="text" name="loc"><br>
  14.     <input type="submit" value="保存"><br>
  16. </form>
  18. </body>
  19. </html>

1.3 分析这个系统包括哪些功能

  • 查看部门列表
  • 新增部门
  • 删除部门
  • 查看部门详情信息
  • 跳转到修改页面
  • 修改部门

1.4 在IDEA中搭建开发环境

  • 创建一个webapp（给这个webapp添加servlet-api-jar和jsp-api-jar到classpath当中

  • [x] 向webapp中添加连接数据库的jar包（MySQL驱动）

    • 必须在WEB-INF目录下创建lib，然后将mysql驱动jar包导入
  • JDBC的工具类

1、实现步骤 - 图1

  1. package oa;
  3. /**
  4. * @Author: 小雷学长
  5. * @Date: 2022/3/22 - 0:42
  6. * @Version: 1.8
  7. */
  9. import javax.xml.transform.Result;
  10. import java.sql.*;
  11. import java.util.ResourceBundle;
  13. /**
  14. * JDBC工具类
  15. */
  16. public class DBUtil {
  18.     //静态变量：也是在类加载时执行，并且是有自上而下的顺序
  19.     //资源绑定器
  20.     private static ResourceBundle bundle = ResourceBundle.getBundle("resources.jdbc");
  22.     //根据属性配置文件的key获取value
  23.     private static String driver = bundle.getString("driver");
  24.     private static String url = bundle.getString("url");
  25.     private static String user = bundle.getString("user");
  26.     private static String password = bundle.getString("password");
  29.     static {
  30.         //注册驱动(注册驱动只需要注册一次，放在静态代码块中，DBUtil类加载的时候执行)
  31.         try {
  32.             /* com.mysql.jdbc.Driver是连接数据库的驱动，不能写死，因为以后可能还会写Oracle数据库
  33.             * OCP开闭原则：对扩展开放，对修改关闭。（OCP：在进行拓展的时候不需要修改Java源码
  34.             * 通过属性配置文件jdbc.properties来获取驱动
  35.             */
  36.             //Class.forName("com.mysql.jdbc.Driver");
  38.             Class.forName(driver);
  39.         } catch (ClassNotFoundException e) {
  40.             e.printStackTrace();
  41.         }
  42.     }
  45.     /**
  46.     * 获取数据库连接对象
  47.     *
  48.     * @return conn
  49.     * @throws SQLException
  50.     */
  51.     public static Connection getConnection() throws SQLException {
  53.         //获取连接
  54.         Connection conn = DriverManager.getConnection(url, user, password);
  55.         return conn;
  56.     }
  58.     /**
  59.     * 释放资源
  60.     * @param conn 连接对象
  61.     * @param ps 数据库操作对象
  62.     * @param rs 结果集对象
  63.     */
  64.     public static void close(Connection conn, Statement ps, ResultSet rs) {
  66.         if (rs != null) {
  67.             try {
  68.                 rs.close();
  69.             } catch (SQLException e) {
  70.                 e.printStackTrace();
  71.             }
  72.         }
  73.         if (ps != null) {
  74.             try {
  75.                 ps.close();
  76.             } catch (SQLException e) {
  77.                 e.printStackTrace();
  78.             }
  79.         }
  80.         if (conn != null) {
  81.             try {
  82.                 conn.close();
  83.             } catch (SQLException e) {
  84.                 e.printStackTrace();
  85.             }
  86.         }
  87.     }
  90. }
  1. driver=com.mysql.jdbc.Driver
  2. url=jdbc:mysql://localhost:3306/study
  3. user=root
  4. password=root

1、实现步骤 - 图2

  • 将所有HTML页面拷贝到web目录下

1.5 实现连接

(1)注意

  • [x] 如何实现？

    • 可以从后端一步一步往前端写，也可以从前端一步一步往后端写，不要想起来什么写什么。要根据程序执行的过程。程序到哪里，就写哪里，这样可以避免错误
  • 假设从前端开始，一定是从用户点击按钮开始

(2) 步骤

  1. 先修改前端页面的超链接，因为用户先点击的就是超链接
  1. <!DOCTYPE html>
  2. <html lang="en">
  3.   <head>
  4.     <meta charset="UTF-8">
  5.     <title>欢迎使用oa系统</title>
  6.   </head>
  7.   <body>
  8.     <a href="/oa/dept/list">查看部门列表</a>
  10.   </body>
  11. </html>
  1. 编写web.xml文件
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
  3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
  5.          version="4.0">
  7.   <servlet>
  8.     <servlet-name>list</servlet-name>
  9.     <servlet-class>oa.DeptListServlet</servlet-class>
  10.   </servlet>
  11.   <servlet-mapping>
  12.     <servlet-name>list</servlet-name>
  13.     <url-pattern>/dept/list</url-pattern>
  14.   </servlet-mapping>
  16. </web-app>
  1. 编写DeptListServlet类继承HttpServlet类，然后重写doGet方法
  1. package oa.action;
  3. import jakarta.servlet.ServletException;
  4. import jakarta.servlet.http.HttpServlet;
  5. import jakarta.servlet.http.HttpServletRequest;
  6. import jakarta.servlet.http.HttpServletResponse;
  8. import java.io.IOException;
  10. /**
  11. * @Author: 小雷学长
  12. * @Date: 2022/3/22 - 10:05
  13. * @Version: 1.8
  14. */
  15. public class DeptListServlet extends HttpServlet {
  16.     @Override
  17.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  18.         throws ServletException, IOException {
  21.     }
  22. }
  1. 在DeptServlet类的doGet方法中连接数据库，查询所有的部门，动态的展示部门列表页面
  • 分析list.html页面中哪部分是固定不变的，哪部分是需要动态展示的
  • list.html页面中的内容所有的双引号，要变成单引号，因为print.out(“”)这里有一个双引号，容易冲突
  1. package oa.action;
  3. import com.sun.corba.se.spi.orb.PropertyParser;
  4. import jakarta.servlet.ServletException;
  5. import jakarta.servlet.http.HttpServlet;
  6. import jakarta.servlet.http.HttpServletRequest;
  7. import jakarta.servlet.http.HttpServletResponse;
  8. import oa.untils.DBUtil;
  10. import java.io.IOException;
  11. import java.io.PrintWriter;
  12. import java.sql.Connection;
  13. import java.sql.PreparedStatement;
  14. import java.sql.ResultSet;
  15. import java.sql.SQLException;
  17. /**
  18.  * @Author: 小雷学长
  19.  * @Date: 2022/3/22 - 10:05
  20.  * @Version: 1.8
  21.  */
  22. public class DeptListServlet extends HttpServlet {
  23.     @Override
  24.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  25.             throws ServletException, IOException {
  27.         //设置响应的内容类型
  28.         response.setContentType("text/html");
  29.         PrintWriter out = response.getWriter();
  31.         out.print("        <!DOCTYPE html>");
  32.         out.print("<html lang='en'>");
  33.         out.print("<head>");
  34.         out.print("    <meta charset='UTF-8'>");
  35.         out.print("    <title>部门列表</title>");
  36.         out.print("</head>");
  37.         out.print("<body>");
  38.         out.print("<h1 align='center'>部门列表</h1>");
  39.         out.print("<hr>");
  40.         out.print("<table border='1px' align='center' width='50%'>");
  41.         out.print("    <tr>");
  42.         out.print("        <th>序号</th>");
  43.         out.print("        <th>部门编号</th>");
  44.         out.print("        <th>部门名称</th>");
  45.         out.print("        <th>操作</th>");
  46.         out.print("    </tr>");
  47.         out.print("    <!--以上是固定的-->");
  48.         /*
  49.         上面一部分是死的
  50.          */
  52.         /*
  53.          * 连接数据库
  54.          */
  55.         Connection conn = null;
  56.         PreparedStatement ps = null;
  57.         ResultSet rs = null;
  59.         try {
  61.             //获取连接
  62.             conn = DBUtil.getConnection();
  64.             //获取预编译的数据库操作对象
  65.             String sql = "select deptno,dname ,loc from dept";
  66.             ps = conn.prepareStatement(sql);
  68.             //执行SQL语句
  69.             rs = ps.executeQuery();
  71.             //处理结果集
  72.             int i = 0;
  73.             while (rs.next()) {
  74.                 String deptno = rs.getString("deptno");
  75.                 String dname = rs.getString("dname");
  76.                 String loc = rs.getString("loc");
  78.                 out.print("    <tr>");
  79.                 out.print("        <td>" + (++i) + "</td>");
  80.                 out.print("        <td>" + deptno + "</td>");
  81.                 out.print("        <td>" + dname + "</td>");
  82.                 out.print("        <td>");
  83.                 out.print("            <a href=''></a>");
  84.                 out.print("            <a href='edit.html'>修改</a>");
  85.                 out.print("            <a href='detail.html'>详情</a>");
  86.                 out.print("        </td>");
  87.                 out.print("    </tr>");
  89.             }
  90.         } catch (SQLException e) {
  91.             e.printStackTrace();
  92.         } finally {
  94.             //释放资源
  95.             DBUtil.close(conn, ps, rs);
  96.         }
  98.         /*
  99.         下面一部分是死的
  100.          */
  101.         out.print("    <!--一下是固定的-->");
  102.         out.print("</table>");
  103.         out.print("<hr>");
  104.         out.print("<a href=' add.html'>新增部门</a>");
  105.         out.print("</body>");
  106.         out.print("</html>");
  107.     }
  108. }

1.6 查看部门详情

  • 从前端往后端一步一步实现，要考虑的是用户要点击的是什么，用户点击的在哪里
  1.  out.print("<a href='" + contextPath + "/dept/detail?deptno = " + deptno + "'>详情</a>");
  • 向服务器提交数据的格式：url?name=value&name=value&name=value&name=value
  • 这里的问号必须是英文的问号，不能写中文的问号，url不能带空格
  1. 编写一个类：DeptDetailServelt.java
  1. package oa.action;
  3. import jakarta.servlet.ServletException;
  4. import jakarta.servlet.http.HttpServlet;
  5. import jakarta.servlet.http.HttpServletRequest;
  6. import jakarta.servlet.http.HttpServletResponse;
  7. import oa.untils.DBUtil;
  9. import java.io.IOException;
  10. import java.io.PrintWriter;
  11. import java.sql.Connection;
  12. import java.sql.PreparedStatement;
  13. import java.sql.ResultSet;
  14. import java.sql.SQLException;
  16. /**
  17.  * @Author: 小雷学长
  18.  * @Date: 2022/3/22 - 15:01
  19.  * @Version: 1.8
  20.  */
  21. public class DeptDetailServelt extends HttpServlet {
  22.     @Override
  23.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  24.             throws ServletException, IOException {
  26.         response.setContentType("text/html");
  27.         PrintWriter out = response.getWriter();
  30.         out.print("<!DOCTYPE html>");
  31.         out.print("<html lang='en'>");
  32.         out.print("<head>");
  33.         out.print("    <meta charset='UTF-8'>");
  34.         out.print("    <title>部门详情</title>");
  35.         out.print("</head>");
  36.         out.print("<body>");
  37.         out.print("<h1>部门详情</h1>");
  38.         out.print("<hr>");
  41.         //获取部门编号
  42.         //虽然提交的是30，但服务器获取的是30这个字符串
  43.         String deptno = request.getParameter("deptno");
  46.         /*
  47.          * 连接数据库
  48.          */
  49.         Connection conn = null;
  50.         PreparedStatement ps = null;
  51.         ResultSet rs = null;
  53.         try {
  55.             //获取连接
  56.             conn = DBUtil.getConnection();
  58.             //获取预编译的数据库操作对象
  59.             String sql = "select deptno,dname,loc from dept where deptno=?";
  60.             ps = conn.prepareStatement(sql);
  62.             ps.setString(1, deptno);
  63.             //这个结果集一定只有一个元素
  66.             //执行SQL语句
  67.             rs = ps.executeQuery();
  69.             //处理结果集
  70.             if (rs.next()) {
  71.                 String dname = rs.getString("dname");
  72.                 String loc = rs.getString("loc");
  74.                 out.print("部门编号" + deptno + "<br>");
  75.                 out.print("部门名称" + dname + "<br>");
  76.                 out.print("部门位置" + loc + "<br>");
  79.             }
  80.         } catch (SQLException e) {
  81.             e.printStackTrace();
  82.         } finally {
  84.             //释放资源
  85.             DBUtil.close(conn, ps, rs);
  86.         }
  88.         out.print("");
  89.         out.print("<form action='list.html'>");
  90.         out.print("    <input type='button' value='后退' onclick='window.history.back()'>");
  91.         out.print("");
  92.         out.print("</form>");
  93.         out.print("");
  94.         out.print("</body>");
  95.         out.print("</html>");
  96.     }
  97. }

1.7 实现删除功能

（1）方法

  • <!--href后面设置为javascript:void(0)表示：仍然保留住超链接的样子，只是点击超链接之后，只执行后面的js代码，不进行页面的跳转，不一定是0-->
  • JavaScript确认删除提示的方法
  1. <script type="text/javascript">
  2.   function del() {
  3.   //弹出确认框，用户点击确定返回TRUE，点击取消返回FALSE
  4.   var ok = window.confirm("亲，删了不可恢复哦！");
  5.   if (ok){
  6.     //发送请求，进行删除数据的操作
  7.     //在js代码中如何发送请求给服务器？？？？？？？
  8.     alert("正在删除数据，请稍后……")
  10.     /*
  11.     四种获取数据的方法
  12.     */
  13.     // document.location.href = "请求路径"
  14.     //document.locaction = "请求路径"
  15.     //window.location.href = "请求路径"
  16.     //window.location = "请求路径"
  17.     document.location.href = "项目名/请求路径";
  18.   }
  21. }
  22. </script>
  25. <!--调用del方法-->
  26. <tr>
  27.         <td>1</td>
  28.         <td>10</td>
  29.         <td>销售部</td>
  30.         <td>
  31.             <a href="javascript:void(0)" onclick="del()">删除</a>
  32.             <a href='edit.html'>修改</a>
  33.             <a href='detail.html'>详情</a>
  34.         </td>
  35.     </tr>

1、实现步骤 - 图3

1、实现步骤 - 图4

  • 四种获取请求的方法
  1. document.location.href = "请求路径"
  2. document.locaction = "请求路径"
  3. window.location.href = "请求路径"
  4. window.location = "请求路径"

（2）实现删除

  • 前端程序要写到后端的java代码中，因为没有JSP的支持，只能在后端里写前端代码
  1. package oa.action;
  3. import com.sun.corba.se.spi.orb.PropertyParser;
  4. import jakarta.servlet.ServletException;
  5. import jakarta.servlet.http.HttpServlet;
  6. import jakarta.servlet.http.HttpServletRequest;
  7. import jakarta.servlet.http.HttpServletResponse;
  8. import oa.untils.DBUtil;
  10. import java.io.IOException;
  11. import java.io.PrintWriter;
  12. import java.sql.Connection;
  13. import java.sql.PreparedStatement;
  14. import java.sql.ResultSet;
  15. import java.sql.SQLException;
  17. /**
  18. * @Author: 小雷学长
  19. * @Date: 2022/3/22 - 10:05
  20. * @Version: 1.8
  21. */
  22. public class DeptListServlet extends HttpServlet {
  23.     @Override
  24.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  25.         throws ServletException, IOException {
  27.         //获取应用的根路径
  28.         String contextPath = request.getContextPath();
  30.         //设置响应的内容类型
  31.         response.setContentType("text/html");
  32.         PrintWriter out = response.getWriter();
  34.         out.print("        <!DOCTYPE html>");
  35.         out.print("<html lang='en'>");
  36.         out.print("<head>");
  37.         out.print("    <meta charset='UTF-8'>");
  38.         out.print("    <title>部门列表</title>");
  39.         out.print("</head>");
  41.         out.print("<body>");
  42.         out.print("<script type='text/javascript'>");
  43.         out.print("        function del(dno) {");
  44.         out.print("    if(window.confirm('亲，删了不可恢复哦！')){");
  45.         out.print("        document.location.href = 'oa/dept/delete?deptno=' + dno;");
  46.         out.print("    }");
  47.         out.print("}");
  48.         out.print("</script>");
  49.         out.print("<h1 align='center'>部门列表</h1>");
  50.         out.print("<hr>");
  51.         out.print("<table border='1px' align='center' width='50%'>");
  52.         out.print("    <tr>");
  53.         out.print("        <th>序号</th>");
  54.         out.print("        <th>部门编号</th>");
  55.         out.print("        <th>部门名称</th>");
  56.         out.print("        <th>操作</th>");
  57.         out.print("    </tr>");
  58.         out.print("    <!--以上是固定的-->");
  59.         /*
  60.         上面一部分是死的
  61.         */
  63.         /*
  64.         * 连接数据库
  65.         */
  66.         Connection conn = null;
  67.         PreparedStatement ps = null;
  68.         ResultSet rs = null;
  70.         try {
  72.             //获取连接
  73.             conn = DBUtil.getConnection();
  75.             //获取预编译的数据库操作对象
  76.             String sql = "select deptno,dname ,loc from dept";
  77.             ps = conn.prepareStatement(sql);
  79.             //执行SQL语句
  80.             rs = ps.executeQuery();
  82.             //处理结果集
  83.             int i = 0;
  84.             while (rs.next()) {
  85.                 String deptno = rs.getString("deptno");
  86.                 String dname = rs.getString("dname");
  87.                 String loc = rs.getString("loc");
  89.                 out.print("    <tr>");
  90.                 out.print("        <td>" + (++i) + "</td>");
  91.                 out.print("        <td>" + deptno + "</td>");
  92.                 out.print("        <td>" + dname + "</td>");
  93.                 out.print("        <td>");
  94.                 out.print("<a href='javascript:void(0)' onclick='del(" + deptno + ")')'>删除</a>");
  95.                 out.print("            <a href='edit.html'>修改</a>");
  96.                 out.print("            <a href='" + contextPath + "/dept/detail?deptno=" + deptno + "'>详情</a>");
  97.                 out.print("        </td>");
  98.                 out.print("    </tr>");
  100.             }
  101.         } catch (SQLException e) {
  102.             e.printStackTrace();
  103.         } finally {
  105.             //释放资源
  106.             DBUtil.close(conn, ps, rs);
  107.         }
  109.         /*
  110.         下面一部分是死的
  111.         */
  112.         out.print("    <!--一下是固定的-->");
  113.         out.print("</table>");
  114.         out.print("<hr>");
  115.         out.print("<a href=' add.html'>新增部门</a>");
  116.         out.print("</body>");
  117.         out.print("</html>");
  118.     }
  119. }

  • [x] 点击删除会出现404问题，解决

    • 配置web.xml
  1.  <!--删除-->
  2.     <servlet>
  3.         <servlet-name>delete</servlet-name>
  4.         <servlet-class>oa.action.DeptDelServlet</servlet-class>
  5.     </servlet>
  6.     <servlet-mapping>
  7.         <servlet-name>delete</servlet-name>
  8.         <url-pattern>/dept/delete</url-pattern>
  9.     </servlet-mapping>

（3） 最终实现

1、实现步骤 - 图5

  1. package oa.action;
  3. import com.sun.corba.se.spi.orb.PropertyParser;
  4. import jakarta.servlet.ServletException;
  5. import jakarta.servlet.http.HttpServlet;
  6. import jakarta.servlet.http.HttpServletRequest;
  7. import jakarta.servlet.http.HttpServletResponse;
  8. import oa.untils.DBUtil;
  10. import java.io.IOException;
  11. import java.io.PrintWriter;
  12. import java.sql.Connection;
  13. import java.sql.PreparedStatement;
  14. import java.sql.ResultSet;
  15. import java.sql.SQLException;
  17. /**
  18.  * @Author: 小雷学长
  19.  * @Date: 2022/3/22 - 10:05
  20.  * @Version: 1.8
  21.  */
  22. public class DeptListServlet extends HttpServlet {
  23.     @Override
  24.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  25.             throws ServletException, IOException {
  27.         //获取应用的根路径
  28.         String contextPath = request.getContextPath();
  30.         //设置响应的内容类型
  31.         response.setContentType("text/html");
  32.         PrintWriter out = response.getWriter();
  34.         out.print("        <!DOCTYPE html>");
  35.         out.print("<html lang='en'>");
  36.         out.print("<head>");
  37.         out.print("    <meta charset='UTF-8'>");
  38.         out.print("    <title>部门列表</title>");
  39.         out.print("</head>");
  41.         out.print("<body>");
  42.         out.print("<script type='text/javascript'>");
  43.         out.print("        function del(dno) {");
  44.         out.print("    if(window.confirm('亲，删了不可恢复哦！')){");
  45.         out.print("        document.location.href = '"+contextPath+"/dept/delete?deptno=' + dno");
  46.         out.print("    }");
  47.         out.print("}");
  48.         out.print("</script>");
  49.         out.print("<h1 align='center'>部门列表</h1>");
  50.         out.print("<hr>");
  51.         out.print("<table border='1px' align='center' width='50%'>");
  52.         out.print("    <tr>");
  53.         out.print("        <th>序号</th>");
  54.         out.print("        <th>部门编号</th>");
  55.         out.print("        <th>部门名称</th>");
  56.         out.print("        <th>操作</th>");
  57.         out.print("    </tr>");
  58.         out.print("    <!--以上是固定的-->");
  59.         /*
  60.         上面一部分是死的
  61.          */
  63.         /*
  64.          * 连接数据库
  65.          */
  66.         Connection conn = null;
  67.         PreparedStatement ps = null;
  68.         ResultSet rs = null;
  70.         try {
  72.             //获取连接
  73.             conn = DBUtil.getConnection();
  75.             //获取预编译的数据库操作对象
  76.             String sql = "select deptno,dname ,loc from dept";
  77.             ps = conn.prepareStatement(sql);
  79.             //执行SQL语句
  80.             rs = ps.executeQuery();
  82.             //处理结果集
  83.             int i = 0;
  84.             while (rs.next()) {
  85.                 String deptno = rs.getString("deptno");
  86.                 String dname = rs.getString("dname");
  87.                 String loc = rs.getString("loc");
  89.                 out.print("    <tr>");
  90.                 out.print("        <td>" + (++i) + "</td>");
  91.                 out.print("        <td>" + deptno + "</td>");
  92.                 out.print("        <td>" + dname + "</td>");
  93.                 out.print("        <td>");
  94.                 out.print("<a href='javascript:void(0)' onclick='del("+ deptno +")'>删除</a>");
  95.                 out.print("            <a href='edit.html'>修改</a>");
  96.                 out.print("            <a href='" + contextPath + "/dept/detail?deptno=" + deptno + "'>详情</a>");
  97.                 out.print("        </td>");
  98.                 out.print("    </tr>");
  100.             }
  101.         } catch (SQLException e) {
  102.             e.printStackTrace();
  103.         } finally {
  105.             //释放资源
  106.             DBUtil.close(conn, ps, rs);
  107.         }
  109.         /*
  110.         下面一部分是死的
  111.          */
  112.         out.print("    <!--一下是固定的-->");
  113.         out.print("</table>");
  114.         out.print("<hr>");
  115.         out.print("<a href=' add.html'>新增部门</a>");
  116.         out.print("</body>");
  117.         out.print("</html>");
  118.     }
  119. }
  1. package oa.action;
  3. import jakarta.servlet.ServletException;
  4. import jakarta.servlet.http.HttpServlet;
  5. import jakarta.servlet.http.HttpServletRequest;
  6. import jakarta.servlet.http.HttpServletResponse;
  7. import oa.untils.DBUtil;
  9. import java.io.IOException;
  10. import java.io.PrintWriter;
  11. import java.sql.Connection;
  12. import java.sql.PreparedStatement;
  13. import java.sql.ResultSet;
  14. import java.sql.SQLException;
  16. /**
  17.  * @Author: 小雷学长
  18.  * @Date: 2022/3/22 - 15:01
  19.  * @Version: 1.8
  20.  */
  22. /**
  23.  * 实现查看部门详情
  24.  */
  25. public class DeptDetailServelt extends HttpServlet {
  26.     @Override
  27.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  28.             throws ServletException, IOException {
  30.         response.setContentType("text/html");
  31.         PrintWriter out = response.getWriter();
  34.         out.print("<!DOCTYPE html>");
  35.         out.print("<html lang='en'>");
  36.         out.print("<head>");
  37.         out.print("    <meta charset='UTF-8'>");
  38.         out.print("    <title>部门详情</title>");
  39.         out.print("</head>");
  40.         out.print("<body>");
  41.         out.print("<h1>部门详情</h1>");
  42.         out.print("<hr>");
  45.         //获取部门编号
  46.         //虽然提交的是30，但服务器获取的是30这个字符串
  47.         String deptno = request.getParameter("deptno");
  50.         /*
  51.          * 连接数据库
  52.          */
  53.         Connection conn = null;
  54.         PreparedStatement ps = null;
  55.         ResultSet rs = null;
  57.         try {
  59.             //获取连接
  60.             conn = DBUtil.getConnection();
  62.             //获取预编译的数据库操作对象
  63.             String sql = "select deptno,dname,loc from dept where deptno=?";
  64.             ps = conn.prepareStatement(sql);
  66.             ps.setString(1, deptno);
  67.             //这个结果集一定只有一个元素
  70.             //执行SQL语句
  71.             rs = ps.executeQuery();
  73.             //处理结果集
  74.             if (rs.next()) {
  75.                 String dname = rs.getString("dname");
  76.                 String loc = rs.getString("loc");
  78.                 out.print("部门编号" + deptno + "<br>");
  79.                 out.print("部门名称" + dname + "<br>");
  80.                 out.print("部门位置" + loc + "<br>");
  83.             }
  84.         } catch (SQLException e) {
  85.             e.printStackTrace();
  86.         } finally {
  88.             //释放资源
  89.             DBUtil.close(conn, ps, rs);
  90.         }
  92.         out.print("");
  93.         out.print("<form action='list.html'>");
  94.         out.print("    <input type='button' value='后退' onclick='window.history.back()'>");
  95.         out.print("");
  96.         out.print("</form>");
  97.         out.print("");
  98.         out.print("</body>");
  99.         out.print("</html>");
  100.     }
  101. }
  1. package oa.action;
  3. import com.sun.net.httpserver.HttpPrincipal;
  4. import jakarta.servlet.ServletException;
  5. import jakarta.servlet.http.HttpServlet;
  6. import jakarta.servlet.http.HttpServletRequest;
  7. import jakarta.servlet.http.HttpServletResponse;
  8. import jdk.internal.org.objectweb.asm.TypeReference;
  9. import oa.untils.DBUtil;
  11. import java.io.IOException;
  12. import java.sql.Connection;
  13. import java.sql.PreparedStatement;
  14. import java.sql.ResultSet;
  15. import java.sql.SQLException;
  17. /**
  18.  * @Author: 小雷学长
  19.  * @Date: 2022/3/22 - 18:08
  20.  * @Version: 1.8
  21.  */
  22. public class DeptDelServlet extends HttpServlet {
  23.     @Override
  24.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  25.             throws ServletException, IOException {
  27.         //根据部门编号，删除部门
  28.         //获取部门编号
  29.         String deptno = request.getParameter("deptno");
  31.         //连接数据库删除数据
  32.         Connection conn = null;
  33.         PreparedStatement ps = null;
  35.         int count = 0;
  37.         try {
  38.             conn = DBUtil.getConnection();
  40.             //开启事务（自动提交机制关闭）（非必要）
  41. //            conn.setAutoCommit(false);
  43.             String sql = "delete from dept where deptno=?";
  44.             ps = conn.prepareStatement(sql);
  45.             ps.setString(1, deptno);
  47.             //返回值是：影响了数据库表当中多少条记录
  48.             count = ps.executeUpdate();
  50.             //事务提交（非必要）
  51. //            conn.commit();
  52.         } catch (SQLException e) {
  53.             e.printStackTrace();
  55.         } finally {
  56.             DBUtil.close(conn, ps, null);
  57.         }
  59.         //判断删除成功还是失败
  60.         if (count == 1) {
  61.             //删除成功
  62.             //仍然跳回到部门列表页面
  63.             //部门列表页面需要执行另一个Servlet，利用转发机制
  64.             request.getRequestDispatcher("/dept/list").forward(request, response);
  66.         } else {
  67.             //删除失败
  68.             request.getRequestDispatcher("/error.html").forward(request, response);
  69.         }
  71.     }
  72. }
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <title>error</title>
  6. </head>
  7. <body>
  8. <h1>操作失败<a href="javascript:void(0)" onclick="window.history.back()">返回</a></h1>
  10. </body>
  11. </html>
  1. driver=com.mysql.jdbc.Driver
  2. url=jdbc:mysql://localhost:3306/study
  3. user=root
  4. password=123456
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
  3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
  5.          version="4.0">
  7.     <!--查看部门列表-->
  8.     <servlet>
  9.         <servlet-name>list</servlet-name>
  10.         <servlet-class>oa.action.DeptListServlet</servlet-class>
  11.     </servlet>
  12.     <servlet-mapping>
  13.         <servlet-name>list</servlet-name>
  14.         <url-pattern>/dept/list</url-pattern>
  15.     </servlet-mapping>
  17.     <!--查看详情-->
  18.     <servlet>
  19.         <servlet-name>detail</servlet-name>
  20.         <servlet-class>oa.action.DeptDetailServelt</servlet-class>
  21.     </servlet>
  22.     <servlet-mapping>
  23.         <servlet-name>detail</servlet-name>
  24.         <url-pattern>/dept/detail</url-pattern>
  25.     </servlet-mapping>
  27.     <!--删除-->
  28.     <servlet>
  29.         <servlet-name>delete</servlet-name>
  30.         <servlet-class>oa.action.DeptDelServlet</servlet-class>
  31.     </servlet>
  32.     <servlet-mapping>
  33.         <servlet-name>delete</servlet-name>
  34.         <url-pattern>/dept/delete</url-pattern>
  35.     </servlet-mapping>
  37. </web-app>

OA.7z

1.8 部门新增功能

  1. package oa.action;
  3. import com.sun.corba.se.spi.orb.PropertyParser;
  4. import jakarta.servlet.ServletException;
  5. import jakarta.servlet.http.HttpServlet;
  6. import jakarta.servlet.http.HttpServletRequest;
  7. import jakarta.servlet.http.HttpServletResponse;
  8. import oa.untils.DBUtil;
  10. import java.io.IOException;
  11. import java.io.PrintWriter;
  12. import java.sql.Connection;
  13. import java.sql.PreparedStatement;
  14. import java.sql.ResultSet;
  15. import java.sql.SQLException;
  16. import java.util.Queue;
  18. /**
  19.  * @Author: 小雷学长
  20.  * @Date: 2022/3/22 - 10:05
  21.  * @Version: 1.8
  22.  */
  23. public class DeptListServlet extends HttpServlet {
  26.     //处理Post请求
  27.     @Override
  28.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  29.             throws ServletException, IOException {
  31.         doGet(request, response);
  33.     }
  35.     @Override
  36.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  37.             throws ServletException, IOException {
  39.         //获取应用的根路径
  40.         String contextPath = request.getContextPath();
  42.         //设置响应的内容类型
  43.         response.setContentType("text/html");
  44.         PrintWriter out = response.getWriter();
  46.         out.print("        <!DOCTYPE html>");
  47.         out.print("<html lang='en'>");
  48.         out.print("<head>");
  49.         out.print("    <meta charset='UTF-8'>");
  50.         out.print("    <title>部门列表</title>");
  51.         out.print("</head>");
  53.         out.print("<body>");
  54.         out.print("<script type='text/javascript'>");
  55.         out.print("        function del(dno) {");
  56.         out.print("    if(window.confirm('亲，删了不可恢复哦！')){");
  57.         out.print("        document.location.href = '" + contextPath + "/dept/delete?deptno=' + dno");
  58.         out.print("    }");
  59.         out.print("}");
  60.         out.print("</script>");
  61.         out.print("<h1 align='center'>部门列表</h1>");
  62.         out.print("<hr>");
  63.         out.print("<table border='1px' align='center' width='50%'>");
  64.         out.print("    <tr>");
  65.         out.print("        <th>序号</th>");
  66.         out.print("        <th>部门编号</th>");
  67.         out.print("        <th>部门名称</th>");
  68.         out.print("        <th>操作</th>");
  69.         out.print("    </tr>");
  70.         out.print("    <!--以上是固定的-->");
  71.         /*
  72.         上面一部分是死的
  73.          */
  75.         /*
  76.          * 连接数据库
  77.          */
  78.         Connection conn = null;
  79.         PreparedStatement ps = null;
  80.         ResultSet rs = null;
  82.         try {
  84.             //获取连接
  85.             conn = DBUtil.getConnection();
  87.             //获取预编译的数据库操作对象
  88.             String sql = "select deptno,dname ,loc from dept";
  89.             ps = conn.prepareStatement(sql);
  91.             //执行SQL语句
  92.             rs = ps.executeQuery();
  94.             //处理结果集
  95.             int i = 0;
  96.             while (rs.next()) {
  97.                 String deptno = rs.getString("deptno");
  98.                 String dname = rs.getString("dname");
  99.                 String loc = rs.getString("loc");
  101.                 out.print("    <tr>");
  102.                 out.print("        <td>" + (++i) + "</td>");
  103.                 out.print("        <td>" + deptno + "</td>");
  104.                 out.print("        <td>" + dname + "</td>");
  105.                 out.print("        <td>");
  106.                 out.print("<a href='javascript:void(0)' onclick='del(" + deptno + ")'>删除</a>");
  107.                 out.print("            <a href='edit.html'>修改</a>");
  108.                 out.print("            <a href='" + contextPath + "/dept/detail?deptno=" + deptno + "'>详情</a>");
  109.                 out.print("        </td>");
  110.                 out.print("    </tr>");
  112.             }
  113.         } catch (SQLException e) {
  114.             e.printStackTrace();
  115.         } finally {
  117.             //释放资源
  118.             DBUtil.close(conn, ps, rs);
  119.         }
  121.         /*
  122.         下面一部分是死的
  123.          */
  124.         out.print("    <!--一下是固定的-->");
  125.         out.print("</table>");
  126.         out.print("<hr>");
  127.         out.print("<a href='" + contextPath + "/add.html'>新增部门</a>");
  128.         out.print("</body>");
  129.         out.print("</html>");
  130.     }
  131. }
  1. package oa.action;
  3. import jakarta.servlet.ServletException;
  4. import jakarta.servlet.http.HttpServlet;
  5. import jakarta.servlet.http.HttpServletRequest;
  6. import jakarta.servlet.http.HttpServletResponse;
  7. import oa.untils.DBUtil;
  9. import java.io.IOException;
  10. import java.sql.Connection;
  11. import java.sql.PreparedStatement;
  12. import java.sql.SQLException;
  14. /**
  15.  * @Author: 小雷学长
  16.  * @Date: 2022/3/22 - 20:36
  17.  * @Version: 1.8
  18.  */
  19. public class DeptSaveServlet extends HttpServlet {
  20.     @Override
  21.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  22.             throws ServletException, IOException {
  25.         //获取部门信息
  26.         String deptno = request.getParameter("deptno");
  27.         String dname = request.getParameter("dname");
  28.         String loc = request.getParameter("loc");
  30.         //连接数据库执行insert语句
  31.         Connection conn = null;
  32.         PreparedStatement ps = null;
  33.         int count = 0;
  35.         try {
  36.             conn = DBUtil.getConnection();
  38.             String sql = "insert into dept(deptno,dname,loc) values(?,?,?)";
  39.             ps = conn.prepareStatement(sql);
  40.             ps.setString(1, deptno);
  41.             ps.setString(2, dname);
  42.             ps.setString(3, loc);
  44.             count = ps.executeUpdate();
  46.         } catch (SQLException e) {
  47.             e.printStackTrace();
  49.         } finally {
  50.             DBUtil.close(conn, ps, null);
  51.         }
  53.         //判断新增成功还是失败
  54.         if (count == 1) {
  55.             //新增成功
  56.             //仍然跳回到部门列表页面
  57.             //部门列表页面需要执行另一个Servlet，利用转发机制
  58.             //转发一次请求
  59.             request.getRequestDispatcher("/dept/list").forward(request, response);
  61.         } else {
  62.             //新增失败
  63.             request.getRequestDispatcher("/error.html").forward(request, response);
  64.         }
  65.     }
  66. }
  1. <!DOCTYPE html>
  2. <html lang="en">
  3.   <head>
  4.     <meta charset="UTF-8">
  5.     <title>新增部门</title>
  6.   </head>
  7.   <body>
  8.     <h1>新增部门</h1>
  9.     <hr>
  10.     <form action="/oa/dept/save" method="post">
  11.       部门编号<input type="text" name="deptno"><br>
  12.       部门名称<input type="text" name="dname"><br>
  13.       部门位置<input type="text" name="loc"><br>
  14.       <input type="submit" value="保存"><br>
  16.     </form>
  18.   </body>
  19. </html>
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
  3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
  5.          version="4.0">
  7.   <!--查看部门列表-->
  8.   <servlet>
  9.     <servlet-name>list</servlet-name>
  10.     <servlet-class>oa.action.DeptListServlet</servlet-class>
  11.   </servlet>
  12.   <servlet-mapping>
  13.     <servlet-name>list</servlet-name>
  14.     <url-pattern>/dept/list</url-pattern>
  15.   </servlet-mapping>
  17.   <!--查看详情-->
  18.   <servlet>
  19.     <servlet-name>detail</servlet-name>
  20.     <servlet-class>oa.action.DeptDetailServelt</servlet-class>
  21.   </servlet>
  22.   <servlet-mapping>
  23.     <servlet-name>detail</servlet-name>
  24.     <url-pattern>/dept/detail</url-pattern>
  25.   </servlet-mapping>
  27.   <!--删除-->
  28.   <servlet>
  29.     <servlet-name>delete</servlet-name>
  30.     <servlet-class>oa.action.DeptDelServlet</servlet-class>
  31.   </servlet>
  32.   <servlet-mapping>
  33.     <servlet-name>delete</servlet-name>
  34.     <url-pattern>/dept/delete</url-pattern>
  35.   </servlet-mapping>
  37.   <!--保存-->
  38.   <servlet>
  39.     <servlet-name>save</servlet-name>
  40.     <servlet-class>oa.action.DeptSaveServlet</servlet-class>
  41.   </servlet>
  42.   <servlet-mapping>
  43.     <servlet-name>save</servlet-name>
  44.     <url-pattern>/dept/save</url-pattern>
  45.   </servlet-mapping>
  47. </web-app>

1.9 实现部门的修改

  1. package oa.action;
  3. import jakarta.servlet.ServletException;
  4. import jakarta.servlet.http.HttpServlet;
  5. import jakarta.servlet.http.HttpServletRequest;
  6. import jakarta.servlet.http.HttpServletResponse;
  7. import oa.untils.DBUtil;
  9. import java.awt.print.Printable;
  10. import java.io.IOException;
  11. import java.io.PrintWriter;
  12. import java.sql.Connection;
  13. import java.sql.PreparedStatement;
  14. import java.sql.ResultSet;
  15. import java.sql.SQLException;
  17. /**
  18. * @Author: 小雷学长
  19. * @Date: 2022/3/23 - 11:19
  20. * @Version: 1.8
  21. */
  22. public class DeptUpdateServlet extends HttpServlet {
  24.     @Override
  25.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  26.         throws ServletException, IOException {
  29.         response.setContentType("text/html");
  30.         PrintWriter out = response.getWriter();
  32.         String deptno = request.getParameter("deptno");
  33.         String dname = request.getParameter("dname");
  34.         String loc = request.getParameter("loc");
  36.         //连接数据库执行insert语句
  37.         Connection conn = null;
  38.         PreparedStatement ps = null;
  39.         ResultSet rs = null;
  40.         int count = 0;
  42.         try {
  43.             conn = DBUtil.getConnection();
  45.             String sql = "update dept set dname = ?,loc = ? where deptno = ?";
  46.             ps = conn.prepareStatement(sql);
  47.             ps.setString(1, dname);
  48.             ps.setString(2, loc);
  49.             ps.setString(3, deptno);
  51.             count = ps.executeUpdate();
  53.         } catch (SQLException e) {
  54.             e.printStackTrace();
  56.         } finally {
  57.             DBUtil.close(conn, ps, rs);
  58.         }
  60.         if (count == 1){
  61.             //更新成功
  62.             //跳转到部门列表页面，转发机制
  63.             request.getRequestDispatcher("/dept/list").forward(request,response);
  64.         }
  65.         else {
  66.             //更新失败
  67.             request.getRequestDispatcher("/error.html").forward(request,response);
  69.         }
  70.     }
  71. }
  1. package oa.action;
  3. import com.sun.net.httpserver.HttpPrincipal;
  4. import jakarta.servlet.ServletException;
  5. import jakarta.servlet.http.HttpServlet;
  6. import jakarta.servlet.http.HttpServletRequest;
  7. import jakarta.servlet.http.HttpServletResponse;
  8. import oa.untils.DBUtil;
  10. import javax.xml.transform.Result;
  11. import java.io.IOException;
  12. import java.io.PrintWriter;
  13. import java.sql.Connection;
  14. import java.sql.PreparedStatement;
  15. import java.sql.ResultSet;
  16. import java.sql.SQLException;
  18. /**
  19.  * @Author: 小雷学长
  20.  * @Date: 2022/3/22 - 22:59
  21.  * @Version: 1.8
  22.  */
  23. public class DeptEditServlet extends HttpServlet {
  24.     @Override
  25.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  26.             throws ServletException, IOException {
  28.         response.setContentType("text/html");
  29.         PrintWriter out = response.getWriter();
  31.         String contextPath = request.getContextPath();
  34.         out.print("<html lang='en'>");
  35.         out.print("<head>");
  36.         out.print("    <meta charset='UTF-8'>");
  37.         out.print("    <title>修改部门</title>");
  38.         out.print("</head>");
  39.         out.print("<body>");
  40.         out.print("<h1>修改部门</h1>");
  41.         out.print("<hr>");
  42.         out.print("<form action='" + contextPath + "/dept/update' method='post'>");
  45.         //获取部门编号
  46.         String deptno = request.getParameter("deptno");
  48.         //连接数据库执行insert语句
  49.         Connection conn = null;
  50.         PreparedStatement ps = null;
  51.         ResultSet rs = null;
  53.         try {
  54.             conn = DBUtil.getConnection();
  56.             String sql = "select dname,loc from dept where deptno=?";
  57.             ps = conn.prepareStatement(sql);
  58.             ps.setString(1, deptno);
  60.             rs = ps.executeQuery();
  62.             if (rs.next()) {
  63.                 String dname = rs.getString("dname");
  64.                 String loc = rs.getString("loc");
  66.                 //输出动态网页
  67.                 out.print("                部门编号<input type='text' name='deptno' value='" + deptno + "' readonly><br><!--readonly只读-->");
  68.                 out.print("                部门名称<input type='text' name='dname' value='" + dname + "'><br>");
  69.                 out.print("                部门位置<input type='text' name='loc' value='" + loc + "'><br>");
  71.             }
  73.         } catch (SQLException e) {
  74.             e.printStackTrace();
  76.         } finally {
  77.             DBUtil.close(conn, ps, rs);
  78.         }
  80.         //判断新增成功还是失败
  82.         out.print("    <input type='submit' value='修改'><br>");
  83.         out.print("");
  84.         out.print("</form>");
  85.         out.print("");
  86.         out.print("</body>");
  87.         out.print("</html>");
  89.     }
  90. }
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
  3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
  5.          version="4.0">
  7.     <!--查看部门列表-->
  8.     <servlet>
  9.         <servlet-name>list</servlet-name>
  10.         <servlet-class>oa.action.DeptListServlet</servlet-class>
  11.     </servlet>
  12.     <servlet-mapping>
  13.         <servlet-name>list</servlet-name>
  14.         <url-pattern>/dept/list</url-pattern>
  15.     </servlet-mapping>
  17.     <!--查看详情-->
  18.     <servlet>
  19.         <servlet-name>detail</servlet-name>
  20.         <servlet-class>oa.action.DeptDetailServelt</servlet-class>
  21.     </servlet>
  22.     <servlet-mapping>
  23.         <servlet-name>detail</servlet-name>
  24.         <url-pattern>/dept/detail</url-pattern>
  25.     </servlet-mapping>
  27.     <!--删除-->
  28.     <servlet>
  29.         <servlet-name>delete</servlet-name>
  30.         <servlet-class>oa.action.DeptDelServlet</servlet-class>
  31.     </servlet>
  32.     <servlet-mapping>
  33.         <servlet-name>delete</servlet-name>
  34.         <url-pattern>/dept/delete</url-pattern>
  35.     </servlet-mapping>
  37.     <!--保存-->
  38.     <servlet>
  39.         <servlet-name>save</servlet-name>
  40.         <servlet-class>oa.action.DeptSaveServlet</servlet-class>
  41.     </servlet>
  42.     <servlet-mapping>
  43.         <servlet-name>save</servlet-name>
  44.         <url-pattern>/dept/save</url-pattern>
  45.     </servlet-mapping>
  47.     <!--修改页面-->
  48.     <servlet>
  49.         <servlet-name>edit</servlet-name>
  50.         <servlet-class>oa.action.DeptEditServlet</servlet-class>
  51.     </servlet>
  52.     <servlet-mapping>
  53.         <servlet-name>edit</servlet-name>
  54.         <url-pattern>/dept/edit</url-pattern>
  55.     </servlet-mapping>
  57.     <!--修改部门-->
  58.     <servlet>
  59.         <servlet-name>update</servlet-name>
  60.         <servlet-class>oa.action.DeptUpdateServlet</servlet-class>
  61.     </servlet>
  62.     <servlet-mapping>
  63.         <servlet-name>update</servlet-name>
  64.         <url-pattern>/dept/update</url-pattern>
  65.     </servlet-mapping>
  68. </web-app>