Refine search
Query q = sessionFactory.getCurrentSession().createQuery("from LoginInfo where userName = :name"); q.setParameter("name", userName); List<LoginInfo> loginList = q.list();
Query query = session.createQuery( "from Employee e join e.skillGroups as s where s in (:skillGroups) group by e having count(s) = :skillGroupsLength"); query.setParameterList("skillGroups", skillGroups); query.setParameter("skillGroupsLength", skillGroups.length); List list = query.list();
Map<String, Object> params = new HashMap<String, Object>(); StringBuffer hql = new StringBuffer("from Product p"); boolean first = true; if (category != null) { hql.append(first ? " where " : " and "); hql.append("p.category = :category"); params.put("category", category); } // And so on... Query query = session.createQuery(hql.toString()); Iterator<String> iter = params.keySet().iterator(); while (iter.hasNext()) { String name = iter.next(); Object value = params.get(name); query.setParameter(name, value); } List results = query.list()
Query query = session.createQuery("from Employee e join e.skillGroups as s where s in (:skillGroups)"); // skillGroups must be a Collection type query.setParameterList("skillGroups", skillGroups); query.setParameter("skillGroupsLength", skillGroups.length); List list = query.list();
session = sessionFactory.openSession(); String hql =" from CustomObjectId c where c.fileName in :fileName"; Query query = session.createQuery(hql); query.setParameter("fileName", fileName); List file=query.list();
SimpleDateFormat formatter = new SimpleDateFormat("dd-MM-YYYY"); String fromDate = "11-07-2014"; Date fromDt = formatter.parse(fromDate); String toDate = "11-07-2014"; Date toDt = formatter.parse(toDate); String userInQuery = "from log where userName in (:userList) and systemdate between :fromDate and :toDate"; Query q = s.createQuery(userInQuery); q.setParameterList("usersList", users); q.setParameter("fromDate", fromDt); q.setParameter("toDate", toDt); q.list();
String qStr = "from User user where user.userName = :userName"; //then run the query to get the user Query q = session.createQuery(qStr); q.setParameter("userName", userName); List<User> users = (List<User>) q.list(); //if the list is not empty, then users.get(0) will give you the object
String queryString = "..."; Query q = session.createQuery(queryString); q.setParameter("orderNo", orderNumber); List<Order> results = q.list();
public List<Local> listLocal(String userLogin) { Query query = sessionFactory.getCurrentSession() .createQuery("select u.userLocales from User u where u.login = ?"); query.setParameter(0, userLogin); return query.list(); }
public List<String[]> getContacts(String param) { Query q = this.getCurrentSession().createSQLQuery("select first_name, last_Name, email_address, fax from contacts where first_name = :param"); q.setParameter("param", param); List<String[]> listResult = q.list(); return listResult; }
String[] likes = {"foo", "bar"}; String myQuery = "select e from User e where 1=1"; for(int i=0; i<likes.length; i++){ myQuery+= " and e.name like :"+i; } Query query = getSessionFactory().getCurrentSession().createQuery(myQuery); for(int i=0; i<likes.length; i++){ query.setParameter(i, "%"+likes[i]+"%"); } query.list();
public List<Entity> getEntitiesAfterDate(Date date) { Query query = openSession().getNamedQuery("Entity.findAfterDate"); query.setParameter("dateAfter", date); return query.list(); }
public List<DriversLicence> findDriversLicencesWith(List<LicenceClass> licenceClasses) { String hqlString = "select dl from DriversLicenceImpl dl where 1=1 "; for (int i = 0; i < licenceClasses.size(); i++) { hqlString += " and :licenceClass" + i + " = some elements(dl.licenceClasses)"; } Query query = getSession().createQuery(hqlString); for (int i = 0; i < licenceClasses.size(); i++) { query.setParameter("licenceClass" + i, licenceClasses.get(i)); } return query.list(); }
Query q = session.createQuery("from ModelClassname where ClassVariableId= :ClassVariableId"); q.setParameter("ClassVariableId", 001); ModelClassname result = (ModelClassname)q.list().get(0); Integer i = result.getClassVariableName(); result.setClassVariableName(i+10); session.update(result);
String hql = "select eq.euipmentName,eq.type " + " from Euipment eq " + " where eq.id in (select qt.euipment from Quotation qt where qt.supQuotation = :ids)"; Query query = session.createQuery(hql); query.setParameter("ids",id); list = (List<Euipment>)query.list();
Query q = session.createQuery("from RegisterPojo where email =:email"); q.setParameter("email", "Fred@Example.com"); RegisterPojo pojo= (RegisterPojo)q.list().get(0); pojo.setName("Fred"); session.update(pojo);
public List<Object[]> getContacts(String param) { Query q = this.getCurrentSession().createSQLQuery("select first_name, last_Name, email_address, fax from contacts where first_name = :param"); q.setParameter("param", param); List<Object[]> listResult = q.list(); return listResult; }
Query query = session.createQuery(" FROM FlightHasSteward where Flight_idFlight = :code"); query.setParameter("code", flightid); List<FlightHasSteward> result = query.list(); final List<FlightHasSteward> res = (List<FlightHasSteward>) query.list(); for (final FlightHasSteward steward : res) { System.out.println(steward.getId().getStewardIdsteward()); }
String hql = "from CrawlerElement e where request.id = :requestId"; Query q = getSession().createQuery(sql); //getSession is not the actual method. q.setParameter("requestId", id); elements = q.list(); //elements is a List<CrawlerElement> where CrawlerElement which is actual @Entity return elements;
Query q = session.createQuery("from Exam exam where exam.student.name=:name"); q.setParameter("name", "xyz"); <br> Exam exam = (Exam)q.list().get(0); <br/> </br>