publishdao.java

一个bbs论坛系统

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