package?com.yangcun.dao;

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

import?com.yangcun.model.Course;
import?com.yangcun.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（）;
	}
	}

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

?????文件????????505??2014-12-19?11:02??CourseSys\.classpath

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

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

?????文件???????3079??2014-12-19?11:03??CourseSys\bin\com\yangcun\dao\CourseDao.class

?????文件???????2237??2014-12-19?11:03??CourseSys\bin\com\yangcun\dao\LogOnDao.class

?????文件???????2125??2014-12-19?11:03??CourseSys\bin\com\yangcun\dao\SelectionDao.class

?????文件???????2542??2014-12-19?11:03??CourseSys\bin\com\yangcun\dao\StudentDao.class

?????文件????????878??2014-12-19?11:03??CourseSys\bin\com\yangcun\model\Admin.class

?????文件???????2213??2014-12-19?11:03??CourseSys\bin\com\yangcun\model\Course.class

?????文件???????1011??2014-12-19?11:03??CourseSys\bin\com\yangcun\model\Selection.class

?????文件???????1523??2014-12-19?11:03??CourseSys\bin\com\yangcun\model\Sinfo.class

?????文件???????1004??2014-12-19?11:03??CourseSys\bin\com\yangcun\model\Student.class

?????文件???????1648??2014-12-19?11:05??CourseSys\bin\com\yangcun\util\DbUtil.class

?????文件???????1632??2014-12-19?11:28??CourseSys\bin\com\yangcun\util\PathUtil.class

?????文件????????631??2014-12-19?11:03??CourseSys\bin\com\yangcun\util\StringUtil.class

?????文件????????848??2014-12-19?11:32??CourseSys\bin\com\yangcun\view\CourseAddInterFrm$1.class

?????文件????????848??2014-12-19?11:32??CourseSys\bin\com\yangcun\view\CourseAddInterFrm$2.class

?????文件???????7230??2014-12-19?11:32??CourseSys\bin\com\yangcun\view\CourseAddInterFrm.class

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

?????文件????????869??2014-12-19?12:01??CourseSys\bin\com\yangcun\view\CourseManageInterFrm$1.class

?????文件????????950??2014-12-19?12:01??CourseSys\bin\com\yangcun\view\CourseManageInterFrm$2.class

?????文件????????837??2014-12-19?12:01??CourseSys\bin\com\yangcun\view\CourseManageInterFrm$3.class

?????文件????????869??2014-12-19?12:01??CourseSys\bin\com\yangcun\view\CourseManageInterFrm$4.class

?????文件????????869??2014-12-19?12:01??CourseSys\bin\com\yangcun\view\CourseManageInterFrm$5.class

?????文件??????13426??2014-12-19?12:01??CourseSys\bin\com\yangcun\view\CourseManageInterFrm.class

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

?????文件????????938??2014-12-19?11:03??CourseSys\bin\com\yangcun\view\CourseViewInterFrm$1.class

?????文件???????4485??2014-12-19?11:03??CourseSys\bin\com\yangcun\view\CourseViewInterFrm.class

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

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

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