@SuppressWarnings("unchecked") public List<Map<String, Object>> findMapBySql(String sql) { SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql); return sqlQuery.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list(); }
@SuppressWarnings("unchecked") public List<Map<String, Object>> findMapBySql(String sql, Map<String, Object> params) { SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql); sqlQuery=getSqlQueryByMap(sqlQuery,params); return sqlQuery.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list(); }
public List findMapBySql(String sql, Map<String, Object> params, int page, int rows,Class clazz) { SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql); sqlQuery=getSqlQueryByMap(sqlQuery,params); if(clazz==null){ sqlQuery.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP); }else{ sqlQuery.setResultTransformer(Transformers.aliasToBean(clazz)); } return sqlQuery.setFirstResult((page - 1) * rows).setMaxResults(rows).list(); }
@Override public List findMapBySql(String sql, Object[] params, Type[] types, Class clazz) { SQLQuery query = this.getCurrentSession().createSQLQuery(sql); if (clazz != null) { query.setResultTransformer(Transformers.aliasToBean(clazz)); } else { query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP); } query.setParameters(params, types); return query.list(); }
s.setResultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP); List<Map<String, Object>> resultList=new ArrayList<Map<String, Object>>(); try {
s.setResultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP); List<Map> resultList=new ArrayList<Map>(); List list = qry2.getResultList();
s.setResultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP); List<Map> resultList=new ArrayList<Map>(); List list = qry2.getResultList();
@Override public <T> List<T> find(String sql, Map<String,Object> params, Class<T> clazz) { SQLQuery query = this.getCurrentSession().createSQLQuery(sql); query=getSqlQueryByMap(query,params); query.setResultTransformer(Transformers.aliasToBean(clazz)); return query.list(); }
q.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE);
public Object _queryObj(String sql, Map<String, Object> paramMap) { Query query = entityManager.createNativeQuery(sql); query.unwrap(SQLQuery.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP); Iterator<String> it = paramMap.keySet().iterator(); while (it.hasNext()) { String key = it.next(); Object value = paramMap.get(key); query.setParameter(key, value); } return query.getSingleResult(); } //--------------------------------------------------------根据元数据生成表结构---------------------------------------------
String query = "SELECT id, IF(type = 'P', amount, amount * -1) as amount FROM report"; Session session = sessionFactory.openSession(); SQLQuery sqlQuery = session.createSQLQuery(query); sqlQuery.setResultTransformer(Transformers.aliasToBean(Report.class)); List<Report> resultList = sqlQuery.list(); session.close();
try{ String MYQUERY = "select DISTINCT lower(column1) as col1 from TABLE order by col1 asc"; List<(Object)> myList = null; SQLQuery query = getSession().createSQLQuery(MYQUERY); query.setResultTransformer(Transformers.aliasToBean(className)); query.addScalar("col1", StandardBasicTypes.STRING); myList = query.list(); } catch (HibernateException e) { System.out.println(e); }
@Override public List<Book> getAuthorBooks(String username) { List<Book> bookDTos = null; try (Session session = sessionFactory.openSession()) { SQLQuery sqlQuery = session.createSQLQuery("SELECT b.title as \"title\", b.price as \"price\"" + " FROM Author a , Book b where b.author_id = a.id and a.username=:username"); sqlQuery.setParameter("username", username); bookDTos = sqlQuery.setResultTransformer(Transformers.aliasToBean(Book.class)).list(); } return bookDTos; }
EntityManagerFactory emf = Persistence.createEntityManagerFactory("test"); EntityManager em = emf.createEntityManager(); Session sess = em.unwrap(Session.class); // <-- Use Hibernate-specific features SQLQuery query = sess.createSQLQuery( "SELECT AVG(age) AS averageAge, AVG(salary) as averageSalary FROM persons"); query.setResultTransformer(Transformers.aliasToBean(MyResult.class)); MyResult result = (MyResult) query.list().get(0);
public List getStudentSchedule(int a) { Session sessionHb = session.openSession(); String sql = "select stud.firstname,stud.roll,sub.subjectname,cls.classname,exam.exam_name,exam.from_time,exam.to_time,exam.exam_date from Student stud,Subject sub,Classs cls,Exam exam where exam.classs=cls.id and exam.subject=sub.id and sub.classs=cls.id and stud.classs=cls.id and stud.roll= :roll"; SQLQuery query = sessionHb.createSQLQuery(sql); query.setParameter("roll", a); query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP); return query.list(); }
@Override public Book getBook(String title) { Book bookDTo = null; try (Session session = sessionFactory.openSession()) { SQLQuery sqlQuery = session .createSQLQuery("SELECT b.title as \"title\", b.price as \"price\"" + " FROM Book b where b.title=:title"); sqlQuery.setParameter("title", title); bookDTo = (Book) sqlQuery.setResultTransformer(Transformers.aliasToBean(Book.class)).uniqueResult(); } return bookDTo; }
@Override public Author getAuthorByUsername(String username) { Author authorDTo = null; try (Session session = sessionFactory.openSession()) { SQLQuery sqlQuery = session .createSQLQuery("SELECT a.username as \"username\", a.name as \"name\", a.email as \"email\"" + "FROM Author a where a.username=:username"); sqlQuery.setParameter("username", username); authorDTo = (Author) sqlQuery.setResultTransformer(Transformers.aliasToBean(Author.class)).uniqueResult(); } return authorDTo; }
public List<Customer> getView( int startPage, int maxResults) { EntityManager entityManager = transactionManager.getEntityManagerFactory().createEntityManager(); Session session = entityManager.unwrap(Session.class); String sql = "SELECT customer.firstname, customer.lastname, customer.address, account.ano, account.bank FROM customer, account WHERE customer.cid = account.cid"; SQLQuery query = session.createSQLQuery(sql); query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP); List<Customer> vList = query.list(); if (entityManager.isOpen()) entityManager.close(); // session.close(); return vList; }
@SuppressWarnings("unchecked") public List<Map<String, Object>> findAllWithMap(final String ql, final Pageable pageable, final Object... params) { Query query = getEntityManager().createQuery(ql + prepareOrder(pageable != null ? pageable.getSort() : null)); applyEnableQueryCache(query); setParameters(query, params); if (pageable != null) { query.setFirstResult(pageable.getOffset()); query.setMaxResults(pageable.getPageSize()); } return query.unwrap(SQLQuery.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list(); }
// the corresponding method: private SQLQuery createQuery(HibernateTransaction t,int lowLimit,int pageSize) { final SQLQuery query = t.fullSQLQuery(MY_QUERY_STRING); query.addScalar("column1", Hibernate.LONG); query.addScalar("column2", Hibernate.LONG); query.setFirstResult(lowLimit); query.setMaxResults(pageSize); query.setResultTransformer(new AliasToBeanResultTransformer(MyDTO.class)); return query; }