配置hessian:

或者是Model的全路径:

     
          
              
               
               
               
               
               
               
           
              
              
               
           
              
          
      
               select *        from (select row_.*, rownum rownum_        from (    
          
          
      
               ) row_        where 1=1        
                           
               )        where 1=1        
                   = #{startRow}             ]]>        
           
          
          
                      select             t.catalog_brand_id,           t.pro_catalog_id,           t.product_brand_name,           t.product_brand_img,           t.product_brand_url,           l.pro_catalog_name,           t.catalog_brand_order        from hwg_catalog_brand t inner join product_catalog l on  l.pro_catalog_id =t.pro_catalog_id                      t.is_delete = 'N'                               and t.PRODUCT_BRAND_NAME like '%'||#{productBrandName}||'%'                                           and t.PRO_CATALOG_ID =#{proCatalogId}                             order by t.ADD_TIME desc                
          
              select count(1) from hwg_catalog_brand t                      t.is_delete = 'N'                               and t.PRODUCT_BRAND_NAME like '%'||#{productBrandName}||'%'                                           and t.PRO_CATALOG_ID =#{proCatalogId}                                 
          
              select t.catalog_brand_id,           t.pro_catalog_id,           t.product_brand_name,           t.product_brand_img,           t.product_brand_url,           t.catalog_brand_order        from hwg_catalog_brand t where t.catalog_brand_id = #{catalogBrandId}        
          
              select t.catalog_brand_id,        t.pro_catalog_id,        t.product_brand_name,        t.product_brand_img,        t.product_brand_url,        t.catalog_brand_order        from hwg_catalog_brand t where t.PRO_CATALOG_ID = #{proCatalogId} AND t.is_delete='N'        ORDER BY t.CATALOG_BRAND_ORDER        
          
              
       
                    SELECT HWG_CATALOG_BRAND_ID_SEQ.nextval from dual        
               insert into HWG_CATALOG_BRAND        
       
                    CATALOG_BRAND_ID,            
        
                         PRO_CATALOG_ID,            
                    
        
                         PRODUCT_BRAND_NAME,            
                    
        
                         PRODUCT_BRAND_IMG,            
                    
        
                         PRODUCT_BRAND_URL,            
                     
        
                         catalog_brand_order,            
                    
        
                         ADD_USER_ID,            
                    
        
                         EDIT_TIME,            
                    
        
                         ADD_TIME,            
                    
        
                         EDIT_USER_ID,            
                
               
       
                    #{catalogBrandId,jdbcType=NUMERIC},            
        
                         #{proCatalogId,jdbcType=NUMERIC},            
                    
        
                         #{productBrandName,jdbcType=VARCHAR},            
                    
        
                         #{productBrandImg,jdbcType=VARCHAR},            
                    
        
                         #{productBrandUrl,jdbcType=VARCHAR},            
                    
        
                         #{catalogBrandOrder,jdbcType=NUMERIC},            
                    
        
                         #{addUserId,jdbcType=NUMERIC},            
                    
        
                         #{editTime,jdbcType=VARCHAR},            
                    
        
                         #{addTime,jdbcType=VARCHAR},            
                    
        
                         #{editUserId,jdbcType=NUMERIC},            
                
           
          
          
      
               update HWG_CATALOG_BRAND        
                   
        
                         PRO_CATALOG_ID =#{proCatalogId,jdbcType=NUMERIC},            
                    
        
                         PRODUCT_BRAND_NAME = #{productBrandName,jdbcType=VARCHAR},            
                    
        
                         PRODUCT_BRAND_IMG = #{productBrandImg,jdbcType=VARCHAR},            
                    
        
                         PRODUCT_BRAND_URL = #{productBrandUrl,jdbcType=VARCHAR},            
                    
        
                         CATALOG_BRAND_ORDER = #{catalogBrandOrder,jdbcType=NUMERIC},            
                    
        
                         ADD_USER_ID = #{addUserId,jdbcType=NUMERIC},            
                    
        
                         ADD_TIME = #{addTime,jdbcType=VARCHAR},            
                    
        
                         EDIT_USER_ID = #{editUserId,jdbcType=NUMERIC},            
                    
        
                         EDIT_TIME = #{editTime,jdbcType=VARCHAR},            
                    
        
                         IS_DELETE = #{isDelete,jdbcType=VARCHAR}            
                
               where catalog_brand_id = #{catalogBrandId,jdbcType=NUMERIC}    
          
          
      
               update HWG_CATALOG_BRAND set IS_DELETE='Y' where catalog_brand_id        in        
       
                    #{item, jdbcType=NUMERIC}        
             
                      
            select c.PRO_CATALOG_ID ,c.PRO_CATALOG_NAME       from PRODUCT_CATALOG c       where c.PRO_PARENT_CATALOG IN       (select c.PRO_CATALOG_ID       from PRODUCT_CATALOG c,PRODUCT_CATALOG_AUTH a       where a.PRO_CATALOG_ID=c.PRO_CATALOG_ID       and c.IS_DELETE='N' and c.PRO_CATALOG_LEVEL=0      and a.AUTH_TYPE=#{value})                  
            
              select           hc.category_id as categoryId, hc.category_name as categoryName        from           hwg_category hc         where           hc.is_delete='N'        order by          hc.category_order