这个Hibernate模糊查询语句怎么写呢?

Question

这个模糊查询怎么写?  谢谢 .我这个写的不对啊.

Answer 1

countHql.append("select count(*) from Orders t where t.id>0");

Map<String, Object> param = new HashMap<String, Object>();

countHql.append(" and t.user.realname like :realname");

param.put("realname", "%" + realname + "%");