1. 首先，和Spring整合一下

2. 接下来是mybatis增删改查的模板

       
         
          
          
              
               
               
               
               
               
           
          
          
              select id, name, description, img_url, sort, is_display        from bbs_brand                                    name = #{name}                                        and is_display = #{isDisplay}                            order by id desc        limit #{startRow},#{pageSize}        
          
              select count(1)        from bbs_brand                                    is_display = #{isDisplay}                                        and name = #{name}                             
          
      
               insert into bbs_brand        
       
                    name,            description,            img_url,            sort,            is_display        
               values        
       
                    #{name},            #{description},            #{imgUrl},            #{sort},            #{isDisplay}        
           
           
          
      
               delete from bbs_brand         
       
                    id=#{id}        
           
              
          
      
               delete from bbs_brand        
       
                    id in            
        
                         #{id}            
                
           
              
          
      
               update bbs_brand        
                   
        
                         name = #{name},            
                    
        
                         description = #{description},            
                    
        
                         img_url = #{imgUrl},            
                    
        
                         sort = #{sort},            
                    
        
                         is_display = #{isDisplay}            
                
               
       
                    id=#{id}        
           
              
          
              select id, name, description, img_url, sort, is_display        from bbs_brand                    id=#{id}