public static List<Event> selectAllEvents(){
        try{
            Connection con = DB.getConnection();
            PreparedStatement ps = con.prepareStatement(SELECTALLEVENTS);
            ResultSet result = ps.executeQuery();
            List<Event> events = new ArrayList<Event>();
            while(result.next()){
                events.add(extractEvent(result));
            }
            return events;            
        } catch(Exception ex){ 
            ex.printStackTrace();
        }
        return null;
    }