private CbsID findExistingPlayer(Integer id) throws SQLException {
CbsID cbsID = new CbsID();
String sql = "SELECT * FROM cbsids WHERE cbs_id = ?";
ResultSet resultSet = connection.prepareAndExecuteStatementFetch(sql, id);
if (resultSet.next()) {
cbsID.initializeFromDBObject(resultSet);
} else {
cbsID.initializeForInsert();
cbsID.cbs_id.changeValue(id);
cbsID.dateAdded.changeValue(localDate.toDate());
cbsID.dateModified.changeValue(localDate.toDate());
}
return cbsID;
}
