📄 line.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="../error/error.jsp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta http-equiv="refresh" content="2" />
<title>在线人数</title>
<link rel="stylesheet" type="text/css" href="../image/com.css" />
<jsp:useBean id="line" class="useBean.Link_db" scope="request" />
</head>
<%
String username="所有人";
try{
username=(String)session.getAttribute("name");
}catch(Exception e){
session.setAttribute("error","用户名不存在");
response.sendRedirect("errorpage.jsp");
}
%>
<body>
<div align="center"><span class="style10">在线人员</span>
<p>
<a href="send.jsp?lname=所有人" target="send" >所有人<br><br>
</a>
<%
try{
String sqls1="SELECT * FROM associator WHERE 在线="+1;
Connection con=useBean.Link_db.getCon();
Statement state=con.createStatement();
ResultSet rs=state.executeQuery(sqls1);
while(rs.next()){
String name=rs.getString("用户名");
%>
<a href="send.jsp?lname=<%=name%>" target="send"><%=name%></a><br><br>
<%
}
line.close();
}catch(Exception e){
}
%>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -