📄 userlist.jsp
字号:
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="OPDB" scope="page" class="database.OPDB" />
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="chat.css">
<META http-equiv="refresh" content="8">
<script language="JavaScript">
function PerformSubmit(user) {
parent.inputFrame.chatForm.talkwith.value=user;
return false;
}
</script>
</HEAD>
<BODY bgcolor="#FF9900" topmargin="0">
<FORM method="post" name="userlist_form" >
<%
String Name = (String) session.getValue("Name");
boolean online = false;
if (Name == null) {
session.putValue("online","no");
out.print("你和聊天室已中断!");
return;
}
synchronized(application) {
Vector ListUser=null;
ListUser =(Vector)application.getAttribute("UserName");
if(ListUser!=null) {
int userNumbers = ListUser.size();
%>
<font color="#0000ff">在线人员</font>[<font color="#ff0000"><%= userNumbers %></font>]<p>
<a href="#" onClick=PerformSubmit("所有人")>所有人</a><br>
<%
String User = null;
for(int i=0;i<ListUser.size();i++) {
User= (String) ListUser.get(i);
if (Name.equals(User)) {
online = true;
}
%>
[<a href="#" class="l1" onClick=PerformSubmit("<%= User%>")><%
out.print(User);
%></a>]<br>
<%
}
if (online) {
session.putValue("online","yes");
}
else {
session.putValue("online","no");
}
}
}
out.print("</form>");
OPDB.connection();
Connection conn =OPDB.getConn();
String sql = null;
Name = OPDB.AsciiToChineseString(Name);
int i = Name.indexOf(OPDB.AsciiToChineseString("[会员]"));
if (i != -1) {
Name = Name.substring(0,i);
sql = "select userlevel,experience from t_bbs_user where username = '" + Name + "' and usertype = 'Y'";
}
else {
sql = "select userlevel,experience from t_bbs_user where username = '" + Name + "' and usertype = 'N'";
}
ResultSet rs = OPDB.select(conn,sql);
String experience = "0";
String userlevel = "过客";
if (rs.next()) {
experience = rs.getString("experience");
userlevel = OPDB.GBK(rs.getString("userlevel"));
}
session.putValue("experience",experience);
session.putValue("userlevel",userlevel);
rs.close();
OPDB.Close();
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -