public void loadEvent(String id) {
        if (!StringUtil.isBlank(id)) {
            PreparedStatement st = null;
            ResultSet rs = null;
            try {
                conn = dbconn.getConnection();
                st = conn.prepareStatement("SELECT * FROM events WHERE id = " + id + " limit 1");
                rs = st.executeQuery();
                if (rs.next()) {
                    setId(rs.getInt("id"));
                    setName(rs.getString("name"));
                    setLocation(rs.getString("location"));
                    if (rs.getDate("start_date") != null) {
                        this.startDate = rs.getDate("start_date").toString();
                    }
                    if (rs.getDate("end_date") != null) {
                        this.endDate = rs.getDate("end_date").toString();
                    }
                } else {
                    System.out.println("event 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");
                }
            }
        }
    }