hibernate 多条件组合查询 之 sql 拼接

public static void main(String[] args) {

      

       Session session = null;

       Transaction tx = null;

       List list = null;

       Criteria criteria = null;

 

       try {

 

           session = HibernateSessionFactory.getSession();

           tx = session.beginTransaction();

 

           DetachedCriteria detachedCriteria = DetachedCriteria

                  .forClass(InfoTab.class);

          

          

           String sql=" 1=1 ";

          

           Integer pareaId = 0; // 父地区；

           Integer careaId = 0; // 子地区；

           Integer categoryId = 0; // 类别；

           String infoPrivider = "中介"; // 来源；

           String houseType= "地下室"; // 房屋类型；

           Integer hxBedRoom=0; // 室；

           Integer hxLivingRoom=0; // 厅；

          

           String hzHouseStatus="有房出租"; // 合租类型;

           String hzRequestSex="男"; // 性别要求；

           String fixUp="尚未"; // 装修程度;

           Integer lcHeightMolecuse=0; // 楼层；

           String orientation="东南"; // 朝向要求;

           Integer buildArea=2000; // 建筑面积；

           Integer useArea=80; // 使用面积；

           Integer rentalDigit=2000; // 租金/价格；

           String title= "出租"; // 标题；

          

           if(pareaId!=0)

           {

              sql+="pareaId=" + pareaId;

           }

           if(careaId!=0)

           {

              sql+=" and careaId=" + careaId;

           }

           if(categoryId!=0)

           {

              sql+=" and categoryId=" + categoryId;

           }

           if(!infoPrivider.equals(""))

           {

              sql+=" and infoPrivider='" + infoPrivider + "'";

           }

           if(!houseType.equals(""))

           {

              sql+=" and houseType='" + houseType +"'";

           }

           if(hxBedRoom!=0)

           {

              sql+=" and hxBedRoom=" + hxBedRoom;

           }

           if(hxLivingRoom!=0)

           {

              sql+=" and hxLivingRoom=" + hxLivingRoom;

           }

           if(!hzHouseStatus.equals(""))

           {

              sql+=" and hzHouseStatus='" + hzHouseStatus + "'";

           }

           if(!hzRequestSex.equals(""))

           {

              sql+=" and hzRequestSex='" + hzRequestSex +"'";

           }

           if(!fixUp.equals(""))

           {

              sql+=" and fixUp='" + fixUp + "'";

           }

           if(lcHeightMolecuse!=0)

           {

              sql+=" and lcHeightMolecuse=" + lcHeightMolecuse;

           }

           if(!orientation.equals(""))

           {

              sql+=" and orientation='" + orientation + "'";

           }

           if(buildArea!=0)

           {

               sql+=" and buildArea=" + buildArea;

           }

           if(useArea!=0)

           {

              sql+=" and useArea=" + useArea;

           }

           if(rentalDigit!=0)

           {

              sql+=" and rentalDigit=" + rentalDigit;

           }

           if(!title.equals(""))

           {

              sql+=" and title like '%" + title + "%'";

           }

           sql+=" order by id desc";

          

           System.out.println(sql);

 

           detachedCriteria.add(Restrictions.sqlRestriction(sql));

 

           criteria = detachedCriteria.getExecutableCriteria(session);

 

           list = criteria.list();

          

           for(int i=0;i<list.size();i++)

           {

              InfoTab infoTab = (InfoTab)list.get(i);

              System.out.println(infoTab.getTitle() +" "+ infoTab.getCategoryId() +" "+ infoTab.getPareaName() +" "+ infoTab.getCareaName() +" " + infoTab.getHouseType() +" " + infoTab.getInfoPrivider());

           }

 

           tx.commit();

 

       } catch (HibernateException he) {

           he.printStackTrace();

       }

    }