#foreach ($column in $columns) #if($column.columnName != $pkColumn.columnName) #end #end #foreach ($column in $columns) ${column.columnName}, #end select from `${tableName}` where ${pkColumn.columnName} = #{${pkColumn.javaField}} SELECT FROM `${tableName}` WHERE ${pkColumn.columnName} in #{item.${pkColumn.columnName}} update `${tableName}` set active=false, #foreach ($column in $columns) #if($column.columnName == "updateflag") updateflag = true, #end #end update_time= #{updateTime} where ${pkColumn.columnName} = #{${pkColumn.javaField}} update `${tableName}` #foreach ($column in $columns) #if($column.columnName != $pkColumn.columnName) $column.columnName = #{$column.javaField}, #end #end WHERE ${pkColumn.columnName} = #{${pkColumn.javaField}} insert into `${tableName}` () values #foreach ($column in $columns) #{$column.javaField}, #end ON DUPLICATE KEY UPDATE #foreach ($column in $columns) #if($column.columnName != $pkColumn.columnName) ${column.columnName} = VALUES(${column.columnName}), #end #end insert into `${tableName}` () values ( #foreach ($column in $columns) #{item.$column.javaField}, #end ) ON DUPLICATE KEY UPDATE #foreach ($column in $columns) #if($column.columnName != $pkColumn.columnName) ${column.columnName} = VALUES(${column.columnName}), #end #end select from `${tableName}` where 1=1 AND update_time between #{startDate} AND #{endDate} select FROM `${tableName}` WHERE updateflag = true and update_time = ]]> #{param1}; select FROM `${tableName}` #foreach($column in $columns) #set($queryType=$column.queryType) #set($javaField=$column.javaField) #set($javaType=$column.javaType) #set($columnName=$column.columnName) #set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)}) #if($columnName=="active") AND active =true #end #if($column.isQuery) #if($column.queryType == "EQ") and $columnName = #{$javaField} #elseif($queryType == "NE") and $columnName != #{$javaField} #elseif($queryType == "GT") and $columnName > #{$javaField} #elseif($queryType == "GTE") and $columnName >= #{$javaField} #elseif($queryType == "LT") and $columnName < #{$javaField} #elseif($queryType == "LTE") and $columnName <= #{$javaField} #elseif($queryType == "LIKE") and instr($columnName,#{$javaField}) #end #end #end AND update_time = ]]> #{startDate} AND date_format(update_time, '%Y-%m-%d') #{endDate}