📄 su_del_gz_result.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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>
<style type="text/css">
<!--
.style1 {color: #CC33FF}
-->
</style>
</head>
<body>
<%@ include file="/commond/conn.jsp"%>
<%
String[] todel=request.getParameterValues("todel");
if(todel!=null)
{for(int i=0;i<todel.length;i++)
{String condition="DELETE FROM MANAGER where ID="+"'"+todel[i]+"'";
rs=sql.executeQuery(condition);
}
}else{
out.print("<SCRIPT language=JavaScript>alert('请您先选择要删除的用户！');");
out.print("javascript:history.go(-1)</SCRIPT>");
}
%>
<div align="center">
<h1 align="center" class="style1">现有工资管理员列表</h1>
<p> </p>
<% int leave=0;
sql=con.createStatement();
String condition="SELECT * FROM MANAGER ORDER BY TYPE";
rs=sql.executeQuery(condition);
%>
</p>
<table width="600" border="1" cellspacing="0" cellpadding="0">
<tr bgcolor="#CC99FF">
<th scope="col">用户名</th>
<th scope="col">密码</th>
<th scope="col">类型</th>
<th scope="col">部门</th>
</tr>
<%while(rs.next())
{leave++;%>
<tr>
<td><div align="center"><%=rs.getString("ID")%></div></td>
<td><div align="center"><%=rs.getString("PWD")%></div></td>
<td><div align="center"><%=rs.getString("TYPE")%></div></td>
<td><div align="center"><%=rs.getString("BM")%></div></td>
</tr>
<%}%>
<%if(leave==0){out.print("<tr bgcolor=#CCCCFF><td height=30 colspan=6><div align=center>当前无记录</div></td></tr> ");}%>
</table>
<p></p>
<p><span class="style2"><a href="su_del_gz.jsp">继续删除</a></span> <span class="style2"><a href="../index/su_index.jsp">返回主页</a></span></p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -