import?java.sql.*;
public?class?checkEnrol{
	
	public?boolean?hasPassPrepare（String?prepare）{???//是否完成預修課
	??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）{???//該學生是否已經(jīng)注冊該課程
??	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?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????1264128??2003-12-01?22:49??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\backup_ClassDB.BAK

?????文件???????3274??2003-12-01?17:27??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\AddClass.jsp

?????文件???????2238??2003-11-27?18:57??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\Addcourse.jsp

?????文件???????2019??2003-12-01?17:22??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\addstudent.jsp

?????文件???????1476??2003-11-27?17:28??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\addteacher.jsp

?????文件????????949??2003-12-01?17:46??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\admin.jsp

?????文件???????1098??2003-11-30?13:57??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\checkmark.jsp

?????文件???????1150??2003-12-01?17:21??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\choosestu.jsp

?????文件???????1743??2003-12-01?19:34??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\DisplayCourse.jsp

?????文件???????1563??2003-12-01?15:56??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\displaystu.jsp

?????文件????????781??2003-11-27?16:22??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\errorpage.jsp

?????文件???????1718??2003-12-01?19:21??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\getClass.jsp

?????文件???????1450??2003-11-29?17:41??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\getcourse.jsp

?????文件???????2121??2003-11-29?17:40??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\getStudent.jsp

?????文件???????1286??2003-11-29?17:40??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\getteacher.jsp

?????文件???????7406??2003-12-01?17:57??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\login.jsp

?????文件????????965??2003-12-01?18:12??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\marking.jsp

?????文件???????1126??2003-12-01?15:55??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\public.jsp

?????文件???????1548??2003-12-01?15:54??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\score.jsp

?????文件????????920??2003-12-01?17:45??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\student.jsp

?????文件????????650??2003-12-01?17:45??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\teacher.jsp

?????文件???????3446??2003-12-01?17:25??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\updateClass.jsp

?????文件???????2061??2003-12-01?22:15??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\updatecour.jsp

?????文件???????1464??2003-12-01?17:20??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\updateinformation.jsp

?????文件???????1941??2003-12-01?22:11??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\updatestu.jsp

?????文件???????1085??2003-11-20?18:19??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\updateStudent.jsp

?????文件???????1129??2003-11-20?21:10??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\updatestu_confirm.jsp

?????文件???????1331??2003-11-27?17:22??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\updatetea.jsp

?????文件???????3435??2003-12-01?19:31??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\WEB-INF\classes\checkEnrol.java

?????文件???????4118??2003-12-01?19:17??scm\學生課績管理系統(tǒng)jsp+servlet+javaBean+sql_server\test（jsp+servlet+javaBean+sql_server）\WEB-INF\classes\classp.java

............此處省略27個文件信息