📄 userlist.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.io.*,java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ include file="conn.jsp" %>
<%
String sqlStr;
sqlStr = "SELECT userid,name FROM userinfo";
%>
<html>
<head>
<title>无标题文档</title>
<LINK href="style.css" type=text/css rel=stylesheet>
<style type="text/css">
<!--
body {font-size:9pt}
td {font-size:9pt}
-->
</style>
<STYLE type=text/css>.bai {
FONT-SIZE: 9pt; COLOR: #000000; LINE-HEIGHT: 100%; FONT-FAMILY: "Verdana"; TEXT-DECORATION: none
}
A:hover {
COLOR: #ff9933; TEXT-DECORATION: underline
}
</STYLE>
<script language="JavaScript">
function Onclick(id,n) {
//alert(id+"/"+n);
document.form1.userid.value=id;
document.form1.name.value=n;
// open("parseprivilege.jsp?userid="+id+"&name="+n+"&userprivilege=N","mainFrame","");
document.form1.target="mainFrame"
document.form1.submit();
}
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="userprivilege.jsp">
<div align="center">
<p align="center"><font face="宋体" size="3" color="#000099"><b><font face="楷体_GB2312" size="4">用户列表</font></b></font></p>
<table width="100%" border="0" cellspacing="1" cellpadding="1" bgcolor="#333333">
<tr bgcolor="#fce38b">
<td width="50%">
<div align="center">标识</div>
</td>
<td width="50%">
<div align="center">姓名</div>
</td>
</tr>
<%
rs= stmt.executeQuery(sqlStr);
String userid="";
String name="";
while (rs.next()) {
userid = rs.getString("userid");
name = rs.getString("name");
byte[] useridbyte=userid.getBytes("ISO8859_1");
userid=new String(useridbyte);
byte[] namebyte=name.getBytes("ISO8859_1");
name=new String(namebyte);
%>
<tr bgcolor="#fffbec">
<td width="50%">
<div align="center"><a href="Javascript:Onclick('<%=userid%>','<%=name%>')"><%=userid%></a></div>
</td>
<td width="50%">
<div align="center"><a href="Javascript:Onclick('<%=userid%>','<%=name%>')"><%=name%></a></div>
</td>
</tr>
<%
}
%>
</table>
<input type="hidden" name="userid">
<input type="hidden" name="name">
</div>
</form>
</body>
</html>
<%
rs.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -