groupdao.java

一个用struts tiles的在线影院web系统

package com.eline.vod.dao;

import java.sql.SQLException;
import java.util.ArrayList;

import com.blue.web.common.exceptions.DAOSysException;
import com.blue.web.common.model.Page;
import com.eline.vod.model.Group;
import com.eline.vod.model.MovieCondition;


public interface GroupDAO {
	// about Group
	int addGroup(Group group) throws DAOSysException, SQLException;
	
	Group getGroup(int groupId) throws DAOSysException, SQLException;
 
	void upateGroup(Group group) throws DAOSysException, SQLException;

	void deleteGroup(int groupID) throws DAOSysException, SQLException;

	// about MovieInGroups
	void addMovieToGroup(int movieID, int groupID);

	void removeMovieFromGroup(int movieID, int groupID);

	void removeMovieFromGroup(int movieID);

	ArrayList getMoviesInGroup(int groupID, int sortBy, boolean approvedOnly);

	Page getMoviesInGroup(int groupID, int sortBy, int pageIndex, int pageSize,
			boolean approvedOnly);

	ArrayList getGroupsForMovie(int movieID, boolean approvedOnly);

	ArrayList getGroups(boolean approvedOnly);

	Page getGroups(int pageIndex, int pageSize, boolean approvedOnly);

	public Page searchMovie(MovieCondition condition, int indexId, int start,
			int count) throws SQLException, DAOSysException;

	boolean isGroupEmpty(int groupId) throws SQLException, DAOSysException;
}