js获取jsonArray的数据

Question

public void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {

    Connection conn = DBConnectUtils.getConnection();
    PreparedStatement pstmt = null;
    ResultSet rs = null;

    try {

        String sql = "select id,username from User";
        System.out.println(sql);
        pstmt = conn.prepareStatement(sql);
        rs = pstmt.executeQuery();
        ResultSetMetaData md = rs.getMetaData();
        int columnCount = md.getColumnCount();
List list = new ArrayList();
        Map map = new LinkedHashMap();
        // 之后将获取的每一条记录封装到一个类中
        if (rs != null) {
            while (rs.next()) {
                for (int i = 1; i <= columnCount; i++) {
                    map.put(md.getColumnName(i), rs.getObject(i));
                }
                list.add(map);
            }
        }

        //ArrayList转为JsonArray
        JSONArray jsonArray = JSONArray.fromObject(list);
        System.out.println("jsonArray.toString():" + jsonArray.toString());

Answer 1

不知道你用的什么发送的请求，如果是jquery整合的ajax发送请求，
直接用回调函数
success:function(data){
直接用data[i],就是遍历jsonarray数组。
data[i].name就是数组里边的属性
}