advisorservice.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 AdvisorService {
	private CommonDaoGenericImpl commonDao;

	public CommonDaoGenericImpl getCommonDao() {
		return commonDao;
	}

	public void setCommonDao(CommonDaoGenericImpl commonDao) {
		this.commonDao = commonDao;
	}
	//获得所有的advisor
	public List<Advisor> getAllAdvisor(){
		return commonDao.getList("getAllAdvisor");
	}
	//根据adviosrNum获得advisor
	public Advisor getAdvisorByAdvisorNum(int advisorNum){
		return commonDao.getByParamter(advisorNum, "getAdvisorByAdvisorNum");
	}
	//根据学生号获得advisor
	public Advisor getAdvisorByStudentNum(int studentNum){
		return commonDao.getByParamter(studentNum, "getAdvisorByStudentNum");
	}
	//根据学生名获得advisor
	public List<Advisor> getAdvisorByStudentName(String fname,String lname){
		HashMap<String,String> hashmap=new HashMap<String,String>();
		hashmap.put("fname", fname);
		hashmap.put("lname", lname);
		return commonDao.getListByParameter(hashmap, "getAdvisorByStudentName");
	}
	//插入学生顾问信息
	public boolean insertAdvisor(Advisor advisor){
		return commonDao.insertByParameter(advisor, "insertAdvisor");
	}
	//删除给定ID的advisor
	public boolean deleteAdvisorByAdvisorNum(int advisorNum){
		return commonDao.deleteByParameter(advisorNum, "deleteAdvisorByAdvisorNum");
	}
	//删除给定学生号的advisor
	public boolean deleteAdvisorByStudentNum(int studentNum){
		return commonDao.deleteByParameter(studentNum, "deleteAdvisorByStudentNum");
	}
	//更新给定ID的顾问
	public boolean updateAdvisorByAdvisorNum(Advisor advisor){
		return commonDao.updateByParameter(advisor, "updateAdvisorByAdvisorNum");
	}
}