itemdaoimpl.java

拍卖系统

package com.dagang.bidsys.dao.impl;

import java.util.List;

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

import com.dagang.bidsys.dao.ItemDao;
import com.dagang.bidsys.model.Item;

public class ItemDaoImpl extends HibernateDaoSupport implements ItemDao {

	public void delete(int id) {
		this.getHibernateTemplate().delete(this.get(id));
	}

	public List findByKind(int kindId) {
		return this.getHibernateTemplate().find(
				"select * from item i where i.kind_id = " + kindId);
	}

	public List findByOwner(int ownerId) {
		return this.getHibernateTemplate().find(
				"select * from item i where i.kind_id = " + ownerId);
	}

	public List findByState(int stateId) {
		return this.getHibernateTemplate().find(
				"select * from item i where i.kind_id = " + stateId);
	}

	public List findByWinner(int winnerId) {
		return this.getHibernateTemplate().find(
				"select * from item i where i.kind_id = " + winnerId);
	}

	public Item get(int id) {
		return (Item)this.getHibernateTemplate().get(Item.class, id);
	}

	public void save(Item item) {
		this.getHibernateTemplate().save(item);
	}

	public void update(Item item) {
		this.getHibernateTemplate().saveOrUpdate(item);
	}
	
	public List findAll(){
		return this.getHibernateTemplate().find("from Item");
	}

}