?? publishdao.java
字號:
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;
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -