IP2Location地址库
https://download.csdn.net/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.csdn.net/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';