相关文章推荐
腹黑的豆浆  ·  BeanDefinitionOverride ...·  1 年前    · 
下面的程序报的错,求助高手publicstringgetipinfo(stringip){string[]arr=ip.Split('.');stringsql="SELECTaddressFROMipsWHERE(CONVERT(bigint,ipstar)<=CONVERT(bigint,"+arr[0]+"... 下面的程序报的错,求助高手
public string getipinfo(string ip)
{
string[] arr = ip.Split('.');
string sql = "SELECT address FROM ips WHERE (CONVERT(bigint, ipstar) <= CONVERT(bigint," + arr[0] + " * 256 * 256 * 256 + " + arr[1] + " * 256 * 256 + " + arr[2] + " * 256 + " + arr[3] + ")) AND (CONVERT(bigint,ipend) >= CONVERT(bigint, " + arr[0] + " * 256 * 256 * 256 + " + arr[1] + " * 256 * 256 + " + arr[2] + " * 256 + " + arr[3] + "))";
return dc.GetObject(sql).ToString();
}
传入参数122.224.115.190这个没报错,202.160.180.78这个就报错了