📄 online.java~1~
字号:
/*
* online.java 在线用户列表
*
* Created on 2007年5月23日, 下午6:28
*/
import inc.User;
import inc.UserList;
import java.io.*;
import java.net.*;
import java.sql.*;
import java.util.Enumeration;
import javax.sql.*;
import inc.condb;
import javax.servlet.*;
import javax.servlet.http.*;
public class online
extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
HttpSession session = request.getSession();
String username = (String) session.getAttribute("username");
if (username == null) {
response.sendRedirect("index.html");
return;
}
try {
ResultSet rs=null;
condb conn=new condb();
UserList ul=UserList.getInstance();
Enumeration<String> enums=ul.getUserList();
out.println("\r\n");
out.println("<style type=\"text/css\">\r\n");
out.println("<!--\r\n");
out.println("body,td,th {\r\n");
out.println("\tfont-size: 12px;\r\n");
out.println("}\r\n");
out.println("-->\r\n");
out.println("</style><body>\r\n");
out.println(
"<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
out.println(" <tr>\r\n");
out.println(" <td width=\"50\" align=\"center\">ID</td>\r\n");
out.println(" <td width=\"100\" align=\"center\">用户名</td>\r\n");
out.println(" <td width=\"100\" align=\"center\">姓名</td>\r\n");
out.println(" <td width=\"100\" align=\"center\">EMAIL</td>\r\n");
out.println(" <td width=\"100\" align=\"center\">电话</td>\r\n");
out.println(" \r\n");
out.println(" <td> </td>\r\n");
out.println(" </tr>\r\n");
int i=0;
while(enums.hasMoreElements())
{
String sql="select * from userinfo where username='"+enums.nextElement()+"'";
rs=conn.executeQuery(sql);
rs.next();
out.println(" <tr>\r\n");
out.println(" <td align=\"center\">"+(++i)+"</td>\r\n");
out.println(" <td align=\"center\">"+rs.getString("username")+"</td>\r\n");
out.println(" <td align=\"center\">"+rs.getString("zsname")+"</td>\r\n");
out.println(" <td align=\"center\">"+rs.getString("useremail")+"</td>\r\n");
out.println(" <td align=\"center\">"+rs.getString("usertel")+"</td>\r\n");
out.println(" </tr>\r\n");
}
out.println("</table>\r\n");
out.println("</body>");
}
catch (Exception e) {
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
doGet(request, response);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -