📄 usermanage.jsp

📁 毕业设计时做的,一个管理关于污染管理的, 源代码,呵呵想想当时还真厉害,可以实现污染检测
💻 JSP
字号:
<HTML>
<BODY>
<%@ page import="java.util.*, java.sql.*"
         contentType="text/html;charset=GB2312" %>
<%if (session.getAttribute("Name")==null){
	response.sendRedirect("login.html");	
}%>
<%int PageSize=5; //一页显示的记录数 
int RowCount; //记录总数 
int PageCount; //总页数 
int Page; //待显示页码 
int i,j;
String strPage = request.getParameter("page"); 
String type = request.getParameter("type");
String userid = request.getParameter("id");
if (strPage==null){
//表明在QueryString中没有page这一个参数，此时显示第一页数据 
	Page = 1; 
} else{
//将字符串转换成整型 
	Page = Integer.parseInt(strPage); 
	if(Page<1) Page = 1; 
}%>
<jsp:useBean id="pool" scope="application" class="chapter10.ConnPool"/>
<%@ include file="conn.jsp"%>
<%  //判断是否为管理员
  	sql="select IsAdmin from Users where Name='"+session.getAttribute("Name")+"'";
  	ResultSet rs=statement.executeQuery(sql);
  	rs.next();
  	boolean IsAdmin=rs.getBoolean(1);
  	rs.close();%>
<%if (IsAdmin){
	if (type!=null){	
		if (type.equals("delete")){
			sql="delete * from Users where ID="+userid;			
		}else if (type.equals("chadmin")){
			sql="update Users set IsAdmin = not IsAdmin where ID="+userid;
		}else if (type.equals("chdisable")){
			sql="update Users set Disable = not Disable where ID="+userid;
		}
		statement.executeUpdate(sql);
	}
	
	//得到记录总数
	sql="select count(*) from Users";
	rs =statement.executeQuery(sql);
	rs.next();
	RowCount =rs.getInt(1); 
	rs.close();
	
	PageCount = (RowCount+PageSize-1) / PageSize; 	//记算总页数 
	if(Page>PageCount) Page = PageCount; 	//调整待显示的页码
	sql = "select * from Users"; 
	rs = statement.executeQuery(sql);		//执行SQL语句并取得结果集 
	i = (Page-1) * PageSize; 	//将记录指针定位到待显示页的第一条记录上 
	for(j=0;j<i;j++) rs.next(); %> 
<center><h2>用户管理</h2></center>
<center>共有用户<%=RowCount%>名&nbsp&nbsp&nbsp&nbsp
<a href="list.jsp">返回主菜单</a>&nbsp&nbsp<a href="login.html">退出</a></center>
<table border="1" cellspacing="0" cellpadding="0" width=60% align=center> 
<tr><td>编号</td><td>姓名</td><td>是否管理员</td><td>是否被禁用</td><td>删除</td></tr>
<% 
i = 0; 
while(i<PageSize && rs.next()){ 
	String id=rs.getString("ID");
	String name=rs.getString("Name");
	String email=rs.getString("Email");
	boolean isadmin=rs.getBoolean("IsAdmin");
	boolean disable=rs.getBoolean("Disable");%>
<tr> 
<td><%=i%></td>
<td><%=name%></td>
<td>
<%if (isadmin){
	out.print("是");
}else{
	out.print("否");
}%>
&nbsp&nbsp<a href="usermanage.jsp?type=chadmin&id=<%=id%>">更改</a>
</td>
<td>
<%if (disable){
	out.print("是");
}else{
	out.print("否");
}%>
&nbsp&nbsp<a href="usermanage.jsp?type=chdisable&id=<%=id%>">更改</a>
</td>
<td><a href=usermanage.jsp?type=delete&id=<%=id%>>删除</a></td>
</tr>
<% i++; } %>
<tr> 
<td colspan=5 align=center> 
第<%=Page%>页&nbsp&nbsp共<%=PageCount%>页  
<%if(Page<PageCount){%>
<a href="usermanage.jsp?page=<%=Page+1%>">下一页</a><%
}
%>  
<%if(Page>1){%>
<a href="usermanage.jsp?page=<%=Page-1%>">上一页</a><%
}%> 
</td> 
</tr>
</table> 
<%}else{
	response.sendRedirect("login.html");	
}%>
<%@ include file="disconn.jsp"%>
</BODY>
</HTML>
⌨️ 快捷键说明

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