studentcompulsorycoursedao.java

学生信息管理系统

package dao;
import conn.ConnectDB;
import java.sql.*;
import java.util.*;
import vo.StudentCompulsoryCourseVO;
public class StudentCompulsoryCourseDAO 
{
	public StudentCompulsoryCourseDAO()
	{
		
	}
	public boolean checkCourse(String course_id,String class_id)
	{
		ResultSet rs=null;
		boolean isexist=false;
		try
		{
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from student_compulsorycourse where course_id='"+course_id+"'");
			if(rs.next())
			{
				rs=stat.executeQuery("select * from student_compulsorycourse where class_id='"+class_id+"'");
				if(rs.next())
				{
					isexist=true;	
				}
				
			}
			else
			isexist=false;
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
			
			return isexist;
	}
	public void insertCourse(StudentCompulsoryCourseVO coursevo)
	{
		try
		{
			ConnectDB.executeUpdate("insert into student_compulsorycourse values('"+coursevo.getStudentId()+"','"+coursevo.getCourseId()+"','"+coursevo.getClassId()+"','"+coursevo.getTerm()+"','"+coursevo.getCourseName()+"')");
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public void deleteCourse(String course_id)
	{
		ResultSet rs=null;
		try
		{
			Connection  conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from student_compulsorycourse where course_id='"+course_id+"'");
			if(rs.next())
			{
				ConnectDB.executeUpdate("delete from student_compulsorycourse where course_id='"+course_id+"'");
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	} 
}