admin.jsp
来自「java + sqlserver2000编写的一个网上购书系统,实现了一些基本的」· JSP 代码 · 共 126 行
JSP
126 行
<%@ page language="java" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DB2" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<head>
<script language=javascript src="../function/admin.js"></script>
<link rel="stylesheet" type="text/css" href="../css/admin.css">
</head>
<BODY BGCOLOR="#FFCCCC">
<TABLE class=navi cellSpacing=1 align=center border=0>
<TBODY >
<TR>
<TH colSpan=2>当前位置：系统管理>>管理员管理</TH>
</TR>
<TR>
<td align=right>[所有管理员] [<A href="index.jsp">回首页</A>]</td>
</TR>
</TBODY>
</TABLE>
<%
try{
int PageSize=5;
int CurPage=1;
ResultSet rs2=null;
int TotalPage=1;
int total=0;
if(request.getParameter("page")!=null)
{
CurPage=Integer.parseInt(request.getParameter("page"));
}
String strsql="select count(*) as recordcount from admin";
rs2=DB2.executeQuery(strsql);
rs2.next();
total=rs2.getInt("recordcount");
if(total % PageSize==0)
TotalPage=total/PageSize;
else
TotalPage=(total/PageSize)+1;
int count=0;
int Start=(CurPage-1)*PageSize;
rs2=null;
String sql2="select * from admin";
rs2=DB2.executeQuery(sql2);
out.print("<table class=\"list\" align=\"center\" border=\"0\" cellpadding=\"5\" cellspacing=\"1\" bgcolor=\"#FFFFFF\" style=\"font-size=12px\" margin-top=\"10px\" width=\"700px\">");
out.print(" <br> ");
out.print("<tr bgcolor=\"#006FDD\"><th>ID</th><th>管理员姓名</th><th>密码</th><th>性别</th><th>电话</th><th>E-mail</th><th>操作</th></tr>");
%>
<form method="post" name="checkform" >
<%
if(Start!=0) { rs2.absolute(Start); }
while(rs2.next())
{
out.print("<tr bgcolor=\"#9DCEFF\"><td>"+(rs2.getInt("AdminID"))+
"</td><td>"+(rs2.getString("AdminName"))+"</td><td><input type='password' class=text1 size='5' value=" +(rs2.getString("AdminPass"))+"></td><td>"+(rs2.getString("Sex"))+
"</td><td>"+(rs2.getString("Telephone"))+"</td><td>"+(rs2.getString("Email"))+
"</td><td align=center> <input type='checkbox' name=check"+rs2.getString("AdminID")+" value="+(rs2.getString("AdminID"))+"></td></tr>");
count++;
if(count==PageSize){
break;}
}%>
<TABLE align=center style="width:700px;">
<tr><td> </td></tr>
<TR>
<TD style="margin-top:30px; text-align:center; font-size:14px; ">
<%
if(CurPage==1){
if(CurPage==TotalPage){
out.println("首页 上一页 下一页 尾页");
}else{
out.println("首页 上一页 <a href='#' onclick='javascript:gotoPagenext("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPagenext("+TotalPage+")'>尾页</a>");
}
}else{
if(CurPage==TotalPage){
out.println("<a href='#' onclick='javascript:gotoPagenext(1)'>首页</a> <a href='#' onclick='javascript:gotoPagenext("+(CurPage-1)+")'> 上一页</a> 下一页 尾页");
}else{
out.println("<a href='#' onclick='javascript:gotoPagenext(1)'>首页</a> <a href='#' onclick='javascript:gotoPagenext("+(CurPage-1)+")'> 上一页</a> <a href='#' onclick='javascript:gotoPagenext("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPagenext("+TotalPage+")'>尾页</a>");
}
}
%></TD>
<td style="margin-top:10px; text-align:center; font-size=14px">
<%
out.print("跳转到第");
out.println("<select size=1 name=\"page\" onChange=\"gotoPagenext(this.value)\">");
for(int i=1;i<=TotalPage;i++)
{
String selectAdd=(i==CurPage)?" selected":"";
out.println("<option value='"+i+"' "+selectAdd+"> "+i+" </option>");
}
out.println("</select>");
out.print("页");
%></td>
<td> </td>
<td style="margin-top:10px text-align:center "> <input type="button" name="Submit" value="全选" onclick="check()" /> <input type="button" name="Submit" value="反选" onclick="check2()" /> </td>
<td >
<input type="button" name="delete" value="删除选中项" style="margin-top:0px" onClick="return admindele();">
<input type="button" name="updata" value="修改选中项" style="margin-top:0px" onClick="updata1()" >
</td>
</TR>
</TABLE>
</form>
<% out.print("<form action='admin_add.jsp' name=addform method=post onsubmit='return admintian()'>");
out.print("<br>"+"<hr color=\"#0033FF\">");
out.print("<table class=\"list\" align=\"center\" border=\"0\" cellpadding=\"5\" cellspacing=\"1\" bgcolor=\"#ffffff\" style=\"font-size=12px\" margin-top=\"10px\" margin-left=\"200px\" width=600px;>");
out.print("<br>");
out.print("<tr bgcolor=\"#006FDD\" ><th>管理员姓名</th><th>密码</th><th>性别</th><th>电话</th><th>E-mail</th><th>管理员照片</th><th>操作</th></tr>");
out.print("<tr bgcolor=\"#9DCEFF\"><td><input type="+"text"+
" name=text1 size=11></td><td><input type="+"password"+
" name=password2 size=11></td><td><input type="+"text"+
" name=text3 size=11></td><td><input type="+"text"+
" name=text4 size=11></td><td><input type="+"text"+
" name=text5 size=11></td><td><input type="+"text"+
" name=text6 size=11></td><td><input type="+"image"+
" name=add src="+"../images/add.gif"+" ></td></tr>");
out.print("</table>");
out.print("</form>");
}catch(SQLException e){out.print(e);}
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?