Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic