#foreach($column in $columns)
#if($column.lowerAttrName==$pk.lowerAttrName)
#else
#end
#end
#foreach($column in $columns)
#if($foreach.count==$!{columns.size()})
a.${column.columnName}
#else
a.${column.columnName},
#end
#end
#foreach($column in $columns)
#if($column.attrType=='String')
AND a.${column.columnName} = #{${classname}.$column.lowerAttrName}
#elseif($column.attrType=='char')
AND a.${column.columnName} = #{${classname}.$column.lowerAttrName}
#else
AND a.${column.columnName} = #{${classname}.$column.lowerAttrName}
#end
#end