public User getUserByEmail(String email) {
		try {
			String sql = "select * from user where email=" + email;
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			if (rs.next()) {
				User user = new User();
				user.setUserId(Integer.parseInt(rs.getString("user_id")));
				user.setEmail(rs.getString("email"));
				user.setPassword(rs.getString("password"));
				stmt.close();
				rs.close();
				closeConnection();
				return user;
			} else {
				stmt.close();
				rs.close();
				closeConnection();
				return null;
			}
		} catch (Exception e) {
			e.printStackTrace();
		}

		return null;
	}