Hibernate中如何使用原生的SQL进行查询呢?

下文讲述Hibernate中使用原生态sql脚本的方法分享 实现思路: 只需使用 createSQLQuery()方法即可使用原生态的sql脚本 例:

 public SQLQuery createSQLQuery(String sqlString) throws HibernateException

 -------------------------------------

 String sql = "SELECT name, salary FROM user";
  SQLQuery query = session.createSQLQuery(sql);
  query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP);
  list results = query.list();

实体查询

String sql = "SELECT * FROM user";
SQLQuery query = session.createSQLQuery(sql);
query.addEntity(User.class);
List results = query.list(); 

原生SQL，参数式查询的方法

String sql = "SELECT * FROM User WHERE id = :user_id";
SQLQuery query = session.createSQLQuery(sql);
query.addEntity(User.class);
query.setParameter("user_id", 888);
List results = query.list();