2018-05-14---sql查询语句占位符查询方法(非原生sql查询)

@Autowired
private SessionFactory sessionFactory
Session session = sessionFactory.getCurrentSession();

1、改变命名参数：
String sql = "select u from User u where u.name=:name ";
Query query = session.createQuery(sql);//非原生sql
query.setParameter(“name”, “zm”);
return query.list;

2、改变JPA占位符：
String sql = "select u from User u where u.name=?0 ";
Query query = session.createQuery(sql);//非原生sql
query.setParameter(“0”, “zm”);
return query.list;