<%@ 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" %> <% request.setCharacterEncoding("utf-8"); // 如果未登录先登录 String user = "" + session.getAttribute("user"); String groupId = "" + session.getAttribute("groupId"); if(user.equals("null") || groupId.equals("null")){ response.sendRedirect("./login.html"); return; } // 如果不是该部门的员工 String _groupId = "" + request.getParameter("g"); String _tId = "" + request.getParameter("t"); if(!_groupId.equals("9") && !_groupId.equals(groupId)){ response.sendRedirect("./home.html"); return; } // 如果不是某个主题请求 if(_tId.equals("null")){ response.sendRedirect("./thread.jsp?g="+ _groupId); return; } SQL sql = new SQL(); // 查询主题信息 String thread_exec = "select u_name,t_title,t_description,t_time from threads inner join thread on threads.t_id=thread.t_id inner join user on threads.u_id=user.u_id where threads.t_id='"+_tId+"'"; // 查询评论信息 String remark_exec = "select u_name,r_description,r_time from remarks inner join threads on threads.t_id=remarks.t_id inner join remark on remarks.r_id=remark.r_id inner join user on remark.u_id=user.u_id where threads.t_id='"+_tId+"'"; String u_name = "", t_description = "", t_title = "", t_time = ""; ArrayList r_user = new ArrayList(); ArrayList r_desc = new ArrayList(); ArrayList r_time = new ArrayList(); if(sql.connect()){ ResultSet rs = sql.executeQuery(thread_exec); while(rs.next()){ u_name = rs.getString("u_name"); t_title = rs.getString("t_title"); t_description = rs.getString("t_description"); t_time = "" + rs.getTimestamp("t_time"); } // 如果不是有效的主题 if(t_title.equals("")){ response.sendRedirect("./thread.jsp?g="+ _groupId); return; } rs = sql.executeQuery(remark_exec); while(rs.next()){ r_user.add(rs.getString("u_name")); r_desc.add(rs.getString("r_description")); r_time.add(""+ rs.getString("r_time")); } } %> TRICELL- 论坛

部门：

昵称：

主题数：

性别：

<%=t_title%>

<%=u_name%> <%=t_time%>

<%=t_description%>

<% Iterator it_user = r_user.iterator(); if(it_user.hasNext()) { %>

评论列表：

<% Iterator it_desc = r_desc.iterator(); Iterator it_time = r_time.iterator(); while(it_user.hasNext()){ %>

<%=it_desc.next()%>

<%=it_user.next()%> <%=it_time.next()%>

<% } %>

提交评论提交成功