Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Muyiwa Johnnny
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Jim Yingst
Wanderer
Sheriff
Posts: 18671
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This question doesn't make any sense in the "meaningless drivel" forum, so I'm monving it to JDBC.
 
lenin laker
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic