public static List borrowBook(String bookname) { Query query = HibernateSessionFactory.getSession().createQuery(
"from Book where bookname like '%'?'%'"); query.setString(0, bookname); List list = query.list(); return list;
}
模糊查询时出错,query.setString(0, bookname);和query.setString(0, "%" +bookname+ "%");我都试过!不行。
希望帅哥美女帮忙解决一下。
"from Book where bookname like '%'?'%'"); query.setString(0, bookname); List list = query.list(); return list;
}
模糊查询时出错,query.setString(0, bookname);和query.setString(0, "%" +bookname+ "%");我都试过!不行。
希望帅哥美女帮忙解决一下。
session.createQuery("from Book where bookname like '%"+OId+"%'");
"from Book where bookname like :bkname");query.setString("bkname", "%"+bookname+"%");
"from Book where bookname like '%'?'%'");query.setString(0, bookname);
要这样写:
Query query = HibernateSessionFactory.getSession().createQuery(
"from Book where bookname like ?");query.setString(0, "%"+ bookname + "%");
这样就OK了。
eg:
Criteria criteria = this.getSession(true).createCriteria(Book.class);
if (bookname != null) criteria.add(Expression.like("bookname ", bookname )); return criteria.list();
String hql="from Book where bookname like ?";楼主这样就OK了。
2楼,hibernate是从0开始的=。=