sql2000全文检索的问题，如我输入查询内容：“图壁厂1号”查询出来的内容不正确

pei051027 2008-07-09 03:42:47

具体是这样：

查询内容：结果：

“图壁厂1号” 只要含有“图壁厂“三个字的都出来了

“图壁厂11号” 查询正确

意思就是说只要是那个1号的“1”是小于10的数字，查询都不正确，
只要是大于10的查询都正确

我想问问sql2000的全文检索在获取关键字的时候怎么取的？我的这个为什么不正确？

...全文

171 17 打赏收藏转发到动态举报

写回复

用AI写文章

17 条回复

切换为时间正序

请发表友善的回复…

发表回复

xuyang840117 2008-07-09

打赏
举报

下面是我写的共通参考下

public class MCHBaseClass
{
private DataSet ds = new DataSet();
private string mPath = "";

public DataSet getDS()
{
return ds;
}

/// <summary>
/// 加载获取的MXL 获取XML路径
/// </summary>
/// <param name="path"></param>
public void LoadSetting(string path)
{
this.mPath = path;
this.ds = new DataSet();

try
{
ds.ReadXml(@mPath);
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
throw;
}
}

public DataTable Getting(string fNode)
{
DataTable dt = new DataTable();

try
{
dt = ds.Tables[fNode];
return dt;

}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
throw;

}
}

/// <summary>
/// 获取fNode父节点下第intKey行 strSection的属性值
/// </summary>
/// <param name="fNode">父节电名称</param>
/// <param name="intKey">行数</param>
/// <param name="strSection">属性名称</param>
/// <returns></returns>
public string Getting(string fNode, int intKey, string strSection)
{
string strValue = "";

try
{
strValue = Convert.ToString(ds.Tables[fNode].Rows[intKey][strSection]);
return strValue;

}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
throw;

}
}

/// <summary>
/// 把ds写到路径mPath下，保存成XML
/// </summary>
/// <param name="ds1"></param>
/// <param name="mPath1"></param>
public void SaveSettings(DataSet ds1, string mPath1)
{
try
{
ds1.WriteXml(@mPath1);
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
throw;
}
}

/// <summary>
/// 更改父节点为fNode 第intKey行 strSection属性值为strDefaultValue
/// </summary>
/// <param name="fNode">父节点名称</param>
/// <param name="intKey">行数</param>
/// <param name="strSection">属性名称</param>
/// <param name="strDefaultValue">更改的值</param>
public void SetSetting(string fNode, int intKey, string strSection, string strDefaultValue)
{
try
{
ds.Tables[fNode].Rows[intKey][strSection] = strDefaultValue;
ds.AcceptChanges();
this.SaveSettings(ds,mPath);

}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
throw;
}

}

/// <summary>
/// 在父节点为fNode intKey行添加属性名称strSection 值strDefaultValue
/// </summary>
/// <param name="fNode">父节点名称</param>
/// <param name="intKey">行数</param>
/// <param name="strSection">添加的属性名称</param>
/// <param name="strDefaultValue">属性值</param>
public void AddSettings(string fNode, int intKey, string strSection, string strDefaultValue)
{
try
{
ds.Tables[fNode].Columns.Add(strSection);
ds.Tables[fNode].Rows[intKey][strSection] = strDefaultValue;
ds.AcceptChanges();
this.SaveSettings(ds, mPath);
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
throw;
}
}

/// <summary>
/// 删除父节点为fNode下的属性值strSection
/// </summary>
/// <param name="fNode"></param>
/// <param name="strSection"></param>
public void DeleteSettings(string fNode, string strSection)
{
try
{
ds.Tables[fNode].Columns.Remove(strSection);
ds.AcceptChanges();
this.SaveSettings(ds, mPath);
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
throw;
}
}
}

hexiaoyulee 2008-07-09