📄 userlist.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="UTF-8"%>
<%@page import="com.record.connectionDataBase.ConnectionDataBase,java.sql.Connection,java.sql.ResultSet,java.sql.Statement,javax.naming.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>新建网页</title>
<meta http-equiv="content-type" content="text/html; charset=gb2312" />
<meta http-equiv="Content-Language" content="zh-CN" />
<meta name="robots" content="all" />
<meta name="author" content="WanfuZheng | www.52ay.com" />
<meta name="Copyright" content="Copyright (c) 2000-2005 www.52ay.com" />
<link rel="icon" href="/favicon.ico" type="image/x-icon" media="screen" />
<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon" media="screen" />
<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
<meta name="description" content="网页制作" />
<meta name="keywords" content="e266@163.com,http://blog.46com.com,郑万福(qq:30401653),制作,卧龙工作室,天翼数码,网站制作,Falsh,下载,成都,多媒体制作,asp,jsp,php,sql,mssql,mysql,酷网站,图标,音乐,mp3" />
<style type="text/css">
<!--
-->
</style>
<script language="javascript">
<!--
function checkedAll(ObjForm)
{
var Obj=window.event.srcElement;
for(var i=0;i<ObjForm.elements.length;i++)
{
if(ObjForm.elements[i].type=="checkbox")
{
if(Obj.checked)
{
ObjForm.elements[i].checked=true;
//doSelectTr(ObjForm.elements[i].parentElement)
}
else
{
ObjForm.elements[i].checked=false;
}
}
}
}
function delFunction()
{
var Id="";
k=0;
Obj=document.formObj;
Count=Obj.elements.length;
for(var i=0;i<Count;i++)
{
if(Obj.elements[i].checked && Obj.elements[i].type=="checkbox" && Obj.elements[i].name!="")
{
k++;
if(k==1)
{
Id=Id+Obj.elements[i].value;
}
else
{
Id=Id+","+Obj.elements[i].value;
}
}
}
if(k==0)
{
alert("请选择要删除的数据！")
}
else
{
if(window.confirm("您确认要删除所选数据吗！"))
{
window.location="UserEditAction.jsp?action=delAll&delId="+Id
}
}
}
//-->
</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form name="formObj" method="post" action="" style="margin:0px;" onsubmit="return duSubmit();">
<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC" align="center">
<tr>
<td bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#4881B7">
<tr>
<td height="30" bgcolor="#75AACF" class="white_12_b">列表</td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#4881B7">
<tr>
<td height="20" colspan="6" bgcolor="#75AACF" class="white_12_b"><p>共 1 页 10 条 本页从第 1 条 到第 10 条 </p></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="50" height="25"><input type="checkbox" name="checkAll" value="checkbox" onclick="checkedAll(formObj)" /><b>ID<b></td>
<td bgcolor="#FFFFFF"><b>用户名称</b></td>
<td bgcolor="#FFFFFF"><b>用户权限</b></td>
<td bgcolor="#FFFFFF" width="60"><b>修改</b></td>
<td bgcolor="#FFFFFF" width="60"><b>删除</b></td>
</tr>
<%
ConnectionDataBase connectionDataBase=new ConnectionDataBase();
String sql="select * from admin order by id desc";
Connection conn=connectionDataBase.getConn();
Statement stmt;
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery(sql);
rs.last();
int rowCount=rs.getRow();
if (rowCount==0) {
out.println("当前没有任何留言！");
return;
}
String strCurpage=request.getParameter("page");
int curPage;
if(strCurpage==null){
curPage=1;
}
else{
curPage=Integer.parseInt(strCurpage);
}
int countPerPage=8;
int pageCount=(rowCount+countPerPage-1)/countPerPage;
rs.absolute((curPage-1)*countPerPage+1);
%>
<%
int i=0;
System.out.println(countPerPage);
while(i<countPerPage && !rs.isAfterLast())
{
%>
<tr>
<td bgcolor="#FFFFFF" height="25"> <input name="check" type="checkbox" value="<%=rs.getInt("id") %>" /></td>
<td bgcolor="#FFFFFF"><%=rs.getString("name") %></td>
<td bgcolor="#FFFFFF"><%
if(rs.getString("type").trim().equals("ismanage"))
out.print("<font color=#990066>管理员权限</font>");
else if(rs.getString("type").trim().equals("isuser"))
out.print("普通用户");
%></td>
<td bgcolor="#FFFFFF"><a href="UserEdit.jsp?action=modify&id=<%=rs.getInt("id") %>"><img src="images/edits.gif" width="39" height="18" border="0" /></a></td>
<td bgcolor="#FFFFFF"><a href="UserEditAction.jsp?action=del&id=<%=rs.getInt("id") %>"><img src="images/del.gif" width="39" height="18" border="0" /></a></td>
</tr>
<%
i++;
rs.next();
}
%>
<tr>
<td height="30" colspan="6" bgcolor="#FFFFFF" style="padding-left:7px;">└ <input name="delAll" type="button" value="删除全部" onclick="delFunction();" /></td>
</tr>
</table><br/>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#4881B7">
<tr>
<td height="25" align="right" bgcolor="#FFFFFF">
<%if(curPage==1){ %>
第一页
上一页
<%
}
else
{
%>
<a href="UserList.jsp?page=<%=1%>">第一页</a>
<a href="UserList.jsp?page=<%=curPage-1%>">上一页</a>
<%
}
if(curPage==pageCount)
{
%>
下一页
最后页
<%
}
else
{
%>
<a href="UserList.jsp?page=<%=curPage+1%>">下一页</a>
<a href="UserList.jsp?page=<%=pageCount%>">最后页</a>
<%}
rs.close();
stmt.close();
conn.close();
%>
</td>
</tr>
</table></td>
</tr>
</table>
<div style="margin:3px 0px 0px 0px;">
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF" style="line-height:25px;color:#200000;" align="center"> 技术支持：红侠工作室 电话：13219047747 电子邮件:e266@163.com
<br/>Ropyright2006 四川新华电脑学校 All Rights Reserved </td>
</tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -