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;
	}
	/*
	?*?對(duì)藥品類別中藥品的數(shù)量進(jìn)行統(tǒng)計(jì)
	?*/
	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;
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????2935??2015-12-18?22:53??ydgl1\.classpath

?????文件????????968??2015-12-18?22:53??ydgl1\.myeclipse\profiler\ydgl2?on?MyEclipse?Tomcat.xml

?????文件????????287??2015-12-18?22:53??ydgl1\.mymetadata

?????文件???????1411??2015-12-18?22:53??ydgl1\.project

?????文件????????500??2015-12-18?22:53??ydgl1\.settings\.jsdtscope

?????文件????????163??2015-12-18?23:14??ydgl1\.settings\org.eclipse.core.resources.prefs

?????文件????????330??2015-12-18?22:53??ydgl1\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2015-12-18?22:53??ydgl1\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-12-18?22:53??ydgl1\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????13468??2015-12-18?22:53??ydgl1\conf\validator-rules.xml

?????文件??????12452??2015-12-18?22:53??ydgl1\db_medicine.sql

?????文件???????1526??2015-12-18?22:53??ydgl1\src\com\bin\dao\CategoryDao.java

?????文件????????728??2015-12-18?22:53??ydgl1\src\com\bin\dao\DoctorDao.java

?????文件???????2056??2015-12-18?22:53??ydgl1\src\com\bin\dao\MedicineDao.java

?????文件????????788??2015-12-18?22:53??ydgl1\src\com\bin\dao\PrescriptionDao.java

?????文件????????722??2015-12-18?22:53??ydgl1\src\com\bin\dao\SalaryDao.java

?????文件???????1992??2015-12-18?22:53??ydgl1\src\com\bin\dao\SellDao.java

?????文件???????4671??2015-12-18?22:53??ydgl1\src\com\bin\dao\SuperDao.java

?????文件???????4143??2015-12-18?22:53??ydgl1\src\com\bin\dao\UserDao.java

?????文件????????757??2015-12-18?22:53??ydgl1\src\com\bin\persistence\SellSeq.java

?????文件???????1199??2015-12-18?22:53??ydgl1\src\com\bin\persistence\TbCategory.hbm.xml

?????文件???????1770??2015-12-18?22:53??ydgl1\src\com\bin\persistence\TbCategory.java

?????文件???????1652??2015-12-18?22:53??ydgl1\src\com\bin\persistence\TbDoctor.hbm.xml

?????文件???????1665??2015-12-18?22:53??ydgl1\src\com\bin\persistence\TbDoctor.java

?????文件???????2042??2015-12-18?22:53??ydgl1\src\com\bin\persistence\TbMedicine.hbm.xml

?????文件???????3231??2015-12-18?22:53??ydgl1\src\com\bin\persistence\TbMedicine.java

?????文件???????1359??2015-12-18?22:53??ydgl1\src\com\bin\persistence\TbPrescription.hbm.xml

?????文件???????1452??2015-12-18?22:53??ydgl1\src\com\bin\persistence\TbPrescription.java

?????文件???????1509??2015-12-18?22:53??ydgl1\src\com\bin\persistence\TbSalary.hbm.xml

?????文件???????1700??2015-12-18?22:53??ydgl1\src\com\bin\persistence\TbSalary.java

............此處省略243個(gè)文件信息