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

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-08-12?18:13??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\
?????文件??????206797??2014-08-12?18:13??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\010.jpg
?????文件??????659804??2014-08-12?18:10??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\1.jpg
?????文件??????182031??2014-08-12?18:10??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\2.jpg
?????文件??????308270??2014-08-12?18:11??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\3.jpg
?????文件???????53949??2015-12-30?14:54??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\4.jpg
?????文件??????282769??2014-08-12?18:11??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\5.jpg
?????文件??????321357??2014-08-12?18:11??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\6.jpg
?????文件??????243612??2014-08-12?18:12??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\7.jpg
?????文件??????278031??2014-08-12?18:13??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\8.jpg
?????文件????????5573??2014-08-12?18:08??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\db_dorm.sql
?????目錄???????????0??2014-08-12?18:07??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\
?????文件?????????548??2014-07-21?11:28??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.classpath
?????文件????????1043??2014-07-21?11:24??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.project
?????目錄???????????0??2014-08-12?18:07??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.settings\
?????文件?????????503??2014-07-21?11:24??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.settings\.jsdtscope
?????文件??????????68??2014-07-24?23:14??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2014-07-21?11:24??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.settings\org.eclipse.jdt.core.prefs
?????文件?????????482??2014-07-21?11:24??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.settings\org.eclipse.wst.common.component
?????文件?????????305??2014-07-21?11:24??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2014-07-21?11:24??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-07-21?11:24??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件?????3621836??2015-04-27?11:29??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.settings\國內最大的免費商業(yè)源碼下載平臺.mht
?????文件?????????223??2015-12-15?12:56??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.settings\源碼說明.txt
?????文件???????14108??2015-07-21?10:13??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\.settings\百納科技源碼.png
?????目錄???????????0??2014-08-12?18:07??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\build\
?????目錄???????????0??2014-08-12?18:07??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\build\classes\
?????目錄???????????0??2014-08-12?18:07??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\build\classes\com\
?????目錄???????????0??2014-08-12?18:07??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\build\classes\com\lero\
?????目錄???????????0??2014-08-12?18:07??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\build\classes\com\lero\dao\
?????文件????????6840??2014-07-24?15:40??MF000687-JAVA學生宿舍后臺管理系統(tǒng)源碼\DormManage\build\classes\com\lero\dao\DormBuildDao.class
............此處省略304個文件信息