pricingmanagementdaohibernateimpl.java

某达内学生培训最后做的电信计费系统项目的全部源代码

package com.team1.netctoss.dao.hibernate;

import java.util.List;

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

import com.team1.netctoss.dao.PricingManagementDAO;
import com.team1.netctoss.entity.Pricing;

public class PricingManagementDAOHibernateImpl extends HibernateDaoSupport
		implements PricingManagementDAO {

	public Long addPricing(Pricing pricing) {
		// TODO Auto-generated method stub
		String sql1 = "from Pricing p where p.pricingName=:pricingName";
		String sql2 = "from Pricing p where p.baseFee=:baseFee and p.rateFee=:rateFee";
		List list1 = getHibernateTemplate().findByNamedParam(sql1,
				"pricingName", pricing.getPricingName());
		List list2 = getHibernateTemplate().findByNamedParam(sql2,
				new String[] { "baseFee", "rateFee" },
				new Object[] { pricing.getBaseFee(), pricing.getRateFee() });
		if (list1.size() != 0 || list2.size() != 0) {
			return -1L;
		} else {
			getHibernateTemplate().save(pricing);
			return pricing.getPricingId();
		}
	}

	public List<Pricing> listPricing() {
		// TODO Auto-generated method stub
		String sql = "from Pricing p";
		return (List<Pricing>) getHibernateTemplate().find(sql);
	}

	public boolean removePricing(Pricing pricing) {
		// TODO Auto-generated method stub
		String sql = "from LabUser lu where lu.pricing.pricingId=:pricingId";
		List list = getHibernateTemplate().findByNamedParam(sql, "pricingId",
				pricing.getPricingId());
		if (list.size() == 0) {
			System.out.println(pricing.getPricingId());
			Pricing pricingToBeDelete = (Pricing)getHibernateTemplate().merge(pricing);
			System.out.println(pricingToBeDelete.getPricingId());
			getHibernateTemplate().delete(pricingToBeDelete);
			return true;
		} else {
			return false;
		}

	}

	public Long modifyPricing(Pricing pricing) {
		// TODO Auto-generated method stub
		String sql = "from Pricing p where p.baseFee=:baseFee and p.rateFee=:rateFee";
		List list = getHibernateTemplate().findByNamedParam(sql,
				new String[] { "baseFee", "rateFee" },
				new Object[] { pricing.getBaseFee(), pricing.getRateFee() });
		if (list.size() != 0) {
			return -1L;
		} else {
			getHibernateTemplate().update(pricing);
			return pricing.getPricingId();
		}
	}

}