teacherserviceimpl.java.svn-base

菲律宾的一个大学的图书管理系统 spring+hibernate+velocity

/*
 * 创建日期 2005-4-12
 */
package biz.bluesky.pts.service.impl;

import java.util.List;

import biz.bluesky.pts.model.TRole;
import biz.bluesky.pts.model.TTeacher;
import biz.bluesky.pts.model.TSubject;
import biz.bluesky.pts.model.TTeacherRole;
import biz.bluesky.pts.model.TTeacherSubject;
import biz.bluesky.pts.model.TTeacherClass;
import biz.bluesky.pts.service.ITeacherService;
import biz.bluesky.pts.service.dao.ITeacherDAO;
import biz.bluesky.pts.util.ErrorCode;

import org.springframework.dao.DataIntegrityViolationException;
import org.springframework.orm.ObjectRetrievalFailureException;
import org.springframework.dao.DataAccessException;


public class TeacherServiceImpl implements ITeacherService {

    private ITeacherDAO teacherDAO;
    
    public void setTeacherDAO(ITeacherDAO teacherDAO) {
        this.teacherDAO = teacherDAO;
    }

    public ITeacherDAO getTeacherDAO() {
        return this.teacherDAO;
    }

    //查询学校的所有教师
    public List findTeachersBySchool(int schoolId) {
        return teacherDAO.findTeachersBySchoolId(schoolId);
    }

    //根据教师名称模糊查询教师
    public List findTeachers(String teacherName) {
        return teacherDAO.findTeachersByName(teacherName);
    }

    //根据教师编号查询教师
    public TTeacher findTeacher(int teacherId) {
        TTeacher teacher = null;
        try {
            teacher = teacherDAO.findTeacherById(teacherId);
        }
        catch(ObjectRetrievalFailureException excp) {
            
        }
        
        return teacher;
    }

    //根据教师名称和学校编号查询教师
    public TTeacher findTeacher(String teacherName, int schoolId) {
        return teacherDAO.findTeacherByName(teacherName,schoolId);
    }

    //查询拥有此角色的教师
    public List findTeachersByRole(int roleId) {
        return teacherDAO.findTeachersByRole(roleId);
    }
    
    //查询不拥有此角色的教师
    public List findTeachersByNotRole(int roleId) {
        return teacherDAO.findTeachersByNotRole(roleId);
    }
 
    //通过科目查询教师
    public List findTeachersBySubject(int subjectId) {
        return teacherDAO.findTeachersBySubject(subjectId);
    }

    //查询没有此科目的教师
    public List findTeachersByNotSubject(int subjectId, int schoolId) {
        return teacherDAO.findTeachersByNotSubject(subjectId,schoolId);
    }
    
    //查询班级的教师
    public List findTeachersByClass(int classId) {
        return teacherDAO.findTeachersByClass(classId);
    }
    
    //查询班级没有的教师
    public List findTeacherByNotClass(int classId, int schoolId) {
        return teacherDAO.findTeacherByNotClass(classId,schoolId);
    }
    
    //新增教师
    public int saveTeacher(TTeacher teacher) {
        if((teacher == null)||(teacher.getName() == "")) {
            return ErrorCode.ERR_TEACHER_EMPTY;
        }
        
        try {
            teacherDAO.saveTeacher(teacher);
        }
        catch(DataIntegrityViolationException excp) {
            return ErrorCode.ERR_TEACHER_REPEAT;
        }
        catch(DataAccessException excp) {
            return ErrorCode.ERR_UNKNOW;
        }
        
        
        return ErrorCode.ERR_UNDISCOVERED;
    }
    
    //新增教师的科目
    public int saveSubjectToTeacher(int teacherId, int subjectId) {
        TTeacherSubject ts = new TTeacherSubject(teacherId,subjectId);
        
        try {
            teacherDAO.saveSubjectToTeacher(ts);
        }
        catch(DataIntegrityViolationException excp) {
            return ErrorCode.ERR_ADD_TEACHER_SUBJECT_RELATETIONSHIP;
        }
        catch(DataAccessException excp) {
            return ErrorCode.ERR_UNKNOW;
        }
        
        return ErrorCode.ERR_UNDISCOVERED;
    }

    //新增教师的权限
    public int saveRoleToTeacher(int teacherId, int roleId) {
        TTeacherRole tr = new TTeacherRole(teacherId,roleId);
        
        try {
            teacherDAO.saveRoleToTeacher(tr);
        }
        catch(DataIntegrityViolationException excp) {
            return ErrorCode.ERR_ADD_ROLE_TEACHER_RELATETIONSHIP;
        }
        catch(DataAccessException excp) {
            return ErrorCode.ERR_UNKNOW;
        }
        
        return ErrorCode.ERR_UNDISCOVERED;
    }

    //新增教师的班级
    public int saveClassToTeacher(int teacherId, int classId) {
        TTeacherClass tc = new TTeacherClass(teacherId, classId);
        
        try {
            teacherDAO.saveClassToTeacher(tc);
        }
        catch(DataIntegrityViolationException excp) {
            return ErrorCode.ERR_ADD_TEACHER_CLASS_RELATETIONSHIP;
        }
        catch(DataAccessException excp) {
            return ErrorCode.ERR_UNKNOW;
        }
        
        return ErrorCode.ERR_UNDISCOVERED;
    }

    //删除教师
    public int removeTeacher(int teacherId) {
        try {
            teacherDAO.removeTeacher(teacherId);
        }
        catch(ObjectRetrievalFailureException exce) {
            return ErrorCode.ERR_TEACHER_NOT_FIND;
        }
        catch(DataAccessException excp) {
            return ErrorCode.ERR_UNKNOW;
        }
        
        return ErrorCode.ERR_UNDISCOVERED;
    }

    //删除教师的科目
    public int removeSubjectFromTeacher(int teacherId,int subjectId) {
        try {
            teacherDAO.removeSubjectFromTeacher(subjectId,teacherId);
        }
        catch(ObjectRetrievalFailureException excp) {
            return ErrorCode.ERR_TEACHER_SUBJECT_RELATETIONSHIP_NOT_FIND;
        }
        catch(DataAccessException excp) {
            return ErrorCode.ERR_UNKNOW;
        }
        
        return ErrorCode.ERR_UNDISCOVERED;
    }

    //删除教师的角色
    public int removeRoleFromTeacher(int teacherId, int roleId) {
        try {
            teacherDAO.removeRoleFromTeacher(roleId,teacherId);
        }
        catch(ObjectRetrievalFailureException excp) {
            return ErrorCode.ERR_ROLE_TEACHER_RELATETIONSHIP_NOT_FIND;
        }
        catch(DataAccessException excp) {
            return ErrorCode.ERR_UNKNOW;
        }
        
        return ErrorCode.ERR_UNDISCOVERED;
    }

    //删除教师的班级
    public int removeClassFromTeacher(int teacherId, int classId) {
        try {
            teacherDAO.removeClassFromTeacher(classId,teacherId);
        }
        catch(ObjectRetrievalFailureException excp) {
            return ErrorCode.ERR_TEACHER_CLASS_RELATETIONSHIP_NOT_FIND;
        }
        catch(DataAccessException excp) {
            return ErrorCode.ERR_UNKNOW;
        }
        
        return ErrorCode.ERR_UNDISCOVERED;
    }
    
}