package?com.cai.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?com.cai.model.Grade;
import?com.cai.model.PageBean;
import?com.cai.util.StringUtil;

public?class?GradeDao?{
	//查詢方法
	public?ResultSet?gradeList（Connection?conPageBean?pageBeanGrade?grade）?throws?Exception{
		StringBuffer?sb=new?StringBuffer（“select?*?from?t_grade“）;
		if（grade!=null?&&?StringUtil.isNotEmpty（grade.getGradeName（）））{
			sb.append（“?and?gradeName?like?‘%“+grade.getGradeName（）+“%‘“）;
		}
		if（pageBean!=null）{
			sb.append（“?limit?“+pageBean.getStart（）+““+pageBean.getRows（））;
		}
		PreparedStatement?pstmt=con.prepareStatement（sb.toString（）.replaceFirst（“and“?“where“））;
		return?pstmt.executeQuery（）;
	}
	
	//右下角統(tǒng)計(jì)方法
	public?int?gradeCount（Connection?conGrade?grade）?throws?Exception{
		StringBuffer?sb=new?StringBuffer（“select?count（*）?as?total?from?t_grade“）;
		if（StringUtil.isNotEmpty（grade.getGradeName（）））{
			sb.append（“?and?gradeName?like?‘%“+grade.getGradeName（）+“%‘“）;
		}
		PreparedStatement?pstmt=con.prepareStatement（sb.toString（）.replaceFirst（“and“?“where“））;
		ResultSet?rs=pstmt.executeQuery（）;
		if（rs.next（））{
			return?rs.getInt（“total“）;
		}else{
			return?0;
		}
	}
	
	
	//刪除方法
	public?int?gradeDelete（Connection?conString?delIds）?throws?Exception{
		String?sql=“delete?from?t_grade?where?id?in?（“+delIds+“）“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		return?pstmt.executeUpdate（）;
	}
	
	//添加方法
	public?int?gradeAdd（Connection?conGrade?grade）?throws?Exception{
		String?sql=“insert?into?t_grade?values（null??）“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?grade.getGradeName（））;
		pstmt.setString（2?grade.getGradeDesc（））;
		return?pstmt.executeUpdate（）;
	}
	
	//更改方法
	public?int?gradeModify（Connection?conGrade?grade）?throws?Exception{
		String?sql=“update?t_grade?set?gradeName=?gradeDesc=??where?id=?“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?grade.getGradeName（））;
		pstmt.setString（2?grade.getGradeDesc（））;
		pstmt.setInt（3?grade.getId（））;
		return?pstmt.executeUpdate（）;
	}
	
}

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????文件????????4234??2017-11-21?22:57??db_studentinfo.sql
?????目錄???????????0??2017-11-21?22:53??Servlet_StudentInfoManage\
?????文件?????????915??2017-10-29?21:07??Servlet_StudentInfoManage\.classpath
?????文件?????????925??2017-07-10?20:34??Servlet_StudentInfoManage\.project
?????目錄???????????0??2017-11-21?22:53??Servlet_StudentInfoManage\.settings\
?????文件?????????567??2017-07-10?20:34??Servlet_StudentInfoManage\.settings\.jsdtscope
?????文件?????????364??2017-07-10?20:34??Servlet_StudentInfoManage\.settings\org.eclipse.jdt.core.prefs
?????文件?????????527??2017-07-10?20:34??Servlet_StudentInfoManage\.settings\org.eclipse.wst.common.component
?????文件?????????345??2017-07-10?20:34??Servlet_StudentInfoManage\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-07-10?20:34??Servlet_StudentInfoManage\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-07-10?20:34??Servlet_StudentInfoManage\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-11-21?22:53??Servlet_StudentInfoManage\WebContent\
?????目錄???????????0??2017-11-21?22:53??Servlet_StudentInfoManage\WebContent\meta-INF\
?????文件??????????39??2017-07-10?20:34??Servlet_StudentInfoManage\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2017-11-21?22:53??Servlet_StudentInfoManage\WebContent\WEB-INF\
?????目錄???????????0??2017-11-21?22:53??Servlet_StudentInfoManage\WebContent\WEB-INF\lib\
?????文件??????188671??2017-07-11?16:35??Servlet_StudentInfoManage\WebContent\WEB-INF\lib\commons-beanutils-1.7.0.jar
?????文件??????571259??2017-07-11?16:35??Servlet_StudentInfoManage\WebContent\WEB-INF\lib\commons-collections-3.2.jar
?????文件??????175426??2017-07-11?16:35??Servlet_StudentInfoManage\WebContent\WEB-INF\lib\commons-collections.jar
?????文件??????279781??2017-07-11?16:35??Servlet_StudentInfoManage\WebContent\WEB-INF\lib\commons-httpclient-3.0.1.jar
?????文件??????261809??2017-07-11?16:35??Servlet_StudentInfoManage\WebContent\WEB-INF\lib\commons-lang-2.4.jar
?????文件???????38015??2017-07-11?16:35??Servlet_StudentInfoManage\WebContent\WEB-INF\lib\commons-logging-1.0.4.jar
?????文件???????77826??2017-07-11?16:35??Servlet_StudentInfoManage\WebContent\WEB-INF\lib\ezmorph-1.0.3.jar
?????文件??????148490??2017-07-11?16:35??Servlet_StudentInfoManage\WebContent\WEB-INF\lib\json-lib-2.2.3-jdk15.jar
?????文件??????446464??2017-07-10?20:38??Servlet_StudentInfoManage\WebContent\WEB-INF\lib\mysql-connector-java-3.1.12-bin.jar
?????文件????????3016??2017-07-12?22:54??Servlet_StudentInfoManage\WebContent\WEB-INF\web.xml
?????文件????????4780??2017-07-13?14:00??Servlet_StudentInfoManage\WebContent\gradeInfoManage.jsp
?????目錄???????????0??2017-11-21?22:53??Servlet_StudentInfoManage\WebContent\images\
?????文件???????47101??2017-07-10?21:11??Servlet_StudentInfoManage\WebContent\images\login3.jpg
?????文件???????15105??2017-07-11?11:33??Servlet_StudentInfoManage\WebContent\images\main.jpg
?????文件????????1620??2017-07-14?10:54??Servlet_StudentInfoManage\WebContent\index.jsp
............此處省略620個(gè)文件信息