91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

資源簡介

資源截圖

代碼片段和文件信息 

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?
?*?CopyRright（c）??2010-08?
?*?創?建?人：???????王昭陽
?*?日????期：????2010-08-08?
?*?描????述：????對數據庫中關于課程的信息進行處理
?*?版?本?號：????????V1.0
?*/?
public?class?CourseDao?{
	private?Connection?conn?=?null;
	/**?
	?*?FunName:???????????initConnection?
	?*?Description?:??????實現數據庫的初始化連接
	?*?@param：			??無
	?*?@return：			??無
	?*?@Author:???????????王昭陽
	?*?@Create?Date:??????2010-08-08
	?*/
	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?:??????獲取所有的課程名稱
	?*?@param：			??無
	?*?@return：			??ArrayList
	?*?@Author:???????????王昭陽
	?*?@Create?Date:??????2010-08-08
	?*/
	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?:??????獲取所有的課程
	?*?@param：			??無
	?*?@return：			??ArrayList
	?*?@Author:???????????王昭陽
	?*?@Create?Date:??????2010-08-08
	?*/
	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?:??????根據課程號獲取對應的課程信息
	?*?@param：			??String?courseno
	?*?@return：			??ArrayList
	?*?@Author:???????????王昭陽
	?*?@Create?Date:??????2010-08-08
	?*/
	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.g

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2010-11-06?18:20??EduSystem\
?????文件?????????851??2010-10-31?13:11??EduSystem\.classpath
?????目錄???????????0??2018-11-03?15:03??EduSystem\.myeclipse\
?????文件?????????300??2010-11-06?18:21??EduSystem\.mymetadata
?????文件????????1227??2010-08-08?10:12??EduSystem\.project
?????目錄???????????0??2010-11-06?14:24??EduSystem\WebRoot\
?????目錄???????????0??2010-11-06?14:24??EduSystem\WebRoot\meta-INF\
?????文件??????????39??2007-11-03?14:32??EduSystem\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2010-11-06?14:24??EduSystem\WebRoot\WEB-INF\
?????目錄???????????0??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\
?????目錄???????????0??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\dao\
?????文件????????4053??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\dao\CourseDao.class
?????文件????????5218??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\dao\ScoreDao.class
?????文件????????2606??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\dao\StudentDao.class
?????文件????????2658??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\dao\TeacherDao.class
?????目錄???????????0??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\filter\
?????文件????????1340??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\filter\EncodingFilter.class
?????文件????????1673??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\filter\SessionCheckFilter.class
?????目錄???????????0??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\
?????文件????????2824??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\LoginServlet.class
?????文件????????1075??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\LogoutServlet.class
?????文件????????2757??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\ModifyPwdServlet.class
?????文件????????3906??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\Stu_ExportScoreServlet.class
?????文件????????1895??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\Stu_QueryCourseServlet.class
?????文件????????1829??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\Stu_QueryScoreServlet.class
?????文件????????3317??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\Stu_SelectCourseServlet.class
?????文件????????1812??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\Tea_EntryScore1Servlet.class
?????文件????????2902??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\Tea_EntryScore2Servlet.class
?????文件????????3724??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\Tea_ExportScoreServlet.class
?????文件????????1749??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\Tea_QueryCourse1Servlet.class
?????文件????????1777??2010-11-06?18:21??EduSystem\WebRoot\WEB-INF\classes\servlet\Tea_QueryCourse2Servlet.class
............此處省略77個文件信息

評論

共有 條評論