HQL实现模糊查询

佚名 7年前 (2019-04-19) 随笔 1507人围观抢沙发百度已收录

hibernate 实现模糊查询两种传参方式，其实各个方法的实质都是一样的，只不过传递参数的方法稍微有点区别

    public List<User> getUsers(String id){
        List list=new ArrayList<User>();
        String hql="from User as user where user.id like '%"+id+"%'";
        factory=DBHelper.getSessionFactory();
        Session session=factory.openSession();
        Transaction transaction=session.beginTransaction();
        Query query=session.createQuery(hql);
        list=query.list();
        transaction.commit();
        session.close();
        return list;
    }

SRE实战互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

public List<User> getUsers(String id){
		List list=new ArrayList<User>();
		String hql="from User as user where user.id like :id";
		factory=DBHelper.getSessionFactory();
		Session session=factory.openSession();
		Transaction transaction=session.beginTransaction();
		Query query=session.createQuery(hql);
		 query.setString("id", "%"+id+"%");    
		list=query.list();
		transaction.commit();
		session.close();
		return list;
	}