package?com.guo.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

import?com.guo.model.CheckMod;
import?com.guo.model.Course;
import?com.guo.model.User;
import?com.guo.model.UserCourse;
import?com.guo.util.CkUtil;
import?com.guo.util.DbUtil;

public?class?CheckDao?{
	public?ResultSet?returnUSer（String?strUser?userCourse?courseConnection?con）?throws?Exception{
		StringBuffer?sql=new?StringBuffer（“SELECT?exchange?FROM?user_course?a??course?eUSER?f?WHERE?a.‘courseId‘?IN（SELECT?b.‘courseId‘FROM??user_course?b?WHERE?b.‘userId‘=?）?AND?a.‘userId‘?IN（SELECT?user.‘userId‘FROM?USER?WHERE?user.‘type‘=3）AND?a.‘userId‘=f.‘userId‘AND?a.‘courseId‘=e.‘courseId‘“）;
		PreparedStatement?pst=null;
			if（“check“

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-10-21?15:20??學生簽到系統源碼\
?????文件????????4415??2013-10-21?15:08??學生簽到系統源碼\簽到數據庫.sql
?????目錄???????????0??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\
?????目錄???????????0??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\
?????文件????????1192??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\.classpath
?????目錄???????????0??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\.myeclipse\
?????目錄???????????0??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\.myeclipse\profiler\
?????文件?????????392??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\.project
?????目錄???????????0??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\.settings\
?????文件?????????629??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\
?????目錄???????????0??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\
?????目錄???????????0??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\
?????目錄???????????0??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\dao\
?????文件????????2899??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\dao\CheckDao.class
?????文件????????2730??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\dao\CourseDao.class
?????文件????????2788??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\dao\UserCourseDao.class
?????文件????????5129??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\dao\UserDao.class
?????目錄???????????0??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\model\
?????文件????????1997??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\model\CheckMod.class
?????文件????????1385??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\model\Course.class
?????文件????????2457??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\model\User.class
?????文件????????1130??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\model\UserCourse.class
?????目錄???????????0??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\util\
?????文件????????1721??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\util\CkUtil.class
?????文件????????1665??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\util\DbUtil.class
?????文件????????2108??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\util\ExcelConnection.class
?????文件????????3424??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\util\ReadExcel.class
?????目錄???????????0??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\view\
?????文件????????1318??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\view\AddConOfSt.class
?????文件????????1517??2013-10-21?15:19??學生簽到系統源碼\簽到源碼\StudentAddentace\bin\com\guo\view\CalendarPanel$chooseDay.class
............此處省略109個文件信息