【SpringBoot整合MyBatisPlus】简单代码示例

测试SpringBoot整合MyBatisPlus简单程序

引入mybatisplus的依赖

<dependencies>
   <dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-jdbc</artifactId>
   </dependency>
   <dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-web</artifactId>
   </dependency>

   <dependency>
       <groupId>mysql</groupId>
       <artifactId>mysql-connector-java</artifactId>
       <scope>runtime</scope>
   </dependency>
   <dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-test</artifactId>
       <scope>test</scope>
   </dependency>
   <dependency>
       <groupId>org.projectlombok</groupId>
       <artifactId>lombok</artifactId>
       <version>RELEASE</version>
       <scope>compile</scope>
   </dependency>
   
   <dependency>
       <groupId>com.baomidou</groupId>
       <artifactId>mybatis-plus-boot-starter</artifactId>
       <version>3.2.0</version>
   </dependency>
</dependencies>

数据表结构和示例数据

对应数据表创建实体类

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.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;
import lombok.experimental.Accessors;
import java.util.Date;

@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
@Accessors(chain = true)
@TableName(value = "user")//默认将类名作为表名
public class User {
    /**
     * 参数一:对应数据库中主键的名称
     * 参数二：id自增
     */
    @TableId(value = "user_id",type = IdType.AUTO)
    private String id;

    private String name;
    private Integer age;
    //如果数据库里的名字不叫name，叫username,则使用这个标签
    @TableField(value = "borthday")
    private Date date;

    /**
     * 不映射数据库表中任何字段
     */
    @TableField(exist = false)
    private String aaa;
}

创建mybatisplus的配置类

@EnableTransactionManagement
@Configuration
@MapperScan("com.example.dao")
public class MyBatisPlusConfiguration {

    //分页拦截器对象
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        // 设置请求的页面大于最大页后操作， true调回到首页，false 继续请求  默认false
        // paginationInterceptor.setOverflow(false);
        // 设置最大单页限制数量，默认 500 条，-1 不受限制
        // paginationInterceptor.setLimit(500);
        // 开启 count 的 join 优化,只针对部分 left join
        // paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));
        return paginationInterceptor;
    }
}

使用mybatis-plus增强接口

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.bean.User;

//使用mybatis-plus增强接口
public interface UserDao extends BaseMapper<User> {

}

创建controller测试mybatisplus

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.bean.User;
import com.example.dao.UserDao;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

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

/**
 * @author hupf
 * @Title: com.example.controller
 * @Description: ${todo}
 * @date 2022/4/19 14:00
 */
@Controller
@ResponseBody
public class TestController {

    @Resource
    private UserDao userDao;

    // 测试获取数据表中的所有数据
    @RequestMapping("/selectList")
    public void selectAllController(){
        System.out.println("==========");
        List<User> users = userDao.selectList(null);
        for (User user : users) {
            System.out.println("user = " + user);
        }
    }

    // 根据主键查询一个
    @RequestMapping("/selectById")
    public void selectByIdController(){
        System.out.println("==========");
        User user = userDao.selectById("1");
        System.out.println(user);
    }

    //条件查询
    @RequestMapping("/QueryWrapperle")
    public void testFind(){
        System.out.println("==========");
        QueryWrapper<User> objectQueryWrapper = new QueryWrapper<>();
        //objectQueryWrapper.eq("age",22);//设置等值查询
        //objectQueryWrapper.lt("age",21);//设置小于查询
        objectQueryWrapper.le("age",30);//小于等于查询     gt是大于查询   ge是大于等于操作
        List<User> users = userDao.selectList(objectQueryWrapper);
        users.forEach(user-> System.out.println(user));
    }

    //模糊查询
    @RequestMapping("/testFindLike")
    public void testFindLike(){
        System.out.println("==========");
        QueryWrapper<User> objectQueryWrapper = new QueryWrapper<>();
        //like  %?%
//        objectQueryWrapper.like("name","k");

        //like %?   以k结尾的
//        objectQueryWrapper.likeLeft("name","k");

        //like ?%   以c开头的
        objectQueryWrapper.likeRight("name","T");
        List<User> users = userDao.selectList(objectQueryWrapper);
        users.forEach(user-> System.out.println(user));
    }

    //保存方法
    @RequestMapping("/testSave")
    public void testSave(){
        System.out.println("==========");
        User user = new User();
        user.setName("xxx").setDate(new Date()).setAge(23);
        userDao.insert(user);
    }

    //修改根据id
    @RequestMapping("/updateT")
    public  void updateT(){
        System.out.println("==========");
        User user = userDao.selectById("2");
        user.setName("updatee_k");
        userDao.updateById(user);
    }

    //批量修改
    @RequestMapping("/testUpdate")
    public void testUpdate(){
        System.out.println("==========");
        User user = userDao.selectById("3");
        user.setName("up_3");

        QueryWrapper<User> updateWapper = new QueryWrapper<>();
        updateWapper.eq("age",23);
        userDao.update(user,updateWapper);
    }


    //基于id删除
    @RequestMapping("/testD")
    public void testD(){
        System.out.println("==========");
        userDao.deleteById("4");
    }


    //基于条件删除
    @RequestMapping("/testDD")
    public void testDD(){
        System.out.println("==========");
        QueryWrapper<User> objectQueryWrapper = new QueryWrapper<>();
        objectQueryWrapper.gt("age",21);
        userDao.delete(objectQueryWrapper);
    }


    //分页查询
    @RequestMapping("/testFindPage")
    public void testFindPage(){
        System.out.println("==========");
        QueryWrapper<User> objectQueryWrapper = new QueryWrapper<>();
        objectQueryWrapper.gt("age",0);
        //参数1：当前页 默认值 1  参数2：每页显示记录数 默认值10
        IPage<User> page = new Page<>(1,2);
        IPage<User> userIPage = userDao.selectPage(page,objectQueryWrapper);
        long total = userIPage.getTotal();
        System.out.println("总记录数：" + total);
        userIPage.getRecords().forEach(user-> System.out.println("user = " + user));
    }
}

修改配置文件

spring.datasource.driver-class-name= com.mysql.cj.jdbc.Driver
spring.datasource.url= jdbc:mysql://localhost:3306/mybatis_test?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root

logging.level.root=info

在启动类上添加路径扫描

@MapperScan("com.example.dao")
@SpringBootApplication
public class SpringbootMybatisPlusApplication {
    public static void main(String[] args) {
        SpringApplication.run(SpringbootMybatisPlusApplication.class,args);
    }
}

在浏览器测试，上面controller中的方法都可以正常运行