Forums Register Login

Retreiving data from Table_A and at the same time inserting into Table_A

+Pie Number of slices to send: Send
I want to retreive data from a database and insert into the same database but a different table on the database.
The idea is I want to treive data from Table_A and regarding what I have in the resultSet ,I'll insert into Table_2 that's the second table in the same database,I try using vector as a placeholder for the resultSet but accessing all the data from the first row to the last row is where i have an issue ,I use for loop to loop through the elements and i was able to display the last record on Table_A and I don't have clue of how to insert into Table_B
+Pie Number of slices to send: Send
This question doesn't make any sense in the "meaningless drivel" forum, so I'm monving it to JDBC.
+Pie Number of slices to send: Send
Hi,
This is just a sample I am giving.
Open connection.
Read data from ResultSet to some Strings, Integers as of ur request.
Fire insert statement for each row want u read
While (Reading Table A resultSet)
{
//Talkeing the result row into java variables.
String ..
String..
con.execute (Fire insert for each row into table B)
}
is it clear?
He puts the "turd" in "saturday". Speaking of which, have you smelled this tiny ad?
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 923 times.
Similar Threads
select vs count(*) - Performance Comparison
More problems with file uploads
what is difference between JDBC1 and JDBC2 ?
Auto increment key in Hibernate
access rows from html table
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 03:46:43.