dreampolice
Technical User
I have a PreparedStatement with alot of values to insert into an Oracle Database.
Anyway to shorten the setString lines in a loop or any other way to shorten this??
Anyway to shorten the setString lines in a loop or any other way to shorten this??
Code:
//Database connection part here
//......
private PreparedStatement stmt;
public void houseMethod(BeanInfo theObject)
{
stmt = connection.prepareStatement("Insert into MainTable (house, zipcode, city, county, phone, mortgage, tax, insurance, state, land) values (?,?,?,?,?,?,?,?,?,?)");
stmt.setString(1, theObject.getHouse());
stmt.setString(2, theObject.getZipcode());
stmt.setString(3, theObject.getCity());
stmt.setString(4, theObject.getCounty());
stmt.setString(5, theObject.getPhone());
stmt.setString(6, theObject.getMortgage());
stmt.setString(7, theObject.getTax());
stmt.setString(8, theObject.getInsurance());
stmt.setString(9, theObject.getState());
stmt.setString(10, theObject.getLand());
stmt.executeUpdate();
}