replydao.java

一个bbs论坛系统

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;
}