Java developers

It's me again. Just when I thought all was well and the dragon had been slayed, I hit another wall.

What I need to do is if the value received in the result set is null then change the value to zero

( My CodeCollapse )

Okay, I hope this is understandable.

In the servlet there are 3 queries running. There is only one process of the result set for all three result sets. The first rs (rs1) retrieves a value from the database and adds 1 to it this result becomes int1.

The second rs (rs2) gets int1 and checks to see if it is divisible by 3 to set int2 to zero if true or to the value of int1 if false.

The third rs (rs3) gets a value from the db and adds it to a value taken from the previous page. It then has to check to see to see if the sum of those to values is great than or less than 500 depending on the answer a third boolean value is set to either 1 or 2.

The fourth rs (rs4) was created to write the information back to the database the ( query statementCollapse )

Since this query is being created and initialized in the do get the values to be put into the query are created and intialized in the process of the result set which places them out of scope.

When you have a result set processing a query that contains an insert statement to an oracle db do you need to run an additional query with a commit statement?


~~Milissa~~