customerdaoimpl.java

来自「尚学课程里面的CRM项目源码,希望对大家有用.」· Java 代码 · 共 49 行

package com.bjsxt.crm.dao.impl.hibernate;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.bjsxt.crm.dao.CustomerDAO;
import com.bjsxt.crm.model.Customer;

public class CustomerDAOImpl extends HibernateDaoSupport implements CustomerDAO {

	public void delete(Customer customer) {
		getHibernateTemplate().delete(customer);
	}

	public List find(String name, int userId) {
		return getHibernateTemplate().find("select c from Customer c where ( c.name like ? or c.shortName like ? ) " +
				"and c.owner.id = ?",new Object[]{"%"+name+"%","%"+name+"%",userId});
	}

	public List findAll() {
		return getHibernateTemplate().loadAll(Customer.class);
	}

	public Customer findById(int id) {
		return (Customer)getHibernateTemplate().load(Customer.class, id);
	}

	public List findCompanyCustomer(String name, int userId) {
		return getHibernateTemplate().find("select c from CompanyCustomer c where ( c.name like ? or c.shortName like ? ) " +
				"and c.owner.id = ?",new Object[]{"%"+name+"%","%"+name+"%",userId});
	}

	public List findPersonalCustomer(String name, int userId) {
		return getHibernateTemplate().find("select c from PersonalCustomer c where ( c.name like ? or c.shortName like ? ) " +
				"and c.owner.id = ?",new Object[]{"%"+name+"%","%"+name+"%",userId});
	}

	public void save(Customer customer) {
		getHibernateTemplate().save(customer);
	}

	public void update(Customer customer) {
		getHibernateTemplate().update(customer);
	}


}