后端环境搭建好后,实现管理系统的增删改查
@RestController
@RequestMapping("/user")
public class UserController {
//@RequestBody:把前台传过来的json,转换为对象
@Resource
UserMapper userMapper;
@PostMapping
public Result<?> save(@RequestBody User user){
if (user.getPassword()==null){
user.setPassword("123456");
}
userMapper.insert(user);
return Result.success();
}
}
1.更新pom.xml,引入hutool依赖 Hutool — 🍬A set of tools that keep Java sweet.
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-all</artifactId>
<version>5.8.5</version>
</dependency>
2.更新application.propeties
按照自己的数据库用户名和密码更改
server.port=9090
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/springboot-vue?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false&serverTimezone=GMT%2b8
spring.datasource.username=root
spring.datasource.password=123456
3.新建User.java
package com.example.demo.entity;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.math.BigDecimal;
import java.util.Date;
import java.util.List;
import java.util.Set;
@TableName("user")
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class User {
@TableId(type = IdType.AUTO) /*自增*/
private Integer id;
private String name;
private String type;
private String tel;
private String fax;
private Date date;
}
4.更新HomeView内methods,以查询功能为例
methods:{
load(){
request.get("/user", {
params:{
pageNum: this.currentPage,
pageSize: this.pageSize,
search: this.search
}
}
5.更新UserController.java,将pageNum pageSize search设置默认值,否则报错
@GetMapping /*查询*/
public Result<?> findPage(@RequestParam(defaultValue = "1") Integer pageNum,
@RequestParam(defaultValue = "10") Integer pageSize,
@RequestParam(defaultValue = "") String search) {
LambdaQueryWrapper<User> wrapper = Wrappers.<User>lambdaQuery();
if (StringUtils.isNotBlank(search)){
wrapper.like(User::getName,search);
}
/*分页模糊查询*/
Page<User> userPage = userMapper.selectPage(new Page<>(pageNum,pageSize), wrapper);
return Result.success(userPage);
模糊查询like()
Mybatis-Plus eq、ne、gt、lt、ge、le分别代表含义
eq 就是 equal等于
ne就是 not equal不等于
gt 就是 greater than大于
lt 就是 less than小于
ge 就是 greater than or equal 大于等于
le 就是 less than or equal 小于等于
in 就是 in 包含(数组)
isNull 就是 等于null
between 就是 在2个条件之间(包括边界值)
like就是 模糊查询
可以在浏览器直接测试(推荐装上JSON-handle插件方便查看json数据)