custdaoimp.java

客户

package com.sinoest.dao;


import java.util.Iterator;
import java.util.List;

import org.hibernate.Criteria;

import org.hibernate.Query;

import org.hibernate.criterion.Example;
import org.hibernate.criterion.MatchMode;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.sinoest.po.SCustomer;
import com.sinoest.struts.form.CustForm;

public class CustDAOImp extends HibernateDaoSupport implements CustDAO {

	public List findCust(String Cname, String CCate, String CTrade,
			String CGrade) {
		 List<SCustomer> list=null;
			 Criteria crit=this.getSession().createCriteria(SCustomer.class);
			 SCustomer cusomer=new SCustomer();
			 cusomer.setCName(Cname);
			 cusomer.setCCate(CCate);
			 cusomer.setCGrade(CGrade);
			 cusomer.setCTrade(CTrade);
			 crit.add(Example.create(cusomer).enableLike(MatchMode.ANYWHERE));
			 list=crit.list();
            return list;
		}

	public List findAllCust() {
		// 查询所有用户
		List list=null;
		// session=HSFactory.getSession();
			 Criteria crit=this.getSession().createCriteria(SCustomer.class);
			 list=crit.list();
			return list;
	}

	public void addCust(CustForm custform) {
		// 增加新用户
			SCustomer customer=new SCustomer();
			//session=HSFactory.getSession();
			customer.setCName(custform.getCName());
			customer.setCCate(custform.getCCate());
			customer.setCTrade(custform.getCTrade());
			customer.setCGrade(custform.getCGrade());
			customer.setMState(custform.getMState());
            this.getHibernateTemplate().save(customer);
	}
	

	public void del(String[] customers) {
		// 删除用户
	    // session=HSFactory.getSession();

		for (int i = 0; i < customers.length; i++) {
			String sql="from SCustomer as sc where sc.CId="+customers[i];
			System.out.println(sql);
			
				 SCustomer customer=null;
				 customer=(SCustomer)this.getSession().get(SCustomer.class, Long.valueOf(customers[i]));
			     if(customer!=null){
					this.getHibernateTemplate().delete(customer);
			     }
			
		}
	}

	public SCustomer selectByCId(String CId) {
		// 根据Id查找用户
		SCustomer customer=null;
			String sql="from SCustomer sc where sc.CId="+CId;
			// session=HSFactory.getSession();
				Query q=this.getSession().createQuery(sql);
				Iterator<SCustomer> it=q.list().iterator();
				if (it.hasNext()){
					 customer=(SCustomer)it.next();
					}
		return customer;
	}

	public void update(CustForm custform) {
		// 更新客户信息
		SCustomer customer=null;
		String sql="from SCustomer sc where sc.CId="+custform.getCId();
		// session=HSFactory.getSession();
			Query q=this.getSession().createQuery(sql);
			Iterator<SCustomer> it=q.list().iterator(); 
			if (it.hasNext()){
				 customer=(SCustomer)it.next();
				 customer.setCName(custform.getCName());
				 customer.setCCate(custform.getCCate());
				 customer.setCTrade(custform.getCTrade());
				 customer.setCGrade(custform.getCGrade());
				 customer.setMState(custform.getMState());
				this.getHibernateTemplate().saveOrUpdate(customer);
				}
	}

}