dianmindao.java

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

package com.ccniit.kaoqin.db.dianmin;

import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;

import com.ccniit.kaoqin.db.DAOBase;


public class DianMinDAO extends DAOBase {
	
	
	@SuppressWarnings({ "static-access", "unchecked" })
	public 	ArrayList getKaoQinPeople(DianMin dianmin) throws ClassNotFoundException, SQLException{
		  
		    ArrayList dianmins1=null;   
		    DianMin dianMin=null;
		  
		    Calendar rightNow = Calendar.getInstance();
	        SimpleDateFormat fmt = new SimpleDateFormat("yyyy-MM-dd");
	        String sysDatetime = fmt.format(rightNow.getTime());   
		    String sqlStr2="select   *  from  dianminList where course_id=? and class_id=? and kaoqin_time=? and teacher_id=? and kaoqin_date=?";
		    pst=dBMain.getPreparedStatement(sqlStr2);
			pst.setInt(1, dianmin.getCourse_id());
			pst.setInt(2, dianmin.getClass_id());
			pst.setInt(3, dianmin.getKaoqin_time());
			pst.setInt(4, dianmin.getTeacher_id());
			pst.setString(5,sysDatetime);
			rs=pst.executeQuery();
			dianmins1=new ArrayList();
			
			
			while(rs.next()){
				dianMin=this.assemble(rs);
				dianmins1.add(dianMin);
				
		        }

			  if(dianmins1.size()==0){
				  dianmins1=new ArrayList();
				
				
					return dianmins1;
					
				}
			  
			
				
			  this.release();
			  return dianmins1; 
			
			
			
			
		
		
	}	
	
	
public static DianMin assemble(java.sql.ResultSet rs) throws SQLException{
	
	DianMin dianMin=new DianMin();
	dianMin.setClass_id(rs.getInt("class_id"));
	dianMin.setCourse_id(rs.getInt("course_id"));
	dianMin.setKaoqin_data(rs.getString("kaoqin_data"));
	dianMin.setKaoqin_time(rs.getInt("kaoqin_time"));
	dianMin.setKaoqin_date(rs.getString("kaoqin_date"));
	dianMin.setStudent_id(rs.getInt("student_id"));
	dianMin.setStudent_name(rs.getString("student_name"));
	dianMin.setStudent_NO(rs.getString("student_NO"));
	dianMin.setStudent_sex(rs.getString("student_sex"));
	dianMin.setTeacher_id(rs.getInt("teacher_id"));
	dianMin.setTeacherCourse_year(rs.getString("teacherCourse_year"));
	dianMin.setTeacherCourse_term(rs.getInt("teacherCourse_term"));
	
	
	return dianMin;
	
}
}