package?com.bin.dao;

import?java.util.List;

import?com.bin.persistence.TbCategory;
import?com.bin.util.HibernateFilter;

public?class?CategoryDao?extends?SuperDao?{
	/*
	?*?查詢指定id藥品類信息
	?*/
	public?TbCategory?loadCategory（int?id）?{
		TbCategory?c?=?null;
		try?{
			session?=?HibernateFilter.getSession（）;
			session.beginTransaction（）;
			c?=?（TbCategory）?session.load（TbCategory.class?new?Integer（id））;
			session.getTransaction（）.commit（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			session.getTransaction（）.rollback（）;
		}
		return?c;
	}
	/*
	?*?查詢所有藥品類別信息
	?*/
	public?List?findAllCategory（）{
		List?list=null;
		try{
			session=HibernateFilter.getSession（）;
			session.beginTransaction（）;
			list=session.createQuery（“from?TbCategory?c“）.list（）;
			session.getTransaction（）.commit（）;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
			session.getTransaction（）.rollback（）;
		}
		return?list;
	}
	/*
	?*?對藥品類別中藥品的數(shù)量進行統(tǒng)計
	?*/
	public?List?findCategoryAndCount（）{
		List?list=null;
		try{
			session=HibernateFilter.getSession（）;
			session.beginTransaction（）;
			//內(nèi)連接查詢語句
			String?hql=“select?c.namecount（*）?from?TbMedicine?m?inner?join?m.tbCategory?c?group?by?c“;
			list=session.createQuery（hql）.list（）;
			session.getTransaction（）.commit（）;
		}
		catch（Exception?e）{
			e.printStackTrace（）;
			session.getTransaction（）.rollback（）;
		}
		return?list;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????2689536??2011-07-08?09:14??醫(yī)藥管理系統(tǒng).doc

?????文件???????2099??2011-06-27?15:39??MedManager\.classpath

?????文件????????542??2011-07-04?19:32??MedManager\.myhibernatedata

?????文件????????303??2011-07-07?23:03??MedManager\.mymetadata

?????文件????????254??2011-06-25?17:26??MedManager\.mystrutsdata

?????文件???????2038??2011-06-25?21:19??MedManager\.project

?????文件???????1417??2011-07-05?11:42??MedManager\.reverse.properties

?????文件????????493??2011-06-25?17:26??MedManager\.settings\.jsdtscope

?????文件?????????88??2011-07-01?16:07??MedManager\.settings\org.eclipse.core.resources.prefs

?????文件????????395??2011-06-25?17:26??MedManager\.settings\org.eclipse.jdt.core.prefs

?????文件????????468??2011-06-25?17:26??MedManager\.settings\org.eclipse.wst.common.component

?????文件????????252??2011-06-25?17:26??MedManager\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2011-06-25?17:26??MedManager\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-06-25?17:26??MedManager\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????6170??2011-07-04?19:10??MedManager\db_medicine1.mer

?????文件????????840??2011-07-04?19:32??MedManager\hibernate.reveng.xml

?????文件???????1526??2011-07-05?11:24??MedManager\src\com\bin\dao\CategoryDao.java

?????文件???????2056??2011-07-04?20:21??MedManager\src\com\bin\dao\MedicineDao.java

?????文件???????1992??2011-07-04?19:44??MedManager\src\com\bin\dao\SellDao.java

?????文件???????4671??2011-06-25?20:43??MedManager\src\com\bin\dao\SuperDao.java

?????文件???????4143??2011-07-04?15:01??MedManager\src\com\bin\dao\UserDao.java

?????文件????????726??2011-07-02?16:12??MedManager\src\com\bin\persistence\SellSeq.java

?????文件???????1199??2011-07-05?11:26??MedManager\src\com\bin\persistence\TbCategory.hbm.xml

?????文件???????1770??2011-07-05?11:06??MedManager\src\com\bin\persistence\TbCategory.java

?????文件???????2042??2011-07-04?20:45??MedManager\src\com\bin\persistence\TbMedicine.hbm.xml

?????文件???????3231??2011-07-04?20:10??MedManager\src\com\bin\persistence\TbMedicine.java

?????文件???????1476??2011-07-05?11:44??MedManager\src\com\bin\persistence\TbSelldetail.hbm.xml

?????文件???????2579??2011-07-04?19:47??MedManager\src\com\bin\persistence\TbSelldetail.java

?????文件???????1222??2011-07-04?20:46??MedManager\src\com\bin\persistence\TbUser.hbm.xml

?????文件???????1784??2011-07-04?19:35??MedManager\src\com\bin\persistence\TbUser.java

............此處省略148個文件信息