public String createEvent(String username, String calendar, String description, Date start, Date end, String location) {
		try {
			java.sql.Timestamp sqlDateStart = new java.sql.Timestamp(start.getTime());
			java.sql.Timestamp sqlDateEnd = new java.sql.Timestamp(end.getTime());

			crs = qb.selectFrom("calendars").where("calendar", "=", calendar).executeQuery();
			if(crs.next()) {
				if(crs.getString("createdBy").equals(username)) {
					String[] keys = {"eventType", "description", "start", "end", "location", "createdBy", "calendar"};
					String[] values = {"Userevent", description, sqlDateStart.toString(), sqlDateEnd.toString(), location, username, calendar};
					qb.insertInto("events", keys).values(values).execute();
					return "Event created";
				} else {
					return "Only calendar creator can create events";
				}
			} else {
				return "Calendar does not exist";
			}
		} catch (SQLException e) {
			return "error";
		} finally {
			try {
				crs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}