91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

資源簡介

該項目實現了學生信息、宿舍信息、管理員信息、考勤信息等的管理功能，學生、宿管、系統管理員登錄后系統顯示不同的界面。數據庫采用的是mysql，功能結構層次非常清晰，是Java學習參考非常難得的好項目。 詳細說明：https://blog.csdn.net/CDWLX/article/details/107540336

資源截圖

代碼片段和文件信息 

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

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????771??2020-07-20?11:29??DormManage\.classpath
?????文件????????1043??2014-07-21?11:24??DormManage\.project
?????文件?????????503??2014-07-21?11:24??DormManage\.settings\.jsdtscope
?????文件??????????92??2018-08-23?23:09??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
?????文件?????????345??2018-08-23?23:09??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
?????文件?????????512??2020-07-20?11:45??DormManage\.settings\org.eclipse.wst.validation.prefs
?????文件??????????39??2014-07-21?11:24??DormManage\WebContent\meta-INF\MANIFEST.MF
?????文件???????17809??2014-07-17?23:29??DormManage\WebContent\WEB-INF\lib\jstl.jar
?????文件??????446464??2014-07-18?10:30??DormManage\WebContent\WEB-INF\lib\mysql-connector-java-3.1.12-bin.jar
?????文件??????351349??2014-07-17?23:29??DormManage\WebContent\WEB-INF\lib\standard.jar
?????文件????????2631??2014-08-11?22:15??DormManage\WebContent\WEB-INF\web.xml
?????文件?????????499??2014-08-11?22:07??DormManage\WebContent\admin\blank.jsp
?????文件????????2498??2014-08-05?18:00??DormManage\WebContent\admin\dormBuild.jsp
?????文件????????1822??2014-07-27?20:11??DormManage\WebContent\admin\dormBuildSave.jsp
?????文件????????2642??2014-07-27?20:11??DormManage\WebContent\admin\dormManager.jsp
?????文件????????3365??2014-07-27?20:12??DormManage\WebContent\admin\dormManagerSave.jsp
?????文件????????2076??2014-08-11?22:05??DormManage\WebContent\admin\passwordChange.jsp
?????文件????????4276??2014-08-06?20:37??DormManage\WebContent\admin\record.jsp
?????文件????????2335??2014-07-27?20:12??DormManage\WebContent\admin\selectManager.jsp
?????文件????????3745??2014-08-06?15:47??DormManage\WebContent\admin\student.jsp
?????文件????????3138??2014-07-24?18:40??DormManage\WebContent\admin\studentRecord.jsp
?????文件????????4126??2014-07-27?20:12??DormManage\WebContent\admin\studentSave.jsp
?????文件???????22102??2014-07-17?21:15??DormManage\WebContent\bootstrap\css\bootstrap-responsive.css
?????文件???????16840??2014-07-17?21:15??DormManage\WebContent\bootstrap\css\bootstrap-responsive.min.css
?????文件??????127343??2014-07-17?21:15??DormManage\WebContent\bootstrap\css\bootstrap.css
?????文件??????106006??2014-07-17?21:15??DormManage\WebContent\bootstrap\css\bootstrap.min.css
?????文件????????8777??2014-07-17?21:15??DormManage\WebContent\bootstrap\img\glyphicons-halflings-white.png
............此處省略199個文件信息

評論

共有 條評論