package?com.java1234.dao;

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

import?com.java1234.model.Grade;
import?com.java1234.model.PageBean;
import?com.java1234.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（）;
	}
	
	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;
		}
	}
	
	/**
	?*?delete?from?tableName?where?field?in?（135）
	?*?@param?con
	?*?@param?delIds
	?*?@return
	?*?@throws?Exception
	?*/
	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（）;
	}
	
}