• Home
• net.oschina.durcframework
• easymybatis
• 1.3.5
• source code
• microsoftsqlserver.vm

×

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.

easymybatis.tpl.microsoftsqlserver.vm Maven / Gradle / Ivy

#set($jq="$")



    
    #foreach($column in $allColumns)
        
    #end
    
    
    
    
    	#set ($i=0) 
        #foreach($column in $columns)
        	#if($i > 0),#end t.[${column.columnName}]
			#set($i=$i +1)             
        #end
    
    
    
    
		SELECT
			
		FROM ${table.tableName} t
		  
		
		
		
	

	
	
		
			SELECT t0.* FROM (
		
		SELECT row_number() over(
			
				ORDER BY ${jq}{order}
				ORDER BY [${pk.columnName}]
			
		) row,
                
       
        
		FROM ${table.tableName} t
		
 		
			) t0 WHERE t0.row BETWEEN (#{start,jdbcType=INTEGER} +1) AND
			(#{start,jdbcType=INTEGER}  + #{limit,jdbcType=INTEGER})
		
	

	
    
		SELECT count(*) FROM [${table.tableName}] t
		
    

	
    
		SELECT 	TOP 1
       		
		FROM [${table.tableName}] t
		WHERE [${pk.columnName}] = #{${pk.javaFieldName}}
	

	
    
		SELECT TOP 1
						
		FROM [${table.tableName}] t
		
		
	

	
	
		SELECT TOP 1
			
		FROM ${table.tableName} t
		WHERE t.[${jq}{column}] = #{value}
	
	
	
	
		SELECT
			
		FROM [${table.tableName}] t
		WHERE t.[${jq}{column}] = #{value}
	

	
    
    #if(${pk.isUuid})
	
            SELECT NEWID()
    
#end
	INSERT INTO [${table.tableName}]
         (
 #set ($i=0) 
        #foreach($column in $columns) 
            #if(!${column.isIdentityPk})               
        #if($i > 0),#end [${column.columnName}]
#set($i=$i +1)
            #end          
        #end
          )
	VALUES (
 #set ($i=0) 
        #foreach($column in $columns) 
            #if(!${column.isIdentityPk})               
        #if($i > 0),#end ${column.mybatisInsertValue}
#set($i=$i +1)
            #end          
        #end
 
        )
	
    
    
    
         #if(${pk.isUuid})
	
            SELECT NEWID()
    
#end
        INSERT INTO [${table.tableName}]
    
        	 

            #foreach($column in $columns) 
                #if(!${column.isIdentityPk}) 
                    
                   [${column.columnName}],
                    
                #end          
            #end
        
                    
            #foreach($column in $columns) 
                #if(!${column.isIdentityPk})  
                    
                    ${column.mybatisInsertValue},                    
                    
                #end          
            #end
        
    
    
    
    
		INSERT INTO [${table.tableName}] 
		(
 #set ($i=0) 
        #foreach($column in $columns) 
            #if(!${column.isIdentityPk})               
        #if($i > 0),#end [${column.columnName}]
#set($i=$i +1)
            #end          
        #end
          )
		VALUES 
		
        ( #set ($i=0)
        #foreach($column in $columns) 
            #if(!${column.isIdentityPk})               
         	#if($i > 0),#end ${column.mybatisInsertValuePrefix}
         	#set($i=$i +1)
            #end          
        #end
        )
		
	
	
	
    
		INSERT INTO [${table.tableName}]
		
			${jq}{column.columnName}
		
		VALUES 
		
        ( 
        	
        		#{entity.${column.alias} ${column.typeHandler}}
        	
        )
        
	
	
	 
    
		INSERT INTO [${table.tableName}] 
		(
 #set ($i=0) 
        #foreach($column in $columns) 
            #if(!${column.isIdentityPk})               
        #if($i > 0),#end [${column.columnName}]
#set($i=$i +1)
            #end          
        #end
          )
		
        SELECT  #set ($i=0)
        #foreach($column in $columns) 
            #if(!${column.isIdentityPk})               
         	#if($i > 0),#end ${column.mybatisInsertValuePrefix}
         	#set($i=$i +1)
            #end          
        #end        
		
	
	
	
    
		INSERT INTO [${table.tableName}]
		
			[${jq}{column.columnName}]
		
		
        SELECT  
        	
        		#{entity.${column.alias} ${column.typeHandler}}
        	
        
	

	
    
    UPDATE [${table.tableName}]
     		
     #foreach($column in $columns) 
         #if(!${column.isPk})               
         [${column.columnName}]=${column.mybatisUpdateValue},        
         #end          
     #end
     	
    WHERE [${pk.columnName}] = #{${pk.javaFieldName}}
    
    
    
    
    UPDATE [${table.tableName}]
    
    	#foreach($column in $columns) 
            #if(!${column.isPk})  
                
                [${column.columnName}]=${column.mybatisUpdateValue},                 
                
            #end          
        #end
    
    WHERE [${pk.columnName}] = #{${pk.javaFieldName}}
    
    
    
    
    UPDATE [${table.tableName}]
    
    	#foreach($column in $columns) 
            #if(!${column.isPk})  
                
                [${column.columnName}]=${column.mybatisUpdateValuePrefix},                 
                
            #end          
        #end
    
    
       
    
	
	
	
		DELETE FROM [${table.tableName}]
		WHERE [${pk.columnName}] = #{${pk.javaFieldName}}
	    
    
    
    
		DELETE FROM [${table.tableName}]