Question

SQL语言如何转换为HQL

select * from reps_res_SentimentWords t where t.name !='rrrr' and t.formula='rrr' and t.remark='rrrr'
转化为

DetachedCriteria dc = DetachedCriteria.forClass(SentimentWords.class);

if (word != null)
{
if (StringUtils.isNotBlank(word.getName()))
{
dc.add(Restrictions.like("name", word.getName(), MatchMode.ANYWHERE));
}if(StringUtils.isNotBlank(word.getFormula())){

dc.add(Restrictions.ne("formula", word.getName()));

}if(StringUtils.isNotBlank(word.getRemark())){

dc.add(Restrictions.ne("remark", word.getRemark()));

}

}
return dao.findByCriteria(dc);
sql 错了应该是

select * from reps_res_SentimentWords t where t.name ='rrrr' and t.formula='rrr' and t.remark='rrrr'

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励20（财富值+成长值）

Answer 1

if (word != null)
{
if (StringUtils.isNotBlank(word.getName()))
{
dc.add(Restrictions.ne("name", "rrrr"));
}if(StringUtils.isNotBlank(word.getFormula())){

dc.add(Restrictions.ne("formula","rrr"));

}if(StringUtils.isNotBlank(word.getRemark())){

dc.add(Restrictions.ne("remark","rrrr"));

}

}
DetachedCriteria.forClass(SentimentWords.class);
这个的意思是查询整表。
add加条件。Restrictions是条件这里面有很多条件方法。比如eq是equal也就是=。ne是not equal也就是!=,le是＜ ge是＞等等 很多

追问

3q