Hibernate数据查询结果转json格式

最新推荐文章于 2019-07-04 09:49:22 发布

Tide

最新推荐文章于 2019-07-04 09:49:22 发布

阅读量3.1k

点赞数

分类专栏： Hibernate 文章标签： hibernate json string exception session list

本文链接：https://blog.csdn.net/tidelu77/article/details/6827758

版权

Hibernate 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

需要org.json.jar包

import org.json.JSONArray;
import org.json.JSONObject;
import org.json.JSONException;

public static String getTodayInfo()
     {
         Session session=HibernateUtil.getSessionFactory().getCurrentSession();
         String todayInfo=null;
         try{
            String hqlS1 = "select * from place";
            System.out.println(hqlS1);

            Transaction tx=session.beginTransaction();
              SQLQuery query=(SQLQuery)session.createSQLQuery(hqlS1).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);

            query.addScalar( "ID", Hibernate.INTEGER );
            query.addScalar( "OCCURSPOT", Hibernate.STRING );
            query.addScalar( "LAT", Hibernate.FLOAT );
            query.addScalar( "LNG", Hibernate.FLOAT );

            List list = query.list();

            session.close();
            
            Map map = null;
            JSONObject jsonObject = null;
            List jsonList = new ArrayList();
            for(int i=0;i<list.size() ;i++){
                map = (Map)list.get(i);
                jsonObject = new JSONObject(map);
                jsonList.add(jsonObject);
            }

            JSONArray json = new JSONArray(jsonList);
            System.out.println( json.toString() );
            todayInfo =  json.toString();

           
         }catch (Exception e) {
            e.printStackTrace();
        }
        return todayInfo;
     }