/**
* IP处理类
*/
import java.sql.*;
public class IPDeal {
/**
* 通过ip地址查询地区名称
* @param strip
* @return ip所在地区名称
*/
public static String
getArea(String strip){
Connection conn =
null;
PreparedStatement pstmt =
null;
String sql;
String strRtn =
null;
try{
MyJdbc myjdbc =
new MyJdbc();
conn = myjdbc.getConn();
sql =
"select * from fullip where startip<='" + strip +
"' and endip>='" + strip +
"'";
pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
if(rs.next()){
strRtn = rs.getString(
"country");
}
else{
strRtn =
"未确定";
}
rs.close();
rs =
null;
}
catch(Exception e){
e.printStackTrace();
}
finally{
if (pstmt !=
null)
try{
pstmt.close();
pstmt =
null;
}
catch(Exception e){}
if (conn !=
null)
try{
conn.close();
conn =
null;
}
catch(Exception e){}
}
return strRtn;
}
/**
* 把ip地址格式化为：000.000.000.000
* @param ip
* @return 返回规格ip
*/
public static String
strfullip(String ip){
StringBuffer buff =
new StringBuffer();
buff.append(
"");
String strzero =
"000";
int ilen =
0;
if(ip !=
null){
String[] arrip = ip.split(
"\\.");
if(arrip.length ==
4){
for(
int i =
0; i <
4; i++){
if (i==
0){
ilen = arrip[i].length();
if(ilen <
3){
buff.append(strzero.substring(
0,
3-ilen)).append(arrip[i]);
}
else{
buff.append(arrip[i]);
}
}
else{
ilen = arrip[i].length();
if(ilen <
3){
buff.append(
".").append(strzero.substring(
0,
3-ilen)).append(arrip[i]);
}
else{
buff.append(
".").append(arrip[i]);
}
}
}
}
}
return buff.toString();
}
/**
* @param args
*/
public static void main(String[] args) {
String strip =
"202.108.33.32";
System.out.println(IPDeal.strfullip(strip));
System.out.println(System.currentTimeMillis());
System.out.println(
"ip" + strip +
"所在地区：" + IPDeal.getArea(IPDeal.strfullip(strip)));
System.out.println(System.currentTimeMillis());
}
}
转载于:https://www.cnblogs.com/bilaisheng/p/10210969.html
相关资源：JAVA上百实例源码以及开源项目
