springboot教程（三） - 集成mybatis-plus

最新推荐文章于 2024-08-23 19:00:48 发布

胡汉三吃肉

最新推荐文章于 2024-08-23 19:00:48 发布

阅读量192

点赞数

分类专栏： spring-boot java 文章标签： mybatis java

本文链接：https://blog.csdn.net/ichpeng/article/details/114920366

版权

java 同时被 2 个专栏收录

5 篇文章 0 订阅

订阅专栏

spring-boot

4 篇文章 0 订阅

订阅专栏

数据库准备

新建teacher表，由于classes为数组类型，mysql不支持数组，需要建关联表，因此将classes修改为字符串类型方便测试。
修改实体类：

package ichpeng.springboot.demo.bean;

import com.baomidou.mybatisplus.annotations.TableId;
import lombok.Data;

/**
 * @author: ichpeng@qq.com
 * @date: 2021/3/16 16:58
 * @description:
 */
@Data
public class Teacher {
    @TableId("teacher_id")
    String teacherId;
    String name;
    String subject;
    String classes;
}

建表：

CREATE TABLE `test`.`teacher`  (
  `teacher_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `subject` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `classes` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`teacher_id`) USING BTREE
)

修改pom.xml，引入相关依赖

		<!--mysql依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!--mybatis-plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>2.3</version>
        </dependency>
        <!--druid连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>

application.yml新增相关配置（spring.datasource）

spring:
  application:
    name: spring-boot-demo
    version: 1.0.0
  datasource:
    druid:
      username: root
      password: 111111
      url: jdbc:mysql://127.0.0.1:3306/test?serverTimezone=GMT%2B8&characterEncoding=utf8&useSSL=false&useUnicode=true
      driver-class-name: com.mysql.cj.jdbc.Driver
      initial-size: 5
      min-idle: 5
      max-active: 20
      max-wait: 60000
      min-evictable-idle-time-millis: 300000
      validation-query: SELECT 1 FROM DUAL
      test-while-idle: true
      test-on-borrow: false
      test-on-return: false
      pool-prepared-statements: true
      max-pool-prepared-statement-per-connection-size: 20
      filters: stat,wall,log4j
      filter:
        stat:
          merge-sql: true
          slow-sql-millis: 5000
      time-between-eviction-runs-millis: 5000
    main:
      allow-bean-definition-overriding: true #当遇到同样名字的时候，是否允许覆盖注册
mybatis-plus:
  configuration:
    # 是否开启自动驼峰命名规则（camel case）映射，即从经典数据库列名 A_COLUMN（下划线命名） 到经典 Java 属性名 aColumn（驼峰命名） 的类似映射
    map-underscore-to-camel-case: true

注意MySQL8的驱动类以及jdbc与之前版本有出入。

新建mapper及xml映射文件

TeacherMapper.java

package ichpeng.springboot.demo.mapper;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import ichpeng.springboot.demo.bean.Teacher;
import org.apache.ibatis.annotations.Mapper;

/**
 * @author: ichpeng@qq.com
 * @date: 2021/3/17 10:35
 * @description:
 */
@Mapper
public interface TeacherMapper extends BaseMapper<Teacher> {
}

TeacherMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="ichpeng.springboot.demo.mapper.TeacherMapper">

    <!-- 开启二级缓存 -->
    <cache type="org.mybatis.caches.ehcache.LoggingEhcache"/>

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="ichpeng.springboot.demo.bean.Teacher">
        <id column="teacher_id" property="teacher_id" />
        <result column="teacher_id" property="teacher_id" />
        <result column="name" property="name" />
        <result column="subject" property="subject" />
        <result column="classes" property="classes" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        teacher_id, name, subject, classes
    </sql>

</mapper>

service及controller

service接口需要继承com.baomidou.mybatisplus.service.IService

package ichpeng.springboot.demo.service;

import com.baomidou.mybatisplus.service.IService;
import ichpeng.springboot.demo.bean.Teacher;

/**
 * @author: ichpeng@qq.com
 * @date: 2021/3/17 10:42
 * @description:
 */
public interface ITeacherService extends IService<Teacher> {
}

service实现类需要继承com.baomidou.mybatisplus.service.impl.ServiceImpl

package ichpeng.springboot.demo.controller;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import ichpeng.springboot.demo.bean.ResultDTO;
import ichpeng.springboot.demo.bean.Teacher;
import ichpeng.springboot.demo.service.ITeacherService;
import ichpeng.springboot.demo.utils.QueryWrapperUtils;
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.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * @author: ichpeng@qq.com
 * @date: 2021/3/16 17:02
 * @description:
 */
@Slf4j
@RestController
@RequestMapping("/teacher")
public class TeacherController {

    @Autowired
    ITeacherService teacherService;

    @PostMapping("/add")
    public Object add(Teacher teacher){
        ResultDTO resultDTO = new ResultDTO();
        try {
            teacherService.save(teacher);
            resultDTO.setStatus(ResultDTO.STATUS_SUCCESS);
            resultDTO.setMessage(ResultDTO.MSG_SUCCESS);
            resultDTO.setResult(teacher);
        } catch (Exception e){
            resultDTO.setStatus(ResultDTO.STATUS_FAILED);
            resultDTO.setMessage(ResultDTO.MSG_FAILED);
            resultDTO.setResult(e);
            log.error("insert teacher error: ", e);
        }
        return resultDTO;
    }

    @GetMapping("/getById")
    public Object getById(String id){
        ResultDTO resultDTO = new ResultDTO();
        try {
            Teacher teacher = teacherService.getById(id);
            resultDTO.setStatus(ResultDTO.STATUS_SUCCESS);
            resultDTO.setMessage(ResultDTO.MSG_SUCCESS);
            resultDTO.setResult(teacher);
        } catch (Exception e){
            resultDTO.setStatus(ResultDTO.STATUS_FAILED);
            resultDTO.setMessage(ResultDTO.MSG_FAILED);
            resultDTO.setResult(e);
            log.error("select teacher error: ", e);
        }
        return resultDTO;
    }
    @GetMapping("/list")
    public Object list(Teacher teacher){
        ResultDTO resultDTO = new ResultDTO();
        try {
            Wrapper<Teacher> wrapper = QueryWrapperUtils.getQueryWrapper(teacher, Teacher.class);
            List<Teacher> teachers = teacherService.list(wrapper);
            resultDTO.setStatus(ResultDTO.STATUS_SUCCESS);
            resultDTO.setMessage(ResultDTO.MSG_SUCCESS);
            resultDTO.setResult(teachers);
        } catch (Exception e){
            resultDTO.setStatus(ResultDTO.STATUS_FAILED);
            resultDTO.setMessage(ResultDTO.MSG_FAILED);
            resultDTO.setResult(e);
            log.error("select teacher error: ", e);
        }
        return resultDTO;
    }

    @GetMapping("/removeById")
    public Object removeById(String id){
        ResultDTO resultDTO = new ResultDTO();
        try {
            teacherService.removeById(id);
            resultDTO.setStatus(ResultDTO.STATUS_SUCCESS);
            resultDTO.setMessage(ResultDTO.MSG_SUCCESS);
        } catch (Exception e){
            resultDTO.setStatus(ResultDTO.STATUS_FAILED);
            resultDTO.setMessage(ResultDTO.MSG_FAILED);
            resultDTO.setResult(e);
            log.error("delete teacher error: ", e);
        }
        return resultDTO;
    }
    @GetMapping("/remove")
    public Object remove(Teacher teacher){
        ResultDTO resultDTO = new ResultDTO();
        try {
            Wrapper<Teacher> wrapper = QueryWrapperUtils.getQueryWrapper(teacher, Teacher.class);
            teacherService.remove(wrapper);
            resultDTO.setStatus(ResultDTO.STATUS_SUCCESS);
            resultDTO.setMessage(ResultDTO.MSG_SUCCESS);
        } catch (Exception e){
            resultDTO.setStatus(ResultDTO.STATUS_FAILED);
            resultDTO.setMessage(ResultDTO.MSG_FAILED);
            resultDTO.setResult(e);
            log.error("delete teacher error: ", e);
        }
        return resultDTO;
    }

    @PostMapping("/updateById")
    public Object updateById(Teacher teacher){
        ResultDTO resultDTO = new ResultDTO();
        try {
            teacherService.updateById(teacher);
            resultDTO.setStatus(ResultDTO.STATUS_SUCCESS);
            resultDTO.setMessage(ResultDTO.MSG_SUCCESS);
        } catch (Exception e){
            resultDTO.setStatus(ResultDTO.STATUS_FAILED);
            resultDTO.setMessage(ResultDTO.MSG_FAILED);
            resultDTO.setResult(e);
            log.error("updateById teacher error: ", e);
        }
        return resultDTO;
    }
}

add
在这里插入图片描述
getById

list

removeById

remove

updateById

用到的一些工具类

package ichpeng.springboot.demo.utils;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import lombok.extern.slf4j.Slf4j;
import org.springframework.util.ReflectionUtils;

import java.beans.PropertyDescriptor;
import java.lang.reflect.Field;
import java.lang.reflect.Method;

/**
 * @author: ichpeng@qq.com
 * @date: 2021/3/17 14:04
 * @description:
 */
@Slf4j
public class QueryWrapperUtils {
    public static <T> QueryWrapper<T> getQueryWrapper(T t, Class clazz) {
        QueryWrapper<T> queryWrapper = new QueryWrapper<>();
        try {
            Object obj = clazz.newInstance();
            Field[] fields = clazz.getDeclaredFields();
            for(int i = 0; i < fields.length; i ++){
                String fieldName = fields[i].getName();
                Method method = new PropertyDescriptor(fieldName, clazz).getReadMethod();
                Object value = ReflectionUtils.invokeMethod(method, t);
                if(value != null && !"".equals(value.toString().trim())){
                    queryWrapper.eq(CamelUtils.camelToUnderline(fieldName, CamelUtils.NOT_TO_UPPERCASE), value);
                }
            }
        } catch (Exception e){
            log.warn("获取表达式异常：",e);
        }
        return queryWrapper;
    }
}

package ichpeng.springboot.demo.utils;

/**
 * @author: ichpeng@qq.com
 * @date: 2021/3/17 14:50
 * @description:
 */
public class CamelUtils {
    public static final char UNDERLINE = '_';
    public static final boolean TO_UPPERCASE = true;
    public static final boolean NOT_TO_UPPERCASE = false;

    /**
     * 驼峰转下划线
     * @param param
     * @param ifUpperCase
     * @return
     */
    public static String camelToUnderline(String param, boolean ifUpperCase) {
        if (param == null || "".equals(param.trim())) {
            return "";
        }
        int len = param.length();
        StringBuilder sb = new StringBuilder(len);
        for (int i = 0; i < len; i++) {
            char c = param.charAt(i);
            if (Character.isUpperCase(c)) {
                sb.append(UNDERLINE);
            }
            if (ifUpperCase) {
                //统一都转大写
                sb.append(Character.toUpperCase(c));
            } else {
                //统一都转小写
                sb.append(Character.toLowerCase(c));
            }


        }
        return sb.toString();
    }

    /**
     * 下划线转驼峰
     * @param param
     * @return
     */
    public static String underlineToCamel(String param) {
        if (param == null || "".equals(param.trim())) {
            return "";
        }
        int len = param.length();
        StringBuilder sb = new StringBuilder(len);
        // "_" 后转大写标志,默认字符前面没有"_"
        Boolean flag = false;
        for (int i = 0; i < len; i++) {
            char c = param.charAt(i);
            if (c == UNDERLINE) {
                flag = true;
                continue;   //标志设置为true,跳过
            } else {
                if (flag == true) {
                    //表示当前字符前面是"_" ,当前字符转大写
                    sb.append(Character.toUpperCase(param.charAt(i)));
                    //重置标识
                    flag = false;
                } else {
                    sb.append(Character.toLowerCase(param.charAt(i)));
                }
            }
        }
        return sb.toString();
    }
}

log4j.properties

### 配置根 ###
log4j.rootLogger=debug,console,fileAppender,dailyRollingInfoFile,dailyRollingErrorFile

### 设置输出sql的级别，其中logger后面的内容全部为jar包中所包含的包名 ###
log4j.logger.org.apache=info
log4j.logger.java.sql.Connection=info
log4j.logger.java.sql.Statement=info
log4j.logger.java.sql.PreparedStatement=info
log4j.logger.java.sql.ResultSet=info

### 配置输出到控制台 ###
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.Target=System.out
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern= %d{ABSOLUTE} %5p %c{1}:%L - %m%n

### 配置输出到文件 ###
log4j.appender.fileAppender=org.apache.log4j.FileAppender
log4j.appender.fileAppender.File=logs/application.log
log4j.appender.fileAppender.Append=true
log4j.appender.fileAppender.Threshold=debug
log4j.appender.fileAppender.layout=org.apache.log4j.PatternLayout
log4j.appender.fileAppender.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss}  [ %t:%r ] - [ %p ]  %m%n

### 配置输出到文件，并且每天都创建一个文件 ###
log4j.appender.dailyRollingInfoFile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.dailyRollingInfoFile.File=logs/info.log
log4j.appender.dailyRollingInfoFile.DatePattern='.'yyyy-MM-dd'.log'
log4j.appender.dailyRollingInfoFile.Threshold=INFO
log4j.appender.dailyRollingInfoFile.layout=org.apache.log4j.PatternLayout
log4j.appender.dailyRollingInfoFile.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss}  [ %t:%r ] - [ %p ]  %m%n
### 配置输出到文件，并且每天都创建一个文件 ###
log4j.appender.dailyRollingErrorFile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.dailyRollingErrorFile.File=logs/error.log
log4j.appender.dailyRollingErrorFile.DatePattern='.'yyyy-MM-dd'.log'
log4j.appender.dailyRollingErrorFile.Threshold=ERROR
log4j.appender.dailyRollingErrorFile.layout=org.apache.log4j.PatternLayout
log4j.appender.dailyRollingErrorFile.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss}  [ %t:%r ] - [ %p ]  %m%n

### 配置输出到文件，且大小到达指定尺寸的时候产生一个新的文件 ###
# log4j.appender.ROLLING_FILE=org.apache.log4j.RollingFileAppender
# log4j.appender.ROLLING_FILE.Threshold=ERROR
# log4j.appender.ROLLING_FILE.File=rolling.log
# log4j.appender.ROLLING_FILE.Append=true
# log4j.appender.ROLLING_FILE.MaxFileSize=10KB
# log4j.appender.ROLLING_FILE.MaxBackupIndex=1
# log4j.appender.ROLLING_FILE.layout=org.apache.log4j.PatternLayout
# log4j.appender.ROLLING_FILE.layout.ConversionPattern=[framework] %d - %c -%-4r [%t] %-5p %c %x - %m%n

### 配置输出到邮件 ###
# log4j.appender.MAIL=org.apache.log4j.net.SMTPAppender
# log4j.appender.MAIL.Threshold=FATAL
# log4j.appender.MAIL.BufferSize=10
# log4j.appender.MAIL.From=chenyl@yeqiangwei.com
# log4j.appender.MAIL.SMTPHost=mail.hollycrm.com
# log4j.appender.MAIL.Subject=Log4J Message
# log4j.appender.MAIL.To=chenyl@yeqiangwei.com
# log4j.appender.MAIL.layout=org.apache.log4j.PatternLayout
# log4j.appender.MAIL.layout.ConversionPattern=[framework] %d - %c -%-4r [%t] %-5p %c %x - %m%n

### 配置输出到数据库 ###
# log4j.appender.DATABASE=org.apache.log4j.jdbc.JDBCAppender
# log4j.appender.DATABASE.URL=jdbc:mysql://127.0.0.1:3306/test?serverTimezone=GMT%2B8&characterEncoding=utf8&useSSL=false&useUnicode=true
# log4j.appender.DATABASE.driver=com.mysql.cj.jdbc.Driver
# log4j.appender.DATABASE.user=root
# log4j.appender.DATABASE.password=111111
# log4j.appender.DATABASE.sql=INSERT INTO LOG4J (EXECUTE_TIME,LEVEL,MESSAGE) VALUES ('%d{yyyy-MM-dd HH:mm:ss}', '%p', '%d [framework] - %c -%-4r [%t] %-5p %c %x - %m')
# log4j.appender.DATABASE.Threshold=INFO
# log4j.appender.DATABASE.layout=org.apache.log4j.PatternLayout
# log4j.appender.DATABASE.layout.ConversionPattern=[framework] %d - %c -%-4r [%t] %-5p %c %x - %m%n