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（）;
			
		}
	}


}

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

?????文件????????475??2011-11-16?21:01??MSC\.classpath

?????文件????????282??2011-11-17?10:39??MSC\.mymetadata

?????文件???????1409??2011-11-16?21:54??MSC\.project

?????文件????????500??2011-11-16?21:01??MSC\.settings\.jsdtscope

?????文件?????????49??2011-11-16?21:01??MSC\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-11-16?21:01??MSC\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2028??2011-11-16?21:01??MSC\db.sql

?????文件???????2864??2011-11-16?21:01??MSC\src\msc\dao\CourseDAO.java

?????文件???????1929??2011-11-16?21:01??MSC\src\msc\dao\MassageDAO.java

?????文件???????6751??2011-11-16?21:01??MSC\src\msc\dao\MscDAO.java

?????文件???????9527??2011-11-16?21:01??MSC\src\msc\dao\ScDAO.java

?????文件???????4491??2011-11-16?21:01??MSC\src\msc\dao\StudentDAO.java

?????文件???????6383??2011-11-16?21:01??MSC\src\msc\dao\TcDAO.java

?????文件???????3176??2011-11-16?21:01??MSC\src\msc\dao\TeacherDAO.java

?????文件???????2741??2011-11-16?21:01??MSC\src\msc\dao\UserDAO.java

?????文件???????1509??2011-11-16?21:32??MSC\src\msc\dbc\DatabaseConnection.java

?????文件???????4393??2011-11-16?21:01??MSC\src\msc\slt\course_slt.java

?????文件???????8927??2011-11-16?21:01??MSC\src\msc\slt\jxl_slt.java

?????文件???????2896??2011-11-16?21:00??MSC\src\msc\slt\login_conf.java

?????文件???????3601??2011-11-16?21:01??MSC\src\msc\slt\menu_slt.java

?????文件???????6823??2011-11-16?21:01??MSC\src\msc\slt\msc_slt.java

?????文件???????3903??2011-11-16?21:01??MSC\src\msc\slt\msg_slt.java

?????文件???????6760??2011-11-16?21:01??MSC\src\msc\slt\sc_slt.java

?????文件???????5447??2011-11-16?21:01??MSC\src\msc\slt\student_slt.java

?????文件???????4390??2011-11-16?21:01??MSC\src\msc\slt\tc_slt.java

?????文件???????5469??2011-11-16?21:01??MSC\src\msc\slt\teacher_slt.java

?????文件????????546??2011-11-16?21:01??MSC\src\msc\util\EncodingFilter.java

?????文件????????472??2011-11-16?21:01??MSC\src\msc\vo\Course.java

?????文件????????726??2011-11-16?21:01??MSC\src\msc\vo\Massage.java

?????文件???????1597??2011-11-16?21:01??MSC\src\msc\vo\Sc.java

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