This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
The moose likes JDBC and the fly likes updating table in oracle through JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply 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: 56554
    
  14

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.


[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 26499
    
  78

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
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: updating table in oracle through JSP
 
Similar Threads
type of exception implicit object??
FormBean - Hidden variable not set
Reloading a Servlet
can we maintain a javascript variable in session
Quick question on session attributes