examdao.java

学生信息管理系统

package dao;
import java.sql.*;
import java.io.*;
import conn.ConnectDB;
import java.util.*;
import vo.ExamVO;
public class ExamDAO 
{
	public ExamDAO()
	{
	}
	public boolean checkExam(String course_id,String term,String student_id)
	{
		boolean isexist=false;
		try
		{
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			ResultSet rs=stat.executeQuery("select * from exam where  course_id='"+course_id+"'and term='"+term+"'and student_id='"+student_id+"'");
			if(rs.next())
			{
				isexist=true;
			}
		}
		catch(Exception e)
		{
			
		}
		return isexist;
	}
	public boolean checkStudent(String student_id)
	{
		boolean isexist=false;
		try
		{
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			ResultSet rs=stat.executeQuery("select * from exam where  student_id='"+student_id+"'");
			if(rs.next())
			{
				isexist=true;
			}
		}
		catch(Exception e)
		{
			
		}
		return isexist;
	}
	public boolean checkDate(String date)
	{
		boolean isexist=false;
		try
		{
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			ResultSet rs=stat.executeQuery("select * from exam where  examtime='"+date+"'");
			if(rs.next())
			{
				isexist=true;
			}
		}
		catch(Exception e)
		{
			
		}
		return isexist;
	}
	
	public ArrayList getExamInforsByStudentId(String student_id)
	{
		ResultSet rs=null;
		ArrayList exams=null;
		try
		{
			exams=new ArrayList();
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from exam where student_id='"+student_id+"'");
			while(rs.next())
			{
				ExamVO examvo=new ExamVO();
				examvo.setCourseId(rs.getString("course_id"));
				examvo.setStudentId(rs.getString("student_id"));
				examvo.setTeacherId(rs.getString("teacher_name"));
				examvo.setTerm(rs.getString("term"));
				examvo.setExamTime(rs.getString("examtime"));
				examvo.setExamType(rs.getString("examtype"));
				examvo.setAddress(rs.getString("address"));
				exams.add(examvo);
			}
		}
		catch(Exception e)
		{
			
		}
		return exams;
	}
	public ArrayList getExamInforsByDate(String examtime)
	{
		ResultSet rs=null;
		ArrayList exams=null;
		try
		{
			exams=new ArrayList();
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from exam where examtime='"+examtime+"'");
			while(rs.next())
			{
				ExamVO examvo=new ExamVO();
				examvo.setCourseId(rs.getString("course_id"));
				examvo.setStudentId(rs.getString("student_id"));
				examvo.setTeacherId(rs.getString("teacher_name"));
				examvo.setTerm(rs.getString("term"));
				examvo.setExamTime(rs.getString("examtime"));
				examvo.setExamType(rs.getString("examtype"));
				examvo.setAddress(rs.getString("address"));
				exams.add(examvo);
			}
		}
		catch(Exception e)
		{
			
		}
		return exams;
	}
	public ArrayList getExamInforsByTerm(String term)
	{
		ResultSet rs=null;
		ArrayList exams=null;
		try
		{
			exams=new ArrayList();
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from exam where term='"+term+"'");
			while(rs.next())
			{
				ExamVO examvo=new ExamVO();
				examvo.setCourseId(rs.getString("course_id"));
				examvo.setStudentId(rs.getString("student_id"));
				examvo.setTeacherId(rs.getString("teacher_name"));
				examvo.setTerm(rs.getString("term"));
				examvo.setExamTime(rs.getString("examtime"));
				examvo.setExamType(rs.getString("examtype"));
				examvo.setAddress(rs.getString("address"));
				exams.add(examvo);
			}
		}
		catch(Exception e)
		{
			
		}
		return exams;
	}
	public void insertExam(ExamVO examvo)
	{
		ResultSet rs=null;
		try
		{
			Connection  conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from course where course_id='"+examvo.getCourseId()+"'");
			if(rs.next())
			{

			ConnectDB.executeUpdate("insert into exam values('"+rs.getString("course_id")+"','"+examvo.getStudentId()+"','"+examvo.getTeacherId()+"','"+examvo.getTerm()+"','"+examvo.getExamType()+"','"+examvo.getExamTime()+"','"+examvo.getAddress()+"')");
				
			}
					
		}
		catch(Exception e)
		{
			
		}
	}
	public void updateExam(ExamVO examvo)
	{
		
		ResultSet rs=null;
		try
		{
			Connection  conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from exam where course_id='"+examvo.getCourseId()+"'and term='"+examvo.getTerm()+"'and student_id='"+examvo.getStudentId()+"'");
			if(rs.next())
			{
				ConnectDB.executeUpdate("update exam set student_id='"+examvo.getStudentId()+"'and teacher_name='"+examvo.getTeacherId()+"'and term='"+examvo.getTerm()+"'and examtype='"+examvo.getExamType()+"'and examtime='"+examvo.getExamTime()+"'and address='"+examvo.getAddress()+"'where course_id='"+examvo.getCourseId()+"'");
				
			}
		}	
			
		catch(Exception e)
		{
			
		}		
	}
	public void deleteExam(String course_id,String term,String student_id)
	{
		ResultSet rs=null;
		try
		{
			Connection  conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from exam where course_id='"+course_id+"'and term='"+term+"'and student_id='"+student_id+"'");
			if(rs.next())
			{
				ConnectDB.executeUpdate("delete from  exam where course_id='"+course_id+"'and term='"+term+"'");
				
			}
		}	
			
		catch(Exception e)
		{
			
		}	
	}		
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
		
	
}