sqlbuilder.java

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

package cn.js.fan.module.cms;

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 getDocRelateSql(String keywords) {
        keywords = keywords.replaceAll("，", ",");
        String[] allkeys = StrUtil.split(keywords, ",");
        int len = allkeys.length;
        String keys = "";
        String sql = "select id from document";
        if (len==0)
            return sql;
        sql += " where";
        for (int i = 0; i < len; i++) {
            if (keys.equals(""))
                sql += " keywords like " +  StrUtil.sqlstr("%" + allkeys[i] + "%");
            else
                sql += " or keywords like " + StrUtil.sqlstr("%" + allkeys[i] + "%");
        }
        return sql;
    }
}