---
title: "Hibernate DetachedCriteria 查询set 类型的字段"
author: "demojava"
date: "2011-01-04T09:48:36Z"
tags: []
categories: ["企业架构"]
slug: "hibernate-detachedcriteria-set"
draft: false
lastmod: "2011-08-07T16:23:49Z"
id: 858365
url: "https://demojava.iteye.com/blog/858365"
---

### [Hibernate DetachedCriteria 查询set 类型的字段](/problems/56648)

#### 例： public class Users { private Set challenges = new HashSet(0); } public class Challenge { private Integer challengeid; private Users users; } User 和Challenge  是一对多的关系 现在想根据 Users  中的challenges.challengeid的某一个属性查询 challenges 是一个属性 &lt;script type="text/javascript"&gt;&lt;/script&gt;

### DetachedCriteria detachedCriteria=DetachedCriteria.forClass("Users"); detachedCriteria.createAlias("challenges","c").add(Restrictions.eq("c.challengeid", "查询值")); Java代码 [![复制代码](http://www.iteye.com/images/icon_copy.gif)](http://www.iteye.com/problems/56648 "复制代码")

1. DetachedCriteria detachedCriteria=DetachedCriteria.forClass("Users");
2. detachedCriteria.createAlias("challenges","c").add(Restrictions.eq("c.challengeid", "查询值"));

```
DetachedCriteria detachedCriteria=DetachedCriteria.forClass("Users");
detachedCriteria.createAlias("challenges","c").add(Restrictions.eq("c.challengeid", "查询值"));
```

我查询的网页:  
[http://topic.csdn.net/u/20090616/10/3e8d5f18-7144-4248-85a4-41bf5c4e3903.html](http://topic.csdn.net/u/20090616/10/3e8d5f18-7144-4248-85a4-41bf5c4e3903.html)

[http://stackoverflow.com/questions/1987471/nhibernate-exclude-a-property-from-a-projection-list-select-clause](http://stackoverflow.com/questions/1987471/nhibernate-exclude-a-property-from-a-projection-list-select-clause)

[http://topic.csdn.net/u/20080225/13/9eb2fbf7-117b-41f4-84d6-4b5461780388.html](http://topic.csdn.net/u/20080225/13/9eb2fbf7-117b-41f4-84d6-4b5461780388.html)

希望能帮助你

1、Users实体

Java代码 [![复制代码](http://www.iteye.com/images/icon_copy.gif)](http://www.iteye.com/problems/56648 "复制代码")

1. **public** **class** Users **implements** java.io.Serializable {
2. // Fields
3. **private** Long id;
4. **private** String userName;
5. **private** Set challenges = **new** HashSet(0);
6. ......
7. }

```
public class Users implements java.io.Serializable {

	// Fields

	private Long id;
	private String userName;
	private Set challenges = new HashSet(0);

    ......

}
```

表记录：  
id  user\_name  
1 小明  
2 小强

2、Challenge实体

Java代码 [![复制代码](http://www.iteye.com/images/icon_copy.gif)](http://www.iteye.com/problems/56648 "复制代码")

1. **public** **class** Challenge **implements** java.io.Serializable {
2. // Fields
3. **private** Long challengeid;
4. **private** Users users;
5. **private** String challengeName;
6. ......
7. }

```
public class Challenge implements java.io.Serializable {

	// Fields

	private Long challengeid;
	private Users users;
	private String challengeName;

    ......

}
```

表记录：  
id challenge\_name user\_id  
1       挑战1      1  
2       挑战2      1  
3       挑战3      2

3、根据challengeid查询Challenge对象，再关联出相应的users信息

Java代码 [![复制代码](http://www.iteye.com/images/icon_copy.gif)](http://www.iteye.com/problems/56648 "复制代码")

01. // 查询条件
02. DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Challenge.**class**);
03. detachedCriteria.add(Restrictions.eq("challengeid", **new** Long(1)));
04. Criteria criteria = detachedCriteria.getExecutableCriteria(session);
05. // 查询
06. List resultList = criteria.list();
07. **if** (resultList != **null** && resultList.size() &gt; 0) {
08. **for** (**int** i = 0; i &lt; resultList.size(); i++) {
09. Challenge challenge = (Challenge) resultList.get(i);
10. // 打印出challenge所关联的users信息
11. System.out.println(challenge.getUsers().getUserName());
12. }
13. }

```
// 查询条件
DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Challenge.class);
detachedCriteria.add(Restrictions.eq("challengeid", new Long(1)));
Criteria criteria = detachedCriteria.getExecutableCriteria(session);

// 查询
List resultList = criteria.list();
if (resultList != null && resultList.size() > 0) {
    for (int i = 0; i < resultList.size(); i++) {
        Challenge challenge = (Challenge) resultList.get(i);
        // 打印出challenge所关联的users信息
        System.out.println(challenge.getUsers().getUserName());
    }
}
```

结果输出：  
小明

4、根据challengeName模糊查询查询Challenge对象，再关联出相应的users信息

Java代码 [![复制代码](http://www.iteye.com/images/icon_copy.gif)](http://www.iteye.com/problems/56648 "复制代码")

01. // 查询条件
02. DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Challenge.**class**);
03. detachedCriteria.add(Restrictions.like("challengeName", "%" + "挑战" + "%"));
04. Criteria criteria = detachedCriteria.getExecutableCriteria(session);
05. // 查询
06. List resultList = criteria.list();
07. **if** (resultList != **null** && resultList.size() &gt; 0) {
08. **for** (**int** i = 0; i &lt; resultList.size(); i++) {
09. Challenge challenge = (Challenge) resultList.get(i);
10. // 打印出challenge所关联的users信息
11. System.out.println(challenge.getUsers().getUserName());
12. }
13. }

```
// 查询条件
DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Challenge.class);
detachedCriteria.add(Restrictions.like("challengeName", "%" + "挑战" + "%"));
Criteria criteria = detachedCriteria.getExecutableCriteria(session);

// 查询
List resultList = criteria.list();
if (resultList != null && resultList.size() > 0) {
    for (int i = 0; i < resultList.size(); i++) {
        Challenge challenge = (Challenge) resultList.get(i);
        // 打印出challenge所关联的users信息
        System.out.println(challenge.getUsers().getUserName());
    }
}
```

结果输出：  
小明  
小明  
小强

5、根据users查询，查询小明对应的所有Challenge信息

Java代码 [![复制代码](http://www.iteye.com/images/icon_copy.gif)](http://www.iteye.com/problems/56648 "复制代码")

01. // 查询条件
02. DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Users.**class**);
03. detachedCriteria.add(Restrictions.eq("userName", "小明"));
04. Criteria criteria = detachedCriteria.getExecutableCriteria(session);
05. // 查询
06. List resultList = criteria.list();
07. **if** (resultList != **null** && resultList.size() &gt; 0) {
08. Set set = ((Users) resultList.get(0)).getChallenges();
09. // 循环打印出小明对应的所有Challenge信息
10. **for** (Iterator it = set.iterator(); it.hasNext();) {
11. Challenge challenge = (Challenge) it.next();
12. System.out.println(challenge.getChallengeName());
13. }
14. }

```
// 查询条件
DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Users.class);
detachedCriteria.add(Restrictions.eq("userName", "小明"));
Criteria criteria = detachedCriteria.getExecutableCriteria(session);

// 查询
List resultList = criteria.list();
if (resultList != null && resultList.size() > 0) {
    Set set = ((Users) resultList.get(0)).getChallenges();
    // 循环打印出小明对应的所有Challenge信息
    for (Iterator it = set.iterator(); it.hasNext();) {
        Challenge challenge = (Challenge) it.next();
        System.out.println(challenge.getChallengeName());
    }
}
```

结果输出：  
挑战2  
挑战1

Java代码 [![复制代码](http://www.iteye.com/images/icon_copy.gif)](http://www.iteye.com/problems/56648 "复制代码")

01. // 查询条件
02. DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Users.**class**);
03. detachedCriteria.createAlias("challenges", "cs");
04. detachedCriteria.add(Restrictions.like("cs.challengeName", "%" + "挑战" + "%"));
05. Criteria criteria = detachedCriteria.getExecutableCriteria(session);
06. // 查询
07. List resultList = criteria.list();
08. **if** (resultList != **null** && resultList.size() &gt; 0) {
09. **for** (**int** i = 0; i &lt; resultList.size(); i++) {
10. Users user = (Users) resultList.get(i);
11. System.out.println(user.getUserName());
12. }
13. }

```
// 查询条件
DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Users.class);
detachedCriteria.createAlias("challenges", "cs");
detachedCriteria.add(Restrictions.like("cs.challengeName", "%" + "挑战" + "%"));
Criteria criteria = detachedCriteria.getExecutableCriteria(session);

// 查询
List resultList = criteria.list();
if (resultList != null && resultList.size() > 0) {
    for (int i = 0; i < resultList.size(); i++) {
        Users user = (Users) resultList.get(i);
        System.out.println(user.getUserName());
    }
}
```

输出结果：  
小明  
小明  
小强

重复结果可以再过滤，这个应该是你想要的查询方式

7、为了避免resultList中的重复记录, 可以转换为Set集合, Set中存放的记录不允许相同。  
以下是对第6的结果进行去重复记录

Java代码 [![复制代码](http://www.iteye.com/images/icon_copy.gif)](http://www.iteye.com/problems/56648 "复制代码")

01. Set resultSet = **new** HashSet();
02. // 添加以后自动去掉重复记录
03. resultSet.addAll(resultList);
04. // 循环打印出小明对应的所有Challenge信息
05. **for** (Iterator it = resultSet.iterator(); it.hasNext();) {
06. Users user = (Users) it.next();
07. System.out.println(user.getUserName());
08. }
09. ```
    <hibernate-mapping>
      <class table="table1">
        <set name="table2" table="table2" lazy="true" cascade="all">
          <key column="result_id"/>
          <many-to-many column="group_id"/>
        </set>
      </class>
    </hibernate-mapping>
    ```
10. ```
    select t2.property1, t2.property2, ... 
        from table1 as t1
        inner join t1.table2 as t2
    select t1.table2.property1, t1.table2.property2, ... from table1 as t1
    
    ```