Shop/src/model/TCommentDAO.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package model;

import bean.Condition;
import bean.Page;
import java.util.*;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.*;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import util.*;

// Referenced classes of package model:
//            TComment, TSysSet

public class TCommentDAO extends HibernateDaoSupport
{

    private static final Log log = LogFactory.getLog(TCommentDAO.class);
    public static final String COMMENT_NAME = "commentName";
    public static final String COMMENT_TEL = "commentTel";
    public static final String COMMENT_MAIL = "commentMail";
    public static final String COMMENT_CONTENT = "commentContent";
    public static final String COMMENT_IP = "commentIp";
    public static final String COMMENT_REPLY = "commentReply";
    public static final String NEWS_ID = "newsId";
    public static final String PRO_ID = "proId";

    public TCommentDAO()
    {
    }

    protected void initDao()
    {
    }

    public Page getPage(int pageNumber, int maxRows, String url, Map map)
    {
        String countSql = "select count(*) from TComment a where 1=1 ";
        String statusSql = "from TComment a where 1=1 ";
        List objectList = new ArrayList();
        List typeList = new ArrayList();
        String toushujianyi_user = ParamUtil.getString(map, "toushujianyi_user", "");
        if("toushujianyi_user".equals(toushujianyi_user))
        {
            countSql = (new StringBuilder(String.valueOf(countSql))).append(" and a.newsId is null and a.proId is null ").toString();
            statusSql = (new StringBuilder(String.valueOf(statusSql))).append(" and a.newsId is null and a.proId is null ").toString();
        }
        String toushujianyi = ParamUtil.getString(map, "toushujianyi", "");
        if("toushujianyi".equals(toushujianyi))
        {
            countSql = (new StringBuilder(String.valueOf(countSql))).append(" and a.newsId is null and a.proId is null and a.userId is null ").toString();
            statusSql = (new StringBuilder(String.valueOf(statusSql))).append(" and a.newsId is null and a.proId is null and a.userId is null ").toString();
        }
        String proId = ParamUtil.getString(map, "proId", "");
        if(!"".equals(proId))
        {
            countSql = (new StringBuilder(String.valueOf(countSql))).append(" and a.proId = ? ").toString();
            statusSql = (new StringBuilder(String.valueOf(statusSql))).append(" and a.proId = ? ").toString();