String sql = "SELECT SYS_AUTO_GENR_CURR_DT FROM RBP_ASET_CLASS_DT WHERE CTRY_PROD_EXCHG_MKT_CDE = :exchange AND CTRY_PROD_EXCHG_MKT_CDE = :exchange"
SQLQuery query = this.getSessionFactory().getCurrentSession().createSQLQuery(sql);
query.setParameter("exchange", "SH"); // 多个,只需指定一次。
List<String> result = query.list();
int result = query.executeUpdate();
如果用 executeUpdate() 去 query SELECT, 报错:
org.hibernate.exception.GenericJDBCException: could not execute native bulk manipulation query