优化主子表代码生成模板

RuoYi

2021-04-13 32c65247b2930a195573438a7f43f59d933fdbe8

优化主子表代码生成模板

 src/main/resources/application-druid.yml

@@ -43,7 +43,7 @@
                allow:

                url-pattern: /druid/*

                # 控制台管理用户名和密码

                login-username: admin

                login-username: ruoyi

                login-password: 123456

            filter:

                stat:


 src/main/resources/vm/xml/mapper.xml.vm

@@ -12,12 +12,12 @@
#if($table.sub)



    <resultMap id="${ClassName}${subClassName}Result" type="${ClassName}" extends="${ClassName}Result">

        <collection property="${subclassName}List" notNullColumn="${subTable.pkColumn.columnName}" javaType="java.util.List" resultMap="${subClassName}Result" />

        <collection property="${subclassName}List" notNullColumn="sub_${subTable.pkColumn.columnName}" javaType="java.util.List" resultMap="${subClassName}Result" />

    </resultMap>



    <resultMap type="${subClassName}" id="${subClassName}Result">

#foreach ($column in $subTable.columns)

        <result property="${column.javaField}"    column="${column.columnName}"    />

        <result property="${column.javaField}"    column="sub_${column.columnName}"    />

#end

    </resultMap>

#end

@@ -64,7 +64,7 @@
        where ${pkColumn.columnName} = #{${pkColumn.javaField}}

#elseif($table.sub)

        select#foreach($column in $columns) a.$column.columnName#if($velocityCount != $columns.size()),#end#end,

           #foreach($column in $subTable.columns) b.$column.columnName#if($velocityCount != $subTable.columns.size()),#end#end

           #foreach($column in $subTable.columns) b.$column.columnName as sub_$column.columnName#if($velocityCount != $subTable.columns.size()),#end#end



        from ${tableName} a

        left join ${subTableName} b on b.${subTableFkName} = a.${pkColumn.columnName}