• Home
• com.github.ibole
• infrastructure-support
• 1.10.0
• source code
• ibatis.ftl

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

templates.ibatis.ftl Maven / Gradle / Ivy

  
  	
  	
  		<#list  model.cols as prop>
  			${prop.colName}<#if prop_has_next>,
  		
  	
  	
  		select  from ${model.tableName}
  	
  	
  	
  		select  
  		 from
  		${model.tableName}
  		<#list model.cols as col>
  			<#if col.isPk>
  				
  			     ${col.colName} = ${r'#{'}${col.fieldName}${r'}'}
  			    
  			
  		
  	
  	
  		delete from ${model.tableName} 
  		<#list model.cols as col>
  			<#if col.isPk>
  				
  			     ${col.colName} = ${r'#{'}${col.fieldName}${r'}'}
  			    
  			
  		
  	
  	
  		insert into ${model.tableName} 
  		(
  			<#list model.cols as col>
  				${col.colName}<#if col_has_next>,
  			
  		)
  		values
  		(
  			<#list model.cols as col>
  				${r'#{'}${col.fieldName}${r'}'}<#if col_has_next>,
  			
  		)
  	
  	
  		update ${model.tableName} 
  		
  			<#list model.cols as col>
  				<#if !col.isPk>
  					
  					${col.colName}=${r'#{'}${col.fieldName}${r'}'}<#if col_has_next>,
  					
  				
  			
  		
  		where
  		    <#list model.cols as col>
  		    	<#list model.pks as pk>
  		    		<#if col.colName = pk>${col.colName}=${r'#{'}${col.fieldName}${r'}'}<#if pk_has_next> and 
  		    	
  		    
  	
  	
  		select  
  		 from
  		${model.tableName}
  		
  		<#list model.cols as col>
  			
	  		
	  			<#assign operator="="/>
	  			<#assign percentpre=""/>
	  			<#assign percentpos=""/>
	  			<#if col.jdbcType = "java.lang.String" && !col.isPk>
	  				<#assign operator="like"/>
	  				<#assign percentpre="concat('%',"/>
	  				<#assign percentpos=",'%')"/>
	  			
	  			<#if col_index != 0> and ${col.colName} ${operator} ${percentpre}${r'#{'}${col.fieldName}${r'}'}${percentpos}