hibernate查询SQL语句返回自定义实体对象

最新推荐文章于 2022-08-18 15:36:03 发布

小雅妹子

最新推荐文章于 2022-08-18 15:36:03 发布

阅读量765

点赞数

本文链接：https://blog.csdn.net/u014311042/article/details/41839579

版权

[1].[代码] [Java]代码跳至 [1] [2]

 
         public 
          <T> List<T> queryBySql(String sql, Class<T> clzz) { 
        
         SQLQuery sqlQuery = getSession().createSQLQuery(sql.toString()); 
        
         sqlQuery.setResultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP); 
        
         @SuppressWarnings 
         ( 
         "unchecked" 
         ) 
        
         List<Map<String, Object>> list = (List<Map<String, Object>>) sqlQuery 
        
         .list(); 
        
         List<T> result =  
         new 
          ArrayList<T>(); 
        
         try 
          { 
        
         PropertyDescriptor[] props = Introspector.getBeanInfo(clzz) 
        
         .getPropertyDescriptors(); 
        
         for 
          (Map<String, Object> map : list) { 
        
         T t = clzz.newInstance(); 
        
         for 
          (Entry<String, Object> entry : map.entrySet()) { 
        
         String attrName = entry.getKey().toLowerCase(); 
        
         for 
          (PropertyDescriptor prop : props) { 
        
         if 
          (!attrName.equals(prop.getName())) { 
        
         continue 
         ; 
        
         } 
        
         Method method = prop.getWriteMethod(); 
        
         method.invoke(t, entry.getValue()); 
        
         } 
        
         } 
        
         result.add(t); 
        
         } 
        
         }  
         catch 
          (Exception e) { 
        
         e.printStackTrace(); 
        
         } 
        
         return 
          result; 
        
         }

[2].[代码] [Java]代码跳至 [1] [2]

 
         @Override 
        
         public 
          List<PsndocInfo> getAllPsndocList() { 
        
         StringBuilder sql =  
         new 
          StringBuilder(); 
        
         sql.append( 
         "\n" 
         ); 
        
         sql.append( 
         "SELECT doc.pk_org, org.name orgname, org.code orgcode, doc.name psnname, doc.code psncode,doc.enablestate\n" 
         ); 
        
         sql.append( 
         "  FROM bd_psndoc doc\n" 
         ); 
        
         sql.append( 
         " inner join org_orgs org\n" 
         ); 
        
         sql.append( 
         "    on doc.pk_org = org.pk_org" 
         ); 
        
         return 
          super 
         .queryBySql(sql.toString(), PsndocInfo. 
         class 
         ); 
        
         }