package?dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.Statement;
import?java.util.ArrayList;

import?vo.Course;
/**?
?*?文件名:???????CourseDao.java?
?*?描????述：????對數據庫中關于課程的信息進行處理
?*/?
public?class?CourseDao?{
	private?Connection?conn?=?null;
	
	public?void?initConnection（）?throws?Exception{
		Class.forName（“oracle.jdbc.driver.OracleDriver“）;
		conn?=?DriverManager.getConnection（“jdbc:oracle:thin:@localhost:1521:XE““scott““tiger“）;
	}
	/**?
	?*?FunName:???????????getAllCoursename?
	?*?Description?:??????獲取所有的課程名稱
	?*/
	public?ArrayList?getAllCoursename（）?throws?Exception{//獲得所有課程名稱
		ArrayList?al?=?new?ArrayList（）;
		this.initConnection（）;
		String?sql?=?“select?distinct（coursename）?from?t_course“;
		Statement?stat?=?conn.createStatement（）;
		ResultSet?rs?=?stat.executeQuery（sql）;
		while（rs.next（））{
			al.add（rs.getString（“coursename“）.trim（））;
		}
		this.closeConnection（）;
		return?al;
	}
	/**?
	?*?FunName:???????????getAllCourse?
	?*?Description?:??????獲取所有的課程
	?*/
	public?ArrayList?getAllCourse（）?throws?Exception{//獲得所有課程
		ArrayList?al?=?new?ArrayList（）;
		this.initConnection（）;
		String?sql?=?“select?*?from?t_course?A?join?t_teacher?B?on?A.teano?=?B.teano“;
		Statement?stat?=?conn.createStatement（）;
		ResultSet?rs?=?stat.executeQuery（sql）;
		while（rs.next（））{
			Course?cou?=?new?Course（）;
			cou.setCourseno（rs.getString（“courseno“）.trim（））;
			cou.setCoursename（rs.getString（“coursename“）.trim（））;
			cou.setCredit（rs.getFloat（“credit“））;
			cou.setTeano（rs.getString（“teano“）.trim（））;
			cou.setTeaname（rs.getString（“teaname“）.trim（））;
			al.add（cou）;
		}
		this.closeConnection（）;
		return?al;
	}
	/**?
	?*?FunName:???????????getCourseByCourseno?
	?*?Description?:??????根據課程號獲取對應的課程信息
	?*/
	public?Course?getCourseByCourseno（String?courseno）?throws?Exception{//根據課程號獲取課程信息
		this.initConnection（）;
		Course?cou?=?null;
		String?sql?=?“select?*?from?t_course?A?join?t_teacher?B?on?A.teano?=?B.teano?where?A.courseno=‘“+courseno+“‘“;
		Statement?stat?=?conn.createStatement（）;
		ResultSet?rs?=?stat.executeQuery（sql）;
		if（rs.next（））{
			cou?=?new?Course（）;
			cou.setCourseno（courseno）;
			cou.setCoursename（rs.getString（“coursename“）.trim（））;
			cou.setCredit（rs.getFloat（“credit“））;
			cou.setTeano（rs.getString（“teano“）.trim（））;
			cou.setTeaname（rs.getString（“teaname“）.trim（））;
		}
		this.closeConnection（）;
		return?cou;
	}
	/**?
	?*?FunName:???????????getCourseByTeano?
	?*?Description?:??????根據職工號獲取對應教師開設的所有課程信息
	?*/
	public?ArrayList?getCourseByTeano（String?teano）?throws?Exception{//獲得相應職工號的開課情況
		ArrayList?al?=?new?ArrayList（）;
		this.initConnection（）;
		String?sql?=?“select?*?from?t_course?A?join?t_teacher?B?on?A.teano?=?B.teano?where?B.teano=‘“+teano+“‘“;;
		Statement?stat?=?conn.createStatement（）;
		ResultSet?rs?=?stat.executeQuery（sql）;
		while（rs.next（））{
			Course?cou?=?new?Course（）;
			cou.set

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

?????文件????????851??2010-10-31?13:11??EduSystem\.classpath

?????文件????????300??2010-11-06?18:21??EduSystem\.mymetadata

?????文件???????1227??2010-08-08?10:12??EduSystem\.project

?????文件???????4465??2019-10-27?17:56??EduSystem\src\dao\CourseDao.java

?????文件???????5287??2019-10-27?17:57??EduSystem\src\dao\ScoreDao.java

?????文件???????1991??2019-10-27?17:57??EduSystem\src\dao\StudentDao.java

?????文件???????1983??2019-10-27?17:57??EduSystem\src\dao\TeacherDao.java

?????文件???????1118??2019-10-27?17:58??EduSystem\src\filter\EncodingFilter.java

?????文件???????1526??2019-10-27?17:58??EduSystem\src\filter\SessionCheckFilter.java

?????文件???????2969??2019-10-27?18:00??EduSystem\src\servlet\LoginServlet.java

?????文件????????996??2019-10-27?18:00??EduSystem\src\servlet\LogoutServlet.java

?????文件???????2602??2019-10-27?18:00??EduSystem\src\servlet\ModifyPwdServlet.java

?????文件???????2597??2019-10-27?18:00??EduSystem\src\servlet\Stu_ExportScoreServlet.java

?????文件???????1513??2019-10-27?18:00??EduSystem\src\servlet\Stu_QueryCourseServlet.java

?????文件???????1448??2019-10-27?18:01??EduSystem\src\servlet\Stu_QueryScoreServlet.java

?????文件???????3367??2019-10-27?18:01??EduSystem\src\servlet\Stu_SelectCourseServlet.java

?????文件???????1464??2019-10-27?18:01??EduSystem\src\servlet\Tea_EntryScore1Servlet.java

?????文件???????2885??2019-10-27?18:02??EduSystem\src\servlet\Tea_EntryScore2Servlet.java

?????文件???????2535??2019-10-27?18:02??EduSystem\src\servlet\Tea_ExportScoreServlet.java

?????文件???????1371??2019-10-27?18:02??EduSystem\src\servlet\Tea_QueryCourse1Servlet.java

?????文件???????1458??2019-10-27?18:02??EduSystem\src\servlet\Tea_QueryCourse2Servlet.java

?????文件???????1408??2019-10-27?18:03??EduSystem\src\servlet\Tea_QueryScore1Servlet.java

?????文件???????2610??2019-10-27?18:03??EduSystem\src\servlet\Tea_QueryScore2Servlet.java

?????文件????????924??2019-10-27?17:59??EduSystem\src\vo\Course.java

?????文件???????1273??2019-10-27?17:59??EduSystem\src\vo\Score.java

?????文件????????768??2019-10-27?17:59??EduSystem\src\vo\ScoreSection.java

?????文件????????716??2019-10-27?17:59??EduSystem\src\vo\Student.java

?????文件????????864??2019-10-27?17:59??EduSystem\src\vo\Teacher.java

?????文件???????2317??2010-10-27?18:38??EduSystem\WebRoot\index.jsp

?????文件???????1178??2010-10-25?23:03??EduSystem\WebRoot\jsp\modifyPwd.jsp

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