subjectserviceimpl.java.svn-base

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

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

import java.util.List;

import biz.bluesky.pts.model.TSubject;
import biz.bluesky.pts.service.ISubjectService;
import biz.bluesky.pts.service.dao.ISubjectDAO;

import biz.bluesky.pts.util.ErrorCode;

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


public class SubjectServiceImpl implements ISubjectService {

    private ISubjectDAO subjectDAO;
    
    public void setSubjectDAO(ISubjectDAO subjectDAO) {
        this.subjectDAO = subjectDAO;
    }

    public ISubjectDAO getSubjectDAO() {
        return this.subjectDAO;
    }

    //通过科目编号查询科目
    public TSubject findSubject(int subjectId) {
        TSubject subject = null;
        
        try {
            subject = subjectDAO.findSubjectById(subjectId); 
        }
        catch(ObjectRetrievalFailureException excp) {
            
        }
        
        return subject;
    }
    
    //根据学校编号查询学校的科目
    public List findSubjects(int schoolId) {
        return subjectDAO.findSubjectsBySchool(schoolId);
    }

    //模糊查询学校内的科目
    public List findSubjects(String subjectName, int schoolId) {
        return subjectDAO.findSubjects(subjectName,schoolId);
    }

    //查询科目
    public TSubject findSubject(String subjectName, int schoolId) {
        return subjectDAO.findSubjectByName(subjectName,schoolId);
    }

    //查询教师的科目
    public List findSubjectsByTeacher(int teacherId) {
        return subjectDAO.findSubjectsByTeacher(teacherId);
    }

    //查询教师不具备的科目
    public List findNotSubjectByTeacher(int teacherId, int schoolId) {
        return subjectDAO.findNotSubjectsByTeacher(teacherId,schoolId);
    }
    
    //新增科目
    public int saveSubject(TSubject subject) {
        if(subject == null) {
            return ErrorCode.ERR_SUBJECT_EMPTY;
        }
        
        try {
            subjectDAO.saveSubject(subject);
        }
        catch(DataIntegrityViolationException excp) {
            return ErrorCode.ERR_SUBJECT_REPEAT;
        }
                       
        return ErrorCode.ERR_UNDISCOVERED;
    }

    //删除科目
    public int removeSubject(int subjectId) {
        try {
            subjectDAO.removeSubject(subjectId);
        }
        catch(ObjectRetrievalFailureException excp) {
            return ErrorCode.ERR_SUBJECT_NOT_FIND;
        }
        catch(DataAccessException excp) {
            return ErrorCode.ERR_UNKNOW;
        }
               
        return ErrorCode.ERR_UNDISCOVERED;
    }

}