/**
 * 
 */
package bookList;

import java.util.Collection;

/**
 * @author yang xueyu
 *
 */
public interface ISubInfoDB {
    //按訂單表id得到訂單的詳細信息
    public SubInfo getSubDetailInfo (int bid);
    //按訂單號得到訂單的詳細信息
    public SubInfo getSubDetailInfo (String subno);
    //添加訂單信息
    public int addSub (SubInfo subs);
    //刪除訂單信息
    public int deleteSub (int id);
    //修改訂單信息
    public int modifySub (SubInfo subs);
    //處理訂單
    public int doAction (int id);
    //查詢所有用戶的訂單
    public Collection getSubLasted ();
    //按用戶名查詢訂單
    public Collection getSubByUser (String username);
    //按查詢類別查詢訂單
    public Collection getSubListBySearch (String search, String keyword);
}