📄 findmessage_high.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
if(session.getValue("ID")==null)
response.sendRedirect("indexs.jsp");
String url="jdbc:oracle:thin:@10.0.0.4:1521:ORCL";
String user="mms";
String psw="mms123";
String number="";
String number_address_province="";
String number_address_city="";
String number_type="";
String op_name="";
String op_time="";
String province="";
String sql="";
String sqlt="";
int pageLine=20;
int intPageCount=0;
int totalRec=0;
int intPage=1;
int i;
if(request.getParameter("page")!=null)
intPage=Integer.parseInt(request.getParameter("page"));
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(Exception e){
out.println("没找到数据库驱动！");
e.printStackTrace();
}
%>
<script language="javascript" src="image/regcheckdata.js"></script>
<SCRIPT language='JavaScript'>
function check_submit(type)
{
if(type==1){
document.login_form.action="foundmessage.jsp";
document.login_form.submit();
}
if(type==2){
document.login_form.action="modify1.jsp";
document.login_form.submit();
}
if(type==3){
document.login_form.action="add.jsp";
document.login_form.submit();
}
if(type==4){
document.login_form.action="delete.jsp";
document.login_form.submit();
}
if(type==5){
document.login_form.action="findmessage_admin.jsp";
document.login_form.submit();
}
}
</script>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户登录界面</title>
</head>
<link rel="stylesheet" href="image/cs.css" type="text/css">
<body>
<TABLE style="MARGIN-TOP: 10px" cellSpacing=0 cellPadding=0 width=760 border=0 background="image/jiao_c2.gif" align="center">
<TR>
<TD vAlign=top>
<TABLE style="MARGIN-TOP: 0px" cellSpacing=0 cellPadding=0 width=759 border=0>
<TR bgColor=#b4d14e>
<TD vAlign=top align=left>
<IMG height=28 src="image/jiao_c1.gif" width=11>
</TD>
<TD style="FONT-WEIGHT: bold; FONT-SIZE: 14px; COLOR: #ffffff; LINE-HEIGHT: 24px" width="100%" align="center">手机号段查询系统管理员界面</TD>
<TD vAlign=top align=right>
<IMG style="FILTER: fliph" height=28 src="image/jiao_c1.gif" width=11>
</TD>
</TR>
</TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=760 border=0>
<TR>
<TD width=760 bgColor=#f1fbcd>
<TABLE cellSpacing=0 cellPadding=2 width="90%" border=0>
<TR>
<TD vAlign=bottom height=13></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<TABLE cellSpacing=0 cellPadding=2 width="100%" border=0>
<FORM name=login_form method=post>
<TR>
<TD width="41%" align=right noWrap class=ygw style="FONT-SIZE: 12px; COLOR: #339900; LINE-HEIGHT: 24px">归属地:</TD>
<TD width="59%" align="left" vAlign=top>
<select name="province">
<option value="北京">北京</option>
<option value="天津">天津</option>
<option value="河北">河北</option>
<option value="山西">山西</option>
<option value="内蒙古">内蒙古</option>
<option value="广东">广东</option>
<option value="海南">海南</option>
<option value="香港">香港</option>
<option value="澳门">澳门</option>
<option value="湖南">湖南</option>
<option value="湖北">湖北</option>
<option value="河南">河南</option>
<option value="台湾">台湾</option>
<option value="上海">上海</option>
<option value="江苏">江苏</option>
<option value="浙江">浙江</option>
<option value="安徽">安徽</option>
<option value="山东">山东</option>
<option value="江西">江西</option>
<option value="福建">福建</option>
<option value="重庆">重庆</option>
<option value="四川">四川</option>
<option value="云南">云南</option>
<option value="西藏">西藏</option>
<option value="贵州">贵州</option>
<option value="广西">广西</option>
<option value="宁夏">宁夏</option>
<option value="陕西">陕西</option>
<option value="青海">青海</option>
<option value="甘肃">甘肃</option>
<option value="新疆">新疆</option>
<option value="辽宁">辽宁</option>
<option value="黑龙江">黑龙江</option>
<option value="吉林">吉林</option>
</select>
<a href="out_message.jsp">倒出数据</a>
<a href="in_message.jsp">倒入数据</a>
<a href="admin_user.jsp">用户管理</a>
</TD>
</TR>
<TR>
<TD colSpan=2 height=30 align="center">
<input type="button" name="chaxun" value="查 询" onClick="check_submit(1)">
</TD>
</TR>
</FORM>
</TABLE>
<table width="760" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="760" height="59" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
</table></td>
</tr>
<tr>
<td height="57" valign="top" align="center"><table width="90%"表cellpadding="0" cellspacing="0" border="1" bgcolor="#FFCCCC">
<!--DWLayoutTable-->
<tr>
<td width="68" height="34" valign="middle"><strong><font color="#990000">手机号段</font></strong></td>
<td width="74" valign="middle"> <div align="center"><strong><font color="#990000">省份</font></strong></div></td>
<td width="74" valign="middle"><div align="center"><strong><font color="#990000">城市</font></strong></div></td>
<td width="125" valign="middle"> <div align="center"><strong><font color="#990000">号段类型</font></strong></div></td>
<td width="73" valign="middle"> <div align="center"><strong><font color="#990000">操作员</font></strong></div></td>
<td width="169" align="center" valign="middle"><font color="#990000"><strong>操作日期</strong></font></td>
<td align="center" valign="middle"><font color="#990000"><strong>操作类型</strong></font></td>
</tr>
<%
province=request.getParameter("province");
sql="select count(*) as cnt from number_info where number_address_province='"+province+"'";
sqlt="select * from number_info number_address_province='"+province+"'";
try{
Connection con=DriverManager.getConnection(url,user,psw);
Statement stm=con.createStatement();
ResultSet countrs=stm.executeQuery(sql);
if(countrs.next())
totalRec=countrs.getInt("cnt");
countrs.close();
stm.close();
intPageCount=(totalRec+pageLine-1)/pageLine;
stm=con.createStatement();
ResultSet rs=stm.executeQuery(sqlt);
if(intPageCount>0){
for(i=1;i<=(intPage-1)*pageLine;i++)
rs.next();
for(i=0;i<pageLine;i++){
if(rs.next()){
number = rs.getString("number_id");
number_type=rs.getString("number_type");
number_type=new String(number_type.getBytes("ISO-8859-1"),"gb2312");
op_name=rs.getString("op_name");
op_time=rs.getString("op_time");
number_address_province = rs.getString("number_address_province");
number_address_province=new String(number_address_province.getBytes("ISO-8859-1"),"gb2312");
System.out.print(number_address_province);
number_address_city = rs.getString("number_address_city");
number_address_city=new String(number_address_city.getBytes("ISO-8859-1"),"gb2312");
%>
<tr>
<td height="22" valign="middle"><a href="foundmessage.jsp?number=<%=number%>"><%=number%></a></td>
<td valign="middle"> <div align="center"><%=number_address_province%></div></td>
<td valign="middle"> <div align="center"><%=number_address_city%></div></td>
<td valign="middle"> <div align="center"><%=number_type%></div></td>
<td valign="middle"><%=op_name%></td>
<td align="center" valign="middle"><%=op_time%></td>
<td width="71" align="center" valign="middle"><a href="modify1.jsp?number=<%=number%>">修 改</a> <a href="delete.jsp?number=<%=number%>">删 除</a></td>
</tr>
<tr>
<td height="2"></td>
<td colspan="2"></td>
<td></td>
<td></td>
<td></td>
</tr>
<%
}
}
}
rs.close();
stm.close();
con.close();
}
catch(SQLException e){
e.printStackTrace(System.out);
}
out.print("<font size='2'>");
out.print("<tr>");
if(intPageCount*pageLine<totalRec)
intPageCount++;
if(intPage>intPageCount)
intPage=intPageCount;
if(intPage<1)
intPage=1;
out.print("<form method='POST' name=pageNum action='findmessage_admin.jsp'>");
out.print("<p align='left'>>>分页 ");
if(intPage<2)
out.print("首页 上一页 ");
else
{
out.print("<a href='findmessage_admin.jsp?page=1'>首页</a> ");
out.print("<a href='findmessage_admin.jsp?page="+(intPage-1)+"'>上一页</a> ");
}
if(intPage-intPageCount>=0)
out.print("下一页 尾页");
else
{
out.print("<a href='findmessage_admin.jsp?page="+(intPage+1)+"'>下一页 </a>");
out.print("<a href='findmessage_admin.jsp?page="+intPageCount+"'>尾页</a>");}
out.print(" 页次：<strong><font color=red>"+intPage+"</font>/"+intPageCount+"</strong>页");
out.print(" 共<b>"+totalRec+"</b>条记录<b>"+pageLine+"</b>条/页");
out.print("转到第<input type='text' name='page' size=2 maxlength=10 class=smallInput value="+intPage+">");
out.print("页<input class=buttonface type='submit' value='GO' name='cndok'>");
out.print("</span></p></form>");
out.print("</font>");
%>
</table>
</td>
</tr>
</table>
<br><br><br>
<table cellspacing=0 cellpadding=0 width=606 align=center border=0>
<tr>
<td align=middle>
<script language=JavaScript src="image/bottom.js"></script>
</td>
</tr>
</table>
</TD>
</TR>
</TABLE>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -