public void updateMatchRecord() {
        if (id != null) {
            PreparedStatement st = null;
            try {
                conn = dbconn.getConnection();
                String q = "UPDATE match_record_2013 SET " +
                        "team_id = ?, match_number = ?, color = ?, " +
                        "auton_top = ?, auton_middle = ?, auton_bottom = ?, " +
                        "teleop_top = ?, teleop_middle = ?, teleop_bottom = ?, " +
                        "teleop_pyramid = ?, pyramid_level = ?, play_style = ?, " +
                        "confidence = ?, ability = ?, fouls = ?, " +
                        "technical_fouls = ?, comments = ?, path = ?, event_id = ? WHERE id = ?";
                st = conn.prepareStatement(q);
                st.setInt(1, this.teamId);
                st.setInt(2, this.matchId);
                st.setString(3, this.color);
                st.setInt(4, this.autonTop);
                st.setInt(5, this.autonMiddle);
                st.setInt(6, this.autonBottom);
                st.setInt(7, this.teleopTop);
                st.setInt(8, this.teleopMiddle);
                st.setInt(9, this.teleopBottom);
                st.setInt(10, this.teleopPyramid);
                st.setInt(11, this.pyramidLevel);
                st.setString(12, this.playStyle);
                st.setInt(13, this.confidence);
                st.setInt(14, this.ability);
                st.setBoolean(15, this.fouls);
                st.setBoolean(16, this.technicalFouls);
                st.setString(17, this.comments);
                st.setString(18, this.path); //TODO path
                st.setInt(19, this.eventId);
                st.setInt(20, this.id.intValue());
                
                st.executeUpdate();
            } catch (SQLException e) {
                System.out.println("Unable to roll back transaction");
            } finally {
                try {
                    conn.close();
                    st.close();
                } catch (SQLException e) {
                    System.out.println("Unable to close connection");
                }
            }
        }
        else {
            System.out.println("Unable to update match record because id is null");
        }
    }