#if(${enableCache}) #end #if(${baseResultMap}) #foreach($field in ${table.fields}) #if(${field.keyFlag})##生成主键排在第一位 #end #end #foreach($field in ${voInfo.fields}) #if(${field.propertyName} != "deleted" and ${field.propertyName} != "id" and ${field.propertyName} != "${field.refTableProperty}" and ${field.propertyName} != "${field.refTableProperty}List")##因为是直接映射到vo，deleted不需要 #end #end #if(${hasRef}) #foreach($field in ${refColumnList}) #if(${field.refType} == "OTM") #foreach($refField in ${field.returnColumnList}) #if(${refField.column} == "id") #else #end #end #end #end #end #end #if(${hasRef}) #foreach($field in ${refColumnList}) #if(${field.refType} == "OTO") #foreach($returnField in ${field.returnColumnList}) #end #end #end #end #if(${hasRef}) #foreach($field in ${refColumnList}) SELECT #foreach($refField in ${field.returnColumnList}) ${refField.column}, #end FROM ${field.refTableName} WHERE ${field.refColumn} = #{id} #end #end #if(${baseColumnList}) #foreach($field in ${table.commonFields}) ${field.columnName}, #end ${table.fieldNames} #end SELECT #foreach($field in ${voInfo.fields}) ${voInfo.tableSimpleName}.${field.columnName}, #end #foreach($field in ${refColumnList}) #if(${field.refType} == "OTO") #foreach($returnField in ${field.returnColumnList}) ${field.refTableSimpleName}.${returnField.column} as ${returnField.asColumn}, #end #end #end ${voInfo.tableSimpleName}.id FROM ${table.name} ${voInfo.tableSimpleName} #foreach($field in ${refColumnList}) #if(${field.refType} == "OTO") INNER JOIN ${field.refTableName} ${field.refTableSimpleName} ON ${voInfo.tableSimpleName}.${field.columnName} = ${field.refTableSimpleName}.${field.refColumn} AND ${field.refTableSimpleName}.deleted = 0 #end #end WHERE ${voInfo.tableSimpleName}.id = #{id} AND ${voInfo.tableSimpleName}.deleted = 0 SELECT #foreach($field in ${voInfo.fields}) ${voInfo.tableSimpleName}.${field.columnName}, #end #foreach($field in ${refColumnList}) #if(${field.refType} == "OTO") #foreach($returnField in ${field.returnColumnList}) ${field.refTableSimpleName}.${returnField.column} as ${returnField.asColumn}, #end #end #end ${voInfo.tableSimpleName}.id FROM ${table.name} ${voInfo.tableSimpleName} #foreach($field in ${refColumnList}) #if(${field.refType} == "OTO") INNER JOIN ${field.refTableName} ${field.refTableSimpleName} ON ${voInfo.tableSimpleName}.${field.columnName} = ${field.refTableSimpleName}.${field.refColumn} AND ${field.refTableSimpleName}.deleted = 0 #end #end WHERE ${voInfo.tableSimpleName}.deleted = 0 #foreach($field in ${queryInfo.fields}) AND ${voInfo.tableSimpleName}.${field.columnName} = #{query.${field.propertyName}} #end