Package javax.persistence

Examples of javax.persistence.EntityManager


  public Usergroups[] getAllGroupFree(Long user_level) {
    Usergroups[] groups = new Usergroups[1];
    if (checkConfLevel(user_level)) {
      try {
        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
      tx.begin();
        Query query = session
            .createQuery("select c from usergroup_id as c where c.level_id = :level_id");
        query.setParameter("level_id", 1);
        int count = query.getResultList().size();
        groups = new Usergroups[count];
        int k = 0;
View Full Code Here


  public Usergroups getSingleGroupFree(Long user_level, Long usergroup_id) {
    Usergroups groups = new Usergroups();
    if (checkConfLevel(user_level)) {
      try {
        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
      tx.begin();
        Query query = session
            .createQuery("select c from Usergroups as c where c.usergroup_id = :usergroup_id AND c.level_id = :level_id");
        query.setParameter("usergroup_id", usergroup_id.longValue());
        query.setParameter("level_id", 1);
        for (Iterator it2 = query.getResultList().iterator(); it2.hasNext();) {
          groups = (Usergroups) it2.next();
View Full Code Here

   */
  public Users getUser(Long user_id) {
    if (user_id != null && user_id > 0) {
      try {
        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
      tx.begin();
        Query query = session.createQuery("select c from Users as c where c.user_id = :user_id");
        query.setParameter("user_id", user_id);
       
        session.flush();
       
        Users users = null;
        try {
          users = (Users) query.getSingleResult();
          } catch (NoResultException ex) {
          }
        session.refresh(users);
       
        tx.commit();
        PersistenceSessionUtil.closeSession(idf);
       
        //Somehow the Organizations are missing here o
View Full Code Here

 
  public void updateUser(Users user) {
    if (user.getUser_id() > 0) {
      try {
        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
        tx.begin();
        session.flush();
        if (user.getUser_id() == null) {
          session.persist(user);
            } else {
              if (!session.contains(user)) {
                session.merge(user);
            }
        }
        tx.commit();
        PersistenceSessionUtil.closeSession(idf);
      } catch (Exception ex2) {
View Full Code Here

        // result +=
        // Groupmanagement.getInstance().deleteUserFromAllGroups(new
        // Long(USER_ID));

        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
        tx.begin();
        if (us.getUser_id() == null) {
          session.persist(us);
            } else {
              if (!session.contains(us)) {
                session.merge(us);
            }
        }
        tx.commit();
       
        PersistenceSessionUtil.closeSession(idf);
View Full Code Here

   */
  public Long selectMaxFromUsers(){
    try {
      //get all users
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery("select count(c.user_id) from Users c where c.deleted = 'false'");
      List ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      log.info("selectMaxFromUsers"+(Long)ll.get(0));
      return (Long)ll.get(0);       
View Full Code Here

  public List<Users> getAllUsers(){
    try {
     
      //get all users
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Users> cq = cb.createQuery(Users.class);
      Root<Users> c = cq.from(Users.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      cq.where(condition);
      TypedQuery<Users> q = session.createQuery(cq);
      List<Users> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return ll;       
View Full Code Here

  public List<Users> getAllUsersDeleted(){
    try {
     
      //get all users
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Users> cq = cb.createQuery(Users.class);
      Root<Users> c = cq.from(Users.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      cq.where(condition);
      TypedQuery<Users> q = session.createQuery(cq);
      List<Users> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return ll;       
View Full Code Here

      hql += " )" ;
     
      log.debug("Show HQL: "+hql);           
     
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
     
      //log.debug("id: "+folderId);
     
      //query.setParameter("macomUserId", userId);
      //query.setParameter("messageFolder", folderId);
View Full Code Here

   * @return
   */
  public boolean checkUserLogin(String DataValue) {
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery("select c from Users as c where c.login = :DataValue AND c.deleted <> :deleted");
      query.setParameter("DataValue", DataValue);
      query.setParameter("deleted", "true");
      int count = query.getResultList().size();

      tx.commit();
View Full Code Here

TOP

Related Classes of javax.persistence.EntityManager

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.