我使用 MySQL 创建了一个用户表TbUser,并且使用@GetMapping("/deleteListUsers") public String deleteListUsers(@RequestParam(defaultValue = "1") int pageNum, Model model) { Page<TbUser> page = tbUserService.findUsers(pageNum); List<TbUser> userList = page.getContent(); model.addAttribute("userList", userList); model.addAttribute("currentPage", pageNum); model.addAttribute("totalPages", page.getTotalPages()); return "management/user-delete"; }完成了用户分页查询功能,查询的结果返回了user-delete.html,请帮使用springboot+hibernate+thymeleaf帮助我完删除单个用户的功能,包含DAO、Controller、Entity、Service
时间: 2024-01-25 08:04:54 浏览: 24
好的,我可以帮你完成这个任务。首先,我们需要先定义一个用户实体类`TbUser`,它应该包含用户的基本信息,如下所示:
```java
@Entity
@Table(name = "tb_user")
public class TbUser {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
private String username;
private String password;
private String email;
// getter and setter methods
}
```
接下来,我们需要定义一个`TbUserService`的接口和实现类`TbUserServiceImpl`,用于实现用户的相关操作,如下所示:
```java
public interface TbUserService {
Page<TbUser> findUsers(int pageNum);
TbUser findUserById(Long id);
void deleteUserById(Long id);
}
@Service
public class TbUserServiceImpl implements TbUserService {
@Autowired
TbUserDao tbUserDao;
@Override
public Page<TbUser> findUsers(int pageNum) {
Pageable pageable = PageRequest.of(pageNum - 1, 10, Sort.by("id").ascending());
return tbUserDao.findAll(pageable);
}
@Override
public TbUser findUserById(Long id) {
return tbUserDao.findById(id).orElse(null);
}
@Override
public void deleteUserById(Long id) {
tbUserDao.deleteById(id);
}
}
```
然后,我们需要定义一个`TbUserDao`接口,它继承了`JpaRepository`,用于实现对用户表的基本操作,如下所示:
```java
public interface TbUserDao extends JpaRepository<TbUser, Long> {
}
```
接下来,我们需要定义一个`TbUserController`类,用于处理与用户相关的请求,如下所示:
```java
@Controller
@RequestMapping("/user")
public class TbUserController {
@Autowired
TbUserService tbUserService;
@GetMapping("/deleteListUsers")
public String deleteListUsers(@RequestParam(defaultValue = "1") int pageNum, Model model) {
Page<TbUser> page = tbUserService.findUsers(pageNum);
List<TbUser> userList = page.getContent();
model.addAttribute("userList", userList);
model.addAttribute("currentPage", pageNum);
model.addAttribute("totalPages", page.getTotalPages());
return "management/user-delete";
}
@GetMapping("/deleteUser/{id}")
public String deleteUser(@PathVariable Long id) {
tbUserService.deleteUserById(id);
return "redirect:/user/deleteListUsers";
}
}
```
最后,在`user-delete.html`文件中,我们需要添加一个删除用户的链接,如下所示:
```html
<a th:href="@{/user/deleteUser/{id}(id=${user.id})}" onclick="return confirm('确定要删除吗?')">删除</a>
```
这样,当用户点击删除链接时,会调用`TbUserController`中的`deleteUser`方法,删除指定用户,并重定向到`deleteListUsers`方法,刷新用户列表。