springboot 实现增删改查,分页查询的mapper层,service层,serviceIpml层,controller层以及前端html和js获取后台数据的代码
时间: 2023-06-13 14:02:14 浏览: 65
以下是一个简单的示例:
1. Mapper层
```java
@Mapper
public interface UserMapper {
// 增
void addUser(User user);
// 删
void deleteUserById(Integer id);
// 改
void updateUser(User user);
// 查
User getUserById(Integer id);
// 分页查询
List<User> getUsersByPage(@Param("start") Integer start, @Param("size") Integer size);
}
```
2. Service层和ServiceImpl层
```java
public interface UserService {
// 增
void addUser(User user);
// 删
void deleteUserById(Integer id);
// 改
void updateUser(User user);
// 查
User getUserById(Integer id);
// 分页查询
List<User> getUsersByPage(Integer pageNum, Integer pageSize);
}
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public void addUser(User user) {
userMapper.addUser(user);
}
@Override
public void deleteUserById(Integer id) {
userMapper.deleteUserById(id);
}
@Override
public void updateUser(User user) {
userMapper.updateUser(user);
}
@Override
public User getUserById(Integer id) {
return userMapper.getUserById(id);
}
@Override
public List<User> getUsersByPage(Integer pageNum, Integer pageSize) {
Integer start = (pageNum - 1) * pageSize;
return userMapper.getUsersByPage(start, pageSize);
}
}
```
3. Controller层
```java
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
// 增加用户
@PostMapping("/add")
public void addUser(@RequestBody User user) {
userService.addUser(user);
}
// 删除用户
@DeleteMapping("/{id}")
public void deleteUserById(@PathVariable Integer id) {
userService.deleteUserById(id);
}
// 修改用户
@PutMapping("/update")
public void updateUser(@RequestBody User user) {
userService.updateUser(user);
}
// 根据id查询用户
@GetMapping("/{id}")
public User getUserById(@PathVariable Integer id) {
return userService.getUserById(id);
}
// 分页查询用户
@GetMapping("/page")
public List<User> getUsersByPage(@RequestParam Integer pageNum, @RequestParam Integer pageSize) {
return userService.getUsersByPage(pageNum, pageSize);
}
}
```
4. 前端HTML和JS获取后台数据
```html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>用户管理</title>
</head>
<body>
<div id="userList"></div>
</body>
<script src="https://cdn.bootcdn.net/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
<script>
$(function () {
// 分页查询
$.ajax({
url: "/user/page?pageNum=1&pageSize=10",
type: "GET",
success: function (res) {
var html = "<table><tr><th>ID</th><th>姓名</th><th>年龄</th></tr>";
for (var i = 0; i < res.length; i++) {
html += "<tr>";
html += "<td>" + res[i].id + "</td>";
html += "<td>" + res[i].name + "</td>";
html += "<td>" + res[i].age + "</td>";
html += "</tr>";
}
html += "</table>";
$("#userList").html(html);
}
});
});
</script>
</html>
```
注意:以上代码仅作为示例,实际业务中需要根据需求进行修改。