学做毕设 2022 第九讲 mybatisplus

<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <optional>true</optional>
</dependency>
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.5.1</version>
</dependency>

@Configuration
@MapperScan("com.yinming.sprintboot.mapper")
public class MybatisPlusConfig {
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }
}

Cause: java.sql.SQLSyntaxErrorException: Table 'yinming.user' doesn't exist

@Data
@TableName("sys_user")
public class User {
    @TableId(value = "id")
    private Integer id;
    private String username;
    @JsonIgnore
    private String password;
    private String nickname;
    private String email;
    private String phone;
    private String address;
}

<!--swagger-->
<dependency>
    <groupId>io.springfox</groupId>
    <artifactId>springfox-boot-starter</artifactId>
    <version>3.0.0</version>
</dependency>

http://localhost:9090/swagger-ui/index.html

package com.yinming.sprintboot.config;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import springfox.documentation.builders.ApiInfoBuilder;
import springfox.documentation.builders.PathSelectors;
import springfox.documentation.builders.RequestHandlerSelectors;
import springfox.documentation.oas.annotations.EnableOpenApi;
import springfox.documentation.service.ApiInfo;
import springfox.documentation.service.Contact;
import springfox.documentation.spi.DocumentationType;
import springfox.documentation.spring.web.plugins.Docket;



@Configuration
@EnableOpenApi
public class SwaggerConfig {
    /**
     * 创建API应用
     * apiInfo() 增加API相关信息
     * 通过select()函数返回一个ApiSelectorBuilder实例,用来控制哪些接口暴露给Swagger来展现，
     * 本例采用指定扫描的包路径来定义指定要建立API的目录。
     *
     * @return
     */
    @Bean
    public Docket restApi() {
        return new Docket(DocumentationType.SWAGGER_2)
                .groupName("标准接口")
                .apiInfo(apiInfo("Spring Boot中使用Swagger2构建RESTful APIs", "1.0"))
                .useDefaultResponseMessages(true)
                .forCodeGeneration(false)
                .select()
                .apis(RequestHandlerSelectors.basePackage("com.yinming.sprintboot.controller"))
                .paths(PathSelectors.any())
                .build();
    }

    /**
     * 创建该API的基本信息（这些基本信息会展现在文档页面中）
     * 访问地址：http://ip:port/swagger-ui.html
     *
     * @return
     */
    private ApiInfo apiInfo(String title, String version) {
        return new ApiInfoBuilder()
                .title(title)
                .description("更多请关注: https://blog.youkuaiyun.com/xqnode")
                .termsOfServiceUrl("https://blog.youkuaiyun.com/xqnode")
                .contact(new Contact("xqnode", "https://blog.youkuaiyun.com/xqnode", "xiaqingweb@163.com"))
                .version(version)
                .build();
    }

}

@RestController
@RequestMapping("/user")
public class UserController {

    @Autowired
    private UserService userService;

    @GetMapping
    public List<User> findAll()
    {
        List<User> all=userService.list();
        return all;
    }

    @PostMapping
    //@RequestBody User 将前台的jason对象转为java对象
    public boolean save(@RequestBody User user)
    {

        //新增或者更新都在这个里面
        return userService.saveUser(user);
    }
    @DeleteMapping("/{id}")
    public boolean delete(@PathVariable Integer id)
    {
        //新增或者更新都在这个里面
        return userService.removeById(id);
    }

    //分页查询
    //接口路径，user/page
    //@RequestParam接收  ？pageNum=1 & pagesize=10
    //limit=(pageNum-1)*pageSize
//    @GetMapping("/page")
//    public Map<String,Object> findPage(@RequestParam Integer pageNum,
//                                       @RequestParam Integer pageSize,
//                                       @RequestParam String username)
//    {
//        pageNum=(pageNum-1)*pageSize;
//        username="%"+username+"%";
//        Integer total=userMapper.selectTotal(username);
//        List<User> data=userMapper.selectPage(pageNum,pageSize,username);
//        Map<String,Object> res=new HashMap<>();
//        res.put("data",data);
//        res.put("total",total);
//        return  res;
//    }

    // 分页查询，mybatisPlus的方式
    @GetMapping("/page")
    public IPage<User> findPage(@RequestParam Integer pageNum,
                                       @RequestParam Integer pageSize,
                                       @RequestParam(defaultValue = "") String username)
    {
        IPage<User> page=new Page<>(pageNum, pageSize);
        QueryWrapper<User> queryWrapper=new QueryWrapper<>();
        queryWrapper.like("username",username);
        IPage<User> userPage=userService.page(page,queryWrapper);
        return userPage;


    }