【MyBatis】spring bootでDB操作をできるだけ速く簡単に作成する【自動生成】

dependencies {
	implementation 'org.springframework.boot:spring-boot-starter-web'
	implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.2.2'
	runtimeOnly 'mysql:mysql-connector-java'
	testImplementation 'org.springframework.boot:spring-boot-starter-test'
}

<?xml version="1.0" encoding="UTF-8"?>
<!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="demoTables" targetRuntime="MyBatis3">
    <!-- DB接続設定 -->
    <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
      connectionURL="jdbc:mysql://localhost/hogedb"
      userId="hoge"
      password="passw0rd">
      <property name="nullCatalogMeansCurrent" value="true" />
    </jdbcConnection>
      
    <!-- Select結果がマッピングされる、Javaモデルの出力設定 -->
    <javaModelGenerator targetPackage="com.example.demo.db.model.generated" targetProject="demo/src/main/java">
      <property name="enableSubPackages" value="true" />
      <property name="trimStrings" value="true" />
    </javaModelGenerator>
      
    <!-- SQLを定義したXMLファイルの出力設定 -->
    <sqlMapGenerator targetPackage="com.example.demo.db.mapper.generated"  targetProject="demo/src/main/resources">
      <property name="enableSubPackages" value="true" />
    </sqlMapGenerator>
    
    <!-- Mapperインターフェースの出力設定 -->
    <javaClientGenerator type="XMLMAPPER" targetPackage="com.example.demo.db.mapper.generated"  targetProject="demo/src/main/java"> 
      <property name="enableSubPackages" value="true" />
    </javaClientGenerator>
    
    <!-- 自動生成するテーブルの設定 -->
    <table tableName="%"
      enableInsert="true"
      enableSelectByPrimaryKey="true"
      enableUpdateByPrimaryKey="true"
      enableDeleteByPrimaryKey="true"
      enableSelectByExample="false"
      enableUpdateByExample="false"
      enableDeleteByExample="false"
      enableCountByExample="false"
      selectByPrimaryKeyQueryId="false"
      selectByExampleQueryId="false"
      modelType="flat">
    </table>
  </context>
</generatorConfiguration>

package com.example.demo;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.example.demo.db.mapper")
public class DemoApplication {

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

}

pring.datasource.url=jdbc:mysql://localhost/hogedb
spring.datasource.username=hoge
spring.datasource.password=passw0rd
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
mybatis.configuration.map-underscore-to-camel-case=true

package com.example.demo.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.ResponseBody;

import com.example.demo.db.mapper.generated.TbSampleMapper;
import com.example.demo.db.model.generated.TbSample;

@Controller
public class SampleController {

    @Autowired
    TbSampleMapper mapper;

    @GetMapping("/sample/select/{id}")
    @ResponseBody
    public String select(@PathVariable("id") Integer id) {
        TbSample sample = mapper.selectByPrimaryKey(id);

        return "product Name = " + sample.getProductName();
    }

    @GetMapping("/sample/update/{id}/{name}")
    @ResponseBody
    public String update(@PathVariable("id") Integer id, @PathVariable("name") String name) {
        TbSample sample = new TbSample();
        sample.setId(id);
        sample.setProductName(name);
        mapper.updateByPrimaryKeySelective(sample);
        return "Update!";
    }

    @GetMapping("/sample/insert/{name}/{category}")
    @ResponseBody
    public String insert(@PathVariable("name") String name, @PathVariable("category") String category) {

        TbSample sample = new TbSample();
        sample.setProductName(name);
        sample.setCategoryId(category);

        mapper.insert(sample);

        return "Insert!";
    }
}

<?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.example.demo.db.mapper.custom.TbSampleCustomMapper">
  <select id="selectByCategory" parameterType="java.lang.String" resultMap="com.example.demo.db.mapper.generated.TbSampleMapper.BaseResultMap">
    select
     <include refid="com.example.demo.db.mapper.generated.TbSampleMapper.Base_Column_List" />
    from tb_sample
    where category_id = #{category,jdbcType=VARCHAR}
  </select>
</mapper>

package com.example.demo.db.mapper.custom;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.example.demo.db.model.generated.TbSample;

@Mapper
public interface TbSampleCustomMapper {
    public List<TbSample> selectByCategory(String category);
}

@Controller
public class SampleController {
    // 省略
    
    @Autowired
    TbSampleCustomMapper mapperCustom;
    
    // 省略

    @GetMapping("/sample/category/{category}")
    @ResponseBody
    public String selectCategory(@PathVariable("category") String category) {
        List<TbSample> samples = mapperCustom.selectByCategory(category);
        StringBuilder s = new StringBuilder();
        samples.forEach(sample -> {
            s.append("[ID=" + sample.getId() + ", PRODUCT_NAME=" + sample.getProductName() + "]<br>");
        });

        return s.toString();
    }
}