一個Hibernate多條件查詢的demo

          Posted on 2009-08-16 11:14 Robert Su 閱讀(660) 評論(0)  編輯  收藏 所屬分類: 工程相關
              public List findByInstance(IInsInfo instance) {
                  log.debug(
          "finding IInsInfo instances with given IInsInfo instance");
                  
          try {
                      Criteria crit 
          = getSession().createCriteria(instance.getClass());
                      Criterion iname 
          = null, gdfield = null, kind = null, property = null;
                      Conjunction conjunction 
          = Restrictions.conjunction();// 合取
                      
          //
                      if (instance.getIname() != null)
                          
          if (!instance.getIname().equals(null)) {
                              iname 
          = Restrictions.like("iname""%"
                                      
          + instance.getIname() + "%");
                              conjunction.add(iname);
                          }
                      
          if (instance.getGdfield() != null)
                          
          if (!instance.getGdfield().equals("")) {
                              gdfield 
          = Restrictions.eq("gdfield", instance.getGdfield());
                              conjunction.add(gdfield);
                          }
                      
          if (instance.getKind() != null)
                          
          if (!instance.getKind().equals("")) {
                              kind 
          = Restrictions.eq("kind", instance.getKind());
                              conjunction.add(kind);
                          }
                      
          if (instance.getProperty() != null)
                          
          if (!instance.getProperty().equals("")) {
                              property 
          = Restrictions.eq("property", instance
                                      .getProperty());
                              conjunction.add(property);
                          }

                      crit.add(conjunction);
                      
          return crit.list();
                  } 
          catch (RuntimeException re) {
                      log.error(
          "find by IInsInfo instance failed", re);
                      
          throw re;
                  }
              }

          posts - 103, comments - 104, trackbacks - 0, articles - 5

          Copyright © Robert Su

          主站蜘蛛池模板: 桃园市| 舞钢市| 洞口县| 新竹市| 宜都市| 红河县| 古蔺县| 辰溪县| 盐边县| 丁青县| 潢川县| 梅州市| 冀州市| 深水埗区| 华蓥市| 赤壁市| 永丰县| 宜春市| 弥渡县| 兖州市| 甘德县| 丽水市| 蕉岭县| 兴城市| 大余县| 独山县| 甘德县| 介休市| 平湖市| 花垣县| 那坡县| 阆中市| 通山县| 扶沟县| 平湖市| 行唐县| 垫江县| 东台市| 林口县| 新晃| 大姚县|