Hibernate -- 普通sql返回结果字段名称改为小写

String sql = "select ip,cjsj,tjkssj,tjjssj,operatorname from SCZMH_GZPTJB where ip is null"

+ " and tjnf = '" + yearValue + "' and tjyf = '" + monthValue + "'";

Query query = session.createSQLQuery(sql)

.addScalar("ip", org.hibernate.Hibernate.STRING)

.addScalar("cjsj", org.hibernate.Hibernate.TIMESTAMP)

.addScalar("tjkssj", org.hibernate.Hibernate.TIMESTAMP)

.addScalar("tjjssj", org.hibernate.Hibernate.TIMESTAMP)

.addScalar("operatorname", org.hibernate.Hibernate.STRING);

query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);

List lt = query.list();