publishbo.java

一个bbs论坛系统

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 {

	/**发表帖子*/
	public boolean addPub(PublishPO publishPO);
	
	/**删除帖子*/
	public boolean deletePub(int id);
	
	/**根据用户名查询帖子*/
	public List<PublishPO> queryPubByUserid(int userid);
	
	/**根据版块查询帖子*/
	public List<PublishPO> queryPubByBlockid(int blockid, Page page);
	
	/**根据发帖时间查询帖子*/
	public List<PublishPO> queryByPublishDate();
	
	/**查询一个版块的帖子总数*/
	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);
	
	/**结贴*/
	public boolean finish(PublishPO po);
}