#foreach($column in $columns) #end select #foreach($column in $columns) `$column.columnName`#if($velocityCount != $columns.size()), #end #end from ${tableName} where ${pk.columnName} = #{id} select #foreach($column in $columns) `$column.columnName`#if($velocityCount != $columns.size()), #end #end from ${tableName} WHERE 1=1 AND name LIKE concat('%',#{name},'%') order by ${sidx} ${order} order by ${pk.columnName} desc limit #{offset}, #{limit} select count(*) from ${tableName} WHERE 1=1 AND name LIKE concat('%',#{name},'%') insert into ${tableName}( #foreach($column in $columns) #if($column.columnName != $pk.columnName || $pk.extra != 'auto_increment') `$column.columnName`#if($velocityCount != $columns.size()), #end #end #end ) values( #foreach($column in $columns) #if($column.columnName != $pk.columnName || $pk.extra != 'auto_increment') #{$column.attrname}#if($velocityCount != $columns.size()), #end #end #end ) update ${tableName} #foreach($column in $columns) #if($column.columnName != $pk.columnName) `$column.columnName` = #{$column.attrname}#if($velocityCount != $columns.size()), #end #end #end where ${pk.columnName} = #{${pk.attrname}} delete from ${tableName} where ${pk.columnName} = #{value} delete from ${tableName} where ${pk.columnName} in #{${pk.attrname}}