select * from t_user_attention t1 ,(select attention_user_id from t_user_attention where fans_id='250') t2 where t1.attention_user_id='226' and t1.fans_id=t2.attention_user_idQuery query = getSession().createQuery("咋写");
query.setParameter(0, 250);
query.setParameter(1, 226);t_user_attention 对应实体类为 Attention
query.setParameter(0, 250);
query.setParameter(1, 226);// 这种情况貌似应该用 createSQLQuery 这个方法。
先定义一个变量撒!Query query = getSession().createQuery("sql");
query.setParameter(0, 250);
query.setParameter(1, 226);
Query query = getSession().createQuery(hql);
query.setParameter("fansId", 250);
query.setParameter("userId ", 226);好了,楼主结贴给分吧
Query query = this.getSession().createSQLQuery(sql).setResultTransformer(Transformers.aliasToBean(client.class));
query.setFirstResult((pageNum - 1) * pageSize);
query.setMaxResults(pageSize);
List retList = query.list();