classesdao.java

学生考勤管理系统————分为课程选择

/**
 * 
 */
package com.ccniit.kaoqin.db.classes;

import java.sql.SQLException;
import java.util.ArrayList;

import com.ccniit.kaoqin.db.DAOBase;
import com.ccniit.kaoqin.db.student.Student;
import com.ccniit.kaoqin.db.student.StudentDAO;

/**
 * 编写小组：邓从伟（张强_李楠）
 *
 */
public class ClassesDAO extends DAOBase {

	/**
	 * 根据班级ID号查询出一条相对应的班级信息
	 * 
	 * @param class_id
	 * @return
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 */
	public Classes getClassById(int class_id) throws ClassNotFoundException,
			SQLException {
		// 对SQL语句进行封装
		String sqlStr = "select * from class where class_id = ?";
		pst = dBMain.getPreparedStatement(sqlStr);
		// 参数指定
		pst.setInt(1, class_id);
		// 执行sql语句
		rs = pst.executeQuery();
		Classes clas = null;
		while (rs.next()) {
			clas = assemble(rs);

		}
		this.release();
		return clas;

	}
@SuppressWarnings({ "static-access", "unchecked" })
public ArrayList getClassesByGradeId(String  grade_name) throws ClassNotFoundException, SQLException{
		
		String sqlStr="select *  from  class  where class_grade=?";
		pst=dBMain.getPreparedStatement(sqlStr);
		
		pst.setString(1, grade_name);
		
		rs=pst.executeQuery();
		ArrayList classess=new ArrayList();
		Classes classes=null;
		
		while(rs.next()){
			classes=this.assemble(rs);
			classess.add(classes);
			
		}
		this.release();
		
		return classess;
		
	}	
		

	/**
	 *  根据班级ID获得班级的详细信息（包括班级的信息和班级的所有成员）
	 * @param class_id
	 * @return
	 * @throws SQLException
	 * @throws ClassNotFoundException
	 */
	
@SuppressWarnings("unchecked")
public Classes  getClassesDetailById(int class_id) throws SQLException, ClassNotFoundException{
	String sqlStr = "select * from class c left join  student s on  c.class_id=s.class_id where  c.class_id=?";
	pst = dBMain.getPreparedStatement(sqlStr);
	pst.setInt(1, class_id);
	rs = pst.executeQuery();
	Classes clas = null;
	ArrayList students = new ArrayList();
	Student stu = null;
	while (rs.next()) {
		stu = StudentDAO.assemble(rs);
		clas = assemble(rs);
		students.add(stu);
		clas.setStudent(students);
	}
	this.release();
	return clas;
	
}
	
/**
 * 根据课程ID 获得班级信息
 * @param course_id
 * @return
 * @throws ClassNotFoundException
 * @throws SQLException
 */

@SuppressWarnings({ "static-access", "unchecked" })
public ArrayList getClassesByCourseId(int course_id) throws ClassNotFoundException, SQLException{
	
	String sqlStr="select *  from  class ,selectCourse where class.class_id=selectCourse.class_id and course_id=?";
	pst=dBMain.getPreparedStatement(sqlStr);
	
	pst.setInt(1, course_id);
	
	rs=pst.executeQuery();
	ArrayList classess=new ArrayList();
	Classes classes=null;
	
	while(rs.next()){
		classes=this.assemble(rs);
		classess.add(classes);
		
	}
	this.release();
	
	return classess;
	
}	
	
	
	
	
/**
 *  添加一个班级
 * @param classes
 * @throws ClassNotFoundException
 * @throws SQLException
 */	
public void addClassess(Classes classes) throws ClassNotFoundException, SQLException{
	
	String sqlStr="insert into class(class_NO,class_name,class_grade)values(?,?,?)";
	pst=dBMain.getPreparedStatement(sqlStr);
	pst.setString(1, classes.getClass_NO());
	pst.setString(2, classes.getClass_name());
	pst.setString(3, classes.getClass_grade());
	pst.executeUpdate();
	this.release();
	
	
}
/**
 *  根据班级ID删除班级
 * @param class_id
 * @throws ClassNotFoundException
 * @throws SQLException
 */

public void deleteClasses(int class_id) throws ClassNotFoundException, SQLException{
	
	String sqlStr="delete from class where class_id=?";
	
	pst=dBMain.getPreparedStatement(sqlStr);
	pst.setInt(1, class_id);
	pst.executeUpdate();
	this.release();
	
	
	
	
}


/**
 * 修改一个班级信息
 * @param classes
 * @throws ClassNotFoundException
 * @throws SQLException
 */
public void modifyClasses(Classes classes) throws ClassNotFoundException, SQLException{
	
	String sqlStr = "update class set class_NO=?,class_name=?,class_grade=? where class_id=?";
	pst = dBMain.getPreparedStatement(sqlStr);
	pst.setString(1, classes.getClass_NO());
	pst.setString(2, classes.getClass_name());
	pst.setString(3, classes.getClass_grade());
	pst.setInt(4, classes.getClass_id());
	pst.executeUpdate();
	this.release();
	
	
}



/**
 *  得到所有的班级
 * @return
 * @throws ClassNotFoundException
 * @throws SQLException
 */
@SuppressWarnings("static-access")
public ArrayList  getAllClasses() throws ClassNotFoundException, SQLException{
	String sqlStr ="select * from class";
	pst=dBMain.getPreparedStatement(sqlStr);
	rs=pst.executeQuery();
	
	ArrayList<Classes> classeses=new ArrayList<Classes>();
	Classes classes=null;
	
	while (rs.next()){
		classes=this.assemble(rs);
		classeses.add(classes);
		
	}
	this.release();
	
	return classeses;
	
}
	

	
	
	/**
	 * 将当前的班级封装成一个对象，供使用
	 * @param rs
	 * @return
	 * @throws SQLException
	 */
public static Classes assemble(java.sql.ResultSet rs) throws SQLException{
	
	Classes classes=new Classes();
	classes.setClass_id(rs.getInt("class_id"));
	classes.setClass_NO(rs.getString("class_NO"));
	classes.setClass_name(rs.getString("class_name"));
	classes.setClass_grade(rs.getString("class_grade"));

	return classes;

}
	
	
}