【草原和大树】asp.net多关键词搜索函数

    {ITPUB个人空间\p!@ F
G"[!W"ku2J
      string[] words ={ };
P-Rp:y(W3Am5~ S^0       stringsql_temp ="", sql ="";

       if(keywords !="")

        {

            words = keywords.Split(' ');

           for(inti = 0; i < words.Length; i++)

            {

               intfirst = 0;

                sql_temp ="( ";

                   if(first == 0)

                    {

                        sql_temp += fileds +" like '%"+ words[i] +"%'";

                        first = 1;

                    }

                   else

                    {

                        sql_temp +=" AND "+ fileds +" like '%"+ words[i] +"%'"; ;

                    }ITPUB个人空间+Z(Ih@0uc
               if(sql_temp.Trim() !="(") sql_temp +=" ) AND ";

                if(i == 0) sql = sql_temp;

                  else

                   {

                    sql += sql_temp;

                   }

            }

            sql = sql.Substring(0, sql.LastIndexOf("AND"));

        }

        returnsql;

    }