ToB企服应用市场:ToB评测及商务社交产业平台

标题: Spring Boot学习随笔- JSP小项目-员工管理系统（验证码生成、增删改查） [打印本页]

作者: 笑看天下无敌手 时间: 2024-2-24 02:06
标题: Spring Boot学习随笔- JSP小项目-员工管理系统（验证码生成、增删改查）

学习视频：【编程不良人】2021年SpringBoot最新最全教程

第十章、项目开发

实现一个登录注册，增删改查功能的系统
10.1 项目开发流程

需求分析
分析用户主要需求提取项目核心功能，根据核心功能构建页面原型
库表设计：
- 分析系统有哪些表
- 分析表之间关联关系
- 确定字段
详细设计（流程图、伪代码）：
验证库表准确性
功能实现（编码）
环境搭建，具体功能实现
功能测试，部署，上线，运维，维护

全栈式开发：前端+后端+运维
10.2 需求分析

系统有哪些模块？
每个模块功能有哪些？
- 用户模块：登录、注册、验证码生成
- 员工模块：查询、删除、更新、添加

10.3 库表设计

用户表：user
员工表：employee
表与表关系：user，employee 独立两张表
创建库表

create database ems;
use ems;
create TABLE user(
id int auto_increment ,username VARCHAR(40) COMMENT '用户名' ,
realname VARCHAR(40) COMMENT '真实姓名' ,
`password` VARCHAR(50) COMMENT '密码',gender TINYINT(3) COMMENT '性别',
PRIMARY KEY (`id`)
);
create TABLE employee(
id int auto_increment,
name VARCHAR(40) COMMENT '姓名',
birthday datetime COMMENT '生日',
salary DOUBLE COMMENT '薪资',
gender TINYINT(3) COMMENT '性别',
PRIMARY KEY(id)
)

复制代码

10.5 编码环节

技术选型：SpringBoot + MyBatis + JSP + MySQL
环境搭建：Spring Boot + JSP + MyBatis
创建名为ems-jsp的项目，并引入web支持依赖，创建完成

环境搭建

pom.xml依赖导入

<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.apache.tomcat.embed</groupId>
<artifactId>tomcat-embed-jasper</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.19</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>3.0.0</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
</dependency>
</dependencies>

复制代码

application.yml:

# 应用服务 WEB 访问端口
server:
port: 8989
servlet:
context-path: /ems-jsp
jsp:
init-parameters:
development: true # 开启jsp模板开发模式
# 配置jsp展示
spring:
mvc:
view:
prefix: /
suffix: .jsp
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/ems?characterEncoding=UTF-8
username: root
password: 123456
# 配置mybatis
mybatis:
mapper-locations: classpath:com.baizhi/mapper/*.xml
type-aliases-package: com.baizhi.entity
# 配置日志
logging:
level:
com.baizhi: debug

复制代码

添加dao包扫描

@SpringBootApplication
@MapperScan("com.baizhi.dao")
public class EmsJspApplication {
public static void main(String[] args) {
SpringApplication.run(EmsJspApplication.class, args);
}
}

复制代码

10.6 验证码实现

业务逻辑
- 生成随机字符（依靠工具类VerifyCode）
- 放入session（与前端传过来的验证码进行比对），放进map（传给前端）
- 生成图片响应
register.jsp
1. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
2. <!DOCTYPE html>
3. <html>
4. <head>
5. <meta charset="UTF-8">
6. <title>Registration Page</title>
7. <link rel="stylesheet" type="text/css" href="css/register.css">
8. </head>
9. <body>
11. <h2>用户注册</h2>
13. <h3 >${param.msg}</h3>
14. <form action="${pageContext.request.contextPath}/user/register" method="post">
15. 用户名: <input type="text" name="username"><br>
16. 真实姓名: <input type="text" name="realname" ><br>
17. 密码: <input type="password" name="password" ><br>
18. <%-- 确认密码： <input type="password" name="confirmPassword"><br>--%>
19. 性别:
20. <select name="gender" >
21. <option value="1">男</option>
22. <option value="0">女</option>
23. </select><br>
25. <label for="verifyCode">验证码:</label><br>
26. <img id="verifyCode" src="" alt="Captcha Image">
27. <a target="_blank" href="https://www.cnblogs.com/javascript:" id="refresh">换一张</a>
28. <input type="text" name="code"><br>
29. <input type="submit" value="注册">
30. </form>
36. </body>
37. </html>
复制代码
css
1. body {
2. font-family: 'Arial', sans-serif;
3. margin: auto;
4. justify-content: center;
5. align-items: center;
6. width: 500px;
7. height: 800px;
8. /*border: 1px solid red;*/
9. }
11. .container {
12. padding: 30px;
13. background-color: #ffffff;
14. border-radius: 8px;
15. box-shadow: 0 0 15px rgba(0, 0, 0, 0.1);
16. /*border: 1px solid red;*/
17. }
19. h2 {
20. text-align: center;
21. }
23. input[type="text"],
24. input[type="password"],
25. input[type="submit"],
26. select {
27. width: calc(100% - 20px);
28. margin-bottom: 15px;
29. padding: 10px;
30. border: 1px solid #dddddd;
31. border-radius: 5px;
32. transition: border-color 0.3s ease-in-out;
33. }
35. input[type="text"]:focus,
36. input[type="password"]:focus,
37. select:focus {
38. outline: none;
39. border-color: #66afe9;
40. }
42. input[type="submit"] {
43. background-color: #4CAF50;
44. color: white;
45. border: none;
46. cursor: pointer;
47. transition: background-color 0.3s ease-in-out;
48. }
50. input[type="submit"]:hover {
51. background-color: seagreen;
52. }
复制代码
验证码实现类
1. package com.baizhi.utils;
2. import javax.imageio.ImageIO;
3. import java.awt.Color;
4. import java.awt.Font;
5. import java.awt.Graphics;
6. import java.awt.image.BufferedImage;
7. import java.io.FileOutputStream;
8. import java.io.IOException;
9. import java.io.OutputStream;
10. import java.util.Random;
12. public class VerifyCode {
13. private int width = 100;// 定义图片的width
14. private int height = 40;// 定义图片的height
15. private int codeCount = 4;// 定义图片上显示验证码的个数
16. private int lineCount = 20;// 定义图片上显示干扰线的条数
17. private String code = null;// 定义用于保存验证码的字符串
18. private BufferedImage buffImg = null;// 定义图片Buffer
20. private char[] codeSequence = { 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'P', 'Q', 'R',
21. 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '1', '2', '3', '4', '5', '6', '7', '8', '9' };
23. public VerifyCode() {
24. this.createCode();
25. }
27. /**
28. * @param width
29. * 图片宽
30. * @param height
31. * 图片高
32. */
33. public VerifyCode(int width, int height) {
34. this.width = width;
35. this.height = height;
36. this.createCode();
37. }
39. /**
40. * @param width
41. * 图片宽
42. * @param height
43. * 图片高
44. * @param codeCount
45. * 字符个数
46. * @param lineCount
47. * 干扰线条数
48. */
49. public VerifyCode(int width, int height, int codeCount, int lineCount) {
50. this.width = width;
51. this.height = height;
52. this.codeCount = codeCount;
53. this.lineCount = lineCount;
54. this.createCode();
55. }
57. public void createCode() {
58. int x = 0, fontHeight = 0, codeY = 0;
59. int red = 0, green = 0, blue = 0;
61. x = width / (codeCount + 2);// 每个字符的宽度
62. fontHeight = height - 2;// 字体的高度
63. codeY = height - 4;
65. // 图像buffer
66. buffImg = new BufferedImage(width, height, BufferedImage.TYPE_INT_RGB);
67. Graphics g = buffImg.createGraphics();
68. // 创建一个随机数生成器类
69. Random random = new Random();
70. // 将图像填充为白色
71. g.setColor(Color.WHITE);
72. g.fillRect(0, 0, width, height);
73. // 创建字体，字体的大小应该根据图片的高度来定。
74. Font font = new Font("Fixedsys", Font.PLAIN, fontHeight);
75. // 设置字体。
76. g.setFont(font);
78. for (int i = 0; i < lineCount; i++) {
79. // 设置随机开始和结束坐标
80. int xs = random.nextInt(width);// x坐标开始
81. int ys = random.nextInt(height);// y坐标开始
82. int xe = xs + random.nextInt(width / 8);// x坐标结束
83. int ye = ys + random.nextInt(height / 8);// y坐标结束
85. // 生成随机颜色
86. red = random.nextInt(255);
87. green = random.nextInt(255);
88. blue = random.nextInt(255);
89. g.setColor(new Color(red, green, blue));
90. g.drawLine(xs, ys, xe, ye);
91. }
93. // randomCode记录随机产生的验证码
94. StringBuffer randomCode = new StringBuffer();
95. // 随机产生codeCount个字符的验证码。
96. for (int i = 0; i < codeCount; i++) {
97. // 得到随机产生的验证码数字。
98. String strRand = String.valueOf(codeSequence[random.nextInt(codeSequence.length)]);
99. // 用随机产生的颜色将验证码绘制到图像中。
100. red = random.nextInt(255);
101. green = random.nextInt(255);
102. blue = random.nextInt(255);
103. g.setColor(new Color(red, green, blue));
104. g.drawString(strRand, (i + 1) * x, codeY);
105. // 将产生的四个随机数组合在一起。
106. randomCode.append(strRand);
107. }
108. // 将四位数字的验证码保存到Session中。
109. code = randomCode.toString();
110. }
112. public void write(String path) throws IOException {
113. OutputStream sos = new FileOutputStream(path);
114. this.write(sos);
115. }
117. public void write(OutputStream sos) throws IOException {
118. ImageIO.write(buffImg, "png", sos);
119. sos.close();
120. }
122. public BufferedImage getBuffImg() {
123. return buffImg;
124. }
126. public String getCode() {
127. return code;
128. }
129. }
复制代码
验证码生成请求
1. @Controller
2. @RequestMapping("user")
3. public class UserController {
5. /**
6. * 生成验证码
7. */
8. @ResponseBody
9. @RequestMapping("verifyCode")
10. public Map<String, String> verifyCode(HttpServletRequest request) throws IOException {
11. Map<String,String> map = new HashMap<>();
12. // 1.使用工具类生成验证码
13. VerifyCode vc = new VerifyCode(120, 40, 4, 100);
14. String code = vc.getCode();
15. map.put("code", code);
16. // 2. 获取验证码的BufferedImage对象
17. BufferedImage captchaImage = vc.getBuffImg();
18. //4.将图片转为base64 [放入src,可以直接显示图片]
19. ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
20. ImageIO.write(captchaImage, "png", outputStream);
21. byte[] imageBytes = outputStream.toByteArray();
22. String image = "data:image/png;base64," + Base64Utils.encodeToString(imageBytes);
23. map.put("image", image);
24. return map;
25. }
26. }
复制代码

10.7 注册实现

业务逻辑
Service
1. @Service
2. @Transactional
3. public class UserServiceImpl implements UserService {
5. @Autowired
6. private UserDao userDao;
8. @Override
9. public void register(User user) {
10. User userDB = userDao.findByUserName(user.getUsername());
11. if (!ObjectUtils.isEmpty(userDB)) {
12. throw new RuntimeException("用户名已存在");
13. }
14. // 注册之前给密码进行加密
15. String passwordSecret = DigestUtils.md5DigestAsHex(user.getPassword().getBytes(StandardCharsets.UTF_8));
16. user.setPassword(passwordSecret);
17. userDao.save(user);
19. }
20. }
复制代码
mapper语句
1. <select id="findByUserName" resultType="com.baizhi.entity.User">
2. select id,username,realname,password,gender from `user`
3. where username = #{username}
4. </select>
复制代码
api
1. @Autowired
2. private UserService userService;
4. @RequestMapping("register")
5. public String register(User user, String code, HttpSession session) {
6. log.debug("接受的验证码：{}", code);
7. log.debug("User：{}", user);
8. // 比较验证
9. try {
10. String sessionCode = session.getAttribute("code").toString();
11. if (!sessionCode.equalsIgnoreCase(code)) {
12. throw new RuntimeException("验证码输入错误！！！");
13. }
14. userService.register(user);
15. } catch (RuntimeException e) {
16. e.printStackTrace();
17. return "redirect:/register.jsp?msg=" + UriEncoder.encode(e.getMessage());
18. }
19. return "redirect:/login.jsp";
20. }
复制代码

10.8用户登录

login.jsp
1. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
2. <!DOCTYPE html>
3. <html>
4. <head>
5. <meta charset="UTF-8">
6. <title>Login Page</title>
7. <link rel="stylesheet" href="css/register.css">
8. </head>
9. <body>
10. <h2>用户登录</h2>
11. <h3 >${param.msg}</h3>
12. <form action="${pageContext.request.contextPath}/employee/list" method="post">
13. <label for="username">用户名:</label><br>
14. <input type="text" id="username" name="username"><br>
15. <label for="password">密码:</label><br>
16. <input type="password" id="password" name="password"><br>
17. <input type="submit" value="登录">
18. <input type="button" onclick="window.location.href='register.jsp'" value="注册">
19. </form>
20. </body>
21. </html>
复制代码
ServiceImpl
1. @Override
2. public User login(String username, String password) {
3. //1. 根据用户名查询数据库是否存在
4. User user = userDao.findByUserName(username);
5. //2.判断对象是否存在
6. if (ObjectUtils.isEmpty(user)) {
7. throw new RuntimeException("用户名输入错误！");
8. }
9. //3.判断密码正确性
10. String digestPassword = DigestUtils.md5DigestAsHex(password.getBytes(StandardCharsets.UTF_8));
11. if (!user.getPassword().equals(digestPassword)) {
12. throw new RuntimeException("密码错误！");
13. }
14. return user;
15. }
复制代码
UserController
1. @RequestMapping("login")
2. public String login(String username, String password,HttpSession session) throws UnsupportedEncodingException {
3. log.debug("接受到的用户名：{},接收到的密码：{}", username, password);
4. try {
5. // 1.执行登录业务逻辑
6. User user = userService.login(username, password);
7. // 2.登录成功，保存用户信息
8. session.setAttribute("user", user);
9. } catch (Exception e) {
10. e.printStackTrace();
11. return "redirect:/login.jsp?msg=" + UriEncoder.encode(e.getMessage());
12. }
13. return "redirect:/emplist.jsp";
14. }
复制代码

10.9 员工列表展示

在数据库查询所有员工信息
在页面中进行展示

emplist.jsp
1. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
2. <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
3. <%@ page language="java" contentType="text/html; charset=UTF-8"
4. pageEncoding="UTF-8" %>
5. <!DOCTYPE html>
6. <html>
7. <head>
8. <title>用户列表</title>
9. <link rel="stylesheet" href="${pageContext.request.contextPath}/css/emplist.css">
10. </head>
11. <body>
13. <h2>用户列表</h2>
14. <table>
15. <tr>
16. <th>ID</th>
17. <th>姓名</th>
18. <th>性别</th>
19. <th>薪水</th>
20. <th>生日</th>
21. <th>操作</th>
22. </tr>
23. <c:forEach var="employee" items="${requestScope.employees}">
24. <tr>
25. <td>${employee.id}</td>
26. <td>${employee.name}</td>
27. <td>${employee.gender?'男':'女'}</td>
28. <td>${employee.salary}</td>
29. <td><fmt:formatDate value="${employee.birthday}" pattern="yyyy-MM-dd"/></td>
30. <td>
31. <a target="_blank" href="https://www.cnblogs.com/javascript:;">删除</a>
32. <a target="_blank" href="https://www.cnblogs.com/javascript:;">修改</a>
33. </td>
34. </tr>
35. </c:forEach>
36. </table>
37. <a target="_blank" href="https://www.cnblogs.com/javascript:;">添加员工信息</a>
40. </body>
41. </html>
复制代码
emplist.css
1. body {
2. font-family: Arial, sans-serif;
3. margin: 0;
4. padding: 0;
5. }
7. #container {
8. max-width: 800px;
9. margin: 0 auto;
10. padding: 20px;
11. }
13. h2 {
14. text-align: center;
15. }
16. table {
17. width: 100%;
18. border-collapse: collapse;
19. margin-bottom: 20px;
20. }
22. th, td {
23. padding: 10px;
24. text-align: left;
25. border: 1px solid #ccc;
26. }
28. thead {
29. background-color: #f2f2f2;
30. }
32. div > button {
33. margin: 5px;
34. padding: 5px 10px;
35. border: none;
36. background-color: #007bff;
37. color: #fff;
38. cursor: pointer;
39. }
41. div > button:hover {
42. background-color: #0056b3;
43. }
45. select, button {
46. padding: 5px;
47. }
49. div > span {
50. margin: 0 10px;
51. font-weight: bold;
52. }
54. label {
55. font-weight: bold;
56. }
复制代码
Service
1. @Service
2. @Transactional
3. public class EmployeeServiceImpl implements EmployeeService {
5. private final EmployeeDao employeeDao;
7. @Autowired
8. public EmployeeServiceImpl(EmployeeDao employeeDao) {
9. this.employeeDao = employeeDao;
10. }
12. @Override
13. public List<Employee> list() {
14. return employeeDao.list();
15. }
16. }
复制代码
EmployeeController
1. @Controller
2. @RequestMapping("employee")
3. public class EmployeeController {
5. private EmployeeService employeeService;
7. @Autowired
8. public EmployeeController(EmployeeService employeeService) {
9. this.employeeService = employeeService;
10. }
12. /**
13. * 员工列表
14. *
15. * @return
16. */
17. @RequestMapping("list")
18. public String listEmployee(HttpServletRequest request, Model model) {
19. //1. 获取员工列表
20. List<Employee> employees = employeeService.list();
21. // request.setAttribute("employees", employees);
22. model.addAttribute("employees", employees);
23. return "emplist";
24. }
25. }
复制代码

10.10 添加员工信息

在EmplyeeController开发一个添加方法
接收员工信息
将员工信息保存到数据库
跳转到员工列表展示数据

addEmp.jsp
1. <%@ page language="java" contentType="text/html; charset=UTF-8"
2. pageEncoding="UTF-8" %>
3. <!DOCTYPE html>
4. <html>
5. <head>
6. <title>添加员工</title>
7. <link rel="stylesheet" href="css/addEmp.css">
8. </head>
9. <body>
10. <h2>添加员工</h2>
12. <form action="${pageContext.request.contextPath}/employee/add" method="post">
13. <table>
14. <tr>
15. <td>姓名:</td>
16. <td><input type="text" id="name" name="name"></td>
17. </tr>
18. <tr>
19. <td>薪水:</td>
20. <td><input type="text" id="salary" name="salary"></td>
21. </tr>
22. <tr>
23. <td>生日:</td>
24. <td><input type="text" id="birthday" name="birthday"></td>
25. </tr>
26. <tr>
27. <td>性别:</td>
28. <td>
29. <select name="gender" >
30. <option value="1">男</option>
31. <option value="0">女</option>
32. </select>
33. </td>
34. </tr>
35. <tr>
36. <td colspan="2"><input type="submit" value="添加"></td>
37. </tr>
38. </table>
39. </form>
42. </body>
43. </html>
复制代码
addEmp.css
1. body {
2. font-family: Arial, sans-serif;
3. margin: 0;
4. padding: 0;
5. }
6. #container {
7. max-width: 800px;
8. margin: 0 auto;
9. padding: 20px;
10. }
12. h2 {
13. text-align: center;
14. }
15. table {
16. width: 100%;
17. border-collapse: collapse;
18. margin-bottom: 20px;
19. color: #212529;
20. }
21. td, th {
22. vertical-align: top;
23. padding: 10px;
24. text-align: left;
25. border: 1px solid #ccc;
26. }
27. input[type="text"], input[type="date"], select {
28. width: 60%;
29. padding: .375rem .75rem;
30. border: 1px solid #ced4da;
31. border-radius: .25rem;
32. }
33. input[type="submit"] {
34. color: #fff;
35. background-color: #007bff;
36. border-color: #007bff;
37. padding: .375rem .75rem;
38. border-radius: .25rem;
39. }
复制代码
EmployeeDaomapper.xml
1. <insert id="add" parameterType="Employee" useGeneratedKeys="true" keyProperty="id">
2. INSERT INTO `ems`.`employee`(`id`, `name`, `birthday`, `salary`, `gender`) VALUES (#{id},#{name},#{birthday},#{salary},#{gender});
3. </insert>
复制代码
EmployeeServiceImpl
1. public void addEmployee(Employee employee) {
2. employeeDao.add(employee);
3. }
复制代码
Controller
1. @RequestMapping("add")
2. public String addEmployee(Employee employee) {
3. log.debug("员工信息：{}", employee);
4. //1. 保存员工信息
5. employeeService.addEmployee(employee);
6. return "redirect:/employee/list";
7. }
复制代码

10.11 更新员工信息

显示员工信息
- 根据id查询员工信息
- 将对象放进作用域
- 跳转到更新页面
UpdateEmp.jsp
1. <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
2. <%@ page language="java" contentType="text/html; charset=UTF-8"
3. pageEncoding="UTF-8" %>
4. <!DOCTYPE html>
5. <html>
6. <head>
7. <title>修改员工信息</title>
8. <link rel="stylesheet" href="${pageContext.request.contextPath}/css/updateEmp.css">
9. </head>
10. <body>
12. <h2>修改员工信息</h2>
13. <form action="${pageContext.request.contextPath}/employee/update" method="post">
14. <input type="text" id="id" name="id" value="${employee.id}" >
15. <label for="name">姓名:</label><br>
16. <input type="text" id="name" name="name" value="${employee.name}"><br>
17. <label for="gender">性别:</label><br>
18. <select id="gender" name="gender">
19. <option value="1" ${employee.gender?'selected':''}>男</option>
20. <option value="0" ${!employee.gender?'selected':''}>女</option>
21. </select><br>
22. <label for="salary">薪水:</label><br>
23. <input type="text" id="salary" name="salary" value="${employee.salary}"><br>
24. <label for="birthday">生日:</label><br>
25. <input type="text" id="birthday" name="birthday" value="<fmt:formatDate value='${employee.birthday}' pattern='yyyy/MM/dd'/>"/><br>
26. <input type="submit" value="提交">
27. </form>
29. </body>
30. </html>
复制代码
UpdateEmp.css
1. body {
2. font-family: Arial, sans-serif;
3. }
5. #container {
6. width: 300px;
7. margin: 0 auto;
8. padding: 20px;
9. border: 1px solid #ccc;
10. border-radius: 5px;
11. background-color: #f8f8f8;
12. }
14. h2 {
15. text-align: center;
16. color: #333;
17. }
19. label {
20. font-weight: bold;
21. color: #555;
22. }
24. input[type="text"], input[type="date"],select {
25. width: 70%;
26. padding: 10px;
27. margin: 5px 0 15px;
28. border: 1px solid #ccc;
29. border-radius: 3px;
30. }
32. input[type="submit"] {
33. width: 100%;
34. padding: 10px;
35. color: white;
36. background-color: #007BFF;
37. border: none;
38. border-radius: 3px;
39. cursor: pointer;
40. }
42. input[type="submit"]:hover {
43. background-color: #0056b3;
44. }
复制代码
Controller
1. @RequestMapping("detail")
2. public String detailEmployee(Integer id, Model model) {
3. log.debug("接收的id:{}",id);
4. Employee employee = employeeService.idByEmployee(id);
5. model.addAttribute("employee", employee);
6. return "updateEmp";
7. }
复制代码
更改员工信息
- 获取更新后的员工信息
- 更新数据库
Controller
1. @RequestMapping("update")
2. public String updateEmployee(Employee employee) {
3. log.debug("修改的员工信息：{}", employee);
4. employeeService.updateEmployee(employee);
5. return "redirect:/employee/list";
6. }
复制代码

10.12 删除员工

传递id给后端进行数据库删除
返回employee/list重新查数据库刷新

emplist.jsp
1. <a target="_blank" href="https://www.cnblogs.com/javascript:;" onclick="deleteEmployee()">删除</a>
复制代码
Controller
1. @RequestMapping("delete")
2. public String deleteEmployee(Integer id) {
3. log.debug("接收的id：{}", id);
4. employeeService.deleteEmployee(id);
5. return "redirect:/employee/list";
6. }
复制代码
mapper
1. <delete id="deleteEmployee">
2. delete from `employee`where id =#{id}
3. </delete>
复制代码

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！

欢迎光临 ToB企服应用市场:ToB评测及商务社交产业平台 (https://dis.qidao123.com/)