public UserEntity updateUserHobby(UserEntity user, HobbyEntity hobby, boolean deleted) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    int id = user.getId();

    String queryStr = "from UserHobbyEntity where userId = :userId and hobbyId = :hobbyId";
    List<UserHobbyEntity> userHobbies =
        session
            .createQuery(queryStr)
            .setString("userId", String.valueOf(id))
            .setString("hobbyId", String.valueOf(hobby.getId()))
            .list();

    if (userHobbies.size() == 0) {
      UserHobbyEntity userHobbyEntity = new UserHobbyEntity();
      userHobbyEntity.setUserId(id);
      userHobbyEntity.setHobbyId(hobby.getId());
      userHobbyEntity.setDeleted(deleted);

      session.beginTransaction();
      session.save(userHobbyEntity);
      session.getTransaction().commit();
    } else {
      UserHobbyEntity userHobbyEntity = userHobbies.get(0);
      userHobbyEntity.setDeleted(deleted);
      session.beginTransaction();
      session.update(userHobbyEntity);
      session.getTransaction().commit();
    }

    session.close();
    return user;
  }
  public List<UserHobbyEntity> getUserHobby(UserEntity user) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    String queryStr = "from UserHobbyEntity where userId = :userId and deleted = false";
    List<UserHobbyEntity> list =
        session.createQuery(queryStr).setString("userId", String.valueOf(user.getId())).list();

    session.close();
    return list;
  }
  public List<UserEntity> getUser(String userName) {
    Session session = HibernateUtil.getSessionFactory().openSession();

    String queryStr = "from UserEntity where userName = :userName";
    List<UserEntity> list = session.createQuery(queryStr).setString("userName", userName).list();

    session.close();
    return list;
  }
  @Override
  public List<UserEntity> getUser(int userId) {
    Session session = HibernateUtil.getSessionFactory().openSession();

    String queryStr = "from UserEntity where id = :userId";
    List<UserEntity> list = session.createQuery(queryStr).setInteger("userId", userId).list();

    session.close();
    return list;
  }
  public UserEntity updateUserPersonality(UserEntity user, PersonalityEntity personality) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    user.setPersonality(personality.getId());
    session.beginTransaction();
    session.update(user);
    session.getTransaction().commit();

    session.close();
    return user;
  }
  @Override
  public UserEntity updateUserDisplayName(UserEntity user, String displayName) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    user.setDisplayName(displayName);
    session.beginTransaction();
    session.update(user);
    session.getTransaction().commit();

    session.close();
    return user;
  }
  public UserEntity updateUserGender(UserEntity user, String gender) {
    Session session = HibernateUtil.getSessionFactory().openSession();

    user.setGender(gender);
    session.beginTransaction();
    session.update(user);
    session.getTransaction().commit();

    session.close();
    return user;
  }
  @Override
  public UserEntity updateProfileImage(UserEntity user, String imageURL) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    user.setProfileImageUrl(imageURL);

    session.beginTransaction();
    session.update(user);
    session.getTransaction().commit();

    session.close();
    return user;
  }
  @Override
  public UserEntity updatePhoneNumber(UserEntity user, String phoneNumber) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    user.setPhoneNum(phoneNumber);

    session.beginTransaction();
    session.update(user);
    session.getTransaction().commit();

    session.close();
    return user;
  }
  @Override
  public List<ArrangementGuestEntity> getAllComments(UserEntity user) {
    Session session = HibernateUtil.getSessionFactory().openSession();

    String queryStr =
        "select age from com.linterest.entity.ArrangementGuestEntity as age "
            + ", com.linterest.entity.ArrangementEntity as ae "
            + "where age.arrangementId = ae.id and ae.host = :user "
            + "order by age.commentStar desc";
    List<ArrangementGuestEntity> userHobbies =
        session.createQuery(queryStr).setEntity("user", user).list();

    return userHobbies;
  }
  public UserEntity userSignup(String userName, String password) {
    Session session = HibernateUtil.getSessionFactory().openSession();

    password = DigestUtils.md5Hex(password);

    UserEntity user = new UserEntity();
    user.setUserName(userName);
    user.setPassword(password);

    session.getTransaction().begin();
    session.persist(user);
    session.getTransaction().commit();

    session.close();
    return user;
  }
  public UserEntity userSignupWithDevice(String deviceName, String deviceId) {
    Session session = HibernateUtil.getSessionFactory().openSession();

    String queryStr =
        "from UserDeviceIdEntity where deviceName = :deviceName and deviceId = :deviceId";
    List<UserDeviceIdEntity> list =
        session
            .createQuery(queryStr)
            .setString("deviceName", deviceName)
            .setString("deviceId", deviceId)
            .list();
    UserEntity user;
    if (list.size() > 0) {
      // Device found.
      UserDeviceIdEntity deviceIdEntity = list.get(0);
      user = deviceIdEntity.getUser();
      session.beginTransaction();
      session.update(user);
      session.getTransaction().commit();
    } else {
      // Device not found.
      user = new UserEntity();
      user.setUserName(Constants.GUEST_NAME);
      user.setPassword(DigestUtils.md5Hex(Constants.GUEST_PASSWORD));

      UserDeviceIdEntity deviceIdEntity = new UserDeviceIdEntity();
      deviceIdEntity.setDeviceName(deviceName);
      deviceIdEntity.setDeviceId(deviceId);
      deviceIdEntity.setUser(user);

      session.beginTransaction();
      session.save(deviceIdEntity);
      session.getTransaction().commit();

      user = deviceIdEntity.getUser();
    }

    session.close();
    return user;
  }