pricingmgmtdaohibernatetemplateimpl.java

电信用户自服务系统

package tarena.netctoss.dao.impl;

import java.util.List;

import tarena.netctoss.dao.IPricingMgmtDAO;
import tarena.netctoss.model.Tpricing;

public class PricingMgmtDAOHibernateTemplateImpl extends
		BaseDAOHibernateTemplateImpl implements IPricingMgmtDAO {

	public Integer selectAssociationServicesCountById(Integer id) {
		// TODO Auto-generated method stub
		System.out.println("===========此方法未实现===========");
		return null;
	}

	public Tpricing selectPricingByBaseFeeAndRateFee(Double baseFee,
			Double rateFee) {
		// TODO Auto-generated method stub
		String hql = "select p from Tpricing p where p.baseFee=:baseFee and p.rateFee=:rateFee";
		String[] strp = new String[]{"baseFee", "rateFee"};
		Object[] strv = new Object[]{baseFee, rateFee};
		List list = getHibernateTemplate().findByNamedParam(hql, strp, strv);
		if(list.size() == 0){
			return null;
		}
		return (Tpricing)list.get(0);
	}

	public Tpricing selectPricingByName(String name) {
		// TODO Auto-generated method stub
		String hql = "select p from Tpricing p where p.name=:name";
		List list = getHibernateTemplate().findByNamedParam(hql, "name", name);
		if(list.size() == 0){
			return null;
		}
		return (Tpricing)list.get(0);
	}

}