Hi all,
PreparedStatement prep = conn.prepareStatement("select company_name, contact_name, address, address2, city, pcode, country, phone, fax, email, website from customer");
ResultSet rs = prep.executeQuery();
while (rs.next()) {
//what I would like to do here is to set up a variable which...