?? findmessage_admin.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="";
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();
}
}
</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="42%" align=right noWrap class=ygw style="FONT-SIZE: 12px; COLOR: #339900; LINE-HEIGHT: 24px">號 段:</TD>
<TD colspan="2" align=left noWrap class=ygw style="FONT-SIZE: 12px; COLOR: #339900; LINE-HEIGHT: 24px"><input id=number style="WIDTH: 125px" name="number"></TD>
<TD width="38%" align="left" vAlign=top>
<a href="admin_data.jsp">數據管理</a>
<a href="admin_user.jsp">用戶管理</a>
</TD>
</TR>
<tr>
<TD height=30 colspan="2" align="left">
<a href="findmessage_high_province.jsp">按省份查詢</a>
<a href="findmessage_high_mobile.jsp">號段匹配查詢</a>
</td>
</tr>
<TR>
<TD colSpan=4 height=30 align="center">
<input type="button" name="chaxun" value="查 詢" onClick="check_submit(1)">
<input type="button" name="xiugai" value="修 改" onClick="check_submit(2)">
<input type="button" name="tianjia" value="添 加" onClick="check_submit(3)">
<input type="button" name="shanchu" value="刪 除" onClick="check_submit(4)">
</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>
<%
try{
Connection con=DriverManager.getConnection(url,user,psw);
Statement stm=con.createStatement();
String sql="select count(*) as cnt from number_info";
ResultSet countrs=stm.executeQuery(sql);
if(countrs.next())
totalRec=countrs.getInt("cnt");
countrs.close();
stm.close();
intPageCount=(totalRec+pageLine-1)/pageLine;
stm=con.createStatement();
String sqlt="select * from number_info";
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");
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 + -