try {
selectStatement.setString(1, name);
ResultSet resultSet = selectStatement.executeQuery();
while (resultSet.next()) {
list.add(new Record(resultSet.getLong(1), name, resultSet.getString(2), resultSet.getBigDecimal(3), resultSet.getBigDecimal(4), resultSet.getDate(5), resultSet.getDate(6)));
}
} catch (SQLException sqlex) {
dealWithSQLException(sqlex, "selecting record from " + table());
}