How to return list as JSON object from jsp in ajax?

Question

This is my jsp file...

    <%@page import="java.util.*,java.util.List,java.util.ArrayList"%>
    <%@ page import="java.io.*,java.sql.*,java.text.*,pis.util.*"%>
    <%@ page  contentType="application/json; charset=UTF-8" pageEncoding="UTF-8"%>
    <%
        response.setContentType("application/json");
        String LedgerNo=request.getParameter("LedgerNo").trim();
        ResultSet rs = dm.getData("SELECT SaleNo , DisplayPrefix ,DisplayNo FROM sale 
           where CustomerName      like '"+ LedgerNo +"'");

        List<Map<String, Object>> menuList = new ArrayList<Map<String, Object>>();

       while (rs.next()) {
           System.out.println("SaleNo.."+rs.getInt(1));
           System.out.println("DisplayNo.."+rs.getString(2) +" "+ rs.getString(3));

           Map<String, Object> menuMap = new HashMap<String, Object>();
           menuMap.put("SaleNo",rs.getInt(1));
           menuMap.put("DisplayNo",rs.getString(3) );
           menuList.add(menuMap);

        } 

        System.out.println("menuList.."+menuList.toString());
        out.println(menuList);
        rs.close();
%>

I got my list as...

[{SaleNo=1, DisplayNo=K 1}, {SaleNo=2, DisplayNo=KC 1}]

I want to return this list as JSON . But it returns error,how can i achieve this?

TedTrippin · Accepted Answer · 2014-09-24 09:47:49Z

1

You need to add quotes around Strings and use colon instead of equals. You don't need quotes around numbers.

your JSON should look like this...

[{"SaleNo":1, "DisplayNo":"K 1"}, {"SaleNo":2, "DisplayNo":"KC 1"}]

answered Sep 24, 2014 at 9:47

TedTrippin

3,6525 gold badges32 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to return list as JSON object from jsp in ajax?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related