package com.lovo.bo;

import java.sql.SQLException;
import java.util.List;

import com.lovo.po.PublishPO;
import com.lovo.util.Page;

public interface PublishBO {

	/**發(fā)表帖子*/
	public boolean addPub(PublishPO publishPO);
	
	/**刪除帖子*/
	public boolean deletePub(int id);
	
	/**根據(jù)用戶名查詢帖子*/
	public List<PublishPO> queryPubByUserid(int userid);
	
	/**根據(jù)版塊查詢帖子*/
	public List<PublishPO> queryPubByBlockid(int blockid, Page page);
	
	/**根據(jù)發(fā)帖時間查詢帖子*/
	public List<PublishPO> queryByPublishDate();
	
	/**查詢一個版塊的帖子總數(shù)*/
	public int queryPublishMaxRowsInBlock(int id);
	public List<PublishPO> queryByContent(String content) throws SQLException;
	public List<PublishPO> queryByTitle(String title) throws SQLException;
	public PublishPO queryByRecomendate() throws SQLException;
	public PublishPO queryByDigestdate() throws SQLException;
	/**獲得帖子ID*/
	public PublishPO queryById(int id);
	
	/**加精帖子*/
	public boolean digest(PublishPO po);
	
	/**置頂帖子*/
	public boolean stick(PublishPO po);
	
	/**推薦帖*/
	public boolean delRecommend(PublishPO po);
	/**加精帖子*/
	public boolean delDigest(PublishPO po);
	
	/**置頂帖子*/
	public boolean delStick(PublishPO po);
	
	/**推薦帖*/
	public boolean recommend(PublishPO po);
	
	/**結(jié)貼*/
	public boolean finish(PublishPO po);
}