📄 70a3d1a3dde1001d17caf3c64da235bc
字号:
<%@ page contentType="text/html; charset=gb2312" language="java"
import="javabean.*"
import="java.util.*"
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>
</head>
<body>
<form name="form1" method="post" action="">
<%
String strPower = (String)session.getAttribute("user_power");
String strNum = request.getParameter("number");
int nTable = 4;
if(strNum != null && strNum != "")
nTable = Integer.parseInt(strNum);
//System.out.println(strPower);
if(nTable == 2){
%>
<table width="500" border="2" cellpadding="1" cellspacing="1" bordercolor="#999999">
<tr>
<td bgcolor="#00CCFF">ID</td>
<td bgcolor="#00CCFF">职工姓名</td>
<td bgcolor="#00CCFF">购买物品</td>
<td bgcolor="#00CCFF">购买数量</td>
<td bgcolor="#00CCFF">购买时间</td>
<td bgcolor="#00CCFF">购买地址</td>
<%if(strPower.equals("2")) {%>
<td bgcolor="#00CCFF">操作</td>
<%} %>
</tr>
<%
ArrayList stalist = (ArrayList)session.getAttribute("stalist");
if(stalist == null)
stalist = new ArrayList();
for(int i=0;i<stalist.size(); i++){
StaffBean sta = (StaffBean)stalist.get(i);
%>
<tr>
<td><%=sta.getBuyId() %></td>
<td><%=sta.getBuyName() %></td>
<td><%=sta.getBuyGoods() %></td>
<td><%=sta.getBuyCount() %></td>
<td><%=sta.getBuyDate() %></td>
<td><%=sta.getBuyAddr() %></td>
<%if(strPower.equals("2")) {%>
<td><a href = "updatesta.jsp?id=<%=sta.getBuyId() %>">修改</a>|<a href = "./DelSta?id=<%=sta.getBuyId()%>">删除</a></td>
<%} %>
</tr>
<%}
%>
</table>
<%
}
else if(nTable == 1){
%>
<table width="500" border="2" cellpadding="1" cellspacing="1" bordercolor="#999999">
<tr>
<td bgcolor="#00CCFF"><center>
<span class="STYLE1">用户ID</span>
</center></td>
<td bgcolor="#00CCFF"><center>
<span class="STYLE1">用户名</span>
</center></td>
<td bgcolor="#00CCFF"><center>
<span class="STYLE1">权限</span>
</center></td>
<%if(strPower.equals("2")) {%>
<td bgcolor="#00CCFF"><center>
<span class="STYLE1">操作</span>
</center></td>
<%} %>
</tr>
<%
UserBean user = new UserBean();
ArrayList userlist = (ArrayList)session.getAttribute("userlist");
if(userlist == null)
userlist = new ArrayList();
for(int i = 0;i<userlist.size();i++){
user = (UserBean)userlist.get(i);
%>
<tr bgcolor="#FFFFFF">
<td><%=user.getUserId() %></td>
<td><%=user.getUserName() %></td>
<td><%=user.getUserPower() %></td>
<%if(strPower.equals("2")){ %>
<td><a href = "updateuser.jsp?id=<%=user.getUserId() %>">修改</a>|<a href = "./DelUser?id=<%=user.getUserId()%>">删除</a></td>
<%} %>
</tr>
<%
}
%>
</table>
<%
}
else if(nTable == 3){
%>
<table width="500" border="2" cellpadding="1" cellspacing="1" bordercolor="#999999">
<tr>
<td bgcolor="#00CCFF"><center>
<span class="STYLE1">用户ID</span>
</center></td>
<td bgcolor="#00CCFF"><center>
<span class="STYLE1">用户名</span>
</center></td>
<td bgcolor="#00CCFF"><center>
<span class="STYLE1">权限</span>
</center></td>
<%if(strPower.equals("2")) {%>
<td bgcolor="#00CCFF"><center>
<span class="STYLE1">操作</span>
</center></td>
<%} %>
</tr>
<%
Connect test = new Connect();
Connection conn = test.getConnect();
ResultSet rs = null;
Statement stmt = null;
stmt = conn.createStatement();
rs = stmt.executeQuery("select user_id,user_name,user_pwd,power_name from Users,Power where user_power = power_id");
while(rs.next()){
String strId = rs.getString("user_id");
%>
<tr bgcolor="#FFFFFF">
<td><%=strId %></td>
<td><%=rs.getString("user_name") %></td>
<td><%=rs.getString("power_name") %></td>
<%if(strPower.equals("2")) {%>
<td><a href = "updateuser.jsp?id=<%=strId %>">修改</a>|<a href = "./DelUser?id=<%=strId %>">删除</a></td>
<%} %>
</tr>
<%
}
%>
</table>
<%
rs.close();
stmt.close();
conn.close();
}else {
%>
<table width="500" border="2" cellpadding="1" cellspacing="1" bordercolor="#999999">
<tr>
<td bgcolor="#00CCFF">ID</td>
<td bgcolor="#00CCFF">职工姓名</td>
<td bgcolor="#00CCFF">购买物品</td>
<td bgcolor="#00CCFF">购买数量</td>
<td bgcolor="#00CCFF">购买日期</td>
<td bgcolor="#00CCFF">购买地址</td>
<%if(strPower.equals("2")) {%>
<td bgcolor="#00CCFF">操作</td>
<%} %>
</tr>
<%
Connect test = new Connect();
Connection conn = test.getConnect();
ResultSet rs = null;
Statement stmt = null;
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from Buy");
while(rs.next()){
String strId = rs.getString("buy_id");
%>
<tr>
<td><%=strId%></td>
<td><%=rs.getString("buy_name") %></td>
<td><%=rs.getString("buy_goods") %></td>
<td><%=rs.getString("buy_count") %></td>
<td><%=rs.getString("buy_date") %></td>
<td><%=rs.getString("buy_addr") %></td>
<%if(strPower.equals("2")) {%>
<td><a href = "updatesta.jsp?id=<%=strId %>">修改</a>|<a href = "./DelSta?id=<%=strId%>">删除</a></td>
<%} %>
</tr>
<%}
%>
</table>
<%
rs.close();
stmt.close();
conn.close();
} %>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -