 |  |  |  |  |  |  |  |
retrieving data from database into jsp page
Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
•
•
Join Date: Jul 2008
Posts: 50
Reputation: 
Solved Threads: 0
Junior Poster in Training
hi stephens,
i promise you that i would go through the jdbc tutorial entirely and get all the concepts clear but right now i have to get this done as soon as possible.if you could just tell me how to write the code for now it would be a great favour.only for this time help me with the code for this particular scenario.Please help.
i promise you that i would go through the jdbc tutorial entirely and get all the concepts clear but right now i have to get this done as soon as possible.if you could just tell me how to write the code for now it would be a great favour.only for this time help me with the code for this particular scenario.Please help.
•
•
Join Date: Jul 2007
Posts: 1,175
Reputation: 
Solved Threads: 125
That shows that you have not put in an effort to go through either of my links, why should I help you then, for a guy of average IQ that should be no more than an hours work and what guarantees that you will go through the tutorial when you no longer need it.
The major reason I am not revealing the mistake is cause the mistake is too simple.
The major reason I am not revealing the mistake is cause the mistake is too simple.
Last edited by stephen84s; Sep 12th, 2008 at 2:58 am.
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."
"How to ask questions the smart way ?"
"How to ask questions the smart way ?"
•
•
Join Date: Jul 2008
Posts: 50
Reputation:
Solved Threads: 0
Junior Poster in Training
ok stephens ,
I will do as you say, no matter it takes whatever time.Actually the moment you posted me the link i am going through that only but unfortunately i cant show you .I will go through that tutorial entirely and get the solution in which i am lacking
till then bye and thanks.
I will do as you say, no matter it takes whatever time.Actually the moment you posted me the link i am going through that only but unfortunately i cant show you .I will go through that tutorial entirely and get the solution in which i am lacking
till then bye and thanks.
•
•
Join Date: Jul 2007
Posts: 1,175
Reputation:
Solved Threads: 125
First run Peter's Query in your DBMS and see how the results are displayed.
Next if your JDBC concepts are good go to my second link first (the one pointing to the javadocs of the ResultSet interface).
If the answer still doesn't click, then I guess you will need to go through the tutorial till you get what you want.
Trust me if you find and correct these small mistakes yourself, you will know how to go about larger problems.
Also I will tell you where you are going wrong you are expecting all the three parameters for SL,PL and CL in one row like:.
Whereas when you run the query given by Peter attached with the
Note the use of the order by clause to force the database to sort the way the records are stored in your ResultSet so that you will always get "cl", "pl" and "sl" in that order in your ResultSet and not in the order their rows were inserted.
You would get three rows like this:-
So you have to just change your code to search for CL,PL and SL vertically rather than horizontally(i.e in one row).
Next if your JDBC concepts are good go to my second link first (the one pointing to the javadocs of the ResultSet interface).
If the answer still doesn't click, then I guess you will need to go through the tutorial till you get what you want.
Trust me if you find and correct these small mistakes yourself, you will know how to go about larger problems.
Also I will tell you where you are going wrong you are expecting all the three parameters for SL,PL and CL in one row like:.
JSP Syntax (Toggle Plain Text)
Whereas when you run the query given by Peter attached with the
order by clause as shown here:- sql Syntax (Toggle Plain Text)
You would get three rows like this:-
JSP Syntax (Toggle Plain Text)
So you have to just change your code to search for CL,PL and SL vertically rather than horizontally(i.e in one row).
Last edited by stephen84s; Sep 12th, 2008 at 3:19 am.
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."
"How to ask questions the smart way ?"
"How to ask questions the smart way ?"
•
•
Join Date: Jul 2008
Posts: 50
Reputation:
Solved Threads: 0
Junior Poster in Training
hi,
I have found the solution and i have rectified the mistake that i was making.I cant even believe that it was such a small mistake.But anyways thanks to you all.
bye
I have found the solution and i have rectified the mistake that i was making.I cant even believe that it was such a small mistake.But anyways thanks to you all.
bye
•
•
Join Date: Dec 2004
Posts: 4,257
Reputation:
Solved Threads: 493
Would you mind tell us what it was?
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
•
•
Join Date: Jul 2007
Posts: 1,175
Reputation:
Solved Threads: 125
Hmmm ........... my crystal ball tells me my previous post was correct !!! 
But I could be wrong cause I am using a cheap third world imitation of a crystal ball (a paper weight to be exact ).
But I could be wrong cause I am using a cheap third world imitation of a crystal ball (a paper weight to be exact
). "Any fool can write code that a computer can understand. Good programmers write code that humans can understand."
"How to ask questions the smart way ?"
"How to ask questions the smart way ?"
•
•
Join Date: Jul 2008
Posts: 50
Reputation:
Solved Threads: 0
Junior Poster in Training
hi stephens and peter,
Actually the same code which both of you provided was very much correct but i was doing mistake from my side. i was confused with the display part into the jsp page because when i was retrieving values from the database i was getting all the values properly but when i had to display into the jsp page i was taking the string value stored in session from the previous page and not from the database bcz of which it was giving me only the first row value. but finally bcz of your help i have found the solution .
thanks to both of you.
bye take care
Actually the same code which both of you provided was very much correct but i was doing mistake from my side. i was confused with the display part into the jsp page because when i was retrieving values from the database i was getting all the values properly but when i had to display into the jsp page i was taking the string value stored in session from the previous page and not from the database bcz of which it was giving me only the first row value. but finally bcz of your help i have found the solution .
thanks to both of you.
bye take care
•
•
•
•
Originally Posted by peter_budo 
Have look at this tutorial. It is not finished yet, however you can use it for initial start
Your tutorial is great! It fully explains MVC working with database and your descriptions are very clear and helpful. Thanks!!
•
•
Join Date: Dec 2004
Posts: 4,257
Reputation:
Solved Threads: 493
•
•
•
•
Originally Posted by chicago1985
peter_budo,
Your tutorial is great! It fully explains MVC working with database and your descriptions are very clear and helpful. Thanks!!
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
 |
Similar Threads
Other Threads in the JSP Forum
- Previous Thread: Disabling text-wrapping for f:selectItem tags
- Next Thread: witch one is better Jboss server or tomcat server
| Thread Tools | Search this Thread |
Latest JSP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for JSP
apache array backbutton combobox comma connection csv database development directorystructure dropdownlist dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 mysql netbeans network parameters passing ping printinserverinsteadofclient project read redirect request.getparameter response seperated servlet servletdopost()readxml sessions software sql ssl state_saving_method stocks sun tomcat tutorial update values video web write
