retiving daabase values by clicking a button

[naveen516]

I am new to java, I have a requirement that
I have a table like
Id---Name---Password---email---phone
101 naveen-11111--- nn@gmail--**** UPDATE
************************************* UPDATE
************************************ UPDATE
like this.
UPDATE is the button, If we click on UPDATE button, that particular row details must be come in another table like

Id----*********
Name--*********
Password -*****
Email--*******
phone---********

like this, I aam using jsp, and back end is Oracle and Type1 driver...


Please help me.............

Thanks and regards
Naveen

[diamonddragon]

One way how You could do it:

1. Create Connection(object) to database (using DriverManager or DataSource).
2. Create Statement object that will insert necessary rows from table1 into table2(using apropriate SQL statement, say: INSERT INTO databaseX.table2 SELECT ... FROM databaseX.table1 WHERE ...)

[DarrylBurke]

Use PreparedStatement instead of Statement.

db

[diamonddragon]

Use PreparedStatement instead of Statement.

db

Or may call addBatch method on simple statement object, call executeBatch method and commit connection object.

[Tolls]

It's only one statement, so batching would be unecessary.
Actually, the title of this thread doesn't seem to match the OP...the title implies a SELECT, and the post is talking about an UPDATE.

[diamonddragon]

Then execute update statement singly.