scoredao.java

are are are are are are are are are are are are

/*
 * ScoreDao.java
 *
 * Created on 2006年5月19日, 上午8:19
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package enova.dao;

import java.util.List;
import enova.pojo.*;

/**
 *
 * @author vlinux
 */
public interface ScoreDao {
    
    public Score get(Integer studentId, Integer courseId) throws DataAccessException;
    //public void update(Score score) throws DataAccessException;
    public void insert(Score score) throws RecordExistException, DataAccessException;
    //public void updateOrInsert(Score score) throws RecordExistException, DataAccessException;
    public void delete(Integer studentId, Integer courseId) throws DataAccessException;
    
    public void update(Integer studentId,Integer courseId,Integer grade) throws DataAccessException;
    public void clean(Integer studentId,Integer courseId) throws DataAccessException;
    public void cleanByClassId(Integer classId,Integer courseId) throws DataAccessException;
    public void cleanByClassIdAndYearAndTerm(Integer classId,Integer year,String term) throws DataAccessException;
    
    public List getByTeacherIdAndCourseIdAndClassIdSortNumber(Integer teacherId,Integer courseId,Integer classId) throws DataAccessException;
    public List getByStudentIdAndYearAndTerm(Integer studentId,Integer year,String term) throws DataAccessException;
    public List getByStudentIdSortYearAndTerm(Integer studentId) throws DataAccessException;
    public List getByClassIdSortYearAndTermAndNumber(Integer classId) throws DataAccessException;
    public List getByClassIdAndYearAndTermSortNumber(Integer classId,Integer year,String term) throws DataAccessException;
    public List getByNumberAndYearAndTerm(String number,Integer year,String term) throws DataAccessException;
    public List getByNumber(String number) throws DataAccessException;
    
    public void updateByTeacherIdAndStudentIdAndCourseId(Integer teacherId,Integer studentId,Integer courseId,Integer value) 
        throws DataAccessException;
}