<%@ 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()){
//out.println("Connect Ok!");
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 - 个人
![头像]( "头像")
部门：
昵称：
主题数：
性别：
TRICELL
桃花影落飞神剑,
碧海潮生按玉箫
