package?com.course;
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;
??	???????????????????????}
??	???????????????????????
??	//根據學生ID獲取其選擇的課程信息??????
???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;
???}?
??	???????????????????????????????????????????????
??	??????????????????????????
??//根據學生的ID，獲得其全部的學分	???????????????????????????????????????????
??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;
?	?	
?	?	}
?	?	
?	?//選課成功		???

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-07-14?22:15??CourseManagement\
?????文件?????????362??2011-06-23?11:44??CourseManagement\.classpath
?????目錄???????????0??2011-07-10?20:46??CourseManagement\.myeclipse\
?????目錄???????????0??2011-07-10?20:46??CourseManagement\.myeclipse\profiler\
?????文件?????????784??2011-07-07?12:08??CourseManagement\.myeclipse\profiler\CourseManagement?on?Tomcat??6.x.xml
?????文件?????????321??2011-07-10?19:49??CourseManagement\.mymetadata
?????文件????????1422??2011-07-06?16:08??CourseManagement\.project
?????目錄???????????0??2011-07-10?20:46??CourseManagement\.settings\
?????文件?????????500??2011-07-10?20:26??CourseManagement\.settings\.jsdtscope
?????文件?????????330??2011-07-10?20:26??CourseManagement\.settings\org.eclipse.jdt.core.prefs
?????文件?????????137??2011-07-09?10:37??CourseManagement\.settings\org.eclipse.ltk.core.refactoring.prefs
?????文件??????????49??2011-07-10?20:26??CourseManagement\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2011-07-10?20:26??CourseManagement\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件????????9296??2011-07-14?22:14??CourseManagement\classdb.sql
?????目錄???????????0??2011-07-10?20:33??CourseManagement\src\
?????目錄???????????0??2011-07-10?20:33??CourseManagement\src\com\
?????目錄???????????0??2011-07-10?20:33??CourseManagement\src\com\course\
?????文件????????3464??2011-07-11?11:09??CourseManagement\src\com\course\checkEnrol.java
?????文件????????4315??2007-09-24?23:36??CourseManagement\src\com\course\classp.java
?????文件????????6018??2007-09-24?23:46??CourseManagement\src\com\course\ClassSvlt.java
?????文件????????3223??2007-09-25?21:26??CourseManagement\src\com\course\course.java
?????文件????????6113??2011-07-12?21:02??CourseManagement\src\com\course\CourseSvlt.java
?????文件????????2689??2011-07-11?10:15??CourseManagement\src\com\course\determine.java
?????文件?????????787??2011-07-09?22:52??CourseManagement\src\com\course\getName.java
?????文件????????3365??2011-07-12?21:49??CourseManagement\src\com\course\login_confirm.java
?????文件????????4379??2011-07-11?12:24??CourseManagement\src\com\course\MarkSvlt.java
?????文件????????2525??2011-07-12?21:49??CourseManagement\src\com\course\sqlBean.java
?????文件????????2990??2007-09-25?21:41??CourseManagement\src\com\course\student.java
?????文件????????4600??2011-07-12?21:49??CourseManagement\src\com\course\StudentLoginSvlt.java
?????文件????????5638??2007-09-25?22:02??CourseManagement\src\com\course\StudentSvlt.java
?????文件????????2348??2007-09-25?22:20??CourseManagement\src\com\course\teacher.java
............此處省略57個文件信息