1. ##引入mybatis支持
    2. $!{mybatisSupport.vm}
    4. ##设置保存名称与保存位置
    5. $!callback.setFileName($tool.append($!{tableInfo.name}, "Mapper.xml"))
    6. $!callback.setSavePath($tool.append($modulePath, "/src/main/resources/mapper"))
    8. ##拿到主键
    9. #if(!$tableInfo.pkColumn.isEmpty())
    10.     #set($pk = $tableInfo.pkColumn.get(0))
    11. #end
    13. <?xml version="1.0" encoding="UTF-8"?>
    14. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    15. <mapper namespace="$!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper">
    17.     <resultMap type="$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}" id="$!{tableInfo.name}Map">
    18. #foreach($column in $tableInfo.fullColumn)
    19.         <result property="$!column.name" column="$!column.obj.name" jdbcType="$!column.ext.jdbcType"/>
    20. #end
    21.     </resultMap>
    23.     <!--查询单个-->
    24.     <select id="queryById" resultMap="$!{tableInfo.name}Map">
    25.         select
    26.           #allSqlColumn()
    28.         from $!tableInfo.obj.name
    29.         where $!pk.obj.name = #{$!pk.name}
    30.     </select>
    32.     <!--查询指定行数据-->
    33.     <select id="queryAllByLimit" resultMap="$!{tableInfo.name}Map">
    34.         select
    35.           #allSqlColumn()
    37.         from $!tableInfo.obj.name
    38.         <where>
    39. #foreach($column in $tableInfo.fullColumn)
    40.             <if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">
    41.                 and $!column.obj.name = #{$!column.name}
    42.             </if>
    43. #end
    44.         </where>
    45.         limit #{pageable.offset}, #{pageable.pageSize}
    46.     </select>
    48.     <!--统计总行数-->
    49.     <select id="count" resultType="java.lang.Long">
    50.         select count(1)
    51.         from $!tableInfo.obj.name
    52.         <where>
    53. #foreach($column in $tableInfo.fullColumn)
    54.             <if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">
    55.                 and $!column.obj.name = #{$!column.name}
    56.             </if>
    57. #end
    58.         </where>
    59.     </select>
    61.     <!--新增所有列-->
    62.     <insert id="insert" keyProperty="$!pk.name" useGeneratedKeys="true">
    63.         insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
    64.         values (#foreach($column in $tableInfo.otherColumn)#{$!{column.name}}#if($velocityHasNext), #end#end)
    65.     </insert>
    67.     <insert id="insertBatch" keyProperty="$!pk.name" useGeneratedKeys="true">
    68.         insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
    69.         values
    70.         <foreach collection="entities" item="entity" separator=",">
    71.         (#foreach($column in $tableInfo.otherColumn)#{entity.$!{column.name}}#if($velocityHasNext), #end#end)
    72.         </foreach>
    73.     </insert>
    75.     <insert id="insertOrUpdateBatch" keyProperty="$!pk.name" useGeneratedKeys="true">
    76.         insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
    77.         values
    78.         <foreach collection="entities" item="entity" separator=",">
    79.             (#foreach($column in $tableInfo.otherColumn)#{entity.$!{column.name}}#if($velocityHasNext), #end#end)
    80.         </foreach>
    81.         on duplicate key update
    82.         #foreach($column in $tableInfo.otherColumn)$!column.obj.name = values($!column.obj.name)#if($velocityHasNext),
    83.         #end#end
    85.     </insert>
    87.     <!--通过主键修改数据-->
    88.     <update id="update">
    89.         update $!{tableInfo.obj.name}
    90.         <set>
    91. #foreach($column in $tableInfo.otherColumn)
    92.             <if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">
    93.                 $!column.obj.name = #{$!column.name},
    94.             </if>
    95. #end
    96.         </set>
    97.         where $!pk.obj.name = #{$!pk.name}
    98.     </update>
    100.     <!--通过主键删除-->
    101.     <delete id="deleteById">
    102.         delete from $!{tableInfo.obj.name} where $!pk.obj.name = #{$!pk.name}
    103.     </delete>
    105. </mapper>