It's not a secret anymore!
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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 63343
    
  70

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: 32614
    
215

Chintan,
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: updating table in oracle through JSP
 
jQuery in Action, 3rd edition