package?plib;
import?java.sql.*;
public?class?checkEnrol
{	
???????????????????????????????????????????????????????????????
	public?boolean?hasLogin（String?stu_idString?cour_id）{???//查詢(xún)?cè)搶W(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）????//學(xué)生選課時(shí)查詢(xún)課程數(shù)據(jù)
????{?
?????
????String?sql=“?select?DISTINCT?course.idcourse.namecourse.markcourse.preparecourse.de

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

?????文件?????125053??2007-06-10?10:25??張藝騫?（源代碼及數(shù)據(jù)庫(kù)文件）\CJGLXT.rar

?????文件?????182460??2007-06-15?10:13??張藝騫?（源代碼及數(shù)據(jù)庫(kù)文件）\date.rar

?????目錄??????????0??2007-06-26?21:26??張藝騫?（源代碼及數(shù)據(jù)庫(kù)文件）

-----------?---------??----------?-----??----

???????????????307513????????????????????3