teachingdao.java

学生信息管理系统

package dao;
import java.util.*;
import java.io.*;
import vo.TeachingVO;
import util.CharsetExchange;
import java.sql.*;
import conn.ConnectDB;
public class TeachingDAO 
{
	public TeachingDAO()
	{
		
	}
	public boolean checkTeacher(String teacher_id)
	{
		boolean isexist=false;
		try
		{
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			ResultSet rs=stat.executeQuery("select * from teacher_class_course where teacher_id='"+teacher_id+"'");
			if(rs.next())
			{
				isexist=true;
			}
			
		}
		catch(Exception e)
		{
			
		}
		return isexist;
	}
	public boolean checkCourse(String course_id,String term)
	{
		ResultSet rs=null;
		boolean isexist=false;
		try
		{
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from teacher_class_course where course_id='"+course_id+"'and term='"+term+"'");
			if(rs.next())
			{
				isexist=true;
			}
		}
		catch(Exception e)
		{
			
		}
		return isexist;
	}
	public boolean checkClass(String class_id,String term)
	{
		ResultSet rs=null;
		boolean isexist=false;
		try
		{
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from teacher_class_course where class_id='"+class_id+"'and term='"+term+"'");
			if(rs.next())
			{
				isexist=true;
			}
		}
		catch(Exception e)
		{
			
		}
		return isexist;
	}
	public ArrayList getTeachingByTeacherId(String teacher_id)
	{
		ResultSet rs=null;
		ArrayList teachingInfors=null;
		try
		{
			teachingInfors=new ArrayList();
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from teacher_class_course where teacher_id='"+teacher_id+"'");
			while(rs.next())
			{
				TeachingVO teachingvo=new TeachingVO();
				teachingvo.setClassId(rs.getString("class_id"));
				teachingvo.setTeacherId(rs.getString("teacher_id"));
				teachingvo.setTerm(rs.getString("term"));
				teachingvo.setCourseId(rs.getString("course_id"));
				teachingInfors.add(teachingvo);
			}
		
		}
		catch(Exception e)
		{
			
		}
		return teachingInfors;
	}
	public ArrayList getTeachingByCourseId(String course_id)
	{
		ResultSet rs=null;
		ArrayList teachingInfors=null;
		try
		{
			teachingInfors=new ArrayList();
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from teacher_class_course where course_id='"+course_id+"'");
			while(rs.next())
			{
				TeachingVO teachingvo=new TeachingVO();
				teachingvo.setClassId(rs.getString("class_id"));
				teachingvo.setTeacherId(rs.getString("teacher_id"));
				teachingvo.setTerm(rs.getString("term"));
				teachingvo.setCourseId(rs.getString("course_id"));
				teachingInfors.add(teachingvo);
			}
		
		}
		catch(Exception e)
		{
			
		}
		return teachingInfors;
	}
	public ArrayList getTeachingByClassId(String class_id)
	{
		ResultSet rs=null;
		ArrayList teachingInfors=null;
		try
		{
			teachingInfors=new ArrayList();
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from teacher_class_course where class_id='"+class_id+"'");
			while(rs.next())
			{
				TeachingVO teachingvo=new TeachingVO();
				teachingvo.setClassId(rs.getString("class_id"));
				teachingvo.setTeacherId(rs.getString("teacher_id"));
				teachingvo.setTerm(rs.getString("term"));
				teachingvo.setCourseId(rs.getString("course_id"));
				teachingInfors.add(teachingvo);
			}
		
		}
		catch(Exception e)
		{
			
		}
		return teachingInfors;
	}
	public ArrayList getTeachingInfors()
	{
		ResultSet rs=null;
		ArrayList teachingInfors=null;
		try
		{
			teachingInfors=new ArrayList();
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from teacher_class_course ");
			while(rs.next())
			{
				TeachingVO teachingvo=new TeachingVO();
				teachingvo.setClassId(rs.getString("class_id"));
				teachingvo.setTeacherId(rs.getString("teacher_id"));
				teachingvo.setTerm(rs.getString("term"));
				teachingvo.setCourseId(rs.getString("course_id"));
				teachingInfors.add(teachingvo);
			}
		
		}
		catch(Exception e)
		{
			
		}
		return teachingInfors;
	}
}