coursemanage.java

用JSP实现毕业设计选题系统,老师在网上出题,学生通过WEB来选题等功能

/**
 * 
 */
package course;
import util.ConnData;
import java.sql.*;

/**
 * @author 朱定芬
 *
 */
public class CourseManage 
{
	ConnData cd=null;
	Statement stmt=null;
	ResultSet rs=null;
	int i=0;
	boolean bn=false;
	String sql=null;
	public CourseManage()
	{
		cd=new ConnData();
		stmt=cd.OpenStmt();
	}
	//保存课程信息
	public int SaveCourseInfo(CourseBean cb)
	{
		try
		{
			sql="Insert Into Course(CourseName,CourseDescription,CourseStatus,CourseTeacher) Values('"
				+cb.getCourseName()+"','"
				+cb.getCourseDescription()+"','"
				+cb.getCourseStatus()+"','"
				+cb.getCourseTeacher()+"')";
			i=stmt.executeUpdate(sql);
		}
		catch(SQLException s)
		{
			System.err.print(s.getMessage());
		}
		return i;
	}
	//修改课程信息
	public int EditCourseInfo(CourseBean cb)
	{
		try
		{
			sql="Update Course Set CourseName='"
				+cb.getCourseName()+"',CourseDescription='"
				+cb.getCourseDescription()+"' Where CourseID="
				+cb.getCourseID();
			i=stmt.executeUpdate(sql);
		}
		catch(SQLException sq)
		{
			System.err.print(sq.getMessage());
		}
		return i;
	}
	//删除课程
	public int DeleteCourseInfo(String id)
	{
		try
		{
			sql="Delete From Course Where CourseID="+id;
			i=stmt.executeUpdate(sql);
		}
		catch(SQLException sql)
		{
			System.err.print(sql.getMessage());
		}
		return i;
	}
	//得到已选课程
	public ResultSet GetOneStudentCourse(String id)
	{
		try
		{
			sql="Select * From Course Where CourseStudent='"+id+"'";
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException sqle)
		{
			System.err.print(sqle.getMessage());
		}
		return rs;
	}
	//得到未选的课程
	public ResultSet GetNoCourse()
	{
		try
		{
			sql="Select * From Course Where CourseStatus='未选'";
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException sqle)
		{
			System.err.print(sqle.getMessage());
		}
		return rs;
	}
	//得到指定老师的所有课程
	public ResultSet GetTeacherCourse(String id)
	{
		try
		{
			sql="Select * From Course Where CourseTeacher='"+id+"'";
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException sqlxe)
		{
			System.err.print(sqlxe.getMessage());
		}
		return rs;
	}
	//得到指定课程
	public ResultSet GetOneCourse(String id)
	{
		try
		{
			sql="Select * From Course Where CourseID='"+id+"'";
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException sqle)
		{
			System.err.print(sqle.getMessage());
		}
		return rs;
	}
	//保存学生选课记录
	public int SaveChoice(String cid,String sid)
	{
		try
		{
			sql="Update Course Set CourseStatus='已选',CourseStudent='"+sid+"' Where CourseID='"+cid+"'";
			i=stmt.executeUpdate(sql);
		}
		catch(SQLException sqlexx)
		{
			sqlexx.printStackTrace();
		}
		return i;
	}
	//保存学生取消选课
	public int SaveNoChoice(String cid,String tid)
	{
		try
		{
			sql="Update Course Set CourseStatus='未选',CourseStudent='null' Where CourseID='"+cid+"'";
			i=stmt.executeUpdate(sql);
		}
		catch(SQLException sqlexx)
		{
			sqlexx.printStackTrace();
		}
		return i;
	}
	//保存学生删除时,使用该课程为未选
	public int SaveNoStudent(String sid)
	{
		try
		{
			sql="Update Course Set CourseStatus='未选',CourseStudent='null' Where CourseStudent='"+sid+"'";
			i=stmt.executeUpdate(sql);
		}
		catch(SQLException sqlexx)
		{
			sqlexx.printStackTrace();
		}
		return i;
	}
	//检测学生是否已经选课了
	public boolean ChkCourse(String tid)
	{
		try
		{
			sql="Select * From Course Where CourseStudent='"+tid+"'";
			rs=stmt.executeQuery(sql);
			if(rs.next())
			{
				bn=true;
			}
			else
			{
				bn=false;
			}
		}
		catch(SQLException sqlexxx)
		{
			sqlexxx.printStackTrace();
		}
		return bn;
	}
}