ip地址库

最新推荐文章于 2025-10-21 08:21:57 发布

原创最新推荐文章于 2025-10-21 08:21:57 发布 · 661 阅读

0 ·

CC 4.0 BY-SA版权

IP2Location地址库
https://download.youkuaiyun.com/download/swolf418/12186884

JAVA将字符串表示的ip地址转换为long表示

/**
   * 将字符串表示的ip地址转换为long表示.
   *
   * @param ip ip地址
   * @return 以32位整数表示的ip地址
   */
   public static final long ip2Long(final String ip) {
       if (!RegexpUtils.isExactlyMatches("(\\d{1,3}\\.){3}\\d{1,3}", ip)) {
           throw new IllegalArgumentException("[" + ip + "]不是有效的ip地址");
       }
       final String[] ipNums = ip.split("\\.");
       return (Long.parseLong(ipNums[0]) << 24)
               + (Long.parseLong(ipNums[1]) << 16)
               + (Long.parseLong(ipNums[2]) << 8)
               + (Long.parseLong(ipNums[3]));

}

https://blog.youkuaiyun.com/testcs_dn/article/details/38585653

纯真ip数据库
http://www.cz88.net/ip/
解析方式
https://www.pianshen.com/article/973866234/

导入csv到数据库
mysql> load data infile '/var/lib/mysql-files/文件.csv' into table mytable fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\n';