hibernate的find语句可以这样写吗?
来源:百度知道 编辑:UC知道 时间:2024/06/17 14:06:36
我想模糊查询书的题目, 可以这样写吗?
public List<Book> getBrowseTitle(String t){
String sql ="SELECT * FROM Book where (title like like'% t %')";
List list = this.getHibernateTemplate().find(sql);
return list;
}
public List<Book> getBrowseTitle(String t){
String sql ="SELECT * FROM Book where (title like like'% t %')";
List list = this.getHibernateTemplate().find(sql);
return list;
}
String hsql = "from Book b where b.title like ?";
list = getHibernateTemplate().find(hsql, '%' + t + '%');
这样写可以:
List list=t.execQuery("from Book where (title like like'% t %')");
Book n=new Book();
for(Iterator<Book> pit=list.iterator();pit.hasNext();){
n=(Book)pit.next();
System.out.println(n.getDescription());
}