public void load() { ThreadConnection c = ThreadConnection.getInstance(); try { PreparedStatement s = c.prepareStatement(STATEMENT); for (int i = 0; i < fields.length; i++) if (fields[i] != null) s.setString(i + 1, fields[i]); else s.setNull(i + 1, Types.VARCHAR); s.setDate(10, createdTimestamp); for (int i = 0; i < ifields.length; i++) s.setInt(11 + i, ifields[i]); c.addBatch(); } catch (SQLException e) { logger.log(Level.SEVERE, e.getMessage(), e); } }