wood burning stoves 2.0*
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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 page..in 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: 60774

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] [Bear's FrontMan] [About Bear] [Books by Bear]
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30085

The syntax of an update statement with examples.

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: updating table in oracle through JSP
Similar Threads
Quick question on session attributes
type of exception implicit object??
Reloading a Servlet
can we maintain a javascript variable in session
FormBean - Hidden variable not set