I am trying to insert records from one sql table into another table automatically by running this method for JUNIT testing purposes. Here is the code that I've tried to write but I'm stuck as to get it to work as well as wondering if I'm going about correctly, so ANY HELP or DIRECTION would be appreciated:
[edited to add code tags] [ September 23, 2005: Message edited by: Jeanne Boyarsky ]
I'm fairly new to Java and I was trying to select from one table and insert the results into a another table. I think I now know that I need to return a resultset and then use that resultset in another method to use in an insert statement by passing into that method the resultset.