package?com.lero.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.List;

import?com.lero.model.DormBuild;
import?com.lero.model.DormManager;
import?com.lero.model.PageBean;
import?com.lero.util.StringUtil;

public?class?DormBuildDao?{

	public?List?dormBuildList（Connection?con?PageBean?pageBean?DormBuild?s_dormBuild）throws?Exception?{
		List?dormBuildList?=?new?ArrayList（）;
		StringBuffer?sb?=?new?StringBuffer（“select?*?from?t_dormBuild?t1“）;
		if（StringUtil.isNotEmpty（s_dormBuild.getDormBuildName（）））?{
			sb.append（“?where?t1.dormBuildName?like?‘%“+s_dormBuild.getDormBuildName（）+“%‘“）;
		}
		if（pageBean?!=?null）?{
			sb.append（“?limit?“+pageB

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????文件????????5573??2014-08-12?18:08??db_dorm.sql
?????目錄???????????0??2014-08-12?18:07??DormManage\
?????文件?????????548??2014-07-21?11:28??DormManage\.classpath
?????文件????????1043??2014-07-21?11:24??DormManage\.project
?????目錄???????????0??2014-08-12?18:07??DormManage\.settings\
?????文件?????????503??2014-07-21?11:24??DormManage\.settings\.jsdtscope
?????文件??????????68??2014-07-24?23:14??DormManage\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2014-07-21?11:24??DormManage\.settings\org.eclipse.jdt.core.prefs
?????文件?????????482??2014-07-21?11:24??DormManage\.settings\org.eclipse.wst.common.component
?????文件?????????305??2014-07-21?11:24??DormManage\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2014-07-21?11:24??DormManage\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-07-21?11:24??DormManage\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2014-08-12?18:07??DormManage\build\
?????目錄???????????0??2014-08-12?18:07??DormManage\build\classes\
?????目錄???????????0??2014-08-12?18:07??DormManage\build\classes\com\
?????目錄???????????0??2014-08-12?18:07??DormManage\build\classes\com\lero\
?????目錄???????????0??2014-08-12?18:07??DormManage\build\classes\com\lero\dao\
?????文件????????6840??2014-07-24?15:40??DormManage\build\classes\com\lero\dao\DormBuildDao.class
?????文件????????5334??2014-08-12?17:43??DormManage\build\classes\com\lero\dao\DormManagerDao.class
?????文件????????7193??2014-08-12?18:05??DormManage\build\classes\com\lero\dao\RecordDao.class
?????文件????????7545??2014-08-12?17:24??DormManage\build\classes\com\lero\dao\StudentDao.class
?????文件????????4146??2014-08-11?21:43??DormManage\build\classes\com\lero\dao\UserDao.class
?????目錄???????????0??2014-08-12?18:07??DormManage\build\classes\com\lero\filter\
?????文件????????1948??2014-07-22?16:05??DormManage\build\classes\com\lero\filter\LoginFilter.class
?????目錄???????????0??2014-08-12?18:07??DormManage\build\classes\com\lero\model\
?????文件????????1623??2014-07-22?16:05??DormManage\build\classes\com\lero\model\Admin.class
?????文件????????1116??2014-07-22?23:30??DormManage\build\classes\com\lero\model\DormBuild.class
?????文件????????2329??2014-07-23?22:43??DormManage\build\classes\com\lero\model\DormManager.class
?????文件?????????817??2014-07-22?17:34??DormManage\build\classes\com\lero\model\PageBean.class
?????文件????????2514??2014-08-06?21:17??DormManage\build\classes\com\lero\model\Record.class
?????文件????????2818??2014-07-24?17:55??DormManage\build\classes\com\lero\model\Student.class
............此處省略258個(gè)文件信息