关于Hibernate的离线查询.

[wawqysys1314]

DetachedCriteria 离线查询如何写子查询呢? 我的sql是这样.
select user_id from meeting_register where user_id not in(select user_id from meeting_signin)

用离线的话需要怎么样写呢?

[花谢尊前不敢香]

DetachedCriteria dc=DetachedCriteria.forClass(User.class); 
String user_id=request.getParameter("user_id");
dc.add(Restrictions.eq("user_id",user_id)); 
List users=dc(dc);
 
public List dc(DetachedCriteria dc){ 
        Session s=HibernateUtil.getSession();//取得session 
        Criteria c=dc.getExecutableCriteria(s); 
        List list=c.list(); 
        s.close(); 
        return list; 
    } 

就是从session中查询

[wawqysys1314]

引用 1 楼 fangmingshijie 的回复:

Java code?123456789101112DetachedCriteria dc=DetachedCriteria.forClass(User.class); String user_id=request.getParameter("user_id");dc.add(Restrictions.eq("user_id",user_id)); List users=d……

我们的项目框架是在service层查询, 不操作session怎么办呢?