Insert record to table with the help of Sequence

I have pasted a small amount of code of my BankProject ...
i really don't know what is wrong with my code(unable to insert data into table). // i need to insert data periodically with help of sequence bc.seq but it's not possible to do with that .... is something wrong with my code

ItDoesntWorkIsUseless. Please tell us why you're unable to insert the data? What goes wrong?

Wouter Oet wrote:ItDoesntWorkIsUseless. Please tell us why you're unable to insert the data? What goes wrong?

Thanks Wouter Oet, i'm getting a blank screen...after i give values.

rather it should say Succesfully Updated ...instead i'm getting a blank empty web page.

Please check the api http://download.oracle.com/javase/1.4.2/docs/api/java/sql/Statement.html#execute(java.lang.String)

its only true when its returns a resultset object

Sudipta Laha wrote:Please check the api http://download.oracle.com/javase/1.4.2/docs/api/java/sql/Statement.html#execute(java.lang.String)

its only true when its returns a resultset object

Thank you ,i've corrected it ... but still i get the blank page as Answer.

Hi
try statement.executeUpdate(string).. it will return a int. Give a SOP to check the integer value.
If its 0 insert has not happened.

Sudipta Laha wrote:Hi
try statement.executeUpdate(string).. it will return a int. Give a SOP to check the integer value.
If its 0 insert has not happened.

it's just the blank screen what i get ...and in console(server ) neither 0/1 gets printed.

Hi,

If you are not getting 0/1(ie.. nothing is comming in console), your code is breaking before that.

Give SOP before that also and check whether this file is getting called correctly/in which part the code is breaking.

In console nothing is getting printed before or After.

you need to debug the whole issue... from the place you are calling the file.
Atleast the file should get called properly, then there may be issues with code that can be corrected. But atleast this code should get called.