MyBatis-Plus概述

最新推荐文章于 2022-10-20 16:24:53 发布

十年少i

最新推荐文章于 2022-10-20 16:24:53 发布

阅读量719

点赞数

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

本文链接：https://blog.csdn.net/fristjcjdncg/article/details/104274299

版权

mybatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

目录
1 pom.xml
2 application.properties
3 启动类
4 Mapper
5 Service
6 利用相关Controller测试

MyBatis-Plus是一款MyBatis的增强工具，在MyBatis的基础上只做增强不做改变，为简化开发、提高效率而生。对于单表操作只调用方法而不用写SQL即可完成相应数据库的操作，快速开发节省大量时间。而对于多表操作，或者自己想写SQL的时候也可以用原来的MyBatis写SQL的方法来实现。

1.pom.xml

这是最近在做基于springboot框架的项目，其中pom配置的相关依赖，这里跟大家共享一波。

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://maven.apache.org/POM/4.0.0"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.3.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.mbyte</groupId>
    <artifactId>easy</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>easy</name>
    <description>easy-byte</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-security</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-aop</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.security</groupId>
            <artifactId>spring-security-test</artifactId>
            <scope>test</scope>
        </dependency>

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.1.0</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>3.1.0</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

        <!-- Druid数据源 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
        <!--mybatis-plus完成项目构建所需模板，真实项目不需要使用-->
        <dependency>
            <groupId>org.freemarker</groupId>
            <artifactId>freemarker</artifactId>
        </dependency>
        <!--commons -->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-lang3</artifactId>
            <version>3.6</version>
        </dependency>
        <dependency>
            <groupId>commons-io</groupId>
            <artifactId>commons-io</artifactId>
            <version>2.5</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.54</version>
        </dependency>

        <!-- activeMq support -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-activemq</artifactId>
        </dependency>
        <!-- activeMq end -->
        <!--热部署-->
        <!--<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>

        </dependency>-->

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-webflux</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-websocket</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-messaging</artifactId>
        </dependency>

        <!--js客户端的静态资源-->
        <dependency>
            <groupId>org.webjars</groupId>
            <artifactId>webjars-locator-core</artifactId>
        </dependency>
        <dependency>
            <groupId>org.webjars</groupId>
            <artifactId>sockjs-client</artifactId>
            <version>1.0.2</version>
        </dependency>
        <dependency>
            <groupId>org.webjars</groupId>
            <artifactId>stomp-websocket</artifactId>
            <version>2.3.3</version>
        </dependency>
        <dependency>
            <groupId>org.webjars</groupId>
            <artifactId>bootstrap</artifactId>
            <version>3.3.7</version>
        </dependency>
        <dependency>
            <groupId>org.webjars</groupId>
            <artifactId>jquery</artifactId>
            <version>3.1.0</version>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <!--<skip>true</skip>-->
                    <mainClass>com.mbyte.easy.EasyApplication</mainClass>
                </configuration>
            </plugin>

            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-surefire-plugin</artifactId>
                <configuration>
                    <skip>true</skip>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

2 application.properties

我使用的数据库是MySQL 5.7，相关的连接配置如下所示（基于项目的情况所配置的）

spring.datasource.druid.url=jdbc:mysql://127.0.0.1:3306/byte_easy?useUnicode=true&characterEncoding=utf-8&serverTimezone=CTT
spring.datasource.druid.username=root
spring.datasource.druid.password=123456
spring.datasource.druid.driver-class-name=com.mysql.cj.jdbc.Driver
# \u521D\u59CB\u5316\u65F6\u5EFA\u7ACB\u7269\u7406\u8FDE\u63A5\u7684\u4E2A\u6570
spring.datasource.druid.initial-size=5
# \u6700\u5927\u8FDE\u63A5\u6C60\u6570\u91CF
spring.datasource.druid.max-active=30 
# \u6700\u5C0F\u8FDE\u63A5\u6C60\u6570\u91CF
spring.datasource.druid.min-idle=5
# \u83B7\u53D6\u8FDE\u63A5\u65F6\u6700\u5927\u7B49\u5F85\u65F6\u95F4\uFF0C\u5355\u4F4D\u6BEB\u79D2
spring.datasource.druid.max-wait=60000
# \u914D\u7F6E\u95F4\u9694\u591A\u4E45\u624D\u8FDB\u884C\u4E00\u6B21\u68C0\u6D4B\uFF0C\u68C0\u6D4B\u9700\u8981\u5173\u95ED\u7684\u7A7A\u95F2\u8FDE\u63A5\uFF0C\u5355\u4F4D\u662F\u6BEB\u79D2
spring.datasource.druid.time-between-eviction-runs-millis=60000
# \u8FDE\u63A5\u4FDD\u6301\u7A7A\u95F2\u800C\u4E0D\u88AB\u9A71\u9010\u7684\u6700\u5C0F\u65F6\u95F4
spring.datasource.druid.min-evictable-idle-time-millis=300000
# \u7528\u6765\u68C0\u6D4B\u8FDE\u63A5\u662F\u5426\u6709\u6548\u7684sql\uFF0C\u8981\u6C42\u662F\u4E00\u4E2A\u67E5\u8BE2\u8BED\u53E5
spring.datasource.druid.validation-query=SELECT 1 FROM DUAL
# \u5EFA\u8BAE\u914D\u7F6E\u4E3Atrue\uFF0C\u4E0D\u5F71\u54CD\u6027\u80FD\uFF0C\u5E76\u4E14\u4FDD\u8BC1\u5B89\u5168\u6027\u3002\u7533\u8BF7\u8FDE\u63A5\u7684\u65F6\u5019\u68C0\u6D4B\uFF0C\u5982\u679C\u7A7A\u95F2\u65F6\u95F4\u5927\u4E8EtimeBetweenEvictionRunsMillis\uFF0C\u6267\u884CvalidationQuery\u68C0\u6D4B\u8FDE\u63A5\u662F\u5426\u6709\u6548\u3002
spring.datasource.druid.test-while-idle=true
# \u7533\u8BF7\u8FDE\u63A5\u65F6\u6267\u884CvalidationQuery\u68C0\u6D4B\u8FDE\u63A5\u662F\u5426\u6709\u6548\uFF0C\u505A\u4E86\u8FD9\u4E2A\u914D\u7F6E\u4F1A\u964D\u4F4E\u6027\u80FD\u3002
spring.datasource.druid.test-on-borrow=false
# \u5F52\u8FD8\u8FDE\u63A5\u65F6\u6267\u884CvalidationQuery\u68C0\u6D4B\u8FDE\u63A5\u662F\u5426\u6709\u6548\uFF0C\u505A\u4E86\u8FD9\u4E2A\u914D\u7F6E\u4F1A\u964D\u4F4E\u6027\u80FD\u3002
spring.datasource.druid.test-on-return=false
# \u662F\u5426\u7F13\u5B58preparedStatement\uFF0C\u4E5F\u5C31\u662FPSCache\u3002PSCache\u5BF9\u652F\u6301\u6E38\u6807\u7684\u6570\u636E\u5E93\u6027\u80FD\u63D0\u5347\u5DE8\u5927\uFF0C\u6BD4\u5982\u8BF4oracle\u3002\u5728mysql\u4E0B\u5EFA\u8BAE\u5173\u95ED\u3002
spring.datasource.druid.pool-prepared-statements=true
# \u8981\u542F\u7528PSCache\uFF0C\u5FC5\u987B\u914D\u7F6E\u5927\u4E8E0\uFF0C\u5F53\u5927\u4E8E0\u65F6\uFF0CpoolPreparedStatements\u81EA\u52A8\u89E6\u53D1\u4FEE\u6539\u4E3Atrue\u3002
spring.datasource.druid.max-pool-prepared-statement-per-connection-size=50
# \u914D\u7F6E\u76D1\u63A7\u7EDF\u8BA1\u62E6\u622A\u7684filters\uFF0C\u53BB\u6389\u540E\u76D1\u63A7\u754C\u9762sql\u65E0\u6CD5\u7EDF\u8BA1
spring.datasource.druid.filters=stat,wall
# \u901A\u8FC7connectProperties\u5C5E\u6027\u6765\u6253\u5F00mergeSql\u529F\u80FD\uFF1B\u6162SQL\u8BB0\u5F55
spring.datasource.druid.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
# \u5408\u5E76\u591A\u4E2ADruidDataSource\u7684\u76D1\u63A7\u6570\u636E
spring.datasource.druid.use-global-data-source-stat=true
# druid\u8FDE\u63A5\u6C60\u76D1\u63A7
spring.datasource.druid.stat-view-servlet.login-username=admin
spring.datasource.druid.stat-view-servlet.login-password=123456
# \u6392\u9664\u4E00\u4E9B\u9759\u6001\u8D44\u6E90\uFF0C\u4EE5\u63D0\u9AD8\u6548\u7387
spring.datasource.druid.web-stat-filter.exclusions=*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*
#thymeleaf\u914D\u7F6E
spring.thymeleaf.prefix=classpath:/templates/
spring.thymeleaf.suffix=.html
spring.thymeleaf.cache=false
spring.thymeleaf.mode=HTML5
spring.thymeleaf.encoding=UTF-8
spring.thymeleaf.servlet.content-type=text/html
spring.thymeleaf.check-template-location=true
#\uFFFD\uFFFD\uFFFD\uFFFD\uFFFD\uFFFD\u013F\uFFFD\uFFFD\u00B7\uFFFD\uFFFD
package.base=com.mbyte.easy
#Mybatis\u914D\u7F6E
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
mybatis-plus.type-aliases-package=${package.base}.entity
mybatis-plus.mapper-locations=classpath:mybatis/mapper/**/*Mapper.xml
#Druid\uFFFD\uFFFD\uFFFD\u073C\uFFFD\uFFFD
durid.patterns=${package.base}.*.*.controller.*,${package.base}.*.*.service.*,${package.base}.*.*.mapper.*
# \u012C\uFFFD\uFFFD\u03AA30\uFFFD\uFFFD\uFFFD\u04E3\uFFFD\uFFFD\uFFFD\uFFFD\uFFFD\u0135\uFFFD\u03BB\uFFFD\uFFFD\uFFFD\uFFFD
server.servlet.session.timeout=1800
#\u6587\u4EF6\u4E0A\u4F20\u6620\u5C04\u8DEF\u5F84
file.upload.suffix.path=/fileSuffix
#\u6587\u4EF6\u4E0A\u4F20\u6620\u5C04\u672C\u5730\u78C1\u76D8\u76EE\u5F55\u4F4D\u7F6E
file.upload.local.path=/home/wangzhen/Desktop/upload/
spring.servlet.multipart.max-file-size=100MB
spring.servlet.multipart.max-request-size=200MB
#\u6587\u4EF6\u4E0A\u4F20\u9879\u76EE\u8BBF\u95EE\u8DEF\u5F84\u524D\u7F00(\u76EE\u524D\u5BCC\u6587\u672C\u7F16\u8F91\u5668\u4E0A\u4F20\u5230\u672C\u5730\u65F6\u4F7F\u7528)
easy.server.path=http://39.106.217.11:8080
server.port=8888
#default point to point
#\u542F\u7528\u53D1\u5E03\u8BA2\u9605\u6A21\u5F0F
#spring.jms.pub-sub-domain=true
#\u72EC\u7ACB\u7684active mq \u670D\u52A1\u914D\u7F6E
spring.activemq.broker-url=tcp://127.0.0.1:61616
spring.activemq.user=admin
spring.activemq.password=admin

3 启动类

/**
 * SpringBoot启动类
 * @author  james
 */
@SpringBootApplication
@EnableScheduling
//@EnableTransactionManagement
public class EasyApplication {

    public static void main(String[] args) {
        SpringApplication.run(EasyApplication.class, args);
    }

}

项目的启动方法：
第一种：
在这里插入图片描述
第二种

4 Mapper

这里共享下我的目录结构
在这里插入图片描述

TicketMapper.java

/**
 * <p>
 * 卡券表 Mapper 接口
 * </p>
 *
 * @author james
 * @since 2020-02-09
 */
@Component(value ="TicketMapper")
public interface TicketMapper extends BaseMapper<Ticket> {
    List<Ticket> selectByIdReturnList(Long id);
    Integer selectByIdReturnTypeId(Long id);
    Ticket selectByIdReturnOne(Long id);
}

TicketMapper.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="com.mbyte.easy.ticket.mapper.TicketMapper">
  <resultMap id="BaseResultMap" type="com.mbyte.easy.ticket.entity.Ticket">
      <id column="id" jdbcType="INTEGER" property="id" />
      <id column="ticketId" jdbcType="INTEGER" property="ticketId" />
      <id column="ticketName" jdbcType="VARCHAR" property="ticketName" />
      <id column="ticketNO" jdbcType="VARCHAR" property="ticketNO" />
      <id column="ticketPwd" jdbcType="VARCHAR" property="ticketPwd" />
      <id column="addMan" jdbcType="VARCHAR" property="addMan" />
      <id column="addDate" jdbcType="TIMESTAMP" property="addDate" />
      <id column="deleteMan" jdbcType="VARCHAR" property="deleteMan" />
      <id column="deleteDate" jdbcType="TIMESTAMP" property="deleteDate" />
      <id column="status" jdbcType="INTEGER" property="status" />
      <id column="holder" jdbcType="INTEGER" property="holder" />

  </resultMap>
    <resultMap id="BaseResultMap2" type="java.lang.Integer">
        <id column="ticketId" jdbcType="INTEGER" property="ticketId" />
    </resultMap>
  <sql id="Base_Column_List">
              id,
      ticketId, ticketName, ticketNO, ticketPwd, addMan, addDate, deleteMan, deleteDate, status, holder
  </sql>

<!--注意:在打开下面注释的时候，在执行添加和更新操作时，一定要添加事物，否则会造成无法添加和更新-->
    <select id="selectByIdReturnList" parameterType="java.lang.Long" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from t_ticket
        where id = #{id,jdbcType=INTEGER}
    </select>

    <select id="selectByIdReturnTypeId" parameterType="java.lang.Long" resultMap="BaseResultMap2">
        select
        ticketId
        from t_ticket
        where id = #{id}
    </select>

    <select id="selectByIdReturnOne" parameterType="java.lang.Long" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from t_ticket
        where id = #{id,jdbcType=INTEGER}
    </select>
//
//上面的代码是根据需求自己写的sql查询语句 
//下面的代码时反向生成的所以就不共享了 ，
//
 </mapper>

5 Service

在ITicketService中加入自己另外需要的方法名，然后去Impl中去实现

/**
 * <p>
 * 卡券表 服务类
 * </p>
 *
 * @author james
 * @since 2020-02-09
 */
public interface ITicketService extends IService<Ticket> {
    Integer selectByIdReturnTicket(Long id);
    //这里就共享一个吧
}

Impl实现类

public class TicketServiceImpl extends ServiceImpl<TicketMapper, Ticket> implements ITicketService {
    @Autowired
    private TicketMapper ticketMapper ;
	//自动注入

 @Override
    public Integer selectByIdReturnTicket(Long id) {
        return  ticketMapper.selectByIdReturnTypeId(id);
    }

6 利用相关Controller测试

/**
* 
* 前端控制器 
* @author james
* @since 
*/
@Controller
@RequestMapping("/ticket/ticket")
public class TicketController extends BaseController  {

    private String prefix = "ticket/ticket/";

    @Autowired
    private ITicketService ticketService;

    @PostMapping("edit")
    @ResponseBody
    public AjaxResult edit(Ticket ticket){
	 Integer ticketTypeId =ticketService.selectByIdReturnTicket(ticket.getId());
	 ....
	 //就是这样调用了一个方法

最后附上我的基础模型框架的码云gitee网址吧。有需要的小伙伴可以克隆一下！
https://gitee.com/zzz444/byteeasy

由上可以看到，因为Service层和Mapper层继承了MyBatis-Plus的内置类，所以只需要调用内置好的CRUD方法即可完成相关操作，简单快捷。如果想自己写SQL，也可以在Service层和Mapper层自定义方法，就如同使用MyBatis一样。

一起加油进步！！！！

十年少i

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
MyBatis-Plus概述

目录1 pom.xml2 application.properties3 启动类4 Mapper5 Service6 利用相关Controller测试MyBatis-Plus是一款MyBatis的增强工具，在MyBatis的基础上只做增强不做改变，为简化开发、提高效率而生。对于单表操作只调用方法而不用写SQL即可完成相应数据库的操作，快速开发节省大量时间。而对于多表操作，或者自己想...
复制链接

扫一扫