Package org.hibernate

Examples of org.hibernate.Criteria.list()

30
31
32
33
34
35
36
37
38
39
40
     
     
      if(user.getUserType()==UserType.Administrator)
      {
        Criteria criteria = session.createCriteria(BOCompany.class);
        return criteria.list();
      }
     
      else
      {
        ArrayList<BOCompany> companyList = new ArrayList<BOCompany>();
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
      session = sessionFactory.openSession();

      Criteria criteria = session.createCriteria(BOFile.class);
      criteria.add(Restrictions.eq("taskID", taskID));
      criteria.add(Restrictions.sqlRestriction(" file_id in(select max(fl.file_id) from files as fl group by fl.file_version_id) "));
      return criteria.list();
     
    } catch (Exception a_th) {
      throw new RuntimeException(a_th);
    } finally {
      close(sessionFactory, session);
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
      sessionFactory = HibernateSessionFactory.getInstance();
      session = sessionFactory.openSession();
      Criteria criteria = session.createCriteria(BOFile.class);
      criteria.add(Restrictions.eq("project", project));
      criteria.add(Restrictions.sqlRestriction(" file_id in(select max(fl.file_id) from files as fl group by fl.file_version_id) "));
      return criteria.list();
    } catch (Exception a_th) {
      throw new RuntimeException(a_th);
    } finally {
      close(sessionFactory, session);
    }
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
                Criteria criteria = session.createCriteria(ArticleType.class);
               
                criteria = prCatNo!=null?criteria.add(Restrictions.eq("prodCatNo", prCatNo)):criteria.add(Restrictions.isNull("prodCatNo"));
                criteria = prCatNo2!=null?criteria.add(Restrictions.eq("prodCatNo2", prCatNo2)):criteria.add(Restrictions.isNull("prodCatNo2"));
               
                List<ArticleType> list =criteria.list();
                if (list != null && list.size() == 1) {
                    return list.get(0);
                }
                return ArticleType.UNKNOWN;
            }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
            crit = crit.createCriteria("supplierType").add(
                Restrictions.ilike("supplierTypeName",
                    typeString));

            return crit.list();
          }

        });
  }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
                              "productAreaGroup",
                              productAreaGroup));
            }


            return crit.list();
          }

        });
  }
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
                .add(Restrictions.eq("customerNr", customerNr));
           
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }

        });
  }
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
                .add(Restrictions.eq("orderNr", orderNr));
           
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }

        });
  }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
                .add(Restrictions.eq("customerNr", customerNr));
           
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }

        });
  }
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
                Restrictions.eq("orderNr", orderNr));
           
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }

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