fll.JudgeInformation.java Source code

Introduction

Here is the source code for fll.JudgeInformation.java

Source

/*
 * Copyright (c) 2012 INSciTE.  All rights reserved
 * INSciTE is on the web at: http://www.hightechkids.org
 * This code is released under GPL; see LICENSE.txt for details.
 */

package fll;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collection;
import java.util.LinkedList;

import net.mtu.eggplant.util.sql.SQLFunctions;

import com.fasterxml.jackson.annotation.JsonCreator;
import com.fasterxml.jackson.annotation.JsonProperty;

/**
 * Judge information.
 */
public final class JudgeInformation implements Serializable {
    private final String id;

    public String getId() {
        return id;
    }

    private final String category;

    public String getCategory() {
        return category;
    }

    private final String station;

    public String getStation() {
        return station;
    }

    @JsonCreator
    public JudgeInformation(@JsonProperty("id") final String id, @JsonProperty("category") final String category,
            @JsonProperty("station") final String station) {
        this.id = id;
        this.category = category;
        this.station = station;
    }

    @Override
    public int hashCode() {
        return id.hashCode();
    }

    @Override
    public boolean equals(final Object o) {
        if (null == o) {
            return false;
        } else if (o == this) {
            return true;
        } else if (o.getClass().equals(JudgeInformation.class)) {
            final JudgeInformation other = (JudgeInformation) o;
            return getId().equals(other.getId()) && getCategory().equals(other.getCategory())
                    && getStation().equals(other.getStation());
        } else {
            return false;
        }
    }

    /**
     * Get all judges stored for this tournament.
     * 
     * @param connection the database
     * @param tournament tournament ID
     * @return the judges
     * @throws SQLException
     */
    public static Collection<JudgeInformation> getJudges(final Connection connection, final int tournament)
            throws SQLException {
        Collection<JudgeInformation> judges = new LinkedList<JudgeInformation>();

        ResultSet rs = null;
        PreparedStatement stmt = null;
        try {
            stmt = connection.prepareStatement("SELECT id, category, station FROM Judges WHERE Tournament = ?");
            stmt.setInt(1, tournament);
            rs = stmt.executeQuery();
            while (rs.next()) {
                final String id = rs.getString(1);
                final String category = rs.getString(2);
                final String station = rs.getString(3);
                final JudgeInformation judge = new JudgeInformation(id, category, station);
                judges.add(judge);
            }
        } finally {
            SQLFunctions.close(rs);
            SQLFunctions.close(stmt);
        }

        return judges;
    }
}