private int makeReservation(String date, String movieName, String username) {
		String sql = "insert into Reservations(performanceId, userId) " +
		"select Performances.id as performanceId, Users.id as userId " +
		"from Performances, Users, Movies " +
		"where Performances.theDate = ? and Performances.movieId = Movies.id and Movies.name = ? and Users.username LIKE ?";
		PreparedStatement ps = null;
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1, date);
			ps.setString(2, movieName);
			ps.setString(3, username);
			int n = ps.executeUpdate();
			if(n == 1){
				ps.close();
				ps = conn.prepareStatement("Select LAST_INSERT_ID() from Reservations");
				ResultSet rs = ps.executeQuery();
				while (rs.next()) {
					return rs.getInt(1);
				}
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if(ps != null) ps.close();
			} catch(SQLException e2) {
				e2.printStackTrace();
			}
		}
		return -1;
	}