Spring boot集成mybatis generator

搭建Spring boot项目

快速生成spring boot web demo

生成网址
从官网快速生成spring boot web demo

集成mybatis generator

引入mybatis generator 插件

在pom.xml引入generator plugin

<plugin>
    <groupId>org.mybatis.generator</groupId>
    <artifactId>mybatis-generator-maven-plugin</artifactId>
    <version>1.4.0</version>
    <configuration>
        <overwrite>true</overwrite>
    </configuration>
    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>${mysql.version}</version>
        </dependency>
    </dependencies>
</plugin>

添加generator config

在resources目录下添加generatorConfig.xml

<!DOCTYPE generatorConfiguration PUBLIC
        "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
    <context id="simple" targetRuntime="MyBatis3Simple">
        <commentGenerator>
            <property name="suppressAllComments" value="true"/>
            <property name="suppressDate" value="true"/>
        </commentGenerator>
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost/test" userId="root" password="root1234"/>

        <javaModelGenerator targetPackage="com.example.model" targetProject="src/main/java"/>

        <sqlMapGenerator targetPackage="com.example.mapper" targetProject="src/main/resources"/>

        <javaClientGenerator type="XMLMAPPER" targetPackage="com.example.mapper" targetProject="src/main/java"/>

        <table tableName="tbl_user" />
    </context>
</generatorConfiguration>

配置mysql 数据源

在application.xml中添加数据源

spring:
  datasource:
    url: jdbc:mysql://localhost/test
    username: root
    password: root1234

application 详细配置请参考官方文档

执行命令生成mapper

mvn mybatis-generator:generate

mybatis generator 详细配置参考官方文档
mybatis mapper详细配置参考官方文档

添加 service接口

package com.example.service;

import com.example.model.TblUser;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public interface ITblUserService {
     List<TblUser> findAll();
}

添加service 实现层

package com.example.service;

import com.example.mapper.TblUserMapper;
import com.example.model.TblUser;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

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

@Service
public class TblUserService implements ITblUserService {

    @Autowired
    private TblUserMapper tblUserMapper;

    @Override
    public List<TblUser> findAll() {
        return tblUserMapper.selectAll();
    }
}

添加control层

package com.example.controller;

import com.example.model.TblUser;
import com.example.service.ITblUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;

@Controller
@RequestMapping("/user")
public class TblUserController {

    @Autowired
    private ITblUserService iTblUserService;

    @ResponseBody
    @RequestMapping(value = "/findAll", method = RequestMethod.GET, produces = "application/json")
    public List<TblUser> findByUser(@RequestBody TblUser tblUser) {
        return iTblUserService.findAll();
    }
}

启动项目，postman测试接口