templates.generator.java.custom2.mapper_xml.vm Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of artoria-extend Show documentation
Artoria is a java technology framework based on the facade pattern.
The newest version!




    
    
#foreach(${column} in ${table.columnList})
#if($column.primaryKey)
        
#end
#end
#foreach(${column} in ${table.columnList})
#if(!$column.primaryKey)
        
#end
#end
    

    
#set($temp = 1)
#foreach(${column} in ${table.columnList})
        `${column.name}`#if($temp < $table.columnList.size()),
#set($temp = $temp + 1)#end
#end

    

    
#foreach(${column} in ${table.columnList})
        and `${column.name}` = #{${column.fieldName}}
#end
    

    
        insert into `${table.name}` (
            
        )
        values (
#set($temp = 1)#foreach(${column} in ${table.columnList})
            #{${column.fieldName}}#if($temp < $table.columnList.size()),
#set($temp = $temp + 1)
#end
#end

        )
    

    
        insert into `${table.name}` (
            
        )
        values
        
        (
#set($temp = 1)#foreach(${column} in ${table.columnList})
            #{item.${column.fieldName}}#if($temp < $table.columnList.size()),
#set($temp = $temp + 1)
#end
#end

        )
        
    

    
        insert into `${table.name}`
        
#foreach(${column} in ${table.columnList})
            `${column.name}`, 
#end
        
        
#foreach( ${column} in ${table.columnList} )
            #{${column.fieldName}}, 
#end
        
    

    
        update `${table.name}`
        set
            `updater_id` = #{updaterId},
            `update_time` = NOW(),
            `alive_flag` = 0
        where `alive_flag` = 1
#foreach(${column} in ${table.columnList})
#if($column.primaryKey)
            and `${column.name}` = #{${column.fieldName}}
#end#end
    

    
        update `${table.name}`
        set
            `updater_id` = #{updaterId},
            `update_time` = NOW(),
            `alive_flag` = 0
        where `alive_flag` = 1
#foreach(${column} in ${table.columnList})
#if($column.primaryKey)
            and `${column.name}` in
            
                    #{item}
            
#end#end
    

    
        update `${table.name}`
        set
            `updater_id` = #{updaterId},
            `update_time` = NOW(),
            `alive_flag` = 0
        where `alive_flag` = 1
#foreach(${column} in ${table.columnList})
#if($column.name != "update_user")
            and `${column.name}` = #{${column.fieldName}}
#end
#end
    

    
        update `${table.name}`
        set
#set($temp = 1)#foreach(${column} in ${table.columnList})
            `${column.name}` = #{${column.fieldName}}#if($temp < $table.columnList.size()),
#set($temp = $temp + 1)
#end
#end

        where `alive_flag` = 1
#foreach(${column} in ${table.columnList})
#if($column.primaryKey)
            and `${column.name}` = #{${column.fieldName}}
#end#end
    

    
        update `${table.name}`
        
#foreach(${column} in ${table.columnList})
            `${column.name}` = #{${column.fieldName}}, 
#end
        
        where `alive_flag` = 1
#foreach(${column} in ${table.columnList})
#if($column.primaryKey)
            and `${column.name}` = #{${column.fieldName}}
#end#end