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.
java json jsp
add a comment |
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.
java json jsp
are you sure the code present insideif
executed?
– secret super star
Nov 17 at 5:45
Just write thejson
towriter
and you do not need to forward therequest
.
– 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
add a comment |
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.
java json jsp
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
java json jsp
edited Nov 22 at 15:53
asked Nov 17 at 3:37
Kyera Nuna
155
155
are you sure the code present insideif
executed?
– secret super star
Nov 17 at 5:45
Just write thejson
towriter
and you do not need to forward therequest
.
– 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
add a comment |
are you sure the code present insideif
executed?
– secret super star
Nov 17 at 5:45
Just write thejson
towriter
and you do not need to forward therequest
.
– 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
add a comment |
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);
}
add a comment |
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);
}
add a comment |
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);
}
add a comment |
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);
}
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);
}
edited Nov 17 at 6:47
answered Nov 17 at 6:37
secret super star
88813
88813
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
are you sure the code present inside
if
executed?– secret super star
Nov 17 at 5:45
Just write the
json
towriter
and you do not need to forward therequest
.– 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