public void loadMatchRecord(String id) {
        if (!StringUtil.isBlank(id)) {
            PreparedStatement st = null;
            ResultSet rs = null;
            try {
                conn = dbconn.getConnection();
                st = conn.prepareStatement("SELECT * FROM match_record_2013 WHERE id = " + id + " limit 1");
                rs = st.executeQuery();
                if (rs.next()) {
                    setId(rs.getInt("id"));
                    setUser(rs.getString("user"));
                    setTeamId(rs.getInt("team_id"));
                    setMatchId(rs.getInt("match_number"));
                    setEventId(rs.getInt("event_id"));
                    setColor(rs.getString("color"));
                    setAutonTop(rs.getInt("auton_top"));
                    setAutonMiddle(rs.getInt("auton_middle"));
                    setAutonBottom(rs.getInt("auton_bottom"));
                    setTeleopTop(rs.getInt("teleop_top"));
                    setTeleopMiddle(rs.getInt("teleop_middle"));
                    setTeleopBottom(rs.getInt("teleop_bottom"));
                    setTeleopPyramid(rs.getInt("teleop_pyramid"));
                    setPyramidLevel(rs.getInt("pyramid_level"));
                    setPlayStyle(rs.getString("play_style"));
                    setConfidence(rs.getInt("confidence"));
                    setAbility(rs.getInt("ability"));
                    setFouls(rs.getBoolean("fouls"));
                    setTechnicalFouls(rs.getBoolean("technical_fouls"));
                    setComments(rs.getString("comments"));
                    setPath(rs.getString("path"));    // TODO path
                } else {
                    System.out.println("match record id " + id.toString() + " not found");
                }
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                try{
                    conn.close();
                    st.close();
                    rs.close();
                }catch (SQLException e) {
                    System.out.println("Error closing query");
                }
            }
        }
    }