package com.lovo.dao;

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

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

public interface PublishDAO {
	/**
	 * 添加主題帖
	 * @param po
	 * @throws SQLException
	 */
	public void insert(PublishPO po) throws SQLException;
	/**
	 * 刪除主題帖
	 * @param id
	 * @throws SQLException
	 */
	public void delete(int id) throws SQLException;
	/**
	 * 修改主題帖
	 * @param po
	 * @throws Exception
	 */
	public void updateRecmmend(PublishPO po) throws SQLException;
	public void updateStick(PublishPO po) throws SQLException;
	public void updateFinish(PublishPO po) throws SQLException;
	public void updateDigest(PublishPO po) throws SQLException;
	public PublishPO queryByRecomendate() throws SQLException;
	public PublishPO queryByDigestdate() throws SQLException;
	/**
	 * 查詢具體的某個帖子
	 * @param id
	 * @return
	 * @throws SQLException
	 */
	public PublishPO queryById(int id) throws SQLException;
	/**
	 * 按主題查詢相關主題
	 * @param title
	 * @return
	 * @throws SQLException
	 */
	public List<PublishPO> queryByTitle(String title) throws SQLException;
	/**
	 * 查詢某個用戶發表的主題帖
	 * @param id
	 * @return
	 * @throws SQLException
	 */
	public List<PublishPO> queryByUserId(int id) throws SQLException;
	/**
	 * 查詢某個版塊的主題帖
	 * @param id
	 * @return
	 * @throws Exception
	 */
	public List<PublishPO> queryByBlockId(int id, Page page) throws SQLException;
	/**
	 * 最新的主題帖
	 * @return
	 * @throws SQLException
	 */
	public List<PublishPO> queryByPublishDate() throws SQLException;
	/**
	 * 查詢一個版塊的帖子總數
	 * @param id
	 * @return
	 * @throws SQLException
	 */
	public int queryPublishMaxRowsInBlock(int id) throws SQLException;
	public List<PublishPO> queryByContent(String content) throws SQLException;
}