• Post Reply Bookmark Topic Watch Topic
  • New Topic

Getting current row

 
jacq carballo
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All!
After doing a query on a database, i do the following:
while (rs.next())
{
salvage everything from the current row.
move the current row to a master table
}
question:
what method should i use in order to select the current row and move it to the master table?
is there a short way aside from the following?
command = "insert into <master> " +
"( " +
"field1 " +
"field2 " +
"field3 " +
") " +
"values " +
"( " +
rs.getString("field1") + ", " +
rs.getString("field2") + ", " +
rs.getString("field3") + ", " +
") "
i know that there should be an api that has a method that would simply allow you to select the content of the whole row.
tia
jacq carballo
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!