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; }