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

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

?????文件????????548??2018-10-22?23:42??DormManage\.classpath

?????文件???????1043??2018-10-22?23:42??DormManage\.project

?????文件????????503??2018-10-22?23:42??DormManage\.settings\.jsdtscope

?????文件?????????68??2018-10-22?23:42??DormManage\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2018-10-22?23:42??DormManage\.settings\org.eclipse.jdt.core.prefs

?????文件????????482??2018-10-22?23:42??DormManage\.settings\org.eclipse.wst.common.component

?????文件????????305??2018-10-22?23:42??DormManage\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-10-22?23:42??DormManage\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-10-22?23:42??DormManage\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3392??2018-10-22?23:51??DormManage\a.sql

?????文件???????6840??2018-10-22?23:42??DormManage\build\classes\com\lero\dao\DormBuildDao.class

?????文件???????5334??2018-10-22?23:42??DormManage\build\classes\com\lero\dao\DormManagerDao.class

?????文件???????7193??2018-10-22?23:42??DormManage\build\classes\com\lero\dao\RecordDao.class

?????文件???????7545??2018-10-22?23:42??DormManage\build\classes\com\lero\dao\StudentDao.class

?????文件???????4146??2018-10-22?23:42??DormManage\build\classes\com\lero\dao\UserDao.class

?????文件???????1948??2018-10-22?23:42??DormManage\build\classes\com\lero\filter\LoginFilter.class

?????文件???????1623??2018-10-22?23:42??DormManage\build\classes\com\lero\model\Admin.class

?????文件???????1116??2018-10-22?23:42??DormManage\build\classes\com\lero\model\DormBuild.class

?????文件???????2329??2018-10-22?23:42??DormManage\build\classes\com\lero\model\DormManager.class

?????文件????????817??2018-10-22?23:42??DormManage\build\classes\com\lero\model\PageBean.class

?????文件???????2514??2018-10-22?23:42??DormManage\build\classes\com\lero\model\Record.class

?????文件???????2818??2018-10-22?23:42??DormManage\build\classes\com\lero\model\Student.class

?????文件????????974??2018-10-22?23:42??DormManage\build\classes\com\lero\util\DateUtil.class

?????文件???????1446??2018-10-22?23:42??DormManage\build\classes\com\lero\util\DbUtil.class

?????文件???????1260??2018-10-22?23:42??DormManage\build\classes\com\lero\util\MD5Util.class

?????文件????????997??2018-10-22?23:42??DormManage\build\classes\com\lero\util\PropertiesUtil.class

?????文件????????590??2018-10-22?23:42??DormManage\build\classes\com\lero\util\StringUtil.class

?????文件???????1870??2018-10-22?23:42??DormManage\build\classes\com\lero\web\BlankServlet.class

?????文件???????8852??2018-10-22?23:42??DormManage\build\classes\com\lero\web\DormBuildServlet.class

?????文件???????8065??2018-10-22?23:42??DormManage\build\classes\com\lero\web\DormManagerServlet.class

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