Java Code Examples for org.hibernate.Session.getNamedQuery()

/**
 * It must be stupid simply indexing the passed domain objects without
 * additional BL and additional queries.<br>
 *
 * Returns the list of products to be indexed. In case if the template
 * product is updated, beside of the index fields for the this product also
 * these for broker, reseller and customer specific copies must be updated
 * as well.
 */
private List<Product> getProductAndCopiesForIndexUpdate(Product product,
        Session session) {
    List<Product> productsToUpdate = new ArrayList<>();
    if (!product.isCopy()) {

        org.hibernate.Query query = session
                .getNamedQuery("Product.getProductsForTemplateIndexUpdate");
        query.setParameter("template", product);
        query.setParameterList("state",
                EnumSet.of(ServiceStatus.ACTIVE, ServiceStatus.INACTIVE,
                        ServiceStatus.SUSPENDED, ServiceStatus.OBSOLETE));
        query.setParameterList("type",
                EnumSet.of(ServiceType.PARTNER_TEMPLATE,
                        ServiceType.CUSTOMER_TEMPLATE));
        productsToUpdate.addAll(
                ParameterizedTypes.list(query.list(), Product.class));
    }
    return productsToUpdate;
}
 

public List<T> getAll(String namedQuery) throws SQLException {
	logger.info("Init abstract GetAll to: " + namedQuery);

	Session session = HibernateUtil.getSessionFactory().openSession();
	List<T> list = null;

	try {
		session.beginTransaction();
		Query query = session.getNamedQuery(namedQuery);
		list = (List<T>) query.list();
		session.getTransaction().commit();

	} catch (HibernateException hibernateException) {
		session.getTransaction().rollback();

		throw new SQLException(hibernateException);

	} finally {
		session.close();
	}

	return list;
}
 

@Override
public List<Object[]> getdataCondition() {
	List<Object[]> newlist=null;
	Session ses=null;
	//get the session
	ses=HibernateUtil.getSession();
		//access the named query
	Query q=ses.getNamedQuery("select_by_range");
	q.setParameter("salary", 50000f);
		//execute the query
	newlist=q.list();
	newlist.forEach(row->{
		for(Object val:row)
		{
			System.out.println("--->"+val);
		}
		System.out.println();
		
	});
	
	return null;
}
 

public List<person> getdata() {
	List<person> plist=null;
	Session ses=null;
	//get the session
	ses=HibernateUtil.getSession();
	//access the named query
	Query q=ses.getNamedQuery("select_All");
	//execute the QBC logic
	plist=q.list();
	//diaplsy the list
	plist.forEach(p->{
		System.out.println(p);
	});
	
	return null;
}
 

@SuppressWarnings("unchecked")
    @Override
	public List<User> findByEmail(String email) {
    	Session session = this.sessionFactory.getCurrentSession();
        TypedQuery<User> query = session.getNamedQuery("findByEmail");  
        query.setParameter("email", email);
//    	Query query = session.getNamedQuery("findByEmail");
//    	query.setString("email", email);
        return query.getResultList();
	}
 

@SuppressWarnings("unchecked")
@Override
public List<User> findByEmailAndPassword(String email, String password) {
	Session session = this.sessionFactory.getCurrentSession();
	TypedQuery<User> query = session.getNamedQuery("findByEmailAndPassword");  
       query.setParameter("email", email); 
       query.setParameter("password", password);
       return query.getResultList();
}
 

@Override
public List<Doctor> findBySpecialityCode(String code) {
	Session session = this.sessionFactory.getCurrentSession();
       TypedQuery<Doctor> query = session.getNamedQuery("findBySpeciality");  
       query.setParameter("specialityCode", code);
       List<Doctor> doctors = query.getResultList();
       return doctors;
}
 

@Override
public Doctor findByUserId(int userId) {
	Session session = this.sessionFactory.getCurrentSession();
       TypedQuery<Doctor> query = session.getNamedQuery("findById");  
       query.setParameter("id", userId);
       List<Doctor> doctors = query.getResultList();
       return doctors.get(0);
}
 

@Override
public List<Doctor> findAll() {
	Session session = this.sessionFactory.getCurrentSession();
       TypedQuery<Doctor> query = session.getNamedQuery("findAll");  
       List<Doctor> doctors = query.getResultList();
       return doctors;
}
 

@Override
public int findAllCount() {
	Session session = this.sessionFactory.getCurrentSession();
       TypedQuery<Number> query = session.getNamedQuery("findAllCount"); 
       int count = ((Number)query.getSingleResult()).intValue();
       return count;
}
 

@SuppressWarnings("unchecked")
    @Override
	public List<User> findByEmail(String email) {
    	Session session = this.sessionFactory.getCurrentSession();
        TypedQuery<User> query = session.getNamedQuery("findByEmail");  
        query.setParameter("email", email);
//    	Query query = session.getNamedQuery("findByEmail");
//    	query.setString("email", email);
        return query.getResultList();
	}
 

@SuppressWarnings("unchecked")
@Override
public List<User> findByEmailAndPassword(String email, String password) {
	Session session = this.sessionFactory.getCurrentSession();
	TypedQuery<User> query = session.getNamedQuery("findByEmailAndPassword");  
       query.setParameter("email", email); 
       query.setParameter("password", password);
       return query.getResultList();
}
 

@Override
public List<Doctor> findBySpecialityCode(String code) {
	Session session = this.sessionFactory.getCurrentSession();
       TypedQuery<Doctor> query = session.getNamedQuery("findBySpeciality");  
       query.setParameter("specialityCode", code);
       List<Doctor> doctors = query.getResultList();
       return doctors;
}
 

@Override
public Doctor findByUserId(int userId) {
	Session session = this.sessionFactory.getCurrentSession();
       TypedQuery<Doctor> query = session.getNamedQuery("findById");  
       query.setParameter("id", userId);
       List<Doctor> doctors = query.getResultList();
       return doctors.get(0);
}
 

@Override
public List<Doctor> findAll() {
	Session session = this.sessionFactory.getCurrentSession();
       TypedQuery<Doctor> query = session.getNamedQuery("findAll");  
       List<Doctor> doctors = query.getResultList();
       return doctors;
}
 

@Override
public int findAllCount() {
	Session session = this.sessionFactory.getCurrentSession();
       TypedQuery<Number> query = session.getNamedQuery("findAllCount"); 
       int count = ((Number)query.getSingleResult()).intValue();
       return count;
}
 

@Override
public List<Rx> findByDoctorId(int doctorId) {
	Session session = this.sessionFactory.getCurrentSession();
       TypedQuery<Rx> query = session.getNamedQuery("findByDoctorId");  
       query.setParameter("id", doctorId);
       List<Rx> rxList = query.getResultList();
	return rxList;
}
 

@SuppressWarnings("unchecked")
    @Override
	public List<User> findByEmail(String email) {
    	Session session = this.sessionFactory.getCurrentSession();
        TypedQuery<User> query = session.getNamedQuery("findByEmail");  
        query.setParameter("email", email);
//    	Query query = session.getNamedQuery("findByEmail");
//    	query.setString("email", email);
        return query.getResultList();
	}
 

@SuppressWarnings("unchecked")
@Override
public List<User> findByEmailAndPassword(String email, String password) {
	Session session = this.sessionFactory.getCurrentSession();
	TypedQuery<User> query = session.getNamedQuery("findByEmailAndPassword");  
       query.setParameter("email", email); 
       query.setParameter("password", password);
       return query.getResultList();
}
 

private void modifyLeftOrRight(Session session, String queryName, Taxonomy taxonomy, int from, int to, int amount)
{
	Query q = session.getNamedQuery(queryName);
	q.setInteger("amount", amount);
	q.setInteger("from", from);
	q.setInteger("to", to);
	q.setParameter("taxonomy", taxonomy);
	q.executeUpdate();
}