复习mybatispuls

最新推荐文章于 2023-03-17 11:16:00 发布

程序员小小刘

最新推荐文章于 2023-03-17 11:16:00 发布

阅读量365

点赞数

分类专栏： mq 文章标签： mybatis

本文链接：https://blog.csdn.net/weixin_55604133/article/details/117234860

版权

mq 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

mybatispuls

mybatispuls的官网
正如官网所说的润物无声、效率至上、丰富功能非常好用
如以下案例：
1.建项目，选择mysqldriver+web+lombok
2.添加mybatisplus的starter依赖

 <dependency>
   <groupId>com.baomidou</groupId>
   <artifactId>mybatis-plus-boot-starter</artifactId>
   <version>3.4.2</version>
</dependency>

3.修改配置

@MapperScan("com.woniuxy.boot.mybatisplusdemo.dao")

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/rocket
    driver-class-name: com.mysql.jdbc.Driver
    username: root
    password: root123
mybatis-plus:
  mapper-locations: classpath:mappers/**/*.xml
  configuration:
    map-underscore-to-camel-case: true
 >   log-impl: org.apache.ibatis.logging.slf4j.Slf4jImpl
 > type-aliases-package: com.woniuxy.boot.mybatisplusdemo.model
 logging:
  level:
    com.woniuxy: debug

4.修改model，添加注解 @TableName @TableId


@TableName("rkt_course")
public class Course {
    @TableId(type = IdType.AUTO)
    private int courseId;
    private String courseName;

5.修改mapper，继承BaseMapper

public interface CourseMapper extends BaseMapper<Course> {


}

6.测试代码

package com.woniuxy.boot.mybatisplusdemo.controller;

import com.woniuxy.boot.mybatisplusdemo.dao.CourseMapper;
import com.woniuxy.boot.mybatisplusdemo.model.Course;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@Slf4j
public class CourseController {


    @Autowired
    private CourseMapper courseMapper;

    @GetMapping("findCourseById")
    public Course find(int id){
        log.info("查询课程，{}",id);
        Course course = courseMapper.selectById(id);
        log.info("{}",course);
        return course;
    }
}

接下介绍下mybatispuls的CRUD

package com.woniuxy.boot.mybatisplusdemo.controller;

import java.util.Date;
import java.util.List;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.woniuxy.boot.mybatisplusdemo.dao.CourseMapper;
import com.woniuxy.boot.mybatisplusdemo.model.Course;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

@RestController
@Slf4j
public class CourseController {


    @Autowired
    private CourseMapper courseMapper;

    @GetMapping("findCourseById")
    public Course find(int id) {
        log.info("查询课程，{}", id);
        Course course = courseMapper.selectById(id);
        log.info("{}", course);
        return course;
    }

    @PostMapping("addCourse")
    public void addCourse(String courseName, int teacherId) {

        Course course = new Course();
        course.setCourseName(courseName);
        course.setCategory("asdfa");
        course.setPrice(10.0D);
        course.setSvipPrice(10.0D);
        course.setVideoType("asd");
        course.setChargeType("asdfa");
        course.setPurchaseCount(0);
        course.setStudyCount(0);
        course.setDescription("asdfasdfadsfadsfa");
        course.setImage("asdfasdf");
        course.setTeacherId(teacherId);
        course.setTeacherName("asdf");
        course.setTeacherDesc("asdfasdfadsfa");
        course.setTeacherAvatar("asdfasdfadsfadsf");

        courseMapper.insert(course);

    }

    @PutMapping("/updateCourse")
    public void modify(String courseName, int courseId) {
        //全量更新
        Course course = courseMapper.selectById(courseId);
        course.setCourseName(courseName);
//        courseMapper.updateById(course);

        UpdateWrapper updateWrapper = new UpdateWrapper<>();
        updateWrapper.eq("course_id",courseId);
        courseMapper.update(course,updateWrapper);

    }

    @DeleteMapping("deleteCourse")
    public void delete(int courseId) {

        courseMapper.deleteById(courseId);
    }

    @GetMapping("search")
    public List<Course> search(String courseName, String category) {
        //
        QueryWrapper<Course> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("category", category)
                .like("course_name", courseName)
                .orderByDesc("price") //排序
                .select("course_name", "price", "category");
        //gt 大于  lt 小于  ge 大于等于 le小于等于 ne不等于 between 在..之间


        //SELECT course_name,price,category FROM rkt_course WHERE (category = ? AND course_name LIKE ?) ORDER BY price DESC
        List<Course> courses = courseMapper.selectList(queryWrapper);

        return courses;
    }

    @PutMapping("update")
    public void update(String courseName,int teacherId){
//        Course course = new Course();
//        course.setCategory("abc");
        UpdateWrapper<Course> updateWrapper = new UpdateWrapper<>();
       //set部分
        updateWrapper.set("course_name",courseName);
        updateWrapper.set("category","abc");
        //where部分，负责构造条件
        updateWrapper.eq("teacher_id",teacherId);
        updateWrapper.like("description","haha");
        courseMapper.update(null,updateWrapper);

        //UPDATE rkt_course SET course_name=?,category=? WHERE (teacher_id = ? AND description LIKE ?)

        //更新所有字段  传实体类，updateWrapper只是负责条件
        //更新部分字段  不传实体类，updateWrapper负责条件以及set部分

        //全量更新
//        Course course = courseMapper.selectById(courseId);
//        course.setCourseName(courseName);
//        UpdateWrapper updateWrapper = new UpdateWrapper<>();
//        updateWrapper.eq("course_id",courseId);
//        courseMapper.update(course,updateWrapper);
    }


}

分页：

1.配置启动分页

package com.woniuxy.boot.mybatisplusdemo.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.autoconfigure.ConfigurationCustomizer;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
@MapperScan("com.woniuxy.boot.mybatisplusdemo.dao")
public class MybatisPlusConfig {

    /**
     * 新的分页插件,一缓和二缓遵循mybatis的规则,需要设置 MybatisConfiguration#useDeprecatedExecutor = false 避免缓存出现问题(该属性会在旧插件移除后一同移除)
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }

    @Bean
    public ConfigurationCustomizer configurationCustomizer() {
        return configuration -> configuration.setUseDeprecatedExecutor(false);
    }

}

输出的结果：

2021-03-23 17:04:05.948 DEBUG 11448 --- [nio-8080-exec-3] c.w.b.m.d.C.selectPage_mpCount           : ==>  Preparing: SELECT COUNT(*) FROM rkt_course WHERE (course_name LIKE ?)
2021-03-23 17:04:05.949 DEBUG 11448 --- [nio-8080-exec-3] c.w.b.m.d.C.selectPage_mpCount           : ==> Parameters: %Java%(String)
2021-03-23 17:04:05.952 DEBUG 11448 --- [nio-8080-exec-3] c.w.b.m.d.C.selectPage_mpCount           : <==      Total: 1
2021-03-23 17:04:05.953 DEBUG 11448 --- [nio-8080-exec-3] c.w.b.m.dao.CourseMapper.selectPage      : ==>  Preparing: SELECT course_id,course_name,category,price,svip_price,video_type,charge_type,purchase_count,study_count,description,image,teacher_id,teacher_name,teacher_desc,teacher_avatar,raw_add_time,raw_update_time FROM rkt_course WHERE (course_name LIKE ?) LIMIT ?
2021-03-23 17:04:05.954 DEBUG 11448 --- [nio-8080-exec-3] c.w.b.m.dao.CourseMapper.selectPage      : ==> Parameters: %Java%(String), 10(Long)
2021-03-23 17:04:05.959 DEBUG 11448 --- [nio-8080-exec-3] c.w.b.m.dao.CourseMapper.selectPage      : <==      Total: 7

代码生成器

前言：为了使用代码生成器，
1）降低mybatis-plus版本为3.2.0
2）修改分页插件的配置

package com.woniuxy.boot.mybatisplusdemo.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.autoconfigure.ConfigurationCustomizer;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.pagination.optimize.JsqlParserCountOptimize;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
@MapperScan("com.woniuxy.boot.mybatisplusdemo.dao")
public class MybatisPlusConfig {

    // 旧版
    @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;
    }

}

3）修改代码分页返回值从Page改为IPage
1.加依赖

  <!--   mybatis-plus代码生成器     -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>3.2.0</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.apache.velocity</groupId>
            <artifactId>velocity-engine-core</artifactId>
            <version>2.1</version>
            <scope>test</scope>
        </dependency>

2.拷贝代码生成器

package com.woniuxy.boot.mybatisplusdemo;

import com.baomidou.mybatisplus.core.exceptions.MybatisPlusException;
import com.baomidou.mybatisplus.core.toolkit.StringPool;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.InjectionConfig;
import com.baomidou.mybatisplus.generator.config.*;
import com.baomidou.mybatisplus.generator.config.po.TableInfo;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
import com.baomidou.mybatisplus.generator.engine.VelocityTemplateEngine;
import org.junit.jupiter.api.Test;

import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

public class MybatisPlusGenerator {




    /**
     * <p>
     * 读取控制台内容
     * </p>
     */
    public static String scanner(String tip) {
        Scanner scanner = new Scanner(System.in);
        StringBuilder help = new StringBuilder();
        help.append("请输入" + tip + "：");
        System.out.println(help.toString());
        if (scanner.hasNext()) {
            String ipt = scanner.next();
            if (StringUtils.isNotEmpty(ipt)) {
                return ipt;
            }
        }
        throw new MybatisPlusException("请输入正确的" + tip + "！");
    }

    public static void main(String[] args) {
        // 代码生成器
        AutoGenerator mpg = new AutoGenerator();

        // 全局配置
        GlobalConfig gc = new GlobalConfig();
        String projectPath = System.getProperty("user.dir");
        gc.setOutputDir(projectPath + "/src/main/java");
        gc.setAuthor("Lucas");
        gc.setOpen(false);
        // gc.setSwagger2(true); 实体属性 Swagger2 注解
        mpg.setGlobalConfig(gc);

        // 数据源配置
        DataSourceConfig dsc = new DataSourceConfig();
        //①数据源
        dsc.setUrl("jdbc:mysql://localhost:3306/rocket?useUnicode=true&useSSL=false&characterEncoding=utf8");
        // dsc.setSchemaName("public");
        dsc.setDriverName("com.mysql.jdbc.Driver");
        dsc.setUsername("root");
        dsc.setPassword("root123");
        mpg.setDataSource(dsc);

        // 包配置
        PackageConfig pc = new PackageConfig();
        //② 包，留意parent设置为上一级，moduleName最后一级
        pc.setParent("com.woniuxy.boot");
        pc.setModuleName("mybatisplusdemo");
        pc.setController("controller");
        pc.setService("service");
        pc.setServiceImpl("service.impl");
        pc.setMapper("dao");
        pc.setXml("mappers");
        pc.setEntity("model");

        mpg.setPackageInfo(pc);

        // 自定义配置
        InjectionConfig cfg = new InjectionConfig() {
            @Override
            public void initMap() {
                // to do nothing
            }
        };

        // 如果模板引擎是 freemarker
//        String templatePath = "/templates/mapper.xml.ftl";
        // 如果模板引擎是 velocity
        String templatePath = "/templates/mapper.xml.vm";

        // 自定义输出配置
        List<FileOutConfig> focList = new ArrayList<>();
        // 自定义配置会被优先输出
        focList.add(new FileOutConfig(templatePath) {
            @Override
            public String outputFile(TableInfo tableInfo) {
                // 自定义输出文件名 ， 如果你 Entity 设置了前后缀、此处注意 xml 的名称会跟着发生变化！！
                return projectPath + "/src/main/resources/mappers" +
                         "/" + tableInfo.getEntityName() + "Mapper" + StringPool.DOT_XML;
            }
        });
        /*
        cfg.setFileCreate(new IFileCreate() {
            @Override
            public boolean isCreate(ConfigBuilder configBuilder, FileType fileType, String filePath) {
                // 判断自定义文件夹是否需要创建
                checkDir("调用默认方法创建的目录");
                return false;
            }
        });
        */
        cfg.setFileOutConfigList(focList);
        mpg.setCfg(cfg);

        // 配置模板
        TemplateConfig templateConfig = new TemplateConfig();

        // 配置自定义输出模板
        //指定自定义模板路径，注意不要带上.ftl/.vm, 会根据使用的模板引擎自动识别
//         templateConfig.setEntity("templates/entity2.java");
//         templateConfig.setService();
//         templateConfig.setController();

        templateConfig.setXml(null);
        mpg.setTemplate(templateConfig);

        // 策略配置
        StrategyConfig strategy = new StrategyConfig();
        strategy.setNaming(NamingStrategy.underline_to_camel);
        strategy.setColumnNaming(NamingStrategy.underline_to_camel);
//        strategy.setSuperEntityClass("com.baomidou.ant.common.BaseEntity");
        strategy.setEntityLombokModel(true);
        strategy.setRestControllerStyle(true);
        // 公共父类
//        strategy.setSuperControllerClass("com.baomidou.ant.common.BaseController");
        // 写于父类中的公共字段
//        strategy.setSuperEntityColumns("id");
        strategy.setInclude(scanner("表名，多个英文逗号分割").split(","));
        strategy.setControllerMappingHyphenStyle(true);
        //③ 表前缀
        strategy.setTablePrefix("rkt");
        mpg.setStrategy(strategy);
        mpg.setTemplateEngine(new VelocityTemplateEngine());
        mpg.execute();
    }

}

修改配置 ①数据源 ② 包，留意parent设置为上一级，moduleName最后一级 ③ 表前缀
运行

总结：复习mybatispuls的CRUD以及代码生成器分页

程序员小小刘

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
打赏
0
评论
复习mybatispuls

mybatispulsmybatispuls的官网如以下案例：1.建项目，选择mysqldriver+web+lombok2.添加mybatisplus的starter依赖 <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.4.2</vers
复制链接

扫一扫