import?java.sql.*;
public?class?checkEnrol{
	
	public?boolean?hasPassPrepare（String?prepare）{???//是否完成預(yù)修課
	??boolean?f=false;
	??int?a=0;
	??String?temp=null;
	??String?sql=“select?score?“+
				“from?enrolclasses?course?“+
				“where???enrol.class_id=classes.id?“+
				“and?classes.cour_id=course.id?“+
				“and?course.id=‘“+prepare+“‘?“;
??????sqlBean?db=new?sqlBean（）;
??????try{
??????	ResultSet?rs?=?db.executeQuery（sql）;
??????	if（rs.next（））
??????	temp=rs.getString（“score“）;
??????	}catch（SQLException?e）{System.out.print（e.toString（））;}
??????	if（temp==null?||?temp.equals（““））
??????	return?false;
??????	else{
??????	try{
??????	?a=Integer.parseInt（temp）;	
??????		}?catch（NumberFormatException?e）{System.out.print（e.toString（））;}
??????	if（a>=60）?f=true;}
??????	return?f;	
		}
	

??	?	????????????
	public?boolean?hasLogin（String?stu_idString?cour_id）{???//該學(xué)生是否已經(jīng)注冊(cè)該課程
??	boolean?f=true;
???String?sql=“select?stu_idclass_id?“+
			“from?enrolclasses?“+
			“where?stu_id=‘“+stu_id+“‘?“+
			“and?classes.id=enrol.class_id?“+
			“and?cour_id=‘“+cour_id+“‘?“;
??	sqlBean?db?=new?sqlBean（）;
??	try{
??	ResultSet?rs=db.executeQuery（sql）;
??	if（rs.next（））{?f=false;}
??	else{?f=true;}
??	}catch（Exception?e）{?e.getMessage（）;}
??	return?f;
??	???????????????????????}
??	???????????????????????
??	??????
???public?ResultSet?getCourse（String?stu_id）
????{?
????String?sql=“select?DISTINCT?course.idcourse.namecourse.preparecourse.dep??“+
			“classes.id?as?class_idclasses.room_idclasses.cour_timeteacher.name?as?tea_name?“+
			“from?courseclassesteacher?“+
			“where?classes.cour_id=course.id??“+
			“and?classes.tea_id=teacher.id?“+
?			“and?classes.id?in?“+
			“（?select?classes.id?from?classesstudentcourse??“+
			“where?classes.id?not?in（?select?class_id?from?enrol?where?stu_id=‘“+stu_id+“‘）?“+
			“and?（?student.department=course.dep?or?course.dep?=‘public‘）??“+
			“and?course.id=classes.cour_id?and?student.id=‘“+stu_id+“‘）?“;

??	??sqlBean?db?=?new?sqlBean（）;
??	ResultSet?rs=??db.executeQuery（sql）;
??	return?rs;
??	??????????????????????????}?
??	??????????????????????????
??	??????????????????????????
??	??????????????????????????
??	???????????????????????????????????????????
??public?String?getTotalMark（String?id）{
????	String?temp=“0“;
??	??String?sql=“select?mark?from?student?where?id=‘“+id+“‘??“;
??	??sqlBean?db?=?new?sqlBean（）;
??????ResultSet?rs=??db.executeQuery（sql）;?	
??	?????try{
??	?????	if（rs.next（））
??	?????	temp=rs.getString（“mark“）;
??	?????	}?catch（Exception?e）{}
??	?????	return?temp;	
??	?????	}
?	?
?	?public?int?updatestu（String?pwString?idString?e_mailString?tel）{
?	?	int?num=0;
?	?
????????String?sql=“update?student?set?password=‘“+pw+“‘e_mail=‘“+e_mail+“‘tel=‘“+tel+“‘??where?id=‘“+id+“‘??“;?????????
?	?	sqlBean?db?=?new?sqlBean（）;
?	?	num=db.executeInsert（sql）;
?	?	return?num;
?	?	
?	?	}
?	?	
?	?		????????????????????
??	?public?int?

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----

?????文件????1264128??2003-12-01?22:49??chengjiguanli\backup_ClassDB.BAK

?????文件???????3274??2003-12-01?17:27??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\AddClass.jsp

?????文件???????2238??2003-11-27?18:57??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\Addcourse.jsp

?????文件???????2019??2003-12-01?17:22??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\addstudent.jsp

?????文件???????1476??2003-11-27?17:28??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\addteacher.jsp

?????文件????????949??2003-12-01?17:46??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\admin.jsp

?????文件???????1098??2003-11-30?13:57??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\checkmark.jsp

?????文件???????1150??2003-12-01?17:21??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\choosestu.jsp

?????文件???????1743??2003-12-01?19:34??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\DisplayCourse.jsp

?????文件???????1563??2003-12-01?15:56??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\displaystu.jsp

?????文件????????781??2003-11-27?16:22??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\errorpage.jsp

?????文件???????1718??2003-12-01?19:21??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\getClass.jsp

?????文件???????1450??2003-11-29?17:41??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\getcourse.jsp

?????文件???????2121??2003-11-29?17:40??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\getStudent.jsp

?????文件???????1286??2003-11-29?17:40??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\getteacher.jsp

?????文件???????7406??2003-12-01?17:57??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\login.jsp

?????文件????????965??2003-12-01?18:12??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\marking.jsp

?????文件???????1126??2003-12-01?15:55??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\public.jsp

?????文件???????1548??2003-12-01?15:54??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\score.jsp

?????文件????????920??2003-12-01?17:45??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\student.jsp

?????文件????????650??2003-12-01?17:45??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\teacher.jsp

?????文件???????3446??2003-12-01?17:25??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\updateClass.jsp

?????文件???????2061??2003-12-01?22:15??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\updatecour.jsp

?????文件???????1464??2003-12-01?17:20??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\updateinformation.jsp

?????文件???????1941??2003-12-01?22:11??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\updatestu.jsp

?????文件???????1085??2003-11-20?18:19??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\updateStudent.jsp

?????文件???????1129??2003-11-20?21:10??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\updatestu_confirm.jsp

?????文件???????1331??2003-11-27?17:22??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\updatetea.jsp

?????文件???????3435??2003-12-01?19:31??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\WEB-INF\classes\checkEnrol.java

?????文件???????4118??2003-12-01?19:17??chengjiguanli\學(xué)生課績(jī)管理系統(tǒng)\WEB-INF\classes\classp.java

............此處省略26個(gè)文件信息