selectcoursedao.java

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

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

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

import com.ccniit.kaoqin.db.DAOBase;
import com.ccniit.kaoqin.db.classes.Classes;


/**
 * 编写小组：邓从伟（张强_李楠）
 *
 */
public class SelectCourseDAO extends DAOBase{
	
	
/**
 * 添加选课的班级
 * @param selectCourses
 * @throws SQLException
 * @throws ClassNotFoundException
 */		
public void  addSelectCourse(int[] class_id,int course_id,String  selectCourse_year,int selectCourse_term) throws SQLException, ClassNotFoundException{
	
	String sqlStr="delete from selectCourse where  course_id=? and selectCourse_year=? and selectCourse_term=? ";
	pst=dBMain.getPreparedStatement(sqlStr);
	
	pst.setInt(1, course_id);
	pst.setString(2, selectCourse_year);
	pst.setInt(3, selectCourse_term);
	pst.executeUpdate();
	
	
	
	//----------------------------------------
    if(class_id.length==0){
    	 this.release();
       }else{
    sqlStr="insert into selectCourse (class_id,course_id,selectCourse_year,selectCourse_term) values(?,?,?,?)";
	  pst=dBMain.getPreparedStatement(sqlStr);
	   for(int i=0;i<class_id.length;i++){
		
		pst.setInt(1, class_id[i]);
		pst.setInt(2, course_id);
		pst.setString(3, selectCourse_year);
		pst.setInt(4, selectCourse_term);
		pst.executeUpdate();   
	   
	   
	   
	   }
	
	}
	   
	   
	   
	   this.release();
	
	
}




@SuppressWarnings({ "static-access", "unchecked" })
public ArrayList getSelectCourseByCourseId(String selectCourse_year,int selectCourse_term,int course_id) throws ClassNotFoundException, SQLException{
	String sqlStr="select * from class," +
			" selectCourse where " +
			"class.class_id=selectCourse.class_id and" +
			" selectCourse_year=? and " +
			"selectCourse_term=? and course_id=?";
	pst=dBMain.getPreparedStatement(sqlStr);
	pst.setString(1,selectCourse_year );
	pst.setInt(2, selectCourse_term);
	pst.setInt(3, course_id);
	
	rs=pst.executeQuery();
	ArrayList selectCourses=new ArrayList();
	Classes selectCourse=null;
	
	while(rs.next()){
		selectCourse=com.ccniit.kaoqin.db.classes.ClassesDAO.assemble(rs);
		selectCourses.add(selectCourse);
	}
	this.release();
	return selectCourses;
	
}	
	
	
	
	
	/**
	 * 将当前的选课信息 封装成一个对象
	 * @param rs
	 * @return
	 * @throws SQLException
	 */
public static SelectCourse assemble(java.sql.ResultSet rs) throws SQLException{
	  SelectCourse selectCourse=new SelectCourse();
	  selectCourse.setSelectCourse_id(rs.getInt("selectCourse_id"));
	  selectCourse.setClass_id(rs.getInt("class_id"));
	  selectCourse.setCourse_id(rs.getInt("course_id"));
	  selectCourse.setSelectCourse_year(rs.getString("selectCourse_year"));
	  selectCourse.setSelectCourse_term(rs.getInt("selectCourse_term"));
	  
	
	
	
	return selectCourse;
	
}

}