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（“插入中出現錯誤！！！“）;
		}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（“刪除中出現錯誤！！！“）;
		}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（“查詢中出現錯誤！！！“）;
		}?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（“修改中出現錯誤！！！“）;
		}finally?{
			dbc.close（）;
			
		}
	}


}

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

?????文件????????642??2011-05-30?20:14??MSC\MSC\.classpath

?????文件????????282??2011-05-30?20:13??MSC\MSC\.mymetadata

?????文件???????1746??2011-05-30?20:14??MSC\MSC\.project

?????文件???????2587??2010-01-28?10:28??MSC\MSC\WebRoot\admin_cou.jsp

?????文件???????3388??2010-01-28?10:28??MSC\MSC\WebRoot\admin_cou_add.jsp

?????文件???????1286??2010-01-28?10:28??MSC\MSC\WebRoot\admin_cou_del.jsp

?????文件???????1265??2010-01-28?10:28??MSC\MSC\WebRoot\admin_cou_sel.jsp

?????文件???????1785??2010-01-28?10:34??MSC\MSC\WebRoot\admin_cou_selrs.jsp

?????文件???????1058??2010-01-28?10:28??MSC\MSC\WebRoot\admin_cou_set.jsp

?????文件???????1204??2010-01-28?10:28??MSC\MSC\WebRoot\admin_cou_upd.jsp

?????文件???????2547??2010-01-28?10:28??MSC\MSC\WebRoot\admin_cou_updrs.jsp

?????文件???????1520??2010-01-28?10:28??MSC\MSC\WebRoot\admin_frame.jsp

?????文件???????3556??2010-01-28?10:28??MSC\MSC\WebRoot\admin_main.jsp

?????文件???????2330??2010-01-28?10:28??MSC\MSC\WebRoot\admin_menu.jsp

?????文件???????2320??2010-01-28?10:28??MSC\MSC\WebRoot\admin_msc.jsp

?????文件???????2950??2010-01-28?10:28??MSC\MSC\WebRoot\admin_navi.jsp

?????文件???????2338??2010-01-28?10:28??MSC\MSC\WebRoot\admin_stu.jsp

?????文件???????3772??2010-01-28?10:28??MSC\MSC\WebRoot\admin_stu_add.jsp

?????文件???????1282??2010-01-28?10:28??MSC\MSC\WebRoot\admin_stu_del.jsp

?????文件???????1275??2010-04-13?22:28??MSC\MSC\WebRoot\admin_stu_sel.jsp

?????文件???????2329??2010-01-28?10:28??MSC\MSC\WebRoot\admin_stu_selrs.jsp

?????文件???????1230??2010-01-28?10:28??MSC\MSC\WebRoot\admin_stu_upd.jsp

?????文件???????3261??2010-01-28?10:28??MSC\MSC\WebRoot\admin_stu_updrs.jsp

?????文件???????2338??2010-01-28?10:28??MSC\MSC\WebRoot\admin_tea.jsp

?????文件???????3015??2010-01-28?10:28??MSC\MSC\WebRoot\admin_tea_add.jsp

?????文件???????1285??2010-01-28?10:28??MSC\MSC\WebRoot\admin_tea_del.jsp

?????文件???????1283??2010-01-28?10:28??MSC\MSC\WebRoot\admin_tea_sel.jsp

?????文件???????1648??2010-01-28?10:28??MSC\MSC\WebRoot\admin_tea_selrs.jsp

?????文件???????1269??2010-01-28?10:28??MSC\MSC\WebRoot\admin_tea_upd.jsp

?????文件???????2552??2010-01-28?10:28??MSC\MSC\WebRoot\admin_tea_updrs.jsp

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