idea插件 easy code 模板

##定义初始变量
#set($tableName = $tool.append($tableInfo.name, "Dao"))
##设置回调
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/dao"))

##拿到主键
#if(!$tableInfo.pkColumn.isEmpty())
    #set($pk = $tableInfo.pkColumn.get(0))
#end

#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}dao;

import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
import org.apache.ibatis.annotations.Param;
import org.springframework.data.domain.Pageable;
import java.util.List;


public interface $!{tableName} {

    
    $!{tableInfo.name} queryById($!pk.shortType $!pk.name);

    
    List<$!{tableInfo.name}> selectByParam($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));


    
    int insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
    
     int insertSelect($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));

    
    int insertBatch(@Param("entities") List<$!{tableInfo.name}> entities);

 
    
    int update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));

    
    int deleteById($!pk.shortType $!pk.name);

}

##引入mybatis支持
$!{mybatisSupport.vm}

##设置保存名称与保存位置
$!callback.setFileName($tool.append($!{tableInfo.name}, "Dao.xml"))
$!callback.setSavePath($tool.append($modulePath, "/src/main/resources/mapper"))

##拿到主键
#if(!$tableInfo.pkColumn.isEmpty())
    #set($pk = $tableInfo.pkColumn.get(0))
#end





    
        #foreach($column in $tableInfo.fullColumn)
                
        #end
    
    
    
    #foreach($column in $tableInfo.fullColumn)
    
         and $!column.obj.name = #{$!column.name}
         
         #end
    
    
      
        #allSqlColumn()
      
    
    
        select
          
        from $!tableInfo.obj.name
        where $!pk.obj.name = #{$!pk.name}
    

    
    
        select
           

        from $!tableInfo.obj.name
        
            
        
    

    
    
        insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
        values (#foreach($column in $tableInfo.otherColumn)#{$!{column.name}}#if($velocityHasNext), #end#end)
    
    
    
        insert into $!{tableInfo.obj.name}
         
          #foreach($column in $tableInfo.otherColumn)
             
                            $!column.obj.name  ,
             
            #end
          
        
        values 
         
        #foreach($column in $tableInfo.otherColumn)
           
                            #{$!column.name},
            
            #end
        
    

    
        insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
        values
        
        (#foreach($column in $tableInfo.otherColumn)#{entity.$!{column.name}}#if($velocityHasNext), #end#end)
        
    

 

    
    
        update $!{tableInfo.obj.name}
        
            #foreach($column in $tableInfo.otherColumn)
                        
                            $!column.obj.name = #{$!column.name},
                        
            #end
        
        where $!pk.obj.name = #{$!pk.name}
    

    
    
        delete from $!{tableInfo.obj.name} where $!pk.obj.name = #{$!pk.name}