获取IP地址,由IP地址获得用户地理位置

最新推荐文章于 2021-10-14 21:20:20 发布

转载最新推荐文章于 2021-10-14 21:20:20 发布 · 404 阅读

文章标签：

#string #数据库 #null #user

c# 专栏收录该内容

26 篇文章

订阅专栏

本文介绍了一种通过IP地址获取用户地理位置的技术实现方案。包括从HTTP请求中获取客户端IP地址的方法及利用数据库匹配IP地址对应的地理位置信息。

#region 获取IP地址,由IP地址获得用户地理位置
   /// <summary>
   /// 获取IP地址
   /// </summary>
   static public string IPAddress
   {
    get
    {
     string userIP;
     // HttpRequest Request = HttpContext.Current.Request;
     System.Web.HttpRequest Request = System.Web.HttpContext.Current.Request;
     // 如果使用代理，获取真实IP
     if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != "")
      userIP = Request.ServerVariables["REMOTE_ADDR"];
     else
      userIP = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
     if (userIP == null || userIP == "")
      userIP = Request.UserHostAddress;
     return userIP;
    }
   }
   /// <summary>
   /// 由IP地址获得用户地理位置
   /// </summary>
   /// <param name="IP">ＩＰ地址</param>
   /// <param name="MDBMapPath">存放ＩＰ地址的数据库物理地址</param>
   /// <returns></returns>
   static public   string IPGetAddress(string IP ,string MDBMapPath)
   {
    string str="";
    string   strConnection="provider=Microsoft.jet.OLEDB.4.0;data Source="+MDBMapPath+";";

    OleDbConnection conn=new OleDbConnection (strConnection);

    conn.Open();
    OleDbCommand comm=new OleDbCommand("select top 1 * from IPAddress where ip1<= '"+IP+"' and ip2 >='"+IP+"' ORDER BY ID DESC",conn);
    OleDbDataReader sdr=comm.ExecuteReader();
    if(sdr.Read())
    {
     str=sdr[3].ToString();
    }
    else
    {
     str="未知地址";
    }
    sdr.Close();
    conn.Close();
    return str;

   }
   /// <summary>
   /// 由IP地址获得用户地理位置
   /// </summary>
   /// <param name="IP">ＩＰ地址</param>
   /// <returns></returns>
   static public string IPGetAddress(string IP)
   {
       //server=.;database=DLJOB;uid=sa;pwd=
    string str="";
    string strConnection="user id=sa;password=;initial catalog=DLJOB;Server=.;Connect Timeout=30";

    // string   strConnection="provider=Microsoft.jet.OLEDB.4.0;data Source="+System.Web.HttpContext.Current.Server.MapPath("/_mdb/IPAddress.mdb")+";";
    SqlConnection conn=new SqlConnection(strConnection);
    conn.Open();
    SqlCommand comm=new SqlCommand("select top 1 * from IPAddress where ip1<= '"+IP+"' and ip2 >='"+IP+"' ORDER BY ID DESC",conn);
    //comm.Parameters.Add("@IP",OleDbType.WChar).Value=IP;
    SqlDataReader sdr=comm.ExecuteReader();
    if(sdr.Read())
    {
     str=sdr[3].ToString();
    }
    else
    {
     str="未知地址";
    }
    sdr.Close();
    conn.Close();
    return str;

}
#endregion