Cannot get response via jquery from controller to jsp

Question

I am sending a id to controller from dropdown(oncgange function). It is working fine. Now in controller after querying from database result is stored in arrylist. i have given returntype arrylist. is it ok or there is any error. please help. i just want to display another dropdown based selected value of first dropdown. Suppose i selected Fruit , so i want to populate this in jsp.

<option value="mango">Mango</option>
<option value="pineapple">Pineapple</option>

jsp

         <script>
            function getScode()
            {
                var code = document.getElementById('code'),
                    code = code.value;
                jQuery.ajax({
                    type: 'POST',
                    url: 'scode.htm',
                    data: {
                        code: code
                    },
                    success: function (html) {
                        $('#scode_data').html(html).show();
                    }
                });
                return false;
            }
        </script>

          Select Genre
            <select name="code" id="code"  onchange="getScode();">        
            <option value="1">Fruit</option>
            <option value="2">Game</option>              
            </select>
          Under that
         <div id="scode_data"></div>

controller

@RequestMapping(value="/scode", method = RequestMethod.POST)
    public @ResponseBody ArrayList getScode(ModelMap modelMap, @RequestParam(value = "code", required = false) String code_val, HttpServletRequest request, HttpServletResponse response) 
throws ClassNotFoundException { 

        SimpleDriverDataSource dataSource = new SimpleDriverDataSource();
        dataSource = new dbconnection.connection().getConnection(dataSource);
        JdbcTemplate jt = new JdbcTemplate(dataSource);

        String sql = "SELECT * FROM cat WHERE fcode='"+code_val+"'";
        srs = jt.queryForRowSet(sql);
        while (srs.next()) {
            pojo obj2 = new pojo();
            obj2.setScode(srs.getString("fcode"));
            obj2.setSname(srs.getString("fname"));
            arraylist.add(obj2);
        }

         return arraylist;
    }

Image link of what i am getting

you'll have send the json version of the arraylist. And in the success function parse that json which you have received and append it to the another — Pallav Jha, Mar 11 '16 at 09:51
i am now able to get data via ajax. But it shows ... arraylist data like .... ** model.pojo@14e79b55model.pojo@46162020 ** — Suraj Roy, Mar 11 '16 at 12:01
Check what are you getting on success in the browser console. `success: function (html) { console.log(html); $('#scode_data').html(html).show(); }` You should be getting array of object. Post the screenshot of that. — Sanjay Rawat, Mar 11 '16 at 20:22
@SurajRoy As you have not converted the list to json you're getting the toString representation of the same. http://stackoverflow.com/questions/20801248/convert-arraylist-into-json This will help you — Pallav Jha, Mar 12 '16 at 15:36
@SanjayRawat can not post screenshot ,,not have enough score — Suraj Roy, Mar 14 '16 at 06:06
As Obi Wan said, you haven't converted list to json. Try that and if you still have issue I'll try to answer. — Sanjay Rawat, Mar 14 '16 at 06:17
fine,, now it is doing some work ,, now its showing this = [{"scode":"1","sname":"mango"},{"scode":"2","sname":"pineapple"}] @SanjayRawat — Suraj Roy, Mar 14 '16 at 06:41
fine,, now it is doing some work ,, now its showing this = [{"scode":"1","sname":"mango"},{"scode":"2","sname":"pineapple"}] i want to show this = @ObiWan-PallavJha — Suraj Roy, Mar 14 '16 at 07:04

score 0 · Accepted Answer · answered Mar 14 '16 at 09:04

0

Now you've to convert the json string into option nodes. Below code would do the work:

success : function(result) {
    var parsed = JSON.parse(result);

            var b = "";
            for(var x = 0; x<parsed.length ; x++){
                b = "<option value = '"+parsed["scode"]>+"'>"
                b = parsed["sname"] + "</option>";
                $("#__id of your select_").append(b);
                b = "";
            }

answered Mar 14 '16 at 09:04

Pallav Jha

3,409
3
29
52

it displays ,,, UNDEFINED – Suraj Roy Mar 14 '16 at 10:11
@SurajRoy the append function should be called from the object of the new select you've created. – Pallav Jha Mar 14 '16 at 10:14
http://i.stack.imgur.com/zL9lF.png .................check thsi image .. i have tested with alert this shows as response – Suraj Roy Mar 14 '16 at 10:29
2 field should come as result.. alert also shows 2 times,, so i think data is coming ,, but for some reason it undefined – Suraj Roy Mar 14 '16 at 10:32
i am thinking how will it access my arraylist.. should i add a modelmap and return modelmap object – Suraj Roy Mar 14 '16 at 10:34
No don't return model map. Comment what you're getting in the response in the success function. – Pallav Jha Mar 14 '16 at 10:41
check this image link ,,, tested with ** alert(b) ** it shows this >>> http://stack.imgur.com/zL9lF.png – Suraj Roy Mar 14 '16 at 10:49

Cannot get response via jquery from controller to jsp

1 Answers1