File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes updating table in oracle through JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "updating table in oracle through JSP" Watch "updating table in oracle through JSP" New topic

updating table in oracle through JSP

Chintan Shah

Joined: Jun 29, 2005
Posts: 27

I am creating a JSP which..there is one integer variable.
Now my problem is that i have to set that value of integer variable in one of my oracle tables.
Please give me syntax of update statement...because i dont know how to set the value of that variable in my table.
I am currently doing project of online ticket booking..and in that..i need to restore the value of integer variable that i am using in my jsp page into the columns of oracle table.
Any help will be appreciated.
Thanks in Advance.
Chinta Shah
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63534

No difference than how you would do it in any other Java program. Though it'd be best to move any Java code out of the JSP and into beans or servlets.

Moved to the JDBC forum.

[Asking smart questions] [About Bear] [Books by Bear]
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32815

The syntax of an update statement with examples.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
It is sorta covered in the JavaRanch Style Guide.
subject: updating table in oracle through JSP
It's not a secret anymore!