hibernate通过参数查询,格式化为map返回结果

来源:互联网 发布:毕向东35天java教学 编辑:程序博客网 时间:2024/05/29 15:55
        final String fpermitId = permitId;        this.getHibernateTemplate().execute(new HibernateCallback() {            @Override            public Object doInHibernate(Session session) throws HibernateException,                    SQLException {                // TODO Auto-generated method stub                StringBuilder queryString = new StringBuilder();                queryString.append(" select * from daul where xxx=?");                SQLQuery sqlQuery = session.createSQLQuery(queryString.toString());                sqlQuery.setString(0, fpermitId);                sqlQuery.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);                return sqlQuery.list();            }        });

其他方法调用上面返回的结果Object

List rList = (List) rObj;            if(null!=rList&&rList.size()>0){                Map<String,Object> rMap = (Map<String,Object>) rList.get(0);                sendNodeType = (String) rMap.get("SENDNODETYPE");            }
0 0