Return values from arraylist to an ajax success function

Question

Retrieve data from an arraylist in the ajax success function. I need to populate my textfields latitude and longitude fields based on the ID passed via ajax. Everything works fine but the data is not rendered to the text fields. The success function returns nothing if the below code is executed. What is wroong in my code?

FetchData.class

public static ArrayList<Info> getAllInfo(String data_id) {
connection = FetchData.getConnection();
ArrayList<Info> inf = new ArrayList<Info>();
try {
    Statement statement = connection.createStatement();
    ResultSet rs = statement.executeQuery("select * from info_table where data_id='"+data_id"'");

    while(rs.next()) {  
        Info in=new Info();
        in.setData_id(rs.getString("data_id"));
        in.setLat(rs.getDouble("Lat"));
        in.setLongi(rs.getDouble("Longi"));
        inf.add(in);
    }
} catch (SQLException e) {
    e.printStackTrace();
}

return inf;
  }
}

Servlet class

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 String dataID=request.getParameter("data_id");
ArrayList<Info> in=new ArrayList<Info>();
in=FetchData.getAllInfo();
Gson gson = new Gson();
JsonElement element = gson.toJsonTree(in, new TypeToken<List<Info>>() {}.getType());

JsonArray jsonArray = element.getAsJsonArray();
response.setContentType("application/json");
response.getWriter().print(jsonArray);

}

my ajax

$.ajax({
url:'Servleturl?dataID='document.getElementById("#data_id").value;
type:'GET',
dataType:'json',
success:function(data){
$("#lat").val(data.Lat);
$("#longi").val(data.Longi);
}
});
});

index.jsp

<input type="text" id="data_id" onblur=""/>
<input type="text" id="lat"/>
<input type="text" id="longi"/>

Any error on firebug console? And you see that request can be sent on network tab of firebug? — Hüseyin BABAL
– Hüseyin BABAL, Commented Feb 25, 2014 at 7:01
Sir no errors and on the console its printingg the values fine. Its just not retrieving in the success function. — Vidya
– Vidya, Commented Feb 25, 2014 at 7:03
Then, your ajax request is not functioning well. Check Network tab of firebug. What are you getting on ajax request — Hüseyin BABAL
– Hüseyin BABAL, Commented Feb 25, 2014 at 7:04
I am getting as undefined sir. data is not returning any value — Vidya
– Vidya, Commented Feb 25, 2014 at 7:06
Could you please go to ..../Servleturl?dataID=some_value on your web browser? some_value needs to be available value. I want to know exact output of your controller request — Hüseyin BABAL
– Hüseyin BABAL, Commented Feb 25, 2014 at 7:08

Ravindra Bhalothia · Accepted Answer · 2017-09-21 08:20:21Z

5

Thank you for all the responses.

I finally found a solution to my own question. hope it will be useful for someone else.

I did the following code.

$.ajax({
    url:'Servleturl?dataID='document.getElementById("#data_id").value;
    type:'GET',
    dataType:'json',
    success:function(data) {
        document.getElementById("#lat").value=data[0].Lat;
        document.getElementById("#longi").value=data[0].Longi;
    }
});

As the data is returned from a arraylist should give the data as array itself to retrieve the values..

Thank you all for the answers.

edited Sep 21, 2017 at 8:20

Ravindra Bhalothia

1,7802 gold badges13 silver badges16 bronze badges

answered Feb 25, 2014 at 17:22

Vidya

6983 gold badges12 silver badges21 bronze badges

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

Comments

user3349807 · Accepted Answer · 2014-02-25 06:58:13Z

0

put input field value <input type="text" id="data_id" onblur=""/> <input type="text" id="lat" value=""/> `

`

answered Feb 25, 2014 at 6:58

user3349807

1

1 Comment

Vidya Over a year ago

It is not returning any values first of all sir.

Hüseyin BABAL · Accepted Answer · 2014-02-25 07:16:50Z

You need to return jsonArray.toString(). If you don't want to use that you need to put extra code;

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    String dataID=request.getParameter("data_id");
    ArrayList<Info> in=new ArrayList<Info>();
    in=FetchData.getAllInfo();
    Gson gson = new Gson();
    JsonElement element = gson.toJsonTree(in, new TypeToken<List<Info>>() {}.getType());

    response.setContentType("application/json; charset=UTF-8");
    PrintWriter printOut = response.getWriter();

    JsonArray jsonArray = element.getAsJsonArray();
    printOut.print(jsonArray);
    printout.flush();
    // Or
    // printOut.print(jsonArray.toString())

}

Collectives™ on Stack Overflow

Return values from arraylist to an ajax success function

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related