hibernate hql拼接语句几种方式，模糊查询

最新推荐文章于 2022-09-02 15:13:50 发布

shiwjlolo

最新推荐文章于 2022-09-02 15:13:50 发布

阅读量828

点赞数

分类专栏： j2ee 文章标签： Hibernate Java

本文链接：https://blog.csdn.net/shiwjlolo/article/details/83396016

版权

j2ee 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

1: OID is param


    String strSQL="from Classes as a where a.classno like :name";    
    Query query = session.createQuery(strSQL);    
    query.setString("name", "%"+OId+"%");    
    List result=query.list();

2: OID is param


    List result=session.createQuery("from Classes as a where a.classno like '%"+OId+"%'").list();

3: OID is param


    List result=session.createQuery("from Classes as a where a.classno like :name").setParameter("name",OId).list();

4: DetachedCriteria 的使用


	public FunctionEntity getFunctionEntityById(String id){
		DetachedCriteria criteria = DetachedCriteria.forClass(FunctionEntity.class);
		criteria.add(Restrictions.eq("id", id));
		return (FunctionEntity) getHibernateTemplate().findByCriteria(criteria).get(0);
	}