SpringBoot mybatis

 <build>
      <plugins>
         <!--MG的插件 -->
         <plugin>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-maven-plugin</artifactId>
            <version>1.3.5</version>
            <dependencies>
                <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java 配置这个依赖主要是为了等下在配置MG的时候可以不用配置classPathEntry这样的一个属性，避免代码的耦合度太高 -->
                <dependency>
                   <groupId>mysql</groupId>
                  <artifactId>mysql-connector-java</artifactId>
                   <version>5.1.43</version>
                </dependency>
 
                <dependency>
                   <groupId>org.mybatis.generator</groupId>
                   <artifactId>mybatis-generator-core</artifactId>
                   <version>1.3.5</version>
                </dependency>
            </dependencies>
            <configuration>
                <verbose>true</verbose>
                <overwrite>true</overwrite>
                <!-- 自动生成的配置 -->
                <configurationFile>
                   src/main/resources/config/mybatis-generator.xml</configurationFile>
            </configuration>
         </plugin>
 
         <plugin>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-maven-plugin</artifactId>
         </plugin>
      </plugins>
   </build>

<?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>
   <properties resource="application-dev.properties" />
   <!-- <context id="Mysql" targetRuntime="MyBatis3"> -->
   <context id="Mysql" targetRuntime="tk.mybatis.mapper.generator.TkMyBatis3Impl"
      defaultModelType="flat">
 
      <!-- 生成的Java文件的编码 -->
      <property name="javaFileEncoding" value="UTF-8" />
      <!-- 格式化java代码 -->
      <property name="javaFormatter"
         value="org.mybatis.generator.api.dom.DefaultJavaFormatter" />
      <!-- 格式化XML代码 -->
      <property name="xmlFormatter"
         value="org.mybatis.generator.api.dom.DefaultXmlFormatter" />
 
      <plugin type="tk.mybatis.mapper.generator.MapperPlugin">
         <property name="mappers" value="com.comba.config.CombaMapper" />
      </plugin>
      <commentGenerator>
         <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
         <property name="suppressAllComments" value="true" />
         <!-- 是否生成注释代时间戳 -->
         <property name="suppressDate" value="true" />
      </commentGenerator>
      <!--数据库链接地址账号密码 -->
      <jdbcConnection driverClass="${spring.datasource.driver-class-name}"
         connectionURL="${spring.datasource.url}" userId="${spring.datasource.username}"
         password="xxx">
      </jdbcConnection>
      <javaTypeResolver>
         <property name="forceBigDecimals" value="false" />
      </javaTypeResolver>
      <!--生成Model类存放位置 -->
      <javaModelGenerator targetPackage="com.demo.entity"
         targetProject="src/main/java">
         <property name="enableSubPackages" value="true" />
         <!-- 是否针对string类型的字段在set的时候进行trim调用 -->
         <property name="trimStrings" value="true" />
      </javaModelGenerator>
      <!--生成映射文件存放位置 -->
      <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources">
         <property name="enableSubPackages" value="true" />
      </sqlMapGenerator>
      <!--生成Dao类存放位置 -->
      <!-- 客户端代码，生成易于使用的针对Model对象和XML配置文件 的代码 type="ANNOTATEDMAPPER",生成Java Model 
         和基于注解的Mapper对象 type="MIXEDMAPPER",生成基于注解的Java Model 和相应的Mapper对象 type="XMLMAPPER",生成SQLMap 
         XML文件和独立的Mapper接口 -->
      <javaClientGenerator type="XMLMAPPER"
         targetPackage="com.comba.dao" targetProject="src/main/java">
         <property name="enableSubPackages" value="true" />
      </javaClientGenerator>
      <!--生成对应表及类名 domainObjectName="plan" -->
<!--      <table tableName="master" domainObjectName="Master" mapperName="{0}Dao"
         enableCountByExample="false" enableUpdateByExample="false"
         enableDeleteByExample="false" enableSelectByExample="false"
         selectByExampleQueryId="false">
       <generatedKey column="id" sqlStatement="Mysql" /> 
      </table>-->
      <table tableName="agv_gis_config" enableCountByExample="false" mapperName="{0}Dao"
         enableUpdateByExample="false" enableDeleteByExample="false" 
         enableSelectByExample="false" selectByExampleQueryId="false">        
         <ignoreColumn column="createtime" />
         <ignoreColumn column="modifytime" />
      </table>
   </context>
</generatorConfiguration>

      <!--通用mapper -->
      <dependency>
         <groupId>tk.mybatis</groupId>
         <artifactId>mapper-spring-boot-starter</artifactId>
         <version>1.1.4</version>
      </dependency>

<update id="updateOrder" parameterType="com.demo.entity.ProductOrder">
    <selectKey keyProperty='id' resultType='Long' order='BEFORE'>
        select
        (select id from product_order where
        product_order_no=#{productOrderNo})id
        from DUAL
    </selectKey>
    update product_order set product_no=#{productNo},product_name=#{productName},produce_date=#{produceDate},
    plan_amount=#{planAmount},start_time=#{startTime} where product_order_no=#{productOrderNo}
</update>