hibernate 查询数据库后怎么转换成这样的格式？

Question

public List<ProductType> treelist(){
Query q=factory.getCurrentSession().createQuery("select pro.cls,pro.id,pro.leaf,pro.text from ProductType as pro");
System.out.print("qlist"+q.list());
return q.list();
}
查询数据库后打印出来的数据是这样的：
[["file",1,"false","湖南"],["file",2,"true","长沙"],["file",3,"true","常德"],["file",4,"true","益阳"],["file",5,"false","湖北"],["file",6,"true","武汉"],["file",7,"false","广东"],["file",8,"true","东莞"]]但是我需要的结果是这样的：
[{"cls":"file","id":1,"leaf":"false","text":"湖南"},["cls":"file","id":2,"leaf":"true","text":"长沙"}]请问怎样转化？ 请给出具体代码！

Answer 1

System.out.print(“cls”+":"+q.cls+.......);一个一个地输出来哟~你现在设置的是将整个列表内容输出的，那肯定是没能一个一个属性输出啊~

Answer 2

q.cls ？ 搞笑的吧？问题已经解决了 我上面查询的结果是 数组， 
直接 
Query q=factory.getCurrentSession().createQuery("from ProductType where parentid=:parentid");

q.setParameter("parentid", parentid);
查询出来的就是对象。 结果是 
[{"cls":"file","id":1,"leaf":false,"parent":null,"text":"湖南"},{"cls":"file","id":5,"leaf":false,"parent":null,"text":"湖北"},{"cls":"file","id":7,"leaf":false,"parent":null,"text":"广东"}]

Answer 3

JSON-lib这个Java类包用于把bean,map和XML转换成JSON并能够把JSON转回成bean和DynaBean。下载地址:http://json-lib.sourceforge.net/
还要需要的第3方包:
org.apache.commons(3.2以上版本)
org.apache.oro
net.sf.ezmorph(ezmorph-1.0.4.jar)
nu.xom Listboolean[] boolArray = new boolean[]{true,false,true};     
           JSONArray jsonArray1 = JSONArray.fromObject( boolArray );     
           System.out.println( jsonArray1 );     
           // prints [true,false,true]    
             
           List list = new ArrayList();     
           list.add( "first" );     
           list.add( "second" );     
           JSONArray jsonArray2 = JSONArray.fromObject( list );     
           System.out.println( jsonArray2 );     
           // prints ["first","second"]    
  
           JSONArray jsonArray3 = JSONArray.fromObject( "['json','is','easy']" );     
           System.out.println( jsonArray3 );     
           // prints ["json","is","easy"] Map
Map map = new HashMap();     
         map.put( "name", "json" );     
         map.put( "bool", Boolean.TRUE );     
           
         map.put( "int", new Integer(1) );     
         map.put( "arr", new String[]{"a","b"} );     
         map.put( "func", "function(i){ return this.arr[i]; }" );     
         JSONObject json = JSONObject.fromObject( map );     
         System.out.println( json );     
         //{"func":function(i){ return this.arr[i]; },"arr":["a","b"],"int":1,"name":"json","bool":true} Bean/** 
     * Bean.java  
        private String name = "json";    
        private int pojoId = 1;    
        private char[] options = new char[]{'a','f'};    
        private String func1 = "function(i){ return this.options[i]; }";    
        private JSONFunction func2 = new JSONFunction(new String[]{"i"},"return this.options[i];"); 
    */   
JSONObject jsonObject = JSONObject.fromObject( new JsonBean() );     
System.out.println( jsonObject );     
 //{"func1":function(i){ return this.options[i]; },"pojoId":1,"name":"json","options":["a","f"],"func2":function(i){ return this.options[i]; }} 
BEANS List list = new ArrayList();  
         JsonBean2 jb1 = new JsonBean2();  
         jb1.setCol(1);  
         jb1.setRow(1);  
         jb1.setValue("xx");  
           
         JsonBean2 jb2 = new JsonBean2();  
         jb2.setCol(2);  
         jb2.setRow(2);  
         jb2.setValue("");  
           
           
         list.add(jb1);  
         list.add(jb2);  
           
         JSONArray ja = JSONArray.fromObject(list);  
         System.out.println( ja.toString() );  
         //[{"value":"xx","row":1,"col":1},{"value":"","row":2,"col":2}]