jsp页面datagrid数据表格接收数据,返回的如果是数组类型数据可以顺利的转换为json数据,可是使用左连接查询的数据返回的是地址数据,不能转为json数据。请教大神如何把地址类型的数据转换为数组类型的数据啊?
控制台信息
信息: Server startup in 25170 ms
Hibernate: select cclient0_.c_ID as c1_1_, cclient0_.c_add as c2_1_, cclient0_.c_address as c3_1_, cclient0_.c_company as c4_1_, cclient0_.c_introduction as c5_1_, cclient0_.c_linkman as c6_1_, cclient0_.c_phone as c7_1_, cclient0_.c_phonex as c8_1_, cclient0_.c_remark as c9_1_ from c_client cclient0_ order by cclient0_.c_add desc limit ?
Hibernate: select count(cclient0_.c_ID) as col_0_0_ from c_client cclient0_
7
[CClient [id=1, company=农业公司05, linkman=张三, address=海淀, phone=133, phonex=155, add=2017-10-25, introduction=, remark=awefwaefa], CClient [id=2, company=公司8, linkman=张三, address=海淀, phone=133, phonex=166, add=2017-10-25, introduction=asfaf, remark=awefawef], CClient [id=27, company=华为公司, linkman=赵六, address=杭州, phone=144, phonex=133, add=2017-10-25, introduction=null, remark=aewfawe], CClient [id=28, company=海尔公司, linkman=田七, address=铁岭, phone=133, phonex=155, add=2017-10-25, introduction=, remark=], CClient [id=29, company=华硕公司, linkman=李四, address=上海, phone=255, phonex=133, add=2017-10-25, introduction=, remark=]]
//数组数据可以转换为json数据
{"total":7,"rows":[{"add":"2017-10-25","address":"海淀","company":"农业公司05","id":1,"introduction":"","linkman":"张三","phone":"133","phonex":"155","remark":"awefwaefa"},{"add":"2017-10-25","address":"海淀","company":"公司8","id":2,"introduction":"asfaf","linkman":"张三","phone":"133","phonex":"166","remark":"awefawef"},{"add":"2017-10-25","address":"杭州","company":"华为公司","id":27,"introduction":"","linkman":"赵六","phone":"144","phonex":"133","remark":"aewfawe"},{"add":"2017-10-25","address":"铁岭","company":"海尔公司","id":28,"introduction":"","linkman":"田七","phone":"133","phonex":"155","remark":""},{"add":"2017-10-25","address":"上海","company":"华硕公司","id":29,"introduction":"","linkman":"李四","phone":"255","phonex":"133","remark":""}]}
//“rows”成功转换为json数据,jsp页面成功接收数据!
Hibernate: select bbasic0_.b_ID as col_0_0_, bbasic0_.b_project as col_1_0_, cclient1_.c_company as col_2_0_ from p_basic bbasic0_ left outer join c_client cclient1_ on bbasic0_.c_ID=cclient1_.c_ID limit ?
Hibernate: select count(bbasic0_.b_ID) as col_0_0_ from p_basic bbasic0_ left outer join c_client cclient1_ on bbasic0_.c_ID=cclient1_.c_ID
33
[[Ljava.lang.Object;@7aa7f835, [Ljava.lang.Object;@29989e7c, [Ljava.lang.Object;@62ccf439, [Ljava.lang.Object;@7db5fcdb, [Ljava.lang.Object;@36ebce57]
//返回的地址数据!无法转换为json数据
{"total":33,"rows":[[1,"农业项目04","农业公司05"],[2,"农业项目03","农业公司05"],[3,"农业项目05","公司8"],[4,"农业项目04","公司8"],[5,"华硕公司12",null]]}
//上面的信息只能接受条数“33”,无法接收具体数据