how to get view data in JSON format from database using jsp











up vote
0
down vote

favorite












I want to change the view from the HTML list to JSON data.



This my code in controller:-



private void listFeedback(HttpServletRequest request, HttpServletResponse response)
throws SQLException, IOException, ServletException {
Feedback p = new Feedback();
int seller_id = Integer.parseInt(request.getParameter("seller_id"));
List<Feedback> feedbacks = p.all(seller_id);
String format = request.getParameter("format");
if(format == "json"){
String json = new Gson().toJson(feedbacks);

response.setContentType("application/json");
response.setCharacterEncoding("UTF-8");
response.getWriter().write(json);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/demo.jsp");
dispatcher.forward(request, response);
}
request.setAttribute("feedbacks", feedbacks);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
dispatcher.forward(request, response);
}


But, It can be still viewed like before, nothing got to change at all. I wish it to be redirected to demo.jsp so that it can have a JSON view. Would anyone help me doing the same?



UPDATE



I just forget to put else in there
so, this the right code



else{
request.setAttribute("feedbacks", feedbacks);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
dispatcher.forward(request, response);
}


Thank you so much for answering my question.










share|improve this question
























  • are you sure the code present inside if executed?
    – secret super star
    Nov 17 at 5:45










  • Just write the json to writer and you do not need to forward the request.
    – secret super star
    Nov 17 at 5:48










  • Possible duplicate of Display JSON data in jsp and html respectively
    – Abhinav
    Nov 17 at 5:48










  • @Kyera Nuna This [hibare.in/pageInfo.php?PageID=28] will definitely help you.
    – Abhinav
    Nov 17 at 5:49















up vote
0
down vote

favorite












I want to change the view from the HTML list to JSON data.



This my code in controller:-



private void listFeedback(HttpServletRequest request, HttpServletResponse response)
throws SQLException, IOException, ServletException {
Feedback p = new Feedback();
int seller_id = Integer.parseInt(request.getParameter("seller_id"));
List<Feedback> feedbacks = p.all(seller_id);
String format = request.getParameter("format");
if(format == "json"){
String json = new Gson().toJson(feedbacks);

response.setContentType("application/json");
response.setCharacterEncoding("UTF-8");
response.getWriter().write(json);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/demo.jsp");
dispatcher.forward(request, response);
}
request.setAttribute("feedbacks", feedbacks);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
dispatcher.forward(request, response);
}


But, It can be still viewed like before, nothing got to change at all. I wish it to be redirected to demo.jsp so that it can have a JSON view. Would anyone help me doing the same?



UPDATE



I just forget to put else in there
so, this the right code



else{
request.setAttribute("feedbacks", feedbacks);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
dispatcher.forward(request, response);
}


Thank you so much for answering my question.










share|improve this question
























  • are you sure the code present inside if executed?
    – secret super star
    Nov 17 at 5:45










  • Just write the json to writer and you do not need to forward the request.
    – secret super star
    Nov 17 at 5:48










  • Possible duplicate of Display JSON data in jsp and html respectively
    – Abhinav
    Nov 17 at 5:48










  • @Kyera Nuna This [hibare.in/pageInfo.php?PageID=28] will definitely help you.
    – Abhinav
    Nov 17 at 5:49













up vote
0
down vote

favorite









up vote
0
down vote

favorite











I want to change the view from the HTML list to JSON data.



This my code in controller:-



private void listFeedback(HttpServletRequest request, HttpServletResponse response)
throws SQLException, IOException, ServletException {
Feedback p = new Feedback();
int seller_id = Integer.parseInt(request.getParameter("seller_id"));
List<Feedback> feedbacks = p.all(seller_id);
String format = request.getParameter("format");
if(format == "json"){
String json = new Gson().toJson(feedbacks);

response.setContentType("application/json");
response.setCharacterEncoding("UTF-8");
response.getWriter().write(json);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/demo.jsp");
dispatcher.forward(request, response);
}
request.setAttribute("feedbacks", feedbacks);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
dispatcher.forward(request, response);
}


But, It can be still viewed like before, nothing got to change at all. I wish it to be redirected to demo.jsp so that it can have a JSON view. Would anyone help me doing the same?



UPDATE



I just forget to put else in there
so, this the right code



else{
request.setAttribute("feedbacks", feedbacks);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
dispatcher.forward(request, response);
}


Thank you so much for answering my question.










share|improve this question















I want to change the view from the HTML list to JSON data.



This my code in controller:-



private void listFeedback(HttpServletRequest request, HttpServletResponse response)
throws SQLException, IOException, ServletException {
Feedback p = new Feedback();
int seller_id = Integer.parseInt(request.getParameter("seller_id"));
List<Feedback> feedbacks = p.all(seller_id);
String format = request.getParameter("format");
if(format == "json"){
String json = new Gson().toJson(feedbacks);

response.setContentType("application/json");
response.setCharacterEncoding("UTF-8");
response.getWriter().write(json);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/demo.jsp");
dispatcher.forward(request, response);
}
request.setAttribute("feedbacks", feedbacks);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
dispatcher.forward(request, response);
}


But, It can be still viewed like before, nothing got to change at all. I wish it to be redirected to demo.jsp so that it can have a JSON view. Would anyone help me doing the same?



UPDATE



I just forget to put else in there
so, this the right code



else{
request.setAttribute("feedbacks", feedbacks);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
dispatcher.forward(request, response);
}


Thank you so much for answering my question.







java json jsp






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 22 at 15:53

























asked Nov 17 at 3:37









Kyera Nuna

155




155












  • are you sure the code present inside if executed?
    – secret super star
    Nov 17 at 5:45










  • Just write the json to writer and you do not need to forward the request.
    – secret super star
    Nov 17 at 5:48










  • Possible duplicate of Display JSON data in jsp and html respectively
    – Abhinav
    Nov 17 at 5:48










  • @Kyera Nuna This [hibare.in/pageInfo.php?PageID=28] will definitely help you.
    – Abhinav
    Nov 17 at 5:49


















  • are you sure the code present inside if executed?
    – secret super star
    Nov 17 at 5:45










  • Just write the json to writer and you do not need to forward the request.
    – secret super star
    Nov 17 at 5:48










  • Possible duplicate of Display JSON data in jsp and html respectively
    – Abhinav
    Nov 17 at 5:48










  • @Kyera Nuna This [hibare.in/pageInfo.php?PageID=28] will definitely help you.
    – Abhinav
    Nov 17 at 5:49
















are you sure the code present inside if executed?
– secret super star
Nov 17 at 5:45




are you sure the code present inside if executed?
– secret super star
Nov 17 at 5:45












Just write the json to writer and you do not need to forward the request.
– secret super star
Nov 17 at 5:48




Just write the json to writer and you do not need to forward the request.
– secret super star
Nov 17 at 5:48












Possible duplicate of Display JSON data in jsp and html respectively
– Abhinav
Nov 17 at 5:48




Possible duplicate of Display JSON data in jsp and html respectively
– Abhinav
Nov 17 at 5:48












@Kyera Nuna This [hibare.in/pageInfo.php?PageID=28] will definitely help you.
– Abhinav
Nov 17 at 5:49




@Kyera Nuna This [hibare.in/pageInfo.php?PageID=28] will definitely help you.
– Abhinav
Nov 17 at 5:49












1 Answer
1






active

oldest

votes

















up vote
0
down vote













It looks format value is null or not json. If the code present inside if executed, you would end up having error (The next lines of code, you are forwarding to another jsp).




"Cannot forward after response has been committed"




Make the below changes to make it work:



you would not need to forward while you wanted to return the JSON. just add below code inside if



if("json".equals(format)){
String json = new Gson().toJson(feedbacks);
response.setContentType("application/json");
response.setCharacterEncoding("UTF-8");
response.getWriter().write(json);
return; // return from here or change to if-else
}


The whole code:



    private void listFeedback(HttpServletRequest request, HttpServletResponse response)
throws SQLException, IOException, ServletException {
Feedback p = new Feedback();
int seller_id = Integer.parseInt(request.getParameter("seller_id"));
List<Feedback> feedbacks = p.all(seller_id);


String format = request.getParameter("format");
if("json".equals(format)){
String json = new Gson().toJson(feedbacks);
response.setContentType("application/json");
response.setCharacterEncoding("UTF-8");
response.getWriter().write(json);
return;// return from here or change to if-else
}
request.setAttribute("feedbacks", feedbacks);
RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
dispatcher.forward(request, response);
}





share|improve this answer























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53347952%2fhow-to-get-view-data-in-json-format-from-database-using-jsp%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    0
    down vote













    It looks format value is null or not json. If the code present inside if executed, you would end up having error (The next lines of code, you are forwarding to another jsp).




    "Cannot forward after response has been committed"




    Make the below changes to make it work:



    you would not need to forward while you wanted to return the JSON. just add below code inside if



    if("json".equals(format)){
    String json = new Gson().toJson(feedbacks);
    response.setContentType("application/json");
    response.setCharacterEncoding("UTF-8");
    response.getWriter().write(json);
    return; // return from here or change to if-else
    }


    The whole code:



        private void listFeedback(HttpServletRequest request, HttpServletResponse response)
    throws SQLException, IOException, ServletException {
    Feedback p = new Feedback();
    int seller_id = Integer.parseInt(request.getParameter("seller_id"));
    List<Feedback> feedbacks = p.all(seller_id);


    String format = request.getParameter("format");
    if("json".equals(format)){
    String json = new Gson().toJson(feedbacks);
    response.setContentType("application/json");
    response.setCharacterEncoding("UTF-8");
    response.getWriter().write(json);
    return;// return from here or change to if-else
    }
    request.setAttribute("feedbacks", feedbacks);
    RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
    dispatcher.forward(request, response);
    }





    share|improve this answer



























      up vote
      0
      down vote













      It looks format value is null or not json. If the code present inside if executed, you would end up having error (The next lines of code, you are forwarding to another jsp).




      "Cannot forward after response has been committed"




      Make the below changes to make it work:



      you would not need to forward while you wanted to return the JSON. just add below code inside if



      if("json".equals(format)){
      String json = new Gson().toJson(feedbacks);
      response.setContentType("application/json");
      response.setCharacterEncoding("UTF-8");
      response.getWriter().write(json);
      return; // return from here or change to if-else
      }


      The whole code:



          private void listFeedback(HttpServletRequest request, HttpServletResponse response)
      throws SQLException, IOException, ServletException {
      Feedback p = new Feedback();
      int seller_id = Integer.parseInt(request.getParameter("seller_id"));
      List<Feedback> feedbacks = p.all(seller_id);


      String format = request.getParameter("format");
      if("json".equals(format)){
      String json = new Gson().toJson(feedbacks);
      response.setContentType("application/json");
      response.setCharacterEncoding("UTF-8");
      response.getWriter().write(json);
      return;// return from here or change to if-else
      }
      request.setAttribute("feedbacks", feedbacks);
      RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
      dispatcher.forward(request, response);
      }





      share|improve this answer

























        up vote
        0
        down vote










        up vote
        0
        down vote









        It looks format value is null or not json. If the code present inside if executed, you would end up having error (The next lines of code, you are forwarding to another jsp).




        "Cannot forward after response has been committed"




        Make the below changes to make it work:



        you would not need to forward while you wanted to return the JSON. just add below code inside if



        if("json".equals(format)){
        String json = new Gson().toJson(feedbacks);
        response.setContentType("application/json");
        response.setCharacterEncoding("UTF-8");
        response.getWriter().write(json);
        return; // return from here or change to if-else
        }


        The whole code:



            private void listFeedback(HttpServletRequest request, HttpServletResponse response)
        throws SQLException, IOException, ServletException {
        Feedback p = new Feedback();
        int seller_id = Integer.parseInt(request.getParameter("seller_id"));
        List<Feedback> feedbacks = p.all(seller_id);


        String format = request.getParameter("format");
        if("json".equals(format)){
        String json = new Gson().toJson(feedbacks);
        response.setContentType("application/json");
        response.setCharacterEncoding("UTF-8");
        response.getWriter().write(json);
        return;// return from here or change to if-else
        }
        request.setAttribute("feedbacks", feedbacks);
        RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
        dispatcher.forward(request, response);
        }





        share|improve this answer














        It looks format value is null or not json. If the code present inside if executed, you would end up having error (The next lines of code, you are forwarding to another jsp).




        "Cannot forward after response has been committed"




        Make the below changes to make it work:



        you would not need to forward while you wanted to return the JSON. just add below code inside if



        if("json".equals(format)){
        String json = new Gson().toJson(feedbacks);
        response.setContentType("application/json");
        response.setCharacterEncoding("UTF-8");
        response.getWriter().write(json);
        return; // return from here or change to if-else
        }


        The whole code:



            private void listFeedback(HttpServletRequest request, HttpServletResponse response)
        throws SQLException, IOException, ServletException {
        Feedback p = new Feedback();
        int seller_id = Integer.parseInt(request.getParameter("seller_id"));
        List<Feedback> feedbacks = p.all(seller_id);


        String format = request.getParameter("format");
        if("json".equals(format)){
        String json = new Gson().toJson(feedbacks);
        response.setContentType("application/json");
        response.setCharacterEncoding("UTF-8");
        response.getWriter().write(json);
        return;// return from here or change to if-else
        }
        request.setAttribute("feedbacks", feedbacks);
        RequestDispatcher dispatcher = request.getRequestDispatcher("feedbacks/list.jsp");
        dispatcher.forward(request, response);
        }






        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited Nov 17 at 6:47

























        answered Nov 17 at 6:37









        secret super star

        88813




        88813






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.





            Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


            Please pay close attention to the following guidance:


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53347952%2fhow-to-get-view-data-in-json-format-from-database-using-jsp%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            What visual should I use to simply compare current year value vs last year in Power BI desktop

            Alexandru Averescu

            Trompette piccolo