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?

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

????.......???????475??2011-01-07?10:29??MSC\.classpath

????.......???????282??2011-01-07?10:29??MSC\.mymetadata

????.......??????1409??2011-01-07?10:29??MSC\.project

????.......???????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

????.......??????2028??2011-01-07?10:29??MSC\db.sql

????.......??????2864??2011-01-07?10:29??MSC\src\msc\dao\CourseDAO.java

????.......??????1929??2011-01-07?10:29??MSC\src\msc\dao\MassageDAO.java

????.......??????6751??2011-01-07?10:29??MSC\src\msc\dao\MscDAO.java

????.......??????9527??2011-01-07?10:29??MSC\src\msc\dao\ScDAO.java

????.......??????4491??2011-01-07?10:29??MSC\src\msc\dao\StudentDAO.java

????.......??????6383??2011-01-07?10:29??MSC\src\msc\dao\TcDAO.java

????.......??????3176??2011-01-07?10:29??MSC\src\msc\dao\TeacherDAO.java

????.......??????2741??2011-01-07?10:29??MSC\src\msc\dao\UserDAO.java

????.......??????1511??2011-01-07?10:29??MSC\src\msc\dbc\DatabaseConnection.java

????.......??????4393??2011-01-07?10:29??MSC\src\msc\slt\course_slt.java

????.......??????8927??2011-01-07?10:29??MSC\src\msc\slt\jxl_slt.java

????.......??????2896??2011-01-07?10:29??MSC\src\msc\slt\login_conf.java

????.......??????3601??2011-01-07?10:29??MSC\src\msc\slt\menu_slt.java

????.......??????6823??2011-01-07?10:29??MSC\src\msc\slt\msc_slt.java

????.......??????3903??2011-01-07?10:29??MSC\src\msc\slt\msg_slt.java

????.......??????6760??2011-01-07?10:29??MSC\src\msc\slt\sc_slt.java

????.......??????5447??2011-01-07?10:29??MSC\src\msc\slt\student_slt.java

????.......??????4390??2011-01-07?10:29??MSC\src\msc\slt\tc_slt.java

????.......??????5469??2011-01-07?10:29??MSC\src\msc\slt\teacher_slt.java

????.......???????546??2011-01-07?10:29??MSC\src\msc\util\EncodingFilter.java

????.......???????472??2011-01-07?10:29??MSC\src\msc\vo\Course.java

????.......???????726??2011-01-07?10:29??MSC\src\msc\vo\Massage.java

????.......??????1597??2011-01-07?10:29??MSC\src\msc\vo\Sc.java

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