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
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