takecourseservice.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 TakeCourseService {
	private CommonDaoGenericImpl commonDao;

	public CommonDaoGenericImpl getCommonDao() {
		return commonDao;
	}

	public void setCommonDao(CommonDaoGenericImpl commonDao) {
		this.commonDao = commonDao;
	}
	
	public List<Student> getStudentsByCourseNum(int courseNum){
		return commonDao.getListByParameter(courseNum, "getStudentsByCourseNum");
	}
	
	public List<Course> getCoursesByStudentNum(int studentNum){
		return commonDao.getListByParameter(studentNum, "getCoursesByStudentNum");
	}
	public List<TakeCourse> getTakeCourseByStudentNum(int studentNum){
		return commonDao.getListByParameter(studentNum, "getTakeCourseByStudentNum");
	}
	public boolean insertTakeCourse(TakeCourse tc){
		return commonDao.insertByParameter(tc, "insertTakeCourse");
	}
	public boolean deleteTakeCourseByKey(int studentNum,int courseNum,String semester,int schoolYear){
		HashMap<String,Object> hashmap=new HashMap<String,Object>();
		hashmap.put("studentNum", studentNum);
		hashmap.put("courseNum", courseNum);
		hashmap.put("semester", semester);
		hashmap.put("schoolYear", schoolYear);
		return commonDao.deleteByParameter(hashmap, "deleteTakeCourseByKey");
	}
	public boolean updateTakeCourseByStudentNum(TakeCourse takeCourse){
		return commonDao.updateByParameter(takeCourse, "updateTakeCourseByStudentNum");
	}
}