hibernate ResultTransformer用法

public List<Map<String, Object>> getCarsByLineName(String lineName, Long fromorto) {
		
		final String tempLineName = lineName;
		final Long tempFromorto = fromorto;

		List<Map<String, Object>> list = (List<Map<String, Object>>) this.getHibernateTemplate().execute(new HibernateCallback() {
			@Override
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				String sql = "select bc.carid carid,\n"
						+ "       ld.cardid cardid,\n"
						+ "       ld.readerid readerid,\n"
						+ "       ri.rlocation rlocation,\n"
						+ "       ri.readername readername,\n"
						+ "       bs.stationid stationid,\n"
						+ "       bs.stationname stationname\n"
						+ "  from bus_carinfo     bc,\n"
						+ "       locatedata      ld,\n"
						+ "       readerinfo      ri,\n"
						+ "       bus_stationinfo bs,\n"
						+ "       bus_lineinfo    bl\n"
						+ " where bc.cardid = ld.cardid\n"
						+ "   and ld.readerid = ri.readerid\n"
						+ "   and bs.readerid(+) = ri.readerid\n"
						+ "   and (bc.lineiddown = bl.lineid or bc.lineidup = bl.lineid)\n"
						+ "   and bl.linename = :lineName   and bl.fromorto = :fromorto";
				SQLQuery query = session.createSQLQuery(sql);

				query.addScalar("CARID", Hibernate.STRING);
				query.addScalar("CARDID", Hibernate.LONG);
				query.addScalar("READERID", Hibernate.LONG);
				query.addScalar("RLOCATION", Hibernate.STRING);
				query.addScalar("READERNAME", Hibernate.STRING);
				query.addScalar("STATIONID", Hibernate.LONG);
				query.addScalar("STATIONNAME", Hibernate.STRING);
				
				query.setParameter("lineName", tempLineName);
				query.setParameter("fromorto", tempFromorto);
				
				List<Map<String, Object>> list = query.setResultTransformer(
						Transformers.ALIAS_TO_ENTITY_MAP).list();
				return list;
			}
		});
		return list;

	}

 

以上代码测试的结果为：[{CARDID=268437586, READERNAME=68, READERID=1000068, STATIONID=141, STATIONNAME=中央党校北门站, RLOCATION=116.45007,39.9918, CARID=鲁A00002}, {CARDID=268437575, READERNAME=68, READERID=1000068, STATIONID=141, STATIONNAME=中央党校北门站, RLOCATION=116.45007,39.9918, CARID=鲁A00001}, {CARDID=268437592, READERNAME=68, READERID=1000068, STATIONID=141, STATIONNAME=中央党校北门站, RLOCATION=116.45007,39.9918, CARID=鲁A00004}]

说明：另外，对于ResultTransformer的用法还有很多，它可以将用SQL语句查询的结果转化成为指定的BEAN，也可以转为LIST，也可以转化为MAP