package com.lovo.dao;

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

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

public interface ReplyDAO {
	/**
	 * 添加回復貼
	 * @param replyPO
	 * @throws SQLException
	 */
	public void insert(ReplyPO replyPO) throws SQLException;
	/**
	 * 刪除回復貼
	 * @param id
	 * @throws SQLException
	 */
	public void delete(int id) throws SQLException;
	/**
	 * 根據ID具體查詢某個回復貼
	 * @param id
	 * @return
	 * @throws SQLException
	 */
	public ReplyPO queryById(int id) throws SQLException;
	/**
	 * 查詢某個用戶的所有帖子
	 * @param id
	 * @return
	 * @throws SQLException
	 */
	public List<ReplyPO> queryByUserId(int id) throws SQLException;
	/**
	 * 查詢某個主題的所有恢復帖子
	 * @param id
	 * @return
	 * @throws SQLException
	 */
	public List<ReplyPO> queryByPublish(int id, Page page) throws SQLException;
	public int queryReplyNumByPublish(int id) throws SQLException;
	public List<ReplyPO> queryByContent(String content, Page page) throws SQLException;
}