求教jquery读取json数组undefined的问题

陈小潮 2015-12-25 08:57:39
各位，小弟请教个问题

我在前台通过jquery ajax访问后台，读取数据库，返回查询结果列表，前台在获取这个json数组的时候，取到的值都是undefined的，请问是怎么回事？应该怎么写？代码如下


js
$(document).ready(function() {

 $("#btn").click(function(){   

		$.ajax( {

	        url : "test.action",  // 数据发送方式

	        type : "post",

	        dataType : "json",// 接收数据格式

	        timeout : 20000,// 设置请求超时时间（毫秒）。

	        success : function(data) { // 请求成功后回调函数。

		  		//读取权限等信息再跳转页面

	        	var d = eval("("+data+")");

				 $.each(result, function (i, n) {

                 alert(n.user_no);

           		 });

//	  			 $.each(d, function(i, item) {

//            	 $("#info > ul").append("<li>" + item.user_no +"---------"+item.last_login_time+"</li>");

//	  			 })

        

	         },

	  	   error : function(e) {

     			 alert(e);

     		}

        })

    })

})



后台java代码


package com.sunyard.cop.ccs.action;



import java.util.ArrayList;

import java.util.HashMap;

import java.util.Map;



import net.sf.json.JSONArray;

import net.sf.json.JSONObject;



import com.opensymphony.xwork2.Action;

import com.opensymphony.xwork2.ActionContext;

import com.sunyard.cop.ccs.common.SQLExecutor;

import com.sunyard.encrypt.impi.EncryptImp;



public class TestAction implements Action {



	

	Map<String,String> map = new HashMap<String,String>();

	

	private JSONArray list;//我要返回给页面的List 

	private String result;

	

	public String execute() throws Exception {

		// TODO Auto-generated method stub

		SQLExecutor dbHelper = new SQLExecutor();

		dbHelper.open();

		String querySql = "select * from sm_users_tb";

		ArrayList array = dbHelper.queryForList(querySql, null);

		list = new JSONArray();

	    list=JSONArray.fromObject(array); 

		System.out.println("list:"+list);

		return SUCCESS;

	}

	



	public JSONArray getList() {

		return list;

	}





	public void setList(JSONArray list) {

		this.list = list;

	}





	public String getResult() {

		return result;

	}

	

	public void setResult(String result) {

		this.result = result;

	}





}


其中后台的返回 list 控制台输出的内容为

[

		{"TELLERLVL":1,"LOGIN_STATE":5,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"admin","USER_NAME":"系统超级管理员","ORGAN_NO":"000000","USER_ENABLE":"1","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20121220164126","PASSWORD":"66UbaZVbHvA=","USER_STATUS":0},

		{"TELLERLVL":0,"LOGIN_STATE":99,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"000001","USER_NAME":"系统参数管理员","ORGAN_NO":"000001","USER_ENABLE":"1","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20120514155225","PASSWORD":"WWzeO3tPUHo=","USER_STATUS":0},

		{"TELLERLVL":2,"LOGIN_STATE":99,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"sunds","USER_NAME":"业务参数管理员","ORGAN_NO":"000001","USER_ENABLE":"1","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20120514155225","PASSWORD":"aDN18k+Z9xU=","USER_STATUS":1},

		{"TELLERLVL":1,"LOGIN_STATE":98,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"000000","USER_NAME":"综合管理员","ORGAN_NO":"000001","USER_ENABLE":"1","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20121220164126","PASSWORD":"4K48Oeeq1B8=","USER_STATUS":0},

		{"TELLERLVL":1,"LOGIN_STATE":98,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"000002","USER_NAME":"柜员2","ORGAN_NO":"000001","USER_ENABLE":"1","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20120514155225","PASSWORD":"MZHMgKIx/wE=","USER_STATUS":0},

		{"TELLERLVL":6,"LOGIN_STATE":99,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"000003","USER_NAME":"柜员3","ORGAN_NO":"000001","USER_ENABLE":"0","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20120514155225","PASSWORD":"Yl0u/AYbePY=","USER_STATUS":0},

		{"TELLERLVL":3,"LOGIN_STATE":98,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"000004","USER_NAME":"柜员4","ORGAN_NO":"20001","USER_ENABLE":"1","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20120514155225","PASSWORD":"3F2zGT4dOKg=","USER_STATUS":0},

		{"TELLERLVL":7,"LOGIN_STATE":99,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"000005","USER_NAME":"柜员5","ORGAN_NO":"20001","USER_ENABLE":"1","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20120514155225","PASSWORD":"t6ij5i/b30E=","USER_STATUS":0},

		{"TELLERLVL":5,"LOGIN_STATE":99,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"000006","USER_NAME":"柜员6","ORGAN_NO":"20002","USER_ENABLE":"1","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20120514155225","PASSWORD":"a4B186C2ieo=","USER_STATUS":0},

		{"TELLERLVL":6,"LOGIN_STATE":99,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"000007","USER_NAME":"柜员7","ORGAN_NO":"20002","USER_ENABLE":"2","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20120514155225","PASSWORD":"NmxKYXsLhfE=","USER_STATUS":0},

		{"TELLERLVL":7,"LOGIN_STATE":98,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"000008","USER_NAME":"柜员8","ORGAN_NO":"20003","USER_ENABLE":"1","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20120514155225","PASSWORD":"1uhqZ8NEqNI=","USER_STATUS":0},

		{"TELLERLVL":8,"LOGIN_STATE":5,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"000009","USER_NAME":"柜员9","ORGAN_NO":"20003","USER_ENABLE":"0","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20120514155225","PASSWORD":"P0pyNC7MGuE=","USER_STATUS":0},

		{"TELLERLVL":9,"LOGIN_STATE":98,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"000010","USER_NAME":"柜员A","ORGAN_NO":"20004","USER_ENABLE":"1","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20120514155225","PASSWORD":"otNA3VDC6CY=","USER_STATUS":0},

		{"TELLERLVL":4,"LOGIN_STATE":5,"LOGIN_MODE":"1","LAST_LOGIN_TIME":"20121220101010","USER_NO":"000011","USER_NAME":"柜员B","ORGAN_NO":"20004","USER_ENABLE":"1","LAST_LOGOUT_TIME":"20121220111111","LAST_MODI_DATE":"20120514155225","PASSWORD":"E1Xmv+0Hq+A=","USER_STATUS":0}

		]



请高人指点，小弟不胜感激
...全文
637 5 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
斯洛文尼亚旅游 2015-12-28
  • 打赏
  • 举报
 回复
服务器端序列化为json格式字符串就行，多少个list都可以。你建立一个类，类里面多申明几个list对象，然后序列化这个类
引用 4 楼 chch010520 的回复:
[quote=引用 3 楼 showbo 的回复:] 注意区分大小写。。 
n.user_no
==>
n.USER_NO
而且你都制定dataType为json了，data就是json对象，你的eval那句应该报错才对。，不需要eval了 dataType : "json",// 接收数据格式 success : function(data) { var d = eval("("+data+")");
谢谢，完美解决了。 另外想再请教，如果jquery调用后台查询，会查询两张表，返回两个list ，请问在jquery中怎么处理这两个list呢？[/quote]
陈小潮 2015-12-27
  • 打赏
  • 举报
 回复
引用 3 楼 showbo 的回复:
注意区分大小写。。 
n.user_no
==>
n.USER_NO
而且你都制定dataType为json了，data就是json对象，你的eval那句应该报错才对。，不需要eval了 dataType : "json",// 接收数据格式 success : function(data) { var d = eval("("+data+")");
谢谢，完美解决了。 另外想再请教，如果jquery调用后台查询，会查询两张表，返回两个list ，请问在jquery中怎么处理这两个list呢？
斯洛文尼亚旅游 2015-12-26
  • 打赏
  • 举报
 回复
注意区分大小写。。 
n.user_no
==>
n.USER_NO
而且你都制定dataType为json了，data就是json对象，你的eval那句应该报错才对。，不需要eval了 dataType : "json",// 接收数据格式 success : function(data) { var d = eval("("+data+")");
陈小潮 2015-12-25
  • 打赏
  • 举报
 回复
引用 1 楼 zzgzzg00 的回复:
result变量哪来的阿？
错了 应该的d 
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
	
$(document).ready(function() {
 $("#btn").click(function(){   
        $.ajax( {
            url : "test.action",  // 数据发送方式
            type : "post",
            dataType : "json",// 接收数据格式
            timeout : 20000,// 设置请求超时时间（毫秒）。
            success : function(data) { // 请求成功后回调函数。
                  //读取权限等信息再跳转页面
                var d = eval("("+data+")");
                 $.each(d, function (i, n) {
                 alert(n.user_no);
                    });
//                   $.each(d, function(i, item) {
//                 $("#info > ul").append("<li>" + item.user_no +"---------"+item.last_login_time+"</li>");
//                   })
         
             },
             error : function(e) {
                  alert(e);
             }
        })
    })
})
这样才对，但是还是undefined
似梦飞花 2015-12-25
  • 打赏
  • 举报
 回复
result变量哪来的阿？
asp如何解析json数组（高分求教）
JSON数据：{"is_menu_open":1,"selfmenu_info":{"button":[{"name":"公司信息","sub_button":{"list":[{"type":"click","name":"公司简介","key":"公司简介"},{"type":"click","name":"公司历程","key":"公司历程"},{"type":"click","name":
python json数组 添加元素_小白求教，这种 json 怎么用 python 解析成参数数组插入 mysql 当中？...
初学python的小白json文件如下：[{"_id": "55501245ef21cb978435bdb0","index": 0,"guid": "316f9bb8-1e0e-4b02-ad41-bc2e65966a26","balance": "$1,115.97","age": 34,"eyeColor": "brown","name": "Manning Schroeder","gend...
php读取json文件中的数据,javascript - php读取json文件并查找其中的内容
有这个么一个json格式个文件 x.json现在 php中想读取json文件内容并按要求查找丛中的item例如：通过A03 输出 dkey 的值该怎么查找对应输出呢？求教！出错回复内容：有这个么一个json格式个文件 x.json现在 php中想读取json文件内容并按要求查找丛中的item例如：通过A03 输出 dkey 的值该怎么查找对应输出呢？求教！出错你的json文件有bom头,$json...
PHP数组重复归类,求教PHP中多维数组中相同的值提取归类
例 PHP中有这么一个多维数组Array[4][{"attr_id": "11","attr_price": "29.8","attr_value": "蓝色","goods_attr_id": "31","goods_id": "10"},{"attr_id": "8","attr_price": "29.8","attr_value": "60CM","goods_attr_id": "29"...
php 提取多维数组的某个值,求教PHP中多维数组中相同的值提取归类
例 PHP中有这么一个多维数组Array[4][{"attr_id": "11","attr_price": "29.8","attr_value": "蓝色","goods_attr_id": "31","goods_id": "10"},{"attr_id": "8","attr_price": "29.8","attr_value": "60CM","goods_attr_id": "29"...
JavaScript

87,997

社区成员

224,709

社区内容

发帖
与我相关
我的任务
社区描述
Web 开发 JavaScript
社区管理员
  • JavaScript
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章