Springboot+Mybatis+lombok 使用

说明：这里是学习的一些记录，我不是做软件开发的。像这里需要整合springboot+spring+mybatis还在学习中。

 

一、lombok配置

（1）插件下载

lombok离线下载地址：https://plugins.jetbrains.com/plugin/6317-lombok/versions

根据自己idea版本进行下载

（2）安装

（3）引入Maven依赖

<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <version>1.18.10</version>
</dependency>

 

二、编写配置文件

Springboot核心配置文件

server:
  port: 8888

logging:
  path: logs
  file: mylog.log

spring:
  application:
    name: myTest
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/dmall?characterEncoding=utf-8
    username: root
    password: root

mybatis:
  type-aliases-package: org.example.mybatis.pojo
  mapper-locations:
    - mapper/*

mybatis核心配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <typeAliases>
        <package name="org.example.mybatis.pojo"/>
    </typeAliases>
    <mappers>
        <mapper resource="mapper/RolesMapper.xml" />
        <mapper resource="mapper/PromoterMapper.xml" />
    </mappers>

    <!--&lt;!&ndash;读取properties中的文件配置&ndash;&gt;
    <properties resource="jdbc.properties">
        <property name="jdbc.username" value="root"/>
        <property name="jdbc.password" value="root"/>
    </properties>

    &lt;!&ndash;配置包扫描&ndash;&gt;
    <typeAliases>
        <package name="org.example.mybatis.pojo"/>
    </typeAliases>

    &lt;!&ndash; 和spring整合后 environments配置将废除 &ndash;&gt;
    <environments default="development">
        <environment id="development">
            &lt;!&ndash; 使用jdbc事务管理 &ndash;&gt;
            <transactionManager type="JDBC" />
            &lt;!&ndash; 数据库连接池 &ndash;&gt;
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}" />
                <property name="url" value="${jdbc.url}" />
                <property name="username" value="${jdbc.username}" />
                <property name="password" value="${jdbc.password}" />
            </dataSource>
        </environment>
    </environments>

    &lt;!&ndash;加载映射文件&ndash;&gt;
    <mappers>
        <mapper resource="mapper/MemberMapper.xml" />
        <mapper resource="mapper/UserMapper.xml" />
        <mapper resource="mapper/RolesMapper.xml" />
        <package name="org.example.mybatis.mapper.UserMapper"/>
        <package name="org.example.mybatis.mapper.MemberMapper"/>
        <package name="org.example.mybatis.mapper.RolesMapper"/>
    </mappers>-->
</configuration>

三、代码

springboot启动，这个application.class这个文件需要放在包的路径下。

package org.example;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.ConfigurableApplicationContext;
import org.springframework.scheduling.annotation.EnableScheduling;

import javax.annotation.PreDestroy;

@SpringBootApplication
@EnableScheduling
public class Application {

    private static ConfigurableApplicationContext context;

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

    @PreDestroy
    public void close(){
        Application.context.close();
    }
}

java bean

package org.example.mybatis.pojo;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.Date;

@Data
public class Promoter {
    @ApiModelProperty(value = "主键id")
    private Integer id;

    @ApiModelProperty(value = "商品名称")
    private String shopName;

    @ApiModelProperty(value = "状态")
    private Integer status;

    @ApiModelProperty(value = "提交时间")
    @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
    private Date applyTime;

    @ApiModelProperty(value = "通过时间")
    @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
    private Date passTime;

    @ApiModelProperty(value = "备注")
    private String remake;

}

测试类：

package org.example.mybatis.controller;

import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.log4j.Log4j;
import org.example.mybatis.pojo.Promoter;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@Log4j
@RestController
@RequestMapping(value = "Promoter")
@Api(value = "Promoter", description = "Promoter管理")
public class PromoterController {

    @Autowired
    private SqlSessionTemplate sqlSessionTemplate;

    @RequestMapping(value = "findAllPromoter", method = RequestMethod.GET)
    @ApiOperation(value = "查询所有Promoter", httpMethod = "GET")
    public List<Promoter> findAllPromoter(){
        List<Promoter> allPromoter = sqlSessionTemplate.selectList("findAllPromoter");
        return allPromoter;
    }
}

编写Mapper文件

<?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="org.example.mybatis.pojo">
    <select id="findAllPromoter" resultType="org.example.mybatis.pojo.Promoter">
        select * from dmall_promoter
    </select>
</mapper>