<%@ page language="java" import="java.util.*" contentType="text/html;charset=utf-8" pageEncoding="utf-8" %> <%@ page import="java.util.*,net.sf.json.*" %> <%@ include file="SQL.jsp" %> <% // 如果未登录先登录 String user = "" + session.getAttribute("user"); if(user.equals("null")){ response.sendRedirect("./login.html"); return; } if(!user.equals("admin@qq.com")){ response.sendRedirect("./home.html"); return; } %> <% SQL sql = new SQL(); String exec_self = "select * from user where u_name='" + user + "'"; String exec_users = "select u_name,u_nickname,u_state_user,u_state_thread from user where u_name!='" + user + "'"; String exec_threads = "select threads.t_id,threads.t_state,threads.g_id,thread.t_title,thread.t_time,user.u_name from threads inner join thread on thread.t_id=threads.t_id inner join user on threads.u_id=user.u_id order by thread.t_time desc"; ArrayList list_u_name = new ArrayList(); ArrayList list_u_state_user = new ArrayList(); ArrayList list_u_state_thread = new ArrayList(); ArrayList list_u_nickname = new ArrayList(); ArrayList list__u_name = new ArrayList(); ArrayList list_t_id = new ArrayList(); ArrayList list_t_state = new ArrayList(); ArrayList list_g_id = new ArrayList(); ArrayList list_t_title = new ArrayList(); ArrayList list_t_time = new ArrayList(); String img_self = "", name_self = "", nickname_self = ""; if(sql.connect()){ // 获取管理员个人信息，昵称等 ResultSet rs = sql.executeQuery(exec_self); while(rs.next()){ img_self = rs.getString("u_img"); name_self = rs.getString("u_name"); nickname_self = rs.getString("u_nickname"); } // 获取用户列表 rs = sql.executeQuery(exec_users); while(rs.next()){ list_u_name.add(rs.getString("u_name")); list_u_state_user.add(rs.getString("u_state_user")); list_u_state_thread.add(rs.getString("u_state_thread")); list_u_nickname.add(rs.getString("u_nickname")); } // 获取主题列表 // 获取用户列表 rs = sql.executeQuery(exec_threads); while(rs.next()){ list__u_name.add(rs.getString("u_name")); list_t_id.add("" + rs.getInt("t_id")); list_g_id.add("" + rs.getInt("g_id")); list_t_state.add(rs.getString("t_state")); list_t_title.add(rs.getString("t_title")); list_t_time.add("" + rs.getTimestamp("t_time")); } } %> TRICELL - 管理员
头像

部门：

昵称：

主题数：

性别：

操作失败，请稍后再试！

用户管理>>

  • 账号 昵称 屏蔽 禁言 删除
    • <% Iterator it_u_name = list_u_name.iterator(); if(it_u_name.hasNext()){ Iterator it_u_nickname = list_u_nickname.iterator(); Iterator it_u_state_user = list_u_state_user.iterator(); Iterator it_u_state_thread = list_u_state_thread.iterator(); while(it_u_name.hasNext()){ String handle1_text = it_u_state_thread.next().equals("1") ? "屏蔽" : "取消屏蔽"; String handle2_text = it_u_state_user.next().equals("1") ? "禁言" : "取消禁言"; %>
  • <%=it_u_name.next()%> <%=it_u_nickname.next()%> <%=handle1_text%> <%=handle2_text%> 删除
    • <% } } %>

主题管理>>

  • 主题 作者 发布时间 屏蔽 删除
    • <% Iterator it__u_name = list__u_name.iterator(); if(it__u_name.hasNext()){ Iterator it_t_id = list_t_id.iterator(); Iterator it_g_id = list_g_id.iterator(); Iterator it_t_state = list_t_state.iterator(); Iterator it_t_title = list_t_title.iterator(); Iterator it_t_time = list_t_time.iterator(); while(it__u_name.hasNext()){ String _href = "./thread_info.jsp?g="+ it_g_id.next()+"&t="+it_t_id.next(); String handle1_text = it_t_state.next().equals("1") ? "屏蔽" : "取消屏蔽"; %>
  • <%=it_t_title.next()%> <%=it__u_name.next()%> <%=it_t_time.next()%> <%=handle1_text%> 删除
    • <% } } %>