#foreach($column in $columns) #end select * from ${tableName} where ${pk.columnName} = #{value} SELECT /*+ FIRST_ROWS */ * FROM ( SELECT A.*, ROWNUM RN FROM ( select * from ${tableName} order by ${sidx} ${order} order by ${pk.columnName} desc ）A WHERE ROWNUM #{upperOffset} ) WHERE RN > #{lowerOffset} select count(*) from ${tableName} 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}}