courseservice.java

数据库系统教材中附录的课程设计accomodation宿舍管理系统源码

package cn.kmp.accommodation.service;

import com.littleQworks.commons.dao.ibatis.spring.CommonDaoGenericImpl;
import java.util.*;

import cn.kmp.accommodation.domain.*;
public class CourseService {
	private CommonDaoGenericImpl commonDao;

	public CommonDaoGenericImpl getCommonDao() {
		return commonDao;
	}

	public void setCommonDao(CommonDaoGenericImpl commonDao) {
		this.commonDao = commonDao;
	}
	//根据学生号，学年，学期获得课程
	public List<Course> getCourseByStudentNum(int studentNum,int schoolYear,String semester){
		HashMap<String,Object> hashmap=new HashMap<String,Object>();
		hashmap.put("studentNum", studentNum);
		hashmap.put("schoolYear", schoolYear);
		hashmap.put("semester", semester);
		return commonDao.getListByParameter(hashmap, "getCourseByStudentNum");	
	}
	//根据课程负责人号获得课程
	public List<Course> getCourseByCourseLeaderNum(int courseLeaderNum){
		return commonDao.getListByParameter(courseLeaderNum, "getCourseByCourseLeaderNum");
	}
	//添加课程
	public boolean insertCourse(Course course){
		return commonDao.insertByParameter(course, "insertCourse");
	}
	//删除课程根据课程号
	public boolean deleteCourseByCourseNum(int courseNum){
		return commonDao.deleteByParameter(courseNum, "deleteCourseByCourseNum");
	}
	//更新给定课程号的课程
	public boolean updateCourseByCourseNum(Course course){
		return commonDao.updateByParameter(course, "updateCourseByCourseNum");
	}
	//根据课程号获得课程
	public Course getCourseByCourseNum(int courseNum){
		return commonDao.getByParamter(courseNum, "getCourseByCourseNum");
	}
}