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?“+pageBean.getStart（）+““+pageBean.getPageSize（））;
		}
		PreparedStatement?pstmt?=?con.prepareStatement（sb.toString（））;
		ResultSet?rs?=?pstmt.executeQuery（）;
		while（rs.next（））?{
			DormBuild?dormBuild=new?DormBuild（）;
			dormBuild.setDormBuildId（rs.getInt（“dormBuildId“））;
			dormBuild.setDormBuildName（rs.getString（“dormBuildName“））;
			dormBuild.setDetail（rs.getString（“dormBuildDetail“））;
			dormBuildList.add（dormBuild）;
		}
		return?dormBuildList;
	}
	
	public?static?String?dormBuildName（Connection?con?int?dormBuildId）throws?Exception?{
		String?sql?=?“select?*?from?t_dormBuild?where?dormBuildId=?“;
		PreparedStatement?pstmt?=?con.prepareStatement（sql）;
		pstmt.setInt（1?dormBuildId）;
		ResultSet?rs?=?pstmt.executeQuery（）;
		if（rs.next（））?{
			return?rs.getString（“dormBuildName“）;
		}
		return?null;
	}
	
	public?int?dormBuildCount（Connection?con?DormBuild?s_dormBuild）throws?Exception?{
		StringBuffer?sb?=?new?StringBuffer（“select?count（*）?as?total?from?t_dormBuild?t1“）;
		if（StringUtil.isNotEmpty（s_dormBuild.getDormBuildName（）））?{
			sb.append（“?where?t1.dormBuildName?like?‘%“+s_dormBuild.getDormBuildName（）+“%‘“）;
		}
		PreparedStatement?pstmt?=?con.prepareStatement（sb.toString（））;
		ResultSet?rs?=?pstmt.executeQuery（）;
		if（rs.next（））?{
			return?rs.getInt（“total“）;
		}?else?{
			return?0;
		}
	}
	
	public?DormBuild?dormBuildShow（Connection?con?String?dormBuildId）throws?Exception?{
		String?sql?=?“select?*?from?t_dormBuild?t1?where?t1.dormBuildId=?“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?dormBuildId）;
		ResultSet?rs=pstmt.executeQuery（）;
		DormBuild?dormBuild?=?new?DormBuild（）;
		if（rs.next（））?{
			dormBuild.setDormBuildId（rs.getInt（“dormBuildId“））;
			dormBuild.setDormBuildName（rs.getString（“dormBuildName“））;
			dormBuild.setDetail（rs.getString（“dormBuildDetail“））;
		}
		return?dormBuild;
	}
	
	public?int?dormBuildAdd（Connection?con?DormBuild?dormBuild）throws?Exception?{
		String?sql?=?“insert?into?t_dormBuild?values（null??）“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?dormBuild.getDormBuildName（））;
		pstmt.setString（2?dormBuild.getDet

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

?????文件???????1125??2017-06-12?12:56??222\.classpath

?????文件???????1053??2017-06-12?12:54??222\.project

?????文件????????564??2017-06-12?12:54??222\.settings\.jsdtscope

?????文件????????364??2017-06-12?12:54??222\.settings\org.eclipse.jdt.core.prefs

?????文件????????468??2017-06-12?12:54??222\.settings\org.eclipse.wst.common.component

?????文件????????414??2017-06-12?12:54??222\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-06-12?12:54??222\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-06-12?12:54??222\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????6558??2017-06-12?12:55??222\src\com\lero\dao\DormBuildDao.java

?????文件???????4815??2017-06-12?12:55??222\src\com\lero\dao\DormManagerDao.java

?????文件???????8554??2017-06-12?12:55??222\src\com\lero\dao\RecordDao.java

?????文件???????9762??2017-06-12?12:55??222\src\com\lero\dao\StudentDao.java

?????文件???????3861??2017-06-12?12:55??222\src\com\lero\dao\UserDao.java

?????文件???????1301??2017-06-12?12:55??222\src\com\lero\filter\LoginFilter.java

?????文件???????1064??2017-06-12?12:55??222\src\com\lero\model\Admin.java

?????文件????????746??2017-06-12?12:55??222\src\com\lero\model\DormBuild.java

?????文件???????1730??2017-06-12?12:55??222\src\com\lero\model\DormManager.java

?????文件????????621??2017-06-12?12:55??222\src\com\lero\model\PageBean.java

?????文件???????1933??2017-06-12?12:55??222\src\com\lero\model\Record.java

?????文件???????2232??2017-06-12?12:55??222\src\com\lero\model\Student.java

?????文件????????550??2017-06-12?12:55??222\src\com\lero\util\DateUtil.java

?????文件????????809??2017-06-12?12:55??222\src\com\lero\util\DbUtil.java

?????文件????????728??2017-06-12?12:55??222\src\com\lero\util\MD5Util.java

?????文件????????517??2017-06-12?12:55??222\src\com\lero\util\PropertiesUtil.java

?????文件????????338??2017-06-12?12:55??222\src\com\lero\util\StringUtil.java

?????文件???????1430??2017-06-12?12:55??222\src\com\lero\web\BlankServlet.java

?????文件???????9558??2017-06-12?12:55??222\src\com\lero\web\DormBuildServlet.java

?????文件???????8982??2017-06-12?12:55??222\src\com\lero\web\DormManagerServlet.java

?????文件???????4983??2017-06-12?12:55??222\src\com\lero\web\LoginServlet.java

?????文件???????5978??2017-06-12?12:55??222\src\com\lero\web\PasswordServlet.java

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