📄 adminuser.jsp

📁 新闻发布系统
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="getadminsession.jsp"%>
<%
request.setCharacterEncoding("GB2312");
%>
<jsp:useBean id="adminuser" scope="page" class="dsp.database.Operation"/>
<%
//总记录数
int totalRecord = 0; 
//当前页 
int currPage = 1; 
//页面大小
int pageSize = 10;
//页数 
int pageCount = 0; 
//每页第一条记录号
int offset = 1; 

String sql = "SELECT * FROM web_admin ORDER BY id ASC";

ResultSet rs = adminuser.query(sql);
totalRecord = adminuser.totalRecord(rs);

pageCount = ((totalRecord % pageSize) == 0)?(totalRecord/pageSize) : (totalRecord/pageSize) + 1;
 
String p = request.getParameter("page");
if(p != null && p != ""){
	currPage = Integer.parseInt(p);
	offset = (currPage - 1) * pageSize + 1;
}

String ctrl = adminuser.showPages(currPage, pageSize, pageCount, "adminuser.jsp?");
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="inc/admin.css" rel="stylesheet" type="text/css">
<script>
function DelUser_check(id,user)
{
	var ok;
	ok=confirm("您是确定要删除【"+user+"】吗？");
	if(ok)
	{
		self.location.href="deluser.jsp?id="+id;
	}
}
</script>
</head>

<body>
<table width="95%" border="1" cellspacing="0" cellpadding="3" align="center" bordercolorlight="#ECEEE4" bordercolordark="#CCCABC">
  <tr> 
    <td colspan="4" align="center" height="30" background="images/tablebg.gif"><b>管 
      理 用 户 </b> </td>
  </tr>
  <tr valign="middle"> 
    <td height="25" colspan="4" align="center"><%=ctrl%></td>
  </tr>
  <tr valign="middle"> 
    <td width="13%" height="25" align="center">ID</td>
    <td width="25%" height="25" align="center">用户名</td>
    <td width="28%" height="25" align="center">管理级别</td>
    <td width="34%" height="25" align="center">操作</td>
  </tr>
<%
int id;
String user="";
while((offset <= pageSize*currPage) && (offset <= totalRecord))
{
	rs.absolute(offset);
	id = rs.getInt("id");
	user = rs.getString("username");
%>
    <tr valign="middle"> 
      <td height="25" align="center"><%=id%></td>
      <td height="25" align="center"><%=user%></td>
      <td height="25" align="center"><%=((rs.getInt("flag")==1)?"管理员":"录入员")%></td>
      <td height="25" align="center">【<a href="modpass.jsp?id=<%=id%>">修改密码</a>】【<a onclick="javascript:DelUser_check(<%=id%>,'<%=user%>')" class=A>删 除</a>】</td>
    </tr>
<%
	offset ++;
}
%>
  <tr valign="middle"> 
    <td height="25" colspan="4" align="center"><%=ctrl%></td>
  </tr>
</table>
 <%@include file="copyright.jsp"%> 
</body>
</html>
<%
adminuser.closestmt();
adminuser.closeconn();
%>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -