Package org.hibernate

Examples of org.hibernate.Session.createQuery()

67
68
69
70
71
72
73
74
75
76
77
    }

    @Override
    public Iterable<User> find(int skip, int limit) {
        Session session = sessionManager.getSession();
        List<User> users = session.createQuery("select user from " + SqlUser.class.getSimpleName() + " as user")
                .setFirstResult(skip)
                .setMaxResults(limit)
                .list();
        return users;
    }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
    }

    @Override
    public Iterable<User> findByStatus(int skip, int limit, UserStatus status) {
        Session session = sessionManager.getSession();
        List<User> users = session.createQuery("select user from " + SqlUser.class.getSimpleName() + " as user where user.status = :status")
                .setParameter("status", status.toString())
                .setFirstResult(skip)
                .setMaxResults(limit)
                .list();
        return users;
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
    }

    @Override
    public User findById(String userId) {
        Session session = sessionManager.getSession();
        List<SqlUser> users = session.createQuery("select user from " + SqlUser.class.getSimpleName() + " as user where user.userId=:id")
                .setParameter("id", userId)
                .list();
        if (users.size() == 0) {
            return null;
        } else if (users.size() > 1) {
View Full Code Here
225
226
227
228
229
230
231
232
233
234
235
            transaction = session.beginTransaction();
            sqlUser = (SqlUser) findById(userId);
            if (sqlUser == null) {
                throw new LumifyException("User does not exist");
            }
            List<SqlWorkspace> workspaces = session.createQuery
                    ("select workspace from " + SqlWorkspace.class.getSimpleName() + " as workspace where workspace.workspaceId=:id")
                    .setParameter("id", workspaceId)
                    .list();
            if (workspaces.size() == 0) {
                throw new LumifyException("Could not find workspace with id: " + workspaceId);
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
        Session session = sessionManager.getSession();
        Transaction transaction = null;
        try {
            transaction = session.beginTransaction();
            String nullCurrentWorkspacesSql = "update " + SqlUser.class.getSimpleName() + " set current_workspace_id = null where current_workspace_id = :workspaceId";
            Query query = session.createQuery(nullCurrentWorkspacesSql).setString("workspaceId", workspace.getWorkspaceId());
            session.delete(workspace);
            query.executeUpdate();
            transaction.commit();
        } catch (HibernateException e) {
            if (transaction != null) {
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
    transaction.commit();
    session.clear();
    transaction = session.beginTransaction();

    // search and update
    StockItem loadedItem = (StockItem) session.createQuery( "from StockItem si" ).uniqueResult();
    assertNotNull( "Cannot load persisted object", loadedItem );
    loadedItem.setCount( 24 );

    transaction.commit();
    session.clear();
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
        try {

            try {
                Session session = NewHibernateUtil.getSessionFactory().openSession();
                session.beginTransaction();
                Query q = session.createQuery("from Documents");
                List resultList = q.list();

                for (Object o : resultList) {
                    Documents actor = (Documents) o;
                    System.out.println(actor.getTitle());
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
    try {
      sessionFactory = HibernateSessionFactory.getInstance();
      session = sessionFactory.openSession();
      for (BOHistory history : project.getCurrentHistoryForProject()) {
        if (history.getHistoryAction() == HistoryAction.Delete && history.getHistoryTable() == HistoryTable.Tasks) {
          Query query = session.createQuery(strQuery + history.getHistoryItem());
          int rows = query.executeUpdate();
        }
      }
    } catch (Exception a_th) {
      throw new RuntimeException(a_th);
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
    BOUser user = null;
    try {
      sessionFactory = HibernateSessionFactory.getInstance();
      session = sessionFactory.openSession();

      Query query = session.createQuery("from BOUser as user where user.loginName = :username and user_password = MD5(:password)");
      query.setString("username", userName);
      query.setString("password", password);
      List<BOUser> lstUsers = query.list();
      if(lstUsers != null && lstUsers.size() > 0) {
        user = lstUsers.get(0);
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
    Session session = null;
    try {
      sessionFactory = HibernateSessionFactory.getInstance();
      session = sessionFactory.openSession();
      String query = "from BOFile as f where f.rootFileID = :rootFileID";
      Query q = session.createQuery(query);
      q.setParameter("rootFileID", versionID);
      return q.list();
    } catch (Exception a_th) {
      throw new RuntimeException(a_th);
    } finally {
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.