SQL 实例
String sql = "select * from (select order_name,order_no from tb_ts_order where status = '0' and id = "+id+" ) where rownum = 1"; List<Map<String, String>> list = tsOrderDao.createSqlQuery(sql) .addScalar("order_name", Hibernate.STRING) .addScalar("order_no", Hibernate.STRING) .setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP) .list();;