guestbookhibernatedao.java

反ajax原代码

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi 
// Source File Name:   GuestBookHibernateDAO.java

package com.laoer.bbscs.dao.hibernate;

import com.laoer.bbscs.bean.GuestBook;
import com.laoer.bbscs.dao.IGuestBookDAO;
import com.laoer.bbscs.sys.Constant;
import com.laoer.bbscs.sys.SysUtil;
import java.sql.SQLException;
import java.util.List;
import net.sf.hibernate.*;
import net.sf.hibernate.type.Type;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate.HibernateCallback;
import org.springframework.orm.hibernate.HibernateTemplate;
import org.springframework.orm.hibernate.support.HibernateDaoSupport;

public class GuestBookHibernateDAO extends HibernateDaoSupport
    implements IGuestBookDAO
{

    private static final Log logger;
    static Class class$com$laoer$bbscs$dao$hibernate$GuestBookHibernateDAO; /* synthetic field */

    public GuestBookHibernateDAO()
    {
    }

    public GuestBook saveGuestBook(GuestBook gb)
    {
        getHibernateTemplate().saveOrUpdate(gb);
        return gb;
        DataAccessException ex;
        ex;
        logger.error("saveGuestBook(GuestBook gb):" + ex);
        return null;
    }

    public GuestBook getGuestBook(long id, long userID)
    {
        String q = "from GuestBook" + SysUtil.getTableID(userID, Constant.MODNUM10) + " gb where gb.id = ? and gb.toID = ?";
        Object o[] = {
            new Long(id), new Long(userID)
        };
        List l = getHibernateTemplate().find(q, o);
        if(l.size() == 0)
            return null;
        else
            return (GuestBook)l.get(0);
    }

    public int getGuestBookAllNum(long userID)
    {
        String q = "select count(gb.id) from GuestBook" + SysUtil.getTableID(userID, Constant.MODNUM10) + " gb where gb.toID = ?";
        List l = getHibernateTemplate().find(q, new Long(userID));
        return ((Integer)l.get(0)).intValue();
        DataAccessException ex;
        ex;
        logger.error("getGuestBookAllNum(long userID):" + ex);
        return 0;
    }

    public int getGuestBookNum(long userID, short isNew)
    {
        String q;
        Object o[];
        q = "select count(gb.id) from GuestBook" + SysUtil.getTableID(userID, Constant.MODNUM10) + " gb where gb.toID = ? and gb.isNew = ?";
        o = (new Object[] {
            new Long(userID), new Short(isNew)
        });
        List l = getHibernateTemplate().find(q, o);
        return ((Integer)l.get(0)).intValue();
        DataAccessException ex;
        ex;
        logger.error("getGuestBookNum(long userID, short isNew):" + ex);
        return 0;
    }

    public List getGuestBookList(final long userID, final int firstResult, int maxResults)
    {
        return getHibernateTemplate().executeFind(maxResults. new HibernateCallback() {

            public Object doInHibernate(Session s)
                throws HibernateException, SQLException
            {
                String q = "from GuestBook" + SysUtil.getTableID(userID, Constant.MODNUM10) + " gb where gb.toID = ? order by gb.id desc";
                Query query = s.createQuery(q);
                query.setLong(0, userID);
                query.setFirstResult(firstResult);
                query.setMaxResults(maxResults);
                List list = query.list();
                return list;
            }

        });
    }

    public List getGuestBookInList(final long userID, List values)
    {
        return getHibernateTemplate().executeFind(values. new HibernateCallback() {

            public Object doInHibernate(Session s)
                throws HibernateException, SQLException
            {
                String q = "from GuestBook" + SysUtil.getTableID(userID, Constant.MODNUM10) + " gb where gb.toID = :toid and gb.id in (:values)";
                Query query = s.createQuery(q);
                query.setLong("toid", userID);
                query.setParameterList("values", values);
                List list = query.list();
                return list;
            }

        });
    }

    public void removeAllGuestBook(long userID)
    {
        getHibernateTemplate().execute(userID. new HibernateCallback() {

            public Object doInHibernate(Session s)
                throws HibernateException, SQLException
            {
                String q = "from GuestBook" + SysUtil.getTableID(userID, Constant.MODNUM10) + " gb where gb.toID = ?";
                s.delete(q, new Long(userID), Hibernate.LONG);
                return null;
            }

        });
    }

    public void removeGuestBook(long id, final long userID)
    {
        getHibernateTemplate().executeFind(id. new HibernateCallback() {

            public Object doInHibernate(Session s)
                throws HibernateException, SQLException
            {
                String q = "from GuestBook" + SysUtil.getTableID(userID, Constant.MODNUM10) + " gb where gb.id = ? and gb.toID = ?";
                Object o[] = {
                    new Long(id), new Long(userID)
                };
                Type t[] = {
                    Hibernate.LONG, Hibernate.LONG
                };
                s.delete(q, o, t);
                return null;
            }

        });
    }

    static Class class$(String x0)
    {
        return Class.forName(x0);
        ClassNotFoundException x1;
        x1;
        throw new NoClassDefFoundError(x1.getMessage());
    }

    static 
    {
        logger = LogFactory.getLog(class$com$laoer$bbscs$dao$hibernate$GuestBookHibernateDAO != null ? class$com$laoer$bbscs$dao$hibernate$GuestBookHibernateDAO : (class$com$laoer$bbscs$dao$hibernate$GuestBookHibernateDAO = class$("com.laoer.bbscs.dao.hibernate.GuestBookHibernateDAO")));
    }
}