<ins id="8sued"><div id="8sued"></div></ins>

asp.net 多字段模糊查詢代碼

2024-07-10 13:22:09

字體：大中小

供稿：網(wǎng)友

string strField = "id|className|classAdd";
string strKeyWords = this.tbxKeyWords.Text.Trim();
string strSql = dbexe.searchText("select * from class", strField, strKeyWords);
經(jīng)常用到多字段的模糊查詢，上面的函數(shù)可以實現(xiàn)，例如strKeyWords值為“武林網(wǎng)”時，可以輸出：
select * from class where id like '%武林網(wǎng)%' or className like '%武林網(wǎng)%' or classAdd like '%武林網(wǎng)%'
函數(shù)：
/// <summary>
/// 根據(jù)關(guān)鍵字實現(xiàn)多字段模糊查詢
/// </summary>
/// <param name="sqlStr">select * from talbe sql語句</param>
/// <param name="sqlText">判斷語句條件，是一個用|隔開的字符串</param>
/// <param name="keywords">關(guān)鍵字</param>
public static string searchText(string strSql, string strField, string keywords)
{
    StringBuilder sb = new StringBuilder(strSql);
    if (strField != string.Empty)
    {
        sb.Append(" where ");
        string[] arrKey = strField.Split('|');
        for (int i = 0; i < arrKey.Length; i++)
        {
            sb.Append(arrKey[i] + " like '%" + keywords + "%' or ");
        }
        string str = sb.ToString();

        //去除最后一個"or"
        if (str.IndexOf("or") >= 0)
        {
            return str.Remove(str.LastIndexOf("or"));
        }
        return str;
    }
    return strSql;

}

上一篇：OpenCms 帶分頁的新聞列表

下一篇：asp.net Repeater取得CheckBox選中的某行某個值