Player30267 2017-11-05 14:08 采纳率: 0%
浏览 2741
已结题

如何把返回的地址数据转换为数组数据?

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”,无法接收具体数据

  • 写回答

3条回答 默认 最新

  • 奔跑的小鱼儿 2017-11-06 02:03
    关注

    把查询到的地址数据再做一层封装啊,可以把它转换为字符串,用到的时候再解析

    评论

报告相同问题?

悬赏问题

  • ¥60 Python如何后台操作Vmwake虚拟机键鼠
  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯:Person is not mapped,如何解決?
  • ¥15 c++头文件不能识别CDialog
  • ¥15 Excel发现不可读取的内容