package?com.jakey.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

import?com.jakey.model.Course;
import?com.jakey.util.StringUtil;



public?class?CourseDao?{
	public?int?courseAdd（Connection?conCourse?course）throws?Exception{
		String?sql=“insert?into?t_course?value（null????0）“;
		PreparedStatement??pstmt=con.prepareStatement（sql）;
		pstmt.setString（1course.getCourseName（））;
		pstmt.setString（2?course.getCourseTime（））;
		pstmt.setString（3?course.getCourseTeacher（））;
		pstmt.setInt（4?course.getCapacity（））;
		return?pstmt.executeUpdate（）;

	}
	public?ResultSet?courseList（Connection?conCourse?course）?throws?SQLException{
		StringBuffer?sb=new?StringBuffer（“select?*?from?t_course“）;
		if（StringUtil.isNotEmpty（course.getCourseName（）））{
			sb.append（“?and?courseName?like?‘%“+course.getCourseName（）+“%‘“）;
		}
		if（StringUtil.isNotEmpty（course.getCourseTime（）））{
			sb.append（“?and?courseTime?like?‘%“+course.getCourseTime（）+“%‘“）;
		}
		if（StringUtil.isNotEmpty（course.getCourseTeacher（）））{
			sb.append（“?and?courseTeacher?like?‘%“+course.getCourseTeacher（）+“%‘“）;
		}
PreparedStatement?pstmt=con.prepareStatement（sb.toString（）.replaceFirst（“and“?“where“））;
return?pstmt.executeQuery（）;
		}
	public?int?courseDelete（Connection?conString?courseId）throws?Exception{
		String?sql=“delete?from?t_course?where?courseId=?“;
		PreparedStatement??pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?courseId）;
		return?pstmt.executeUpdate（）;

	}
	public?int?courseModify（Connection?conCourse?course）throws?Exception{
		String?sql=“update?t_course?set?courseName=?courseTime=?courseTeacher=?capacity=??where?courseId=??“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?course.getCourseName（））;
		pstmt.setString（2?course.getCourseTime（））;
		pstmt.setString（3?course.getCourseTeacher（））;
		pstmt.setInt（4course.getCapacity（）?）;
		pstmt.setInt（5?course.getCourseId（））;
		return?pstmt.executeUpdate（）;
		
	}
	public?ResultSet?UnderFullList（Connection?conCourse?course）?throws?SQLException{
		String?sql=“select?*?from?t_course?where?capacity>numSelected“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		return?pstmt.executeQuery（）;
	}
	}

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

?????文件????????729??2015-07-10?23:11??yc_java_11_mysql\.classpath

?????文件????????385??2013-08-19?16:18??yc_java_11_mysql\.project

?????文件????????629??2013-08-19?16:18??yc_java_11_mysql\.settings\org.eclipse.jdt.core.prefs

?????文件???????3065??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\dao\CourseDao.class

?????文件???????2217??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\dao\LogOnDao.class

?????文件???????2115??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\dao\SelectionDao.class

?????文件???????2522??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\dao\StudentDao.class

?????文件????????874??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\model\Admin.class

?????文件???????2209??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\model\Course.class

?????文件???????1007??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\model\Selection.class

?????文件???????1519??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\model\Sinfo.class

?????文件???????1000??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\model\Student.class

?????文件???????1642??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\util\DbUtil.class

?????文件????????627??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\util\StringUtil.class

?????文件????????836??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\view\CourseAddInterFrm$1.class

?????文件????????836??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\view\CourseAddInterFrm$2.class

?????文件???????7219??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\view\CourseAddInterFrm.class

?????文件???????7720??2013-08-26?17:27??yc_java_11_mysql\bin\com\jakey\view\CourseAddInterFrm.form

?????文件????????857??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\view\CourseManageInterFrm$1.class

?????文件????????940??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\view\CourseManageInterFrm$2.class

?????文件????????825??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\view\CourseManageInterFrm$3.class

?????文件????????857??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\view\CourseManageInterFrm$4.class

?????文件????????857??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\view\CourseManageInterFrm$5.class

?????文件??????14458??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\view\CourseManageInterFrm.class

?????文件??????18150??2013-09-03?18:52??yc_java_11_mysql\bin\com\jakey\view\CourseManageInterFrm.form

?????文件????????928??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\view\CourseViewInterFrm$1.class

?????文件???????4461??2015-07-30?16:45??yc_java_11_mysql\bin\com\jakey\view\CourseViewInterFrm.class

?????文件???????3382??2013-08-29?12:24??yc_java_11_mysql\bin\com\jakey\view\CourseViewInterFrm.form

?????文件????????805??2013-05-09?11:17??yc_java_11_mysql\bin\com\jakey\view\image\add.png

?????文件????????678??2013-08-25?13:19??yc_java_11_mysql\bin\com\jakey\view\image\admin.png

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