I want to add data from jsp page to data base. I written connection for data base in scriplet page. In jsp page I have 1 textarea named as Notes.After clicking the submit button it should add to database through action/any type. I am using backend database sql server.
Thanks in advance its urgent plz .....
cheers amit bhadre
[ June 07, 2006: Message edited by: amit bhadre ] [ June 07, 2006: Message edited by: Bear Bibeault ]
In an effort to help you get the most from our forums, we've compiled a list of tips for asking questions here. You can find the list in our FAQ section here. In particular, please see EaseUp.
Please, also see: UseRealWords Abbreviations such as '2' instead of to and 'plz' instead of 'please' confound language translation software making it difficult for our non-English speaking members to read your post.
Again, welcome to JavaRanch and good luck with your question. -Ben
1 - retrieve parameters from the web page into a variable. Often that is done with request.getParameter("nameOfFieldOnPage"); Alternatively you can use <jsp:useBean> and <jsp:setProperty> and populate a bean which has properties the same as the parameters from the page. Or you can get a framework to do that for you.
2 - obtain a database connection. Preferably from a connection pool, or a bean provider, rather than writing database code into a JSP.