1、步骤

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（以列表页面为核心，展开操作） ```html <!DOCTYPE html> 查看部门列表

  1. ```html
  2. <!DOCTYPE html>
  3. <html lang="en">
  4. <head>
  5.     <meta charset="UTF-8">
  6.     <title>部门列表</title>
  7. </head>
  8. <body>
  9. <h1 align="center">部门列表</h1>
  10. <hr>
  11. <table border="1px" align="center" width="50%">
  12.     <tr>
  13.         <th>序号</th>
  14.         <th>部门编号</th>
  15.         <th>部门名称</th>
  16.         <th>操作</th>
  17.     </tr>
  18.     <tr>
  19.         <td>1</td>
  20.         <td>10</td>
  21.         <td>销售部</td>
  22.         <td>
  23.             <a href="javascript:void(0)" onclick="window.confirm('亲，确认删除该数据吗？')">删除</a>
  24.             <a href="edit.html">修改</a>
  25.             <a href="detail.html">详情</a>
  26.         </td>
  27.     </tr>
  28.     <tr>
  29.         <td>2</td>
  30.         <td>20</td>
  31.         <td>研发部</td>
  32.         <td>
  33.             <a href="javascript:void(0)" onclick="window.confirm('亲，确认删除该数据吗？')">删除</a>
  34.             <a href="edit.html">修改</a>
  35.             <a href="detail.html">详情</a>
  36.         </td>
  37.     </tr>
  38.     <tr>
  39.         <td>3</td>
  40.         <td>30</td>
  41.         <td>运用部</td>
  42.         <td>
  43.             <a href="javascript:void(0)" onclick="window.confirm('亲，确认删除该数据吗？')">删除</a>
  44.             <a href="edit.html">修改</a>
  45.             <a href="detail.html">详情</a>
  46.         </td>
  47.     </tr>
  48.     <tr>
  49.         <td>4</td>
  50.         <td>40</td>
  51.         <td>媒体部</td>
  52.         <td>
  53.             <a href="javascript:void(0)" onclick="window.confirm('亲，确认删除该数据吗？')">删除</a>
  54.             <a href="edit.html">修改</a>
  55.             <a href="detail.html">详情</a>
  56.         </td>
  57.     </tr>
  58. </table>
  60. <hr>
  61. <a href="add.html">新增部门</a>
  63. </body>
  64. </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 分析这个系统包括哪些功能

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

  • [x] 修改部门

    1.4 在IDEA中搭建开发环境

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

  • 向webapp中添加连接数据库的jar包（MySQL驱动）
    • 必须在WEB-INF目录下创建lib，然后将mysql驱动jar包导入
  • JDBC的工具类

image.png

  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

image.png

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

    1.5 实现连接

    1.51 注意

  • [x] 如何实现？

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

    1.52 步骤

  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文件 ```xml <?xml version=”1.0” encoding=”UTF-8”?>

    list oa.DeptListServlet list /dept/list 

  2. ---
  4. 3. 编写DeptListServlet类继承HttpServlet类，然后重写doGet方法
  5. ```java
  6. package oa.action;
  8. import jakarta.servlet.ServletException;
  9. import jakarta.servlet.http.HttpServlet;
  10. import jakarta.servlet.http.HttpServletRequest;
  11. import jakarta.servlet.http.HttpServletResponse;
  13. import java.io.IOException;
  15. /**
  16. * @Author: 小雷学长
  17. * @Date: 2022/3/22 - 10:05
  18. * @Version: 1.8
  19. */
  20. public class DeptListServlet extends HttpServlet {
  21.     @Override
  22.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  23.         throws ServletException, IOException {
  26.     }
  27. }
  1. 在DeptServlet类的doGet方法中连接数据库，查询所有的部门，动态的展示部门列表页面
  • 分析list.html页面中哪部分是固定不变的，哪部分是需要动态展示的
  • list.html页面中的内容所有的双引号，要变成单引号，因为print.out(“”)这里有一个双引号，容易冲突 ```java package oa.action;

import com.sun.corba.se.spi.orb.PropertyParser; import jakarta.servlet.ServletException; import jakarta.servlet.http.HttpServlet; import jakarta.servlet.http.HttpServletRequest; import jakarta.servlet.http.HttpServletResponse; import oa.untils.DBUtil;

import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;

/**

  • @Author: 小雷学长
  • @Date: 2022/3/22 - 10:05

  • @Version: 1.8 */ public class DeptListServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest request, HttpServletResponse response)

    1.      throws ServletException, IOException {
    3.  //设置响应的内容类型
    4.  response.setContentType("text/html");
    5.  PrintWriter out = response.getWriter();
    7.  out.print("        <!DOCTYPE html>");
    8.  out.print("<html lang='en'>");
    9.  out.print("<head>");
    10.  out.print("    <meta charset='UTF-8'>");
    11.  out.print("    <title>部门列表</title>");
    12.  out.print("</head>");
    13.  out.print("<body>");
    14.  out.print("<h1 align='center'>部门列表</h1>");
    15.  out.print("<hr>");
    16.  out.print("<table border='1px' align='center' width='50%'>");
    17.  out.print("    <tr>");
    18.  out.print("        <th>序号</th>");
    19.  out.print("        <th>部门编号</th>");
    20.  out.print("        <th>部门名称</th>");
    21.  out.print("        <th>操作</th>");
    22.  out.print("    </tr>");
    23.  out.print("    <!--以上是固定的-->");
    24.  /*
    25.  上面一部分是死的
    26.   */
    28.  /*
    29.   * 连接数据库
    30.   */
    31.  Connection conn = null;
    32.  PreparedStatement ps = null;
    33.  ResultSet rs = null;
    35.  try {
    37.      //获取连接
    38.      conn = DBUtil.getConnection();
    40.      //获取预编译的数据库操作对象
    41.      String sql = "select deptno,dname ,loc from dept";
    42.      ps = conn.prepareStatement(sql);
    44.      //执行SQL语句
    45.      rs = ps.executeQuery();
    47.      //处理结果集
    48.      int i = 0;
    49.      while (rs.next()) {
    50.          String deptno = rs.getString("deptno");
    51.          String dname = rs.getString("dname");
    52.          String loc = rs.getString("loc");
    54.          out.print("    <tr>");
    55.          out.print("        <td>" + (++i) + "</td>");
    56.          out.print("        <td>" + deptno + "</td>");
    57.          out.print("        <td>" + dname + "</td>");
    58.          out.print("        <td>");
    59.          out.print("            <a href=''></a>");
    60.          out.print("            <a href='edit.html'>修改</a>");
    61.          out.print("            <a href='detail.html'>详情</a>");
    62.          out.print("        </td>");
    63.          out.print("    </tr>");
    65.      }
    66.  } catch (SQLException e) {
    67.      e.printStackTrace();
    68.  } finally {
    70.      //释放资源
    71.      DBUtil.close(conn, ps, rs);
    72.  }
    74.  /*
    75.  下面一部分是死的
    76.   */
    77.  out.print("    <!--一下是固定的-->");
    78.  out.print("</table>");
    79.  out.print("<hr>");
    80.  out.print("<a href=' add.html'>新增部门</a>");
    81.  out.print("</body>");
    82.  out.print("</html>");

    } }

  2. ---
  4. <a name="OjnZ1"></a>
  5. ## 1.6 查看部门详情
  7. - [x] 从前端往后端一步一步实现，要考虑的是用户要点击的是什么，用户点击的在哪里
  8. ```java
  9.  out.print("<a href='" + contextPath + "/dept/detail?deptno = " + deptno + "'>详情</a>");
  • 向服务器提交数据的格式：url?name=value&name=value&name=value&name=value
  • 这里的问号必须是英文的问号，不能写中文的问号，url不能带空格
  1. 编写一个类：DeptDetailServelt.java ```java package oa.action;

import jakarta.servlet.ServletException; import jakarta.servlet.http.HttpServlet; import jakarta.servlet.http.HttpServletRequest; import jakarta.servlet.http.HttpServletResponse; import oa.untils.DBUtil;

import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;

/**

  • @Author: 小雷学长
  • @Date: 2022/3/22 - 15:01

  • @Version: 1.8 */ public class DeptDetailServelt extends HttpServlet { @Override protected void doGet(HttpServletRequest request, HttpServletResponse response)

    1.      throws ServletException, IOException {
    3.  response.setContentType("text/html");
    4.  PrintWriter out = response.getWriter();
  1.     out.print("<!DOCTYPE html>");
  2.     out.print("<html lang='en'>");
  3.     out.print("<head>");
  4.     out.print("    <meta charset='UTF-8'>");
  5.     out.print("    <title>部门详情</title>");
  6.     out.print("</head>");
  7.     out.print("<body>");
  8.     out.print("<h1>部门详情</h1>");
  9.     out.print("<hr>");
  12.     //获取部门编号
  13.     //虽然提交的是30，但服务器获取的是30这个字符串
  14.     String deptno = request.getParameter("deptno");
  17.     /*
  18.      * 连接数据库
  19.      */
  20.     Connection conn = null;
  21.     PreparedStatement ps = null;
  22.     ResultSet rs = null;
  24.     try {
  26.         //获取连接
  27.         conn = DBUtil.getConnection();
  29.         //获取预编译的数据库操作对象
  30.         String sql = "select deptno,dname,loc from dept where deptno=?";
  31.         ps = conn.prepareStatement(sql);
  33.         ps.setString(1, deptno);
  34.         //这个结果集一定只有一个元素
  37.         //执行SQL语句
  38.         rs = ps.executeQuery();
  40.         //处理结果集
  41.         if (rs.next()) {
  42.             String dname = rs.getString("dname");
  43.             String loc = rs.getString("loc");
  45.             out.print("部门编号" + deptno + "<br>");
  46.             out.print("部门名称" + dname + "<br>");
  47.             out.print("部门位置" + loc + "<br>");
  50.         }
  51.     } catch (SQLException e) {
  52.         e.printStackTrace();
  53.     } finally {
  55.         //释放资源
  56.         DBUtil.close(conn, ps, rs);
  57.     }
  59.     out.print("");
  60.     out.print("<form action='list.html'>");
  61.     out.print("    <input type='button' value='后退' onclick='window.history.back()'>");
  62.     out.print("");
  63.     out.print("</form>");
  64.     out.print("");
  65.     out.print("</body>");
  66.     out.print("</html>");
  67. }

}

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

image.png
image.png

  • [x] 四种获取请求的方法

    1. document.location.href = "请求路径"
    2. document.locaction = "请求路径"
    3. window.location.href = "请求路径"
    4. window.location = "请求路径"

    1.72 实现删除

  • [x] 前端程序要写到后端的java代码中，因为没有JSP的支持，只能在后端里写前端代码 ```java package oa.action;

import com.sun.corba.se.spi.orb.PropertyParser; import jakarta.servlet.ServletException; import jakarta.servlet.http.HttpServlet; import jakarta.servlet.http.HttpServletRequest; import jakarta.servlet.http.HttpServletResponse; import oa.untils.DBUtil;

import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;

/**

  • @Author: 小雷学长
  • @Date: 2022/3/22 - 10:05

  • @Version: 1.8 */ public class DeptListServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest request, HttpServletResponse response)

    1.   throws ServletException, IOException {
    3.   //获取应用的根路径
    4.   String contextPath = request.getContextPath();
    6.   //设置响应的内容类型
    7.   response.setContentType("text/html");
    8.   PrintWriter out = response.getWriter();
    10.   out.print("        <!DOCTYPE html>");
    11.   out.print("<html lang='en'>");
    12.   out.print("<head>");
    13.   out.print("    <meta charset='UTF-8'>");
    14.   out.print("    <title>部门列表</title>");
    15.   out.print("</head>");
    17.   out.print("<body>");
    18.   out.print("<script type='text/javascript'>");
    19.   out.print("        function del(dno) {");
    20.   out.print("    if(window.confirm('亲，删了不可恢复哦！')){");
    21.   out.print("        document.location.href = 'oa/dept/delete?deptno=' + dno;");
    22.   out.print("    }");
    23.   out.print("}");
    24.   out.print("</script>");
    25.   out.print("<h1 align='center'>部门列表</h1>");
    26.   out.print("<hr>");
    27.   out.print("<table border='1px' align='center' width='50%'>");
    28.   out.print("    <tr>");
    29.   out.print("        <th>序号</th>");
    30.   out.print("        <th>部门编号</th>");
    31.   out.print("        <th>部门名称</th>");
    32.   out.print("        <th>操作</th>");
    33.   out.print("    </tr>");
    34.   out.print("    <!--以上是固定的-->");
    35.   /*
    36.   上面一部分是死的
    37.   */
    39.   /*
    40.   * 连接数据库
    41.   */
    42.   Connection conn = null;
    43.   PreparedStatement ps = null;
    44.   ResultSet rs = null;
    46.   try {
    48.       //获取连接
    49.       conn = DBUtil.getConnection();
    51.       //获取预编译的数据库操作对象
    52.       String sql = "select deptno,dname ,loc from dept";
    53.       ps = conn.prepareStatement(sql);
    55.       //执行SQL语句
    56.       rs = ps.executeQuery();
    58.       //处理结果集
    59.       int i = 0;
    60.       while (rs.next()) {
    61.           String deptno = rs.getString("deptno");
    62.           String dname = rs.getString("dname");
    63.           String loc = rs.getString("loc");
    65.           out.print("    <tr>");
    66.           out.print("        <td>" + (++i) + "</td>");
    67.           out.print("        <td>" + deptno + "</td>");
    68.           out.print("        <td>" + dname + "</td>");
    69.           out.print("        <td>");
    70.           out.print("<a href='javascript:void(0)' onclick='del(" + deptno + ")')'>删除</a>");
    71.           out.print("            <a href='edit.html'>修改</a>");
    72.           out.print("            <a href='" + contextPath + "/dept/detail?deptno=" + deptno + "'>详情</a>");
    73.           out.print("        </td>");
    74.           out.print("    </tr>");
    76.       }
    77.   } catch (SQLException e) {
    78.       e.printStackTrace();
    79.   } finally {
    81.       //释放资源
    82.       DBUtil.close(conn, ps, rs);
    83.   }
    85.   /*
    86.   下面一部分是死的
    87.   */
    88.   out.print("    <!--一下是固定的-->");
    89.   out.print("</table>");
    90.   out.print("<hr>");
    91.   out.print("<a href=' add.html'>新增部门</a>");
    92.   out.print("</body>");
    93.   out.print("</html>");

    } }

  2. - [x] 点击删除会出现404问题，解决
  3.    - 配置web.xml
  4. ```java
  5.  <!--删除-->
  6.     <servlet>
  7.         <servlet-name>delete</servlet-name>
  8.         <servlet-class>oa.action.DeptDelServlet</servlet-class>
  9.     </servlet>
  10.     <servlet-mapping>
  11.         <servlet-name>delete</servlet-name>
  12.         <url-pattern>/dept/delete</url-pattern>
  13.     </servlet-mapping>

1.73 最终实现

image.png

  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>