teachcoursedao.java

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

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

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

import com.ccniit.kaoqin.db.DAOBase;
import com.ccniit.kaoqin.db.teacher.Teacher;

/**
 * 编写小组：邓从伟（张强_李楠）
 *
 */
public class TeachCourseDAO  extends DAOBase{
	
	
	
/**
 * 添加老师代课的班级
 * @param teachCourses
 * @throws ClassNotFoundException
 * @throws SQLException
 */
public void addTeachCours(int course_id,String teacherCourse_year,int teacherCourse_term,int[] teacher_ids) throws ClassNotFoundException, SQLException{
	
	String sqlStr="delete from teachCourse where course_id=? and teacherCourse_year=? and teacherCourse_term=?"; 
	pst=dBMain.getPreparedStatement(sqlStr);
	pst.setInt(1, course_id);
	pst.setString(2, teacherCourse_year);
	pst.setInt(3, teacherCourse_term);
	pst.executeUpdate();
	

	
	
	if(teacher_ids.length==0){
		this.release();
	}else{
	//-----------------------------------------------------
	sqlStr="insert into teachCourse (teacher_id,course_id,teacherCourse_year,teacherCourse_term)values (?,?,?,?)";
	pst=dBMain.getPreparedStatement(sqlStr);
	
	for(int i=0;i<teacher_ids.length;i++){
		pst.clearParameters();
		pst.setInt(1, teacher_ids[i]);
		pst.setInt(2, course_id);
		pst.setString(3, teacherCourse_year);
		pst.setInt(4, teacherCourse_term);
		pst.executeUpdate();
		
	}
	}
	this.release();
	
}

@SuppressWarnings({ "static-access", "unchecked" })
public ArrayList getTeachCourseByCourseId(int teacherCourse_term ,int course_id,String teacherCourse_year) throws ClassNotFoundException, SQLException{
	
	
	String sqlStr="select * from " +
			" teacher ,teachCourse where  " +
			"teacher.teacher_id=teachCourse.teacher_id " +
			" and teacherCourse_year=? and " +
			"teacherCourse_term=? and course_id=? ";
	pst=dBMain.getPreparedStatement(sqlStr);
	pst.setString(1, teacherCourse_year);
	pst.setInt(2, teacherCourse_term);
	pst.setInt(3, course_id);
	
	 rs=pst.executeQuery();
	 ArrayList teachCourses=new ArrayList();
	 Teacher teachCourse=null;
	 while(rs.next()){
		 teachCourse=com.ccniit.kaoqin.db.teacher.TeacherDAO.assemble(rs);
		 teachCourses.add(teachCourse);
		 
	 }
	 this.release();
	return teachCourses;
	
}
	
	
public static TeachCourse assemble(java.sql.ResultSet rs) throws SQLException{
	
	TeachCourse teachCourse =new TeachCourse();
	teachCourse.setTeacherCourse_id(rs.getInt("teacherCourse_id"));
	teachCourse.setTeacher_id(rs.getInt("teacher_id"));
	teachCourse.setCourse_id(rs.getInt("course_id"));
	teachCourse.setTeacherCourse_year(rs.getString("teacherCourse_year"));
	teachCourse.setTeacherCourse_term(rs.getInt("teacherCourse_term"));
	
	return teachCourse;
	
}
	

}