public static List<Event> load(){
		Connection conn = null;
		Statement stat = null;
		ResultSet result = null;
		List<Event> list = new ArrayList<Event>();
		
		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/gent?user=root&password=root");
			stat = conn.createStatement();
			result = stat.executeQuery("select name, create_time, flag from event;");
			while(result.next()){
				Event evt = new Event();
				evt.setName(result.getString("name"));
				evt.setFlag(result.getInt("flag"));
				evt.setCreateTime(result.getDate("create_time"));
				list.add(evt);
			}
		} catch (InstantiationException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(result != null){
				try {
					result.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				result = null;
			}
			if(stat != null){
				try {
					stat.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				stat = null;
			}
		}
		
		return list;
	}