hibernate查询oracle字段，转化为对象字段，字段名确定

最新推荐文章于 2021-04-04 21:57:18 发布

平哥Jiash

最新推荐文章于 2021-04-04 21:57:18 发布

阅读量526

点赞数

分类专栏： HIBERNATE ORACLE 文章标签： hibernate oracle 对象

本文链接：https://blog.youkuaiyun.com/VB123hjp/article/details/52838042

版权

ORACLE 同时被 2 个专栏收录

10 篇文章

订阅专栏

HIBERNATE

3 篇文章

订阅专栏

public Iterator findAttbyId(String eid) {       
        final String sql = "select a.ATTACH_ID \"attachId\",a.ITEM_CODE \"itemCode\",a.tt_id  \"transactId\",a.ORIGINAL_NAME \"originalName\", "
                + " a.ATTACH_NAME \"attachName\",a.ATTACH_PATH \"attachPath\",a.ATTACH_TYPE \"attachType\",a.INDEX_ID \"indexId\",a.PUB_ITEM_ATTACH_ID \"pubItemAttachId\" "
                + " from s_fujian a where a.tt_id = '"+eid+"'";

        List<CbmsAttach> list = cbmsAttachDao.getHibernateTemplate().executeFind(new HibernateCallback() {

            @Override
            public Object doInHibernate(Session session) throws HibernateException,
                    SQLException {

                SQLQuery query = session.createSQLQuery(sql);

                query.addScalar("attachId", Hibernate.STRING);
                query.addScalar("itemCode", Hibernate.STRING);
                query.addScalar("transactId", Hibernate.STRING);
                query.addScalar("originalName", Hibernate.STRING);
                query.addScalar("attachName", Hibernate.STRING);
                query.addScalar("attachPath", Hibernate.STRING);
                query.addScalar("attachType", Hibernate.STRING);
                query.addScalar("indexId", Hibernate.BIG_DECIMAL);
                query.addScalar("pubItemAttachId", Hibernate.STRING);

                return query.setResultTransformer(Transformers.aliasToBean(Ctch.class)).list();  
            }
        });
        return list.iterator();
    }