一個Hibernate多條件查詢的demo

          Posted on 2009-08-16 11:14 Robert Su 閱讀(664) 評論(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

          主站蜘蛛池模板: 江永县| 中方县| 青神县| 昌吉市| 桂平市| 团风县| 天祝| 文成县| 宁波市| 九寨沟县| 视频| 榕江县| 秦皇岛市| 凤城市| 滨州市| 通山县| 赤壁市| 怀来县| 沽源县| 博白县| 嘉定区| 河间市| 吉首市| 林州市| 太湖县| 普兰县| 勐海县| 海阳市| 舒兰市| 县级市| 惠水县| 大兴区| 芒康县| 洞头县| 翁源县| 巫溪县| 习水县| 巧家县| 连江县| 磐石市| 青田县|