?? guestbookdao.java
字號(hào):
/*
* GuestBookDAO.java
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Library General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*
* Author: Winter Lau
* http://dlog4j.sourceforge.net
*
*/
package com.liusoft.dlog4j.dao;
import java.util.Date;
import java.util.List;
import com.liusoft.dlog4j.beans.GuestBookBean;
import com.liusoft.dlog4j.beans.SiteBean;
/**
* 留言本的數(shù)據(jù)訪問(wèn)接口
* @author Winter Lau
*/
public class GuestBookDAO extends DAO {
/**
* 獲取某條留言信息
* @param msg_id
* @return
*/
public static GuestBookBean getMsg(int siteid, int msg_id){
if(msg_id < 0)
return null;
GuestBookBean gbb = (GuestBookBean)getBean(GuestBookBean.class, msg_id);
if(gbb.getSiteId()==siteid)
return gbb;
return null;
}
/**
* 獲取某個(gè)站點(diǎn)的留言板消息數(shù)
* @param site
* @return
*/
public static int getMsgCount(SiteBean site){
if(site == null) return -1;
return executeNamedStatAsInt("GUESTBOOK_COUNT", site.getId());
}
/**
* 獲取某個(gè)站點(diǎn)的新留言板消息數(shù)
* @param site
* @return
*/
public static int getNewMsgCount(SiteBean site, int fromId){
if(site == null) return -1;
return executeNamedStat("GUESTBOOK_COUNT_AFTER", site.getId(), fromId).intValue();
}
/**
* 分頁(yè)瀏覽留言本中的所有信息
* @param site
* @param fromIdx
* @param fetchCount
* @return
*/
public static List listMsgs(SiteBean site, int fromIdx, int fetchCount){
return executeNamedQuery("LIST_GUESTBOOK", fromIdx, fetchCount, site.getId());
}
/**
* 刪除留言板中的口條信息
* @param site
* @param msg_id
* @return
*/
public static int deleteMsg(int siteid, int msg_id){
return commitNamedUpdate("DELETE_GUESTBOOK", msg_id, siteid);
}
/**
* 寫入一條新的留言板信息
* @param gbb
*/
public static void createMsg(GuestBookBean gbb){
if(gbb.getCreateTime()==null)
gbb.setCreateTime(new Date());
save(gbb);
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -