 |  |  |  |  |  |  |  |
how to update database using mysql and jsp
Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Dec 2004
Posts: 4,273
Reputation: 
Solved Threads: 494
Google is your friend! There are many examples over the internet, for example this site http://www.java2s.com/Tutorial/Java/...__Database.htm
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
U can write all code using scriptlet. Simply start scriptlet,create connection, write and execute update query, close connection and scriptlet.
For Ex
<%
create connection
Create query
resultset
execute query
close connection
%>
Hope it provides u some help!!
U can find example code in google.
For Ex
<%
create connection
Create query
resultset
execute query
close connection
%>
Hope it provides u some help!!
U can find example code in google.
•
•
Join Date: Feb 2006
Posts: 2,467
Reputation:
Solved Threads: 267
•
•
•
•
Originally Posted by Shubhra 
U can write all code using scriptlet. Simply start scriptlet,create connection, write and execute update query, close connection and scriptlet.
For Ex
<%
create connection
Create query
resultset
execute query
close connection
%>
Hope it provides u some help!!
U can find example code in google.
You can also scratch your back with a butcher knife, but I wouldn't suggest it.
Java Programmer and Sun Systems Administrator
----------------------------------------------
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
----------------------------------------------
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
Ya OK.
What I provided was actually the short cut.
Correct way is to do all such stuff in class. Create object in jsp and simply execute the method!!
Am I correct now??
What I provided was actually the short cut.
Correct way is to do all such stuff in class. Create object in jsp and simply execute the method!!
Am I correct now??
•
•
Join Date: Feb 2006
Posts: 2,467
Reputation:
Solved Threads: 267
Well, if you knew the right way, why did you suggest the wrong way?
As I said:
You can also scratch your back with a butcher knife, but I wouldn't suggest it.
As I said:
You can also scratch your back with a butcher knife, but I wouldn't suggest it.
Java Programmer and Sun Systems Administrator
----------------------------------------------
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
----------------------------------------------
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
Actually I wrote what came first to my mind.
Your comment stroke me to give a2nd thought.
I apologise.
Your comment stroke me to give a2nd thought.
I apologise.
|
Similar Threads
- How to Connect MySQL from JSP Page (JSP)
- facing problem in database connectivity in jsp to mysql (JSP)
- Please help me in connecting JSP to MySql (JSP)
- To update database through gridview (ASP.NET)
- Update Database Problems (Visual Basic 4 / 5 / 6)
- timer for consolidated database (MySQL) (Visual Basic 4 / 5 / 6)
- Update entire Mysql DataBase with PhP (PHP)
Other Threads in the JSP Forum
- Previous Thread: jsp:forward on click on a hyperlink
- Next Thread: Connectivity with mydwl using lsp
Views: 5799 | Replies: 7
| 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
