实验09 SpringBoot 用户管理实战（JPA）
【实验目的及要求】
1
. 掌握 Spring Boot 整合JPA 实现数据 CRUD（增删改查）；
2
. 掌握
MVC 分层架构（Controller→Service→Mapper）
3. 学会前后端数据交互：Thymeleaf 模板
4
. 掌握密码加密等基础安全处理
5
. 要求所有回答的文本格式：五号，宋体、1
.5倍行距，保留段单元格背景。
【实验步骤】
1、 导入jpademo项目框架，添加依赖
<dependency>
<groupId>org
.springframework
.boot</groupId>
<artifactId>spring-boot-starter-actuator</artifactId>
</dependency>
<dependency>
<groupId>org
.springframework
.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org
.springframework
.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
<groupId>org
.springframework
.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org
.springframework
.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
<optional>true</optional>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8
.0
.2
3</version> <!-- 使用最新的版本号 -->
</dependency>
<!-- Spring Boot Starter Data JPA -->
<dependency>
<groupId>org
.springframework
.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org
.springframework
.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
2、 实体类
package com
.example
.demo
.entity;
import jakarta
.persistence
.Entity;
import jakarta
.persistence
.GeneratedValue;
import jakarta
.persistence
.GenerationType;
import jakarta
.persistence
.Id;
import jakarta
.persistence
.Table;
@Entity
@Table
(name="user")
public class User {
@Id
@GeneratedValue
(strategy = GenerationType
.IDENTITY)
private Long id;
private String name;
private int age;
// 构造函数、getter和setter
public User
() {}
public User
(String name, int age) {
this
.name = name;
this
.age = age;
}
public Long getId
() {
return id;
}
public void setId
(Long id) {
this
.id = id;
}
public String getName
() {
return name;
}
public void setName
(String name) {
this
.name = name;
}
public int getAge
() {
return age;
}
public void setAge
(int age) {
this
.age = age;
}
}
3、 Repository
package com
.example
.demo
.repository;
import org
.springframework
.data
.jpa
.repository
.JpaRepository;
import java
.util
.List;
import com
.example
.demo
.entity
.User;
public interface UserRepository extends JpaRepository<User, Long> {
List<User> findByName
(String name);
}
4、 Controller
package com
.example
.demo
.controller;
import java
.util
.List;
import java
.util
.Optional;
import org
.springframework
.stereotype
.Controller;
import org
.springframework
.ui
.Model;
import org
.springframework
.web
.bind
.annotation
.GetMapping;
import org
.springframework
.web
.bind
.annotation
.ModelAttribute;
import org
.springframework
.web
.bind
.annotation
.PathVariable;
import org
.springframework
.web
.bind
.annotation
.PostMapping;
import org
.springframework
.web
.bind
.annotation
.RequestParam;
import com
.example
.demo
.entity
.User;
import com
.example
.demo
.repository
.UserRepository;
@Controller
public class UserController {
private final UserRepository userRepository;
public UserController
(UserRepository userRepository) {
this
.userRepository = userRepository;
}
@GetMapping
("/users")
public String listUsers
(Model model) {
List<User> users = userRepository
.findAll
();
model
.addAttribute
("users", users);
return "users";
}
@GetMapping
("/users/new")
public String showCreate
Form(Model model) {
model
.addAttribute
("user", new User
());
return "create_user";
}
@PostMapping
("/users")
public String createUser
(@ModelAttribute User user) {
userRepository
.save
(user);
return "redirect:/users";
}
@GetMapping
("/users/{id}/edit")
public String showEdit
Form(@PathVariable Long id, Model model) {
Optional<User> userOptional = userRepository
.findById
(id);
if
(userOptional
.isPresent
()) {
model
.addAttribute
("user", userOptional
.get
());
return "edit_user";
} else {
return "redirect:/users";
}
}
@PostMapping
("/users/{id}")
public String updateUser
(@PathVariable Long id, @ModelAttribute User user) {
user
.setId
(id);
userRepository
.save
(user);
return "redirect:/users";
}
@GetMapping
("/users/{id}/delete")
public String deleteUser
(@PathVariable Long id) {
userRepository
.deleteById
(id);
return "redirect:/users";
}
@GetMapping
("/findbyname")
public String findbyname
(@
RequestParam
(name = "nameToFind", required = false) String name, Model model) {
System
.out
.println
("received query:" + name);
List<User> users = userRepository
.findByName
(name);
model
.addAttribute
("users", users);
return "findbyname";
}
@GetMapping
("/findbyname2/{name}")
public String findbyname2
(@PathVariable String name, Model model) {
System
.out
.println
("received query2:" + name);
List<User> users = userRepository
.findByName
(name);
model
.addAttribute
("users", users);
return "findbyname";
}
}
5、 前端页面
增加用户：
<!DOCTYPE html>
<html xmlns:th="http://www
.thymeleaf
.org">
<head>
<title>Create User</title>
</head>
<body>
<h1>Create New User</h1>
<
form action="/users" method="post">
<label for="name">Name:</label>
<input type="text" id="name" name="name" required><br>
<label for="age">Age:</label>
<input type="number" id="age" name="age" required><br>
<input type="submit" value="Create User">
</
form>
</body>
</html>
编辑用户：
<!DOCTYPE html>
<html xmlns:th="http://www
.thymeleaf
.org">
<head>
<title>Edit User</title>
</head>
<body>
<h1>Edit User</h1>
<
form action="/users/{id}" th:action="@{&#
39;/users/&#
39; + ${user
.id}}" method="post">
<input type="hidden" name="id" th:value="${user
.id}">
<label for="name">Name:</label>
<input type="text" id="name" name="name" th:value="${user
.name}" required><br>
<label for="age">Age:</label>
<input type="number" id="age" name="age" th:value="${user
.age}" required><br>
<input type="submit" value="Update User">
</
form>
</body>
</html>
列出所有用户：
<!DOCTYPE html>
<html xmlns:th="http://www
.thymeleaf
.org">
<head>
<title>User List</title>
</head>
<body>
<h1>User List</h1>
<table border="1">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Age</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<tr th:each="user : ${users}">
<td th:text="${user
.id}"></td>
<td th:text="${user
.name}"></td>
<td th:text="${user
.age}"></td>
<td>
<a th:href="@{/users/{id}/edit
(id=${user
.id})}">Edit</a>
<a th:href="@{/users/{id}/delete
(id=${user
.id})}"
onclick="return confirm
(&#
39;Are you sure you want to delete this user?&#
39;)">Delete</a>
</td>
</tr>
</tbody>
</table>
<a href="/users/new">Create New User</a>
<
form action="/findbyname" method="get">
<label for="nameToFind"> Find By Name:</label>
<input type="text" id="nameToFind" name="nameToFind" required><br>
<input type="submit" value="FindByname">
</
form>
</body>
</html>
按名字查找：
<!DOCTYPE html>
<html xmlns:th="http://www
.thymeleaf
.org">
<head>
<title>findbyname list</title>
</head>
<body>
<h1>User List</h1>
<ul>
<li th:each="user:${users}">
Name:<span th:text="${user
.name}"></span>,Age:<span th:text="${user
.age}"></span>
</li>
</ul>
<
form action="/users" method="get">
<input type="submit" value="Back to List User">
</
form>
</body>
</html>
6、 SQL脚本
-- Server version 8
.0
.41
drop database if exists userdb;
create database if not exists userdb;
use userdb;
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`
(
`id` bigint NOT NULL AUTO_INCREMENT,
`age` int NOT NULL,
`name` varchar
(255) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
insert into user
(age,name) values
(21,&#
39;Bob&#
39;);
insert into user
(age,name) values
(22,&#
39;James&#
39;);
insert into user
(age,name) values
(38,&#
39;张三&#
39;);
insert into user
(age,name) values
(45,&#
39;李四&#
39;);
insert into user
(age,name) values
(29,&#
39;Eileen&#
39;);
7、 测试结果截图输出
（1）列出用户清单，截图：
（2）修改用户信息，截图：
（
3）删除用户，截图：
（4）扩展功能：为用户表添加 “性别、邮箱、手机号，角色” 字段，实现新增和编辑功能，采用Lombok自动添加getter和setter方法：
修改的代码：
运行截图：
本文讨论了在MVC3提交过程中遇到的潜在危险输入问题，包括从客户端接收包含HTML标签的数据时引发的安全警告。文章提供了通过修改HTTP运行时配置和禁用请求验证来解决这一问题的方法，并强调了在应用输入验证的重要性。
扫一扫
174
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
