?? admin_user.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 name="";
String userpassword="";
String usertype="";
int pageLine=20;
int intPageCount=0;
int totalRec=0;
int intPage=1;
int i;
boolean sign=false;
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'>
function check_submit(type)
{
if(type==1){
document.login_form.action="foundmessage_user.jsp";
document.login_form.submit();
}
if(type==2){
document.login_form.action="modify1_user.jsp";
document.login_form.submit();
}
if(type==3){
document.login_form.action="add_user.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>
<INPUT id=name style="WIDTH: 125px" name="name">
</TD>
</TR>
<tr>
<TD colSpan=2 height=30 align="center"> </td>
</tr>
<TR>
<TD colSpan=2 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)">
<input type="button" name="manager" value="號段管理" onClick="check_submit(5)">
</TD>
</TR>
</FORM>
</TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=760 border=0>
<TR bgColor=#f1fbcd>
<TD vAlign=bottom align=left height=11>
<IMG height=11 src="image/jiao_c2.gif" width=11>
</TD>
<TD vAlign=bottom align=right>
<IMG style="FILTER: fliph" height=11 src="image/jiao_c2.gif" width=11>
</TD>
</TR>
</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="70%"表cellpadding="0" cellspacing="0" border="1" bgcolor="#FFCCCC">
<!--DWLayoutTable-->
<tr>
<td width="105" height="34" valign="middle"><strong><font color="#990000">用戶名</font></strong></td>
<td width="146" valign="middle"> <div align="center"><strong><font color="#990000">密碼</font></strong></div></td>
<td width="104" valign="middle"> <div align="center"><strong><font color="#990000">用戶類型</font></strong></div></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 userinfo";
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="";
sqlt="select * from userinfo";
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()){
name = rs.getString("name");
name=new String(name.getBytes("ISO-8859-1"),"gb2312");
userpassword = rs.getString("userpassword");
System.out.print(userpassword);
userpassword=new String(userpassword.getBytes("ISO-8859-1"),"gb2312");
usertype=rs.getString("usertype");
%>
<tr>
<td height="22" valign="middle"><a href="foundmessage_user.jsp?name=<%=name%>"><%=name%></a></td>
<td valign="middle"> <div align="center"><%=userpassword%></div></td>
<td valign="middle"> <div align="center"><%=usertype%></div></td>
<td width="148" align="center" valign="middle"><a href="modify1_user.jsp?name=<%=name%>">修 改</a> <a href="delete_user.jsp?name=<%=name%>">刪 除</a></td>
</tr>
<tr>
<td height="2"></td>
<td></td>
<td></td>
<td></td>
<td width="7"></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='admin_user.jsp'>");
out.print("<p align='left'>>>分頁 ");
if(intPage<2)
out.print("首頁 上一頁 ");
else{
out.print("<a href='admin_user.jsp?page=1'>首頁</a> ");
out.print("<a href='admin_user.jsp?page="+(intPage-1)+"'>上一頁</a> ");
}
if(intPage-intPageCount>=0)
out.print("下一頁 尾頁");
else{
out.print("<a href='admin_user.jsp?page="+(intPage+1)+"'>下一頁 </a>");
out.print("<a href='admin_user.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 + -