Hello all,
I am new to
JDBC and am currently following The
Java Tutorial for this. I am working on a program where I am supposed to update a database using stored procedures.
The database has a primary key column and I am first to query the database to know the maximum value of this key and then add 1 to this max value. This value I have to use as a new value while inserting the record into the database. I insert the rest of the field manually.
I have come across simple queries for stored procedures and am fairly comfortable with them but this is confusing me a bit.
The SQL scripts are pretty straightforward but I would be really thankful if somebody could help me with writing stored procedures for these.
Thanks
Knight