private void createData() throws RetsServerException, SQLException {
PreparedStatement ps = null;
ConnectionHelper helper = RetsServer.createHelper();
try {
Connection con = helper.getConnectionTransaction();
ps =
con.prepareStatement(
"INSERT INTO "
+ "rets_property_res(id,r_lp,r_broker,r_agent_id,r_ln,"
+ " r_zip_code,r_ld,r_sqft,r_e_school,"
+ " r_m_school,r_h_school,r_stname,r_url,"
+ " r_ltyp, r_stnum, r_vew, r_ar,r_status,"
+ " r_owner)"
+ " VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);");
for (int i = 0; i < mNumProperties; i++) {
// todo: LookupMulti EF needs to be added.
// todo: LookupMulti IF needs to be added.
mCount += mRandom.nextInt(10);
ps.setInt(1, i);
ps.setInt(2, mRandom.nextInt(1000000));
ps.setString(3, getNextBroker());
ps.setString(4, getNextAgent());
ps.setString(5, "LN" + Long.toHexString(i));
ps.setInt(6, mRandom.nextInt(99999));
ps.setDate(7, getNextDate());
ps.setString(8, Long.toString(mRandom.nextInt(7000)));
ps.setInt(9, getNextSchool());
ps.setInt(10, getNextSchool());
ps.setInt(11, getNextSchool());
ps.setString(12, getNextStreet());
ps.setString(13, getNextURL());
ps.setString(14, getNextListingType());
ps.setString(15, Long.toString(mRandom.nextInt(9999999)));
ps.setInt(16, mRandom.nextInt(2048));
ps.setString(17, getNextLocation());
ps.setString(18, getNextStatus());
ps.setString(19, getNextOwner());
ps.execute();
}
ps.close();
helper.commit();
} finally {
helper.close(LOG);
}
}
private void dropData() throws RetsServerException, SQLException {
ConnectionHelper helper = RetsServer.createHelper();
Connection connection = null;
Statement statement = null;
try {
connection = helper.getConnection();
statement = connection.createStatement();
statement.execute("delete from rets_property_res");
helper.commit();
} finally {
if (statement != null) statement.close();
helper.close(LOG);
}
}