aspose file tools*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "updating table in oracle through JSP" Watch "updating table in oracle through JSP" New topic
Author

updating table in oracle through JSP

Chintan Shah
Greenhorn

Joined: Jun 29, 2005
Posts: 27
Hello..friends,

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
Marshal

Joined: Jan 10, 2002
Posts: 61413
    
  67

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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30752
    
156

Chintan,
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
 
 
subject: updating table in oracle through JSP