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）{???//該學生是否已經注冊該課程
??	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?

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

?????文件???????3274??2003-12-01?17:27??test\AddClass.jsp

?????文件???????2238??2003-11-27?18:57??test\Addcourse.jsp

?????文件???????2019??2003-12-01?17:22??test\addstudent.jsp

?????文件???????1476??2003-11-27?17:28??test\addteacher.jsp

?????文件????????949??2003-12-01?17:46??test\admin.jsp

?????文件???????1098??2003-11-30?13:57??test\checkmark.jsp

?????文件???????1150??2003-12-01?17:21??test\choosestu.jsp

?????文件???????1743??2003-12-01?19:34??test\DisplayCourse.jsp

?????文件???????1563??2003-12-01?15:56??test\displaystu.jsp

?????文件????????781??2003-11-27?16:22??test\errorpage.jsp

?????文件???????1718??2003-12-01?19:21??test\getClass.jsp

?????文件???????1450??2003-11-29?17:41??test\getcourse.jsp

?????文件???????2121??2003-11-29?17:40??test\getStudent.jsp

?????文件???????1286??2003-11-29?17:40??test\getteacher.jsp

?????文件???????7406??2003-12-01?17:57??test\login.jsp

?????文件????????340??2008-12-23?15:26??test\management\.classpath

?????目錄??????????0??2008-12-23?15:26??test\management\.myeclipse

?????文件????????303??2008-12-31?09:36??test\management\.mymetadata

?????文件???????1228??2008-12-23?15:28??test\management\.project

?????文件??????68345??2008-12-30?11:06??test\management\031.jpg

?????文件??????64144??2008-12-30?11:21??test\management\2312.jpg

?????目錄??????????0??2008-12-23?15:26??test\management\src

?????文件???????4238??2008-12-30?08:23??test\management\WebRoot\addbj.jsp

?????文件???????2714??2008-12-27?16:57??test\management\WebRoot\addbwxx.jsp

?????文件????????823??2008-12-29?08:42??test\management\WebRoot\adddepart.jsp

?????文件???????2256??2008-12-30?22:57??test\management\WebRoot\adddepart1.jsp

?????文件???????2922??2008-12-27?16:24??test\management\WebRoot\addffxx.jsp

?????文件???????2351??2008-12-27?15:08??test\management\WebRoot\addsb.jsp

?????文件????????611??2008-12-29?11:18??test\management\WebRoot\addsbfl.jsp

?????文件???????1757??2008-12-29?11:06??test\management\WebRoot\addsbfl1.jsp

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