Springboot框架+Mybatis-Plus+Wrapper条件构造器实现数据的查询功能

一、前期准备

数据库的连接
application.yml的配置：端口、数据库名称、用户、密码根据实际情况修改。

server:
port: 8080

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/xqyj?characterEncoding=utf8&serverTimezone=UTC
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver

pom.xml的引用

       <!--转换成json字符串的工具-->
        <dependency>
            <groupId>com.google.code.gson</groupId>
            <artifactId>gson</artifactId>
            <version>2.8.2</version>
        </dependency>
        <!--springboot集成web操作-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
      
        <!--mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!--lombok依赖-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <!--mybatis-plus依赖-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.1</version>
        </dependency>
       

接口测试工具：ApiPost

二、参数查询

创建实体类entity

package com.org.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 lombok.Data;

import java.util.List;


@Data
@TableName("gkxs")   //对应数据库中的表名、列出所有字段
public class Gkxs {
    @TableId(value = "ID", type = IdType.AUTO)
    private Long id;

    private String xm;

    private Integer xh;

    private String nj;

    private String ssxy;

    private String zymc;

    private String bjmc;

    private String xqjc;

    private String xf;

    private String kcdm;

    private String kcmc;

    private String kcjsgh;

    private String zzcj;

    private  String bkcxbs;

    @TableField(exist = false)
    private List<Teacher> Teachers;


//    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
//    private Date date;
}

创建数据持久层mapper

package com.org.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.org.entity.Gkxs;

public interface GradeMapper extends BaseMapper<Gkxs>{

}

创建接口层controlle

package com.org.controller;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.org.entity.Gkxs;
import com.org.mapper.CollegeMapper;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.util.List;

@RestController
@RequestMapping("/grade")
public class GradeController {
    @Resource
    private CollegeMapper collegeMapper;

    @GetMapping(value = "/all")
    public List gkxs() {
        // 查询数据库 gkxs表的所有数据
        return collegeMapper.selectList(Wrappers.lambdaQuery());
    }


    @GetMapping()
    public List selectList(String njType) {
        //根据某年级查询并列举所有数据
        QueryWrapper<Gkxs> wrapper = new QueryWrapper<>();
        wrapper.eq("nj",njType);
        List<Gkxs> list = collegeMapper.selectList(wrapper);
        return list;
    }

    @GetMapping(value = "/count")
    public Object selectCount(String njType) {
        //查询某年级的总人数
        QueryWrapper<Gkxs> wrapper = new QueryWrapper<>();
        wrapper.eq("nj",njType);
        Integer count = collegeMapper.selectCount(wrapper);
        return  count;
    }

}

接口测试：

 

 

以上是一个很简单的条件查询，有任何错误的地方，欢迎一起讨论学习。