Right, i need to be put on suicide watch after spending two days solid on this, so i have decided to take another approach. So i am going back to the INSERT INTO part of my code but i wanna make a slight change,
heres the original statement
CODE
try
{
con = DatabaseUtils.connect(DRIVER, URL);
String sql = "INSERT INTO Competitor(Competitor_ID, First_Name, Last_Name, Time_Set) VALUES (?, ?, ?, ?)";
ps = con.prepareStatement(sql);
for(int i = 0; i < update1.length; i++)
{
ps.setString(1, update2[i].getidNo());
ps.setString(2, update2[i].getFirstname());
ps.setString(3, update2[i].getLastname());
ps.setString(4, update2[i].getTime());
ps.addBatch();
}
int[] upCounts = ps.executeBatch( );
con.commit( );
}
Now the object i am looping has four variables going to the same table. I would like to remove the fourth one, Time_Set, and send it to a different table called RoundCompetitor. Is this possible or would i need to create a new Object which only has the first three variables?
cheers
| 