sqlbuilder.java

源码/软件简介: 云网论坛1.1RC国际版是采用JSP开发的集论坛、CMS（网站内容管理系统）、博客、聊天室、商城、交友、语音灌水等于一体的门户式社区。拥有CWBBS ( Cloud Web BBS

package com.redmoon.forum;

import cn.js.fan.util.StrUtil;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class SQLBuilder {
    public SQLBuilder() {
    }

    public static String getShowtopictreeSql(long rootid) {
        String sql = "select id from sq_message where rootid=" + rootid + " ORDER BY orders";
        return sql;
    }

    public static String getShowtopicSql(long rootid) {
        String sql = "select id from sq_message where rootid=" + rootid +
                     " ORDER BY lydate asc"; //orders"; 这样会使得顺序上不按时间，平板式时会让人觉得奇怪
        return sql;
    }

    public static String getMyblogSql(String blogUserDir,
                                      String userName) {
        String sql = "";
        if (blogUserDir.equals(""))
            // sql = "select id from sq_message where replyid=-1 and name=" + StrUtil.sqlstr(userName) + " and isBlog=1 ORDER BY lydate desc";
            sql = "select id from sq_thread where name=" +
                  StrUtil.sqlstr(userName) +
                  " and isBlog=1 ORDER BY lydate desc";
        else
            // sql = "select id from sq_message where replyid=-1 and name=" + StrUtil.sqlstr(userName) + " and blogUserDir=" + StrUtil.sqlstr(blogUserDir) + " and isBlog=1 ORDER BY lydate desc";
            sql = "select id from sq_thread where name=" +
                  StrUtil.sqlstr(userName) + " and blogUserDir=" +
                  StrUtil.sqlstr(blogUserDir) +
                  " and isBlog=1 ORDER BY lydate desc";
        return sql;
    }

    public static String getListtopicSql(String boardcode, String op, String timelimit) {
        String sql = "";
        if (timelimit.equals("all")) {
            if (op.equals("showelite"))
                sql = "select id from sq_thread where boardcode=" +
                      StrUtil.sqlstr(boardcode) +
                      " and iselite=1 ORDER BY msg_level desc,redate desc";
            else {
                // sql = "select id from sq_message where replyid=-1 and boardcode="+StrUtil.sqlstr(boardcode)+" and msg_level<=" + MsgDb.LEVEL_TOP_BOARD + " ORDER BY msg_level desc,redate desc";
                sql = "select id from sq_thread where boardcode=" +
                      StrUtil.sqlstr(boardcode) + " and msg_level<=" +
                      MsgDb.LEVEL_TOP_BOARD +
                      " ORDER BY msg_level desc,redate desc";
            }
        } else {
            /*
            if (op.equals("showelite"))
                sql = "select id from sq_thread where boardcode=" +
                      StrUtil.sqlstr(boardcode) + "and msg_level<=" +
                      MsgDb.LEVEL_TOP_BOARD +
                      " and TO_DAYS(NOW()) - TO_DAYS(lydate) <=" + timelimit +
                      " and iselite=1 ORDER BY msg_level desc,redate desc";
            else
                sql = "select id from sq_thread where boardcode=" +
                      StrUtil.sqlstr(boardcode) + "and msg_level<=" +
                      MsgDb.LEVEL_TOP_BOARD +
                      " and TO_DAYS(NOW()) - TO_DAYS(lydate) <=" + timelimit +
                      " ORDER BY msg_level desc,redate desc";
             */
            long cur = System.currentTimeMillis();
            long dlt = Long.parseLong(timelimit)*24*60*60000;
            long afterDay = cur - dlt;

            if (op.equals("showelite"))
                sql = "select id from sq_thread where boardcode=" +
                      StrUtil.sqlstr(boardcode) + "and msg_level<=" +
                      MsgDb.LEVEL_TOP_BOARD +
                      " and lydate>" + StrUtil.sqlstr("" + afterDay) +
                      " and iselite=1 ORDER BY msg_level desc,redate desc";
            else
                sql = "select id from sq_thread where boardcode=" +
                      StrUtil.sqlstr(boardcode) + "and msg_level<=" +
                      MsgDb.LEVEL_TOP_BOARD +
                      " and lydate>" + StrUtil.sqlstr("" + afterDay) +
                      " ORDER BY msg_level desc,redate desc";
        }
        return sql;
    }
}