#parse("vms/$version/common/variable/head.vm") #parse("vms/$version/common/comment/XmlDesc.vm") #set($Y='`') #* 不用标签 有利于保护代码 避免因null导致清库 获取全量更新 *# ##id必须在最前面 否则编译不通过 #foreach( $node in $nodeList) #if($node.dbField.dbPriorityKey) #end #end ##result必须在id后面 #foreach( $node in $nodeList) #if(!$node.dbField.dbPriorityKey) #end #end select from where 1=1 select from select from where 1=1 select from where ${Y}$dbPriorityKeySqlField${Y} in #{id} select count(1) from where 1=1 insert into () values() replace into () values() insert into () values() replace into () values() insert into () values () replace into () values () insert into () values () replace into () values () -- truncate table delete from delete from where 1=1 #if($hasDbPriorityKey) delete from where ${Y}$dbPriorityKeySqlField${Y} in #{id} #end update update update update #foreach( $node in $nodeList) #parse("vms/$version/common/util/douHao.vm") ${Y}$node.dbField.dbRealName${Y}#if($douHao),#end #end #foreach( $node in $nodeList) #parse("vms/$version/common/util/douHao.vm") ${Y}$node.dbField.dbRealName${Y}#if($douHao),#end #end #*单表sql mysql十分强大 如果主键null 它会自动使用自增 *# #foreach($node in $nodeList) #if($node.dbField.dbPriorityKey) ${Y}$node.dbField.dbRealName${Y}, #else${Y}$node.dbField.dbRealName${Y},#end #end #foreach( $node in $nodeList) #{$node.dbField.javaField#if($CreateVmUtil.isTimestemp($node.dbField.javaType)),jdbcType=TIMESTAMP#end},#if(!$node.dbField.dbPriorityKey)NULL,#end #end #foreach($node in $nodeList) ${Y}$node.dbField.dbRealName${Y}, #end #foreach( $node in $nodeList) #{$node.dbField.javaField#if($CreateVmUtil.isTimestemp($node.dbField.javaType)),jdbcType=TIMESTAMP#end}, #end #*批量sql 暂时无法得知主键策略 先按数据库自增处理 *# #foreach($node in $nodeList) #if($node.dbField.dbPriorityKey) ${Y}$node.dbField.dbRealName${Y}, #else${Y}$node.dbField.dbRealName${Y},#end #end #foreach( $node in $nodeList) #{item.$node.dbField.javaField#if($CreateVmUtil.isTimestemp($node.dbField.javaType)),jdbcType=TIMESTAMP#end},#if(!$node.dbField.dbPriorityKey)NULL,#end #end #foreach($node in $nodeList) ${Y}$node.dbField.dbRealName${Y}, #end #foreach( $node in $nodeList) #{item.$node.dbField.javaField#if($CreateVmUtil.isTimestemp($node.dbField.javaType)),jdbcType=TIMESTAMP#end}, #end #foreach( $node in $nodeList) #if(!$node.dbField.dbPriorityKey) ${Y}${node.dbField.dbRealName}${Y}=#{$node.dbField.javaField#if($CreateVmUtil.isTimestemp($node.dbField.javaType)),jdbcType=TIMESTAMP#end} ${Y}${node.dbField.dbRealName}${Y}=NULL , #end #end #foreach( $node in $nodeList) #if(!$node.dbField.dbPriorityKey) ${Y}${node.dbField.dbRealName}${Y}=#{$node.dbField.javaField#if($CreateVmUtil.isTimestemp($node.dbField.javaType)),jdbcType=TIMESTAMP#end}, #end #end where 1=1 ##普通查询属性 #if($hasDbPriorityKey) and ${Y}$dbPriorityKeySqlField${Y} = #{magicalCoderPrimaryKeyName} #elseif($hasDbUniqueNodes) #foreach($uniqueNode in $dbUniqueNodes) and ${Y}$uniqueNode.dbField.dbRealName${Y} = #{magicalCoderPrimaryKeyName} #end #end where 1=1 #if($hasDbPriorityKey) and ${Y}$dbPriorityKeySqlField${Y} = #{$dbPriorityKeyJavaField} #elseif($hasDbUniqueNodes) #foreach($uniqueNode in $dbUniqueNodes) and ${Y}$uniqueNode.dbField.dbRealName${Y} = #{$uniqueNode.dbField.javaField} #end #end #foreach( $node in $nodeList) #if(!$node.dbField.dbPriorityKey) ${Y}${node.dbField.dbRealName}${Y}=#{item.$node.dbField.javaField#if($CreateVmUtil.isTimestemp($node.dbField.javaType)),jdbcType=TIMESTAMP#end} ${Y}${node.dbField.dbRealName}${Y}=NULL , #end #end #foreach( $node in $nodeList) #if(!$node.dbField.dbPriorityKey) ${Y}${node.dbField.dbRealName}${Y}=#{item.$node.dbField.javaField#if($CreateVmUtil.isTimestemp($node.dbField.javaType)),jdbcType=TIMESTAMP#end}, #end #end where 1=1 #if($hasDbPriorityKey) and ${Y}$dbPriorityKeySqlField${Y} = #{item.$dbPriorityKeyJavaField} #elseif($hasDbUniqueNodes) #foreach($uniqueNode in $dbUniqueNodes) and ${Y}$uniqueNode.dbField.dbRealName${Y} = #{item.$uniqueNode.dbField.javaField} #end #end ${databaseRealName}.${tableRealName} ##普通查询属性 #foreach( $node in $nodeList) #if($CreateVmUtil.isTimestemp($node.dbField.javaType)) and ${Y}$node.dbField.dbRealName${Y} = #{$node.dbField.javaField,jdbcType=TIMESTAMP} #else and ${Y}$node.dbField.dbRealName${Y} = #{$node.dbField.javaField} #end #end #parse("vms/$version/sql/include/query/where.vm") group by #foreach( $node in $nodeList) ${Y}$node.dbField.dbRealName${Y} #end #foreach( $node in $nodeList) order by ${Y}$node.dbField.dbRealName${Y} desc order by ${Y}$node.dbField.dbRealName${Y} asc #end group by ${notSafeGroupBy} order by ${notSafeOrderBy} LIMIT #{start},#{limit}