实验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
.23</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 showCreateForm(
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 showEditForm(@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="@{'/users/' + ${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('Are you sure you want to delete this user?')">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,'Bob');
insert into user(age,name) values(22,'James');
insert into user(age,name) values(38,'张三');
insert into user(age,name) values(45,'李四');
insert into user(age,name) values(29,'Eileen');
7、 测试结果截图输出
（1）列出用户清单，截图：
（2）修改用户信息，截图：
（3）删除用户，截图：
（4）扩展功能：为用户表添加 “性别、邮箱、手机号，角色” 字段，实现新增和编辑功能，采用Lombok自动添加getter和setter方法：
修改的代码：
运行截图：
本文介绍了一个使用@RequestMapping注解处理GET请求的方法，该方法通过路径参数获取角色ID，并调用service层方法获取角色信息，最终返回角色编辑页面。
扫一扫
1345
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
