package edu.jlu.fuliang.dao.impl;

import java.util.List;

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

import edu.jlu.fuliang.dao.SingerDAO;
import edu.jlu.fuliang.domain.Band;
import edu.jlu.fuliang.domain.CompositeSinger;
import edu.jlu.fuliang.domain.Singer;
import edu.jlu.fuliang.domain.SingleSinger;

public class SingerDAOImpl extends HibernateDaoSupport implements SingerDAO{

	@Override
	public void deleteSinger(Long id) {
		getHibernateTemplate().delete(id);
	}

	@Override
	public List<Band> getAllBands() {
		return getHibernateTemplate().find("from Band");
	}

	@Override
	public List<CompositeSinger> getAllCompositeSingers() {
		return getHibernateTemplate().find("from CompositeSinger");
	}

	@Override
	public List<Singer> getAllSingers() {
		return getHibernateTemplate().find("from Singer");
	}

	@Override
	public List<SingleSinger> getAllSingleSingers() {
		return getHibernateTemplate().find("from SingleSinger");
	}

	@Override
	public List<Band> getBandsByName(String name) {
		return getHibernateTemplate().find("from Band b where b.name=?", new String[]{name});
	}

	@Override
	public Singer getSingerById(Long id) {
		return (Singer)getHibernateTemplate().get(Singer.class, id);
	}

	@Override
	public List<Singer> getSingerByRegion(String region) {
		return getHibernateTemplate().find("from Singer s where s.region=?", new String[]{region});
	}

	@Override
	public List<Singer> getSingersByName(String name) {
		return getHibernateTemplate().find("from Singer s where s.name=?",new String[]{name});
	}

	@Override
	public List<SingleSinger> getSingleSingersByName(String name) {
		return getHibernateTemplate().find("from SingleSinger s where s.name=?",new String[]{name});
	}

	@Override
	public void saveSinger(Singer singer) {
		getHibernateTemplate().save(singer);
	}

	@Override
	public void updateSinger(Singer singer) {
		getHibernateTemplate().saveOrUpdate(singer);
	}
}