?? shouji.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="org.zhengmao.soft.*" %>
<%@ include file="check.jsp" %>
<html><head>
<title>飛越ip-手機地址查詢_修訂版</title>
<link rel="stylesheet" href="oa.css">
<script language=javascript src="MM_script"></script>
<SCRIPT LANGUAGE=javascript>
<!--
var SubmitFlag = false;
function IsAllNumber(strs){
var test = true;
for(var j=0;j<strs.length&&test;j++){
if(strs.substring(j,j+1) != "0"&&
strs.substring(j,j+1) != 1&&
strs.substring(j,j+1) != 2&&
strs.substring(j,j+1) != 3&&
strs.substring(j,j+1) != 4&&
strs.substring(j,j+1) != "5"&&
strs.substring(j,j+1) != "6"&&
strs.substring(j,j+1) != "7"&&
strs.substring(j,j+1) != "8"&&
strs.substring(j,j+1) != "9")
test =false;
}
return test;
}
function onBtnSubmit(form){
if(form.number.value==""){
alert("請輸入數(shù)據(jù)！");
return false;
}
if(form.number.value.length<11){
alert("請正確輸入數(shù)據(jù)！");
return false;
}
if(!IsAllNumber(form.number.value)){
alert("請輸入正確數(shù)據(jù)！");
return false;
}
return true;
}
function onIpSubmit(form){
if(!IsAllNumber(form.ip1.value) ||!IsAllNumber(form.ip4.value)
||!IsAllNumber(form.ip2.value) ||!IsAllNumber(form.ip3.value)){
alert("請輸入正確數(shù)據(jù)！");
return false;
}
form.ip1.value = addZero(form.ip1.value);
form.ip2.value = addZero(form.ip2.value);
form.ip3.value = addZero(form.ip3.value);
form.ip4.value = addZero(form.ip4.value);
return true;
}
function addZero(str){
switch(str.length){
case 1:
str = "00"+str;
break;
case 2:
str = "0"+str;
break;
case 3:
str = str;
break;
default:
str = str.substring(0,3);
break;
}
return str;
}
//-->
</SCRIPT>
</head>
<body bgcolor=#d6d3ce oncontextmenu=self.event.returnValue=false;showmenu() >
<%@ include file="rightmenu.jsp" %>
<%
String kind="";
if(request.getParameter("kind")!=null){
kind = request.getParameter("kind");
}
String sql;
if(kind.compareTo("shouji")==0){
if( request.getParameter("number") != null){
String number = request.getParameter("number").trim();
int tmpnum = Integer.parseInt(number.substring(0,7));
sql = "select * from shouji where start <= "+tmpnum+" and ends>="+tmpnum;
sqlbean.executeQuery(sql);
if(sqlbean.next()){
%>
<div align=center>
<center>
<table border=1 cellpadding=4 style='BORDER-COLLAPSE: collapse' bordercolor=#0092f2 width=100% id="AutoNumber1">
<tr>
<td width='100%' colspan=2 align=middle background="pics/b1.gif" height=22 class=tdc1>搜索結(jié)果:</td>
</tr>
<tr>
<td width='28%' align=middle height=22 bgcolor=#eff1f3 class=tdc>你要搜索的手機號碼:</td>
<td width='75%' align=middle height=22 bgcolor=#eff1f3 class=tdc><%=number%></td>
</tr>
<tr>
<td width='28%' align=middle height=22 bgcolor=#eff1f3 class=tdc>所在地址:</td>
<td width='75%' align=middle height=22 bgcolor=#eff1f3 class=tdc><%=sqlbean.getString("city")%></td>
</tr>
<tr>
<td width='28%' align=middle height=22 bgcolor=#eff1f3 class=tdc>區(qū)號和描述:</td>
<td width='75%' align=middle height=22 bgcolor=#eff1f3 class=tdc><%=sqlbean.getString("detail")%></td>
</tr>
</table>
</center>
</div>
<p>
<% }else{ %>
<div align=center>
<center>
<table border=1 cellpadding=4 style='BORDER-COLLAPSE: collapse' bordercolor=#0092f2 width=500 id="AutoNumber1">
<tr>
<td width='100%' colspan=2 align=middle background="pics/b1.gif" height=22 class=tdc1>搜索結(jié)果:</td>
</tr>
<tr>
<td width='28%' align=middle height=22 bgcolor=#eff1f3 class=tdc>你要搜索的手機號碼:</td>
<td width='75%' align=middle height=22 bgcolor=#eff1f3 class=tdc><%=number%></td>
</tr>
<tr>
<td width='28%' align=middle height=22 bgcolor=#eff1f3 class=tdc>查詢結(jié)果:</td>
<td width='75%' align=middle height=22 bgcolor=#eff1f3 class=tdc>沒有找到！！</td>
</tr>
</table>
</center>
</div>
<%
}
}
}else if(kind.compareTo("ip")==0){
if( request.getParameter("ip1") != null){
String number1 = request.getParameter("ip1").trim();
String number2 = request.getParameter("ip2").trim();
String number3 = request.getParameter("ip3").trim();
String number4 = request.getParameter("ip4").trim();
String number = number1+"."+number2+"."+number3+"."+number4;
sql="select * from ipaddr where start<='"+number+"' and ends>='"+number+"' and left(start,3)='"+number1+"' and left(ends,3)='"+number1+"' and mid(start,5,3)='"+number2+"' and '"+number2+"'=mid(ends,5,3) and mid(start,9,3)='"+number3+"' and '"+number3+"'=mid(ends,9,3)";
sqlbean.executeQuery(sql);
if(sqlbean.getTotalNum()<1){
sql="select * from ipaddr where start<='"+number+"' and ends>='"+number+"' and left(start,3)='"+number1+"' and left(ends,3)='"+number1+"' and mid(start,5,3)='"+number2+"' and '"+number2+"'=mid(ends,5,3)";
sqlbean.executeQuery(sql);
if(sqlbean.getTotalNum()<1){
sql="select * from ipaddr where start<='"+number+"' and ends>='"+number+"' and left(start,3)='"+number1+"' and left(ends,3)='"+number1+"'";
sqlbean.executeQuery(sql);
if(sqlbean.getTotalNum()<1){
sql="select * from ipaddr where start<='"+number+"' and ends>='"+number+"'";
sqlbean.executeQuery(sql);
}
}
}
//out.println(sql);
if(sqlbean.next()){
%>
<div align=center>
<center>
<table border=1 cellpadding=4 style='BORDER-COLLAPSE: collapse' bordercolor=#0092f2 width=500 id="AutoNumber1">
<tr>
<td width='100%' colspan=2 align=middle background="pics/b1.gif" height=22 class=tdc1>搜索結(jié)果:</td>
</tr>
<tr>
<td width='28%' align=middle height=22 bgcolor=#eff1f3 class=tdc>你要搜索的IP地址:</td>
<td width='75%' align=middle height=22 bgcolor=#eff1f3 class=tdc><%=number%></td>
</tr>
<tr>
<td width='28%' align=middle height=22 bgcolor=#eff1f3 class=tdc>所在地區(qū):</td>
<td width='75%' align=middle height=22 bgcolor=#eff1f3 class=tdc><%=sqlbean.getString("country")%></td>
</tr>
<tr>
<td width='28%' align=middle height=22 bgcolor=#eff1f3 class=tdc>詳細描述:</td>
<td width='75%' align=middle height=22 bgcolor=#eff1f3 class=tdc><%=sqlbean.getString("local")%></td>
</tr>
</table>
</center>
</div>
<p>
<% } else{ %>
<div align=center>
<center>
<table border=1 cellpadding=4 style='BORDER-COLLAPSE: collapse' bordercolor=#0092f2 width=500 id="AutoNumber1">
<tr>
<td width='100%' colspan=2 align=middle background="pics/b1.gif" height=22 class=tdc1>搜索結(jié)果:</td>
</tr>
<tr>
<td width='28%' align=middle height=22 bgcolor=#eff1f3 class=tdc>你要搜索的IP地址:</td>
<td width='75%' align=middle height=22 bgcolor=#eff1f3 class=tdc><%=number%></td>
</tr>
<tr>
<td width='28%' align=middle height=22 bgcolor=#eff1f3 class=tdc>查詢結(jié)果:</td>
<td width='75%' align=middle height=22 bgcolor=#eff1f3 class=tdc>沒有找到！！</td>
</tr>
</table>
</center>
</div>
<%
}
}
}
%>
<div align=center>
<center>
<table border=1 cellpadding=4 style='BORDER-COLLAPSE: collapse' bordercolor="0092f2" width=500 id="AutoNumber1">
<tr>
<td width='100%' align=center background="pics/b1.gif" height=22 class=tdc1 colspan=2>搜索某一 IP 地址的地理位置</td>
</tr>
<tr>
<td width='28%' align=center height=22 bgcolor=#EFF1F3 class=tdc>請輸入要搜索的IP地址:</td>
<form method="post" action="shouji.jsp" id=form1 name=form1 onsubmit="return SubmitFlag;">
<td width='75%' align=center height=22 bgcolor=#EFF1F3 class=tdc>
<input type=text name="ip1" size=3 class=tdc maxlength=3 value=0>
<input type=text name="ip2" size=3 class=tdc maxlength=3 value=0>
<input type=text name="ip3" size=3 class=tdc maxlength=3 value=0>
<input type=text name="ip4" size=3 class=tdc maxlength=3 value=0>
<input type=hidden name="kind" size="20" value="ip">
<input type=submit value="查 詢" name="B2" class=bdtj onclick="SubmitFlag = onIpSubmit(this.form);">
</td> </form>
</tr>
<tr>
<td width='28%' align=center height=22 bgcolor=#EFF1F3 class=tdc>你當(dāng)前所在的IP:</td>
<td width='75%' align=center height=22 bgcolor=#EFF1F3 class=tdc><%=request.getRemoteAddr()%></td>
</tr>
</table>
</center>
</div>
<div align=center>
</div>
<div align=center>
<center>
<table border=1 cellpadding=4 style='BORDER-COLLAPSE: collapse' bordercolor=#0092f2 width=500 id="AutoNumber1">
<tr>
<td width='100%' align=middle background="pics/b1.gif" height=22 class=tdc1 colspan=2>搜索手機號碼對應(yīng)的地理位置</td>
</tr>
<tr>
<td width='28%' align=middle height=22 bgcolor=#eff1f3 class=tdc>請輸入要搜索的號碼:</td>
<form method="post" action="shouji.jsp" onsubmit="return SubmitFlag;" id=form2 name=form2>
<td width='75%' align=middle height=22 bgcolor=#eff1f3 class=tdc>
<input name="number" class=tdc >
<input type=hidden name="kind" value="shouji">
<input type=submit value="查 詢" name="B1" class=bdtj onclick="SubmitFlag = onBtnSubmit(this.form);">
</td> </form>
</tr>
</table>
</center>
</div>
</BODY></HTML>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -