package?msc.dao;

import?java.sql.ResultSet;
import?java.sql.Statement;
import?java.util.Vector;

import?msc.dbc.DatabaseConnection;
import?msc.vo.Course;

public?class?CourseDAO?{
	public?void?InsertCourse（String?cnoString?cnamedouble?credit）?throws?Exception{
		String?sql=“INSERT?INTO?course（cnocnamecredit）?VALUES（‘“+cno+“‘‘“+cname+“‘“+credit+“）;“;
		Statement?stmt=null;
		DatabaseConnection?dbc=null;
		dbc=new?DatabaseConnection（）;
	?
		try{
			stmt=dbc.getConnection（）.createStatement（）;
			stmt.executeUpdate（sql）;
			stmt.close（）;
		}catch?（Exception?e）{
			throw?new?Exception（“插入中出現(xiàn)錯誤！！！“）;
		}finally?{
			dbc.close（）;
			
		}
	}
	public?void?DeletebyID（String?cno）?throws?Exception{
		String?sql=“DELETE?FROM?course?WHERE?cno=‘“+cno+“‘;“;
		Statement?stmt=null;
		DatabaseConnection?dbc=null;
		dbc=new?DatabaseConnection（）;
		try{
			stmt=dbc.getConnection（）.createStatement（）;
			stmt.executeUpdate（sql）;
			stmt.close（）;
		}catch?（Exception?e）{
			throw?new?Exception（“刪除中出現(xiàn)錯誤！！！“）;
		}finally?{
			dbc.close（）;
			
		}
	}
	public?Vector?Select（String?cnoString?cnamedouble?credit）throws?Exception{
		Vector?all=new?Vector（）;
		String?sql1=“SELECT?*?FROM?course?WHERE?“;
		String?sql=null;
		if（cno!=““）
		{
			sql=sql1+“cno?LIKE?‘%“+cno+“%‘“;
			if（cname!=““）
			{
				sql=sql+“and?cname?LIKE?‘%“+cname+“%‘“;
			}
			if（credit!=0）
			{
				sql=sql+“credit=‘“+credit+“‘“;
			}
		}else
		{
			if（cname!=““）
			{
				sql=sql1+“cname?LIKE?‘%“+cname+“%‘“;
				if（credit!=0）
				{
					sql=sql+“and?credit=‘“+credit+“‘“;
				}
			}else
			{
				if（credit!=0）
				{
					sql=sql1+“credit=‘“+credit+“‘“;
				}else
				{
					sql=“SELECT?*?FROM?course“;
				}
				
			}
		}
		sql=sql+“;“;
		Statement?stmt=null;
		DatabaseConnection?dbc=null;
		dbc=new?DatabaseConnection（）;
		try{
			stmt?=?dbc.getConnection（）.createStatement（）;
			ResultSet?rs?=?stmt.executeQuery（sql）;
			while（rs.next（））?{
				Course?cou=new?Course（）;
				cou.setCno（rs.getString（“cno“））;
				cou.setCname（rs.getString（“cname“））;
				cou.setCredit（rs.getDouble（“credit“））;
				all.addElement（cou）;
			}
			rs.close（）;
			stmt.close（）;
		}?catch?（Exception?e）?{
			throw?new?Exception（“查詢中出現(xiàn)錯誤！！！“）;
		}?finally?{
			dbc.close（）;
		}
		return?all;
	}
	public?void?UpdatebyID（String?cnoString?cnamedouble?credit）?throws?Exception{
		String?sql=“UPDATE?course?set?cname=‘“+cname+“‘credit=“+credit+“??WHERE?cno=‘“+cno+“‘;“;
		Statement?stmt=null;
		DatabaseConnection?dbc=null;
		dbc=new?DatabaseConnection（）;
		try{
			stmt=dbc.getConnection（）.createStatement（）;
			stmt.executeUpdate（sql）;
			stmt.close（）;
		}catch?（Exception?e）{
			throw?new?Exception（“修改中出現(xiàn)錯誤！！！“）;
		}finally?{
			dbc.close（）;
			
		}
	}


}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-09-28?08:36??MSC\
?????文件?????????475??2011-01-07?10:29??MSC\.classpath
?????文件?????????282??2011-01-07?10:29??MSC\.mymetadata
?????文件????????1409??2011-01-07?10:29??MSC\.project
?????目錄???????????0??2017-09-28?08:36??MSC\.settings\
?????文件?????????500??2011-01-07?10:29??MSC\.settings\.jsdtscope
?????文件??????????49??2011-01-07?10:29??MSC\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2011-01-07?10:29??MSC\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-09-28?08:36??MSC\WebRoot\
?????目錄???????????0??2011-03-18?16:15??MSC\WebRoot\meta-INF\
?????文件??????????36??2011-01-07?10:29??MSC\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2017-09-28?08:36??MSC\WebRoot\WEB-INF\
?????目錄???????????0??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\
?????目錄???????????0??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\
?????目錄???????????0??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\dao\
?????文件????????4112??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\dao\CourseDAO.class
?????文件????????3270??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\dao\MassageDAO.class
?????文件????????7467??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\dao\MscDAO.class
?????文件???????10883??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\dao\ScDAO.class
?????文件????????5765??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\dao\StudentDAO.class
?????文件????????7813??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\dao\TcDAO.class
?????文件????????4339??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\dao\TeacherDAO.class
?????文件????????3964??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\dao\UserDAO.class
?????目錄???????????0??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\dbc\
?????文件????????1609??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\dbc\DatabaseConnection.class
?????目錄???????????0??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\slt\
?????文件????????2170??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\slt\course_slt.class
?????文件????????2476??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\slt\jxl_slt.class
?????文件????????1564??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\slt\login_conf.class
?????文件????????2664??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\slt\menu_slt.class
?????文件????????2821??2017-10-04?16:06??MSC\WebRoot\WEB-INF\classes\msc\slt\msc_slt.class
............此處省略159個文件信息