<#if classInfo.fieldList?exists && classInfo.fieldList?size gt 0> <#list classInfo.fieldList as fieldItem > <#if classInfo.fieldList?exists && classInfo.fieldList?size gt 0> <#list classInfo.fieldList as fieldItem > `${fieldItem.columnName}`<#if fieldItem_has_next>, INSERT INTO ${classInfo.tableName} <#if classInfo.fieldList?exists && classInfo.fieldList?size gt 0> <#list classInfo.fieldList as fieldItem > <#if fieldItem.columnName != "id_" > ${r""} `${fieldItem.columnName}`<#if fieldItem_has_next>, ${r""} <#if classInfo.fieldList?exists && classInfo.fieldList?size gt 0> <#list classInfo.fieldList as fieldItem > <#if fieldItem.columnName != "id_" > <#--<#if fieldItem.columnName="addtime" || fieldItem.columnName="updatetime" > ${r""} NOW()<#if fieldItem_has_next>, ${r""} <#else>--> ${r""} ${r"#{"}${fieldItem.fieldName}${r"}"}<#if fieldItem_has_next>, ${r""} <#----> DELETE FROM ${classInfo.tableName} WHERE `id_` = ${r"#{id}"} UPDATE ${classInfo.tableName} <#list classInfo.fieldList as fieldItem > <#if fieldItem.columnName != "id_" && fieldItem.columnName != "AddTime" && fieldItem.columnName != "UpdateTime" > ${r""}${fieldItem.columnName} = ${r"#{"}${fieldItem.fieldName}${r"}"}<#if fieldItem_has_next>,${r""} WHERE `id_` = ${r"#{"}id${r"}"} SELECT FROM ${classInfo.tableName} WHERE `id_` = ${r"#{id}"} SELECT FROM ${classInfo.tableName} LIMIT ${r"#{offset}"}, ${r"#{pageSize}"} SELECT count(1) FROM ${classInfo.tableName}