private static final MerchItemPackage loadItemFrom_Database(int accountid) {
Connection con = DatabaseConnection.getConnection();
try {
PreparedStatement ps = con.prepareStatement("SELECT * from hiredmerch where accountid = ?");
ps.setInt(1, accountid);
ResultSet rs = ps.executeQuery();
if (!rs.next()) {
ps.close();
rs.close();
return null;
}
int packageid = rs.getInt("PackageId");
MerchItemPackage pack = new MerchItemPackage();
pack.setPackageid(packageid);
pack.setMesos(rs.getInt("Mesos"));
pack.setSavedTime(rs.getLong("time"));
ps.close();
rs.close();
Map<Long, Pair<Item, MapleInventoryType>> items =
ItemLoader.HIRED_MERCHANT.loadItems(false, packageid);
if (items != null) {
List iters = new ArrayList();
for (Pair z : items.values()) {
iters.add(z.left);
}
pack.setItems(iters);
}
return pack;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
