ixiong.java

ktv点歌系统前台收银有开包房

package com.ktv.dao;

import java.util.Iterator;

import javax.sound.midi.MidiDevice.Info;

public interface Ixiong {

	/**
	 * 增加记录
	 * @param info Info
	 */
	public abstract void setInfo(Info info) throws Exception;

	/**
	 * 通过ID取得记录
	 * @param id String
	 * @return Info
	 */
	public abstract Info getInfoById(String id) throws Exception;

	/**
	 * 修改记录
	 * @param Info info
	 */
	public abstract void modifyInfo(Info info) throws Exception;

	/**
	 * 删除记录
	 * @param Info info
	 */
	public abstract void removeInfo(Info info) throws Exception;

	/**
	 * 取记录总数
	 * @return int
	 */
	public abstract int getInfosCount() throws Exception;

	/**
	 * 取所有记录集合
	 * @return Iterator
	 */
	public abstract Iterator getAllInfos() throws Exception;

	/**
	 * 取记录集合
	 * @return Iterator
	 * @param int position, int length
	 */
	public abstract Iterator getInfos(int position, int length)
			throws Exception;

	/**
	 * 取第一条记录
	 * @throws Exception
	 * @return Station
	 */
	public abstract Info getFirstInfo() throws Exception;

	/**
	 * 取最后一条记录
	 * @throws Exception
	 * @return Station
	 */
	public abstract Info getLastInfo() throws Exception;

	/**
	 * 取符合条件记录总数, [表中要有 isperson 字段]
	 * @return int
	 * @param int isPerson
	 */

	public abstract int getInfosCountByIsperson(int isPerson) throws Exception;

	/**
	 * 取所有符合条件记录集合, 模糊查询条件.[表中要有 isperson 字段]
	 * @return Iterator
	 * @param int isPerson
	 */

	public abstract Iterator getAllInfosByIsperson(int isPerson)
			throws Exception;

	/**
	 * 取符合条件记录集合, 模糊查询条件.[表中要有 isperson 字段]
	 * @return Iterator
	 * @param int isPerson,int position, int length
	 */

	public abstract Iterator getInfosByIsperson(int isPerson, int position,
			int length) throws Exception;

	////////////////////////////////////////////////////////
	/////                                                ///
	///// 以下部份表中要有特定字段才能正确运行   查询部份      ///
	/////                                                ///
	///////////////////////////////////////////////////////
	/**
	 * 取符合条件记录总数, 模糊查询条件.[表中要有 title 字段]
	 * @return int
	 * @param String text
	 */
	public abstract int getInfosCount(String text) throws Exception;

	/**
	 * 取所有符合条件记录集合, 模糊查询条件.[表中要有 title 字段]
	 * @return Iterator
	 * @param String text
	 */

	public abstract Iterator getAllInfos(String text) throws Exception;

	/**
	 * 取符合条件记录集合, 模糊查询条件.[表中要有 title 字段]
	 * @return Iterator
	 * @param String text,int position, int length
	 */
	public abstract Iterator getInfos(String text, int position, int length)
			throws Exception;

	/**
	 * 取符合条件记录总数.[ 表中要有 registername 字段]
	 * @return int
	 * @param String text
	 */
	public abstract int getInfosCountByRegisterName(String registerName)
			throws Exception;

	/**
	 * 通过注册名取得一条记录,如有多条,只取第一条.[表中要有 registername字段]
	 * @param registername String
	 * @return Info
	 */
	public abstract Info getInfoByRegisterName(String registerName)
			throws Exception;

	/**
	 * 通过注册名取得所有记录集合.[表中要有 registername字段]
	 * @param registername String
	 * @return Iterator
	 */
	public abstract Iterator getAllInfosByRegisterName(String registerName)
			throws Exception;

	/**
	 * 通过注册名取得记录列表.[表中要有 registername字段]
	 * @param registername String
	 * @return Iterator
	 */
	public abstract Iterator getInfosByRegisterName(String registerName,
			int position, int length) throws Exception;

	/**
	 * 取记录总数.[ 表中要有 board_id 字段]
	 * @return int
	 * @param String boardId
	 */
	public abstract int getInfosCountByBoard(String boardId) throws Exception;

	/**
	 * 通过版块名取得所有记录集合.[表中要有 board_id字段]
	 * @param BoardId String
	 * @return Iterator
	 */
	public abstract Iterator getAllInfosByBoard(String boardId)
			throws Exception;

	/**
	 * 通过版块名取得记录列表.[表中要有 board_id字段]
	 * @param BoardId String
	 * @return Iterator
	 */
	public abstract Iterator getInfosByBoard(String boardId, int position,
			int length) throws Exception;

	/**
	 * 取符合条件记录总数.[ 表中要有 board_id 字段,title]  模糊查询title
	 * @return int
	 * @param String boardId ,String text
	 */
	public abstract int getInfosCountByBoard(String boardId, String text)
			throws Exception;

	/**
	 * 通过版块名取得记录列表.[表中要有 board_id字段]  模糊查询title
	 * @param String boardID,int position, int length
	 * @return Iterator
	 */
	public abstract Iterator getInfosByBoard(String boardId, int position,
			int length, String text) throws Exception;

	/**
	 * 取记录总数
	 * @return int
	 * @param int isAuditing
	 */
	public abstract int getInfosCount(int isAuditing) throws Exception;

	/**
	 * 取所有记录集合
	 * @return Iterator
	 * @param int position, int length,int isAuditing
	 */
	public abstract Iterator getAllInfos(int isAuditing) throws Exception;

	/**
	 * 取记录集合
	 * @return Iterator
	 * @param int position, int length,int isAuditing
	 */
	public abstract Iterator getInfos(int position, int length, int isAuditing)
			throws Exception;

	/**
	 * 取符合条件记录总数, [表中要有 isperson isAuditing 字段]
	 * @return int
	 * @param int isPerson,int isAuditing
	 */

	public abstract int getInfosCountByIsperson(int isPerson, int isAuditing)
			throws Exception;

	/**
	 * 取所有符合条件记录集合, 模糊查询条件.[表中要有 isperson isAuditing 字段]
	 * @return Iterator
	 * @param int isPerson,int isAuditing
	 */

	public abstract Iterator getAllInfosByIsperson(int isPerson, int isAuditing)
			throws Exception;

	/**
	 * 取符合条件记录集合, 模糊查询条件.[表中要有 isperson isAuditing 字段]
	 * @return Iterator
	 * @param int isPerson,int position, int length,int isAuditing
	 */

	public abstract Iterator getInfosByIsperson(int isPerson, int position,
			int length, int isAuditing) throws Exception;

	////////////////////////////////////////////////////////
	/////                                                ///
	///// 要有特定字段才能正确运行   有审核功能    查询部份    ///
	/////                                                ///
	///////////////////////////////////////////////////////
	/**
	 * 取符合条件记录总数, 模糊查询条件.[表中要有 title 字段]
	 * @return int
	 * @param String text,int isAuditing
	 */
	public abstract int getInfosCount(String text, int isAuditing)
			throws Exception;

	/**
	 * 取所有符合条件记录集合, 模糊查询条件.[表中要有 title 字段]
	 * @return Iterator
	 * @param String text,int isAuditing
	 */

	public abstract Iterator getAllInfos(String text, int isAuditing)
			throws Exception;

	/**
	 * 取符合条件记录集合, 模糊查询条件.[表中要有 title 字段]
	 * @return Iterator
	 * @param String text,int position, int length,int isAuditing
	 */
	public abstract Iterator getInfos(String text, int position, int length,
			int isAuditing) throws Exception;

	/**
	 * 取符合条件记录总数.[ 表中要有 registername isauditing字段]
	 * @return int
	 * @param String text,int isAuditing
	 */
	public abstract int getInfosCountByRegisterName(String registerName,
			int isAuditing) throws Exception;

	/**
	 * 通过注册名取得一条记录,如有多条,只取第一条.[表中要有 registername isauditing字段]
	 * @param registername String,int isAuditing
	 * @return Info
	 */
	public abstract Info getInfoByRegisterName(String registerName,
			int isAuditing) throws Exception;

	/**
	 * 通过注册名取得所有记录集合.[表中要有 registername isauditing字段]
	 * @param registername String,int isAuditing
	 * @return Iterator
	 */
	public abstract Iterator getAllInfosByRegisterName(String registerName,
			int isAuditing) throws Exception;

	/**
	 * 通过注册名取得记录列表.[表中要有 registername isauditing字段]
	 * @param registername String,int isAuditing
	 * @return Iterator
	 */
	public abstract Iterator getInfosByRegisterName(String registerName,
			int position, int length, int isAuditing) throws Exception;

	/**
	 * 取记录总数.[ 表中要有 board_id isauditing字段]
	 * @return int
	 * @param String boardId,int isAuditing
	 */
	public abstract int getInfosCountByBoard(String boardId, int isAuditing)
			throws Exception;

	/**
	 * 通过版块名取得所有记录集合.[表中要有 board_id isauditing字段]
	 * @param BoardId String,int isAuditing
	 * @return Iterator
	 */
	public abstract Iterator getAllInfosByBoard(String boardId, int isAuditing)
			throws Exception;

	/**
	 * 通过版块名取得记录列表.[表中要有 board_id isauditing字段]
	 * @param BoardId String,int isAuditing
	 * @return Iterator
	 */
	public abstract Iterator getInfosByBoard(String boardId, int position,
			int length, int isAuditing) throws Exception;

	/**
	 * 取符合条件记录总数.[ 表中要有 board_id isauditing字段,title]  模糊查询title
	 * @return int
	 * @param String boardId ,String text,int isAuditing
	 */
	public abstract int getInfosCountByBoard(String boardId, String text,
			int isAuditing) throws Exception;

	/**
	 * 通过版块名取得记录列表.[表中要有 board_id字段 isauditing]  模糊查询title
	 * @param String boardId,int position, int length,int isAuditing
	 * @return Iterator
	 */
	public abstract Iterator getInfosByBoard(String boardId, int position,
			int length, String text, int isAuditing) throws Exception;

}