📄 answer.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
import="java.sql.*" pageEncoding="GB2312"%>
<jsp:useBean id="ask" scope="page" class="edu.AskBean" />
<jsp:useBean id="user" scope="page" class="edu.UserBean" />
<jsp:useBean id="answer" scope="page" class="edu.AnswerBean" />
<jsp:useBean id="teacher" scope="page" class="edu.TeacherBean" />
<jsp:useBean id="classs" scope="page" class="edu.ClassBean" />
<jsp:useBean id="subjects" scope="page" class="edu.SubjectBean" />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>主题</title>
<script language=JavaScript>
function getconfirm()
{
if (confirm("如果删除提问的话,那么在它下面的回复也将被删除!你确定要删除吗？"))
return ture;
else
return false;
}
function getconfirm_ans()
{
if (confirm("你确定要删除吗？"))
return ture;
else
return false;
}
</script>
<style type="text/css">
<!--
.STYLE1 {
color: #FFFFFF;
font-size: 12px;
}
.STYLE2 {font-size: 12px}
.STYLE4 {font-size: 12px}
-->
</style>
<link rel="stylesheet" href="style.css" type="text/css">
<style type="text/css">
<!--
.STYLE5 {font-weight: bold}
.STYLE6 {color: #FF0000}
-->
</style>
</head>
<body>
<%
int allrow=0, intpage=1;
int pagesize=10;//一页显示行数
int ask_id=0,u_id=0,grade_id=0,class_id=0,subject_id=0;
String ask_photo=null,ans_photo=null,title=null,content=null,time=null,u_name=null,ask_sort=null,ask_name=null,sort=null,sortadmin=null;
String class_name=null,subject_name=null;
try{sortadmin=session.getAttribute("sort").toString();}catch(NullPointerException e){}
try{ask_id=Integer.valueOf(request.getParameter("ask_id")).intValue();
}catch(NumberFormatException e){}
ResultSet rs = ask.getAsk(ask_id);
while(rs.next()){
title=rs.getString("a_title");
content=rs.getString("a_content");
time=rs.getString("a_time");
u_id=rs.getInt("u_id");
ask_sort=rs.getString("ask_sort");
grade_id=rs.getInt("grade_id");
class_id=rs.getInt("class_id");
subject_id=rs.getInt("subject_id");
ResultSet rs_class2=classs.getClasss(class_id);
if(rs_class2.next())
class_name=rs_class2.getString("class");
rs_class2.close();
ResultSet rs_subject2=subjects.getSubjects(subject_id);
if(rs_subject2.next())
subject_name=rs_subject2.getString("subject");
rs_subject2.close();
if(ask_sort.equalsIgnoreCase("user")){sort="学生";}
if(ask_sort.equalsIgnoreCase("teacher")){sort="老师";}
if(ask_sort.equalsIgnoreCase("admin")){sort="管理员";}
ResultSet rs_sort=ask.getAskSortName(ask_sort,u_id);
while(rs_sort.next()){
ask_name=rs_sort.getString(1);
ask_photo=rs_sort.getString(2);
}
session.setAttribute("grade_id",String.valueOf(grade_id));
session.setAttribute("class_id",String.valueOf(class_id));
session.setAttribute("subject_id",String.valueOf(subject_id));
session.setAttribute("ask_id",String.valueOf(ask_id));
session.setAttribute("title",String.valueOf(title));
session.setAttribute("content",String.valueOf(content));
}rs.close();
%>
<div align="center">
<table width="750" height="25" border="0" cellpadding="0"
cellspacing="0">
<tr>
<td width="770" height="160"><iframe name="top" height="160"
width="770" scrolling="no" src="top.jsp" frameborder="0"></iframe></td>
</tr>
</table>
</div>
<div align="center">
<table width="750" height="25" border="0" cellpadding="0"
cellspacing="0">
<tr bgcolor="#858B8E">
<td width="635" bgcolor="#6699FF">当前位置
<a href="asklist_class.jsp?grade_id=<%=grade_id %>&class_id=<%=class_id %>"><%=class_name %></a> → <a href="asklist.jsp?grade_id=<%=grade_id %>&class_id=<%=class_id %>&subject_id=<%=subject_id %>"><%=subject_name %></a>
<span class="STYLE1">
<strong>本页主题:</strong><%=title%></span></td>
<td width="115" bgcolor="#6699FF">
<div align="right"><span class="STYLE5"><a
href="ask.jsp"> 提问</a> <a href="qanswer.jsp?ask_id=<%=ask_id %>">回答</a></span></div>
</td>
</tr>
</table>
<table width="750" border="0" align="center" cellspacing="1"
bgcolor="#EBEBEB">
<tr>
<td width="22%" valign="top" bgcolor="#FFFFFF">
<p align="center"><span class="STYLE2">提问人：</span> <strong><%=ask_name %></strong><br>
<span class="STYLE2">分组：<%=sort %></span> <br>
<img
src="<%if(ask_photo!=null&&!ask_photo.equalsIgnoreCase("")){%>uploadfile/images/<%=ask_photo%><%}else{%>images/dlbj173149.gif<%}%>"
width="120" height="120"></p>
</td>
<td width="78%" valign="top" bgcolor="#FFFFFF"><span
class="STYLE2"><strong><%=title%></strong></span>
<p><span class="STYLE2"><%=content%></span>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">
<div align="center"><span class="STYLE4">发表于：<%=time %></span></div>
</td>
<td bgcolor="#FFFFFF">
<div align="left"><a
href="show.jsp?sort=<%=ask_sort %>&&userid=<%=u_id %>" target="_blank"
><img src="images/profile.gif" width="50"
height="18" border="0"></a> <a
href="modifyask.jsp?ask_id=<%=ask_id %>&u_id=<%=u_id %>&sort=<%=ask_sort %>">
<img src="images/edit.gif" width="50" height="18" border="0"></a> <%try{if(sortadmin.equalsIgnoreCase("admin")){ %>
<a href="Servletask?action=delete&id=<%=ask_id %>"
onClick="return getconfirm()"><img src="images/delete.gif"
width="50" height="18" border="0"></a>
<%}}catch(NullPointerException e){} %>
</div>
</td>
</tr>
</table>
<table height="2">
<tr>
<td></td>
</tr>
</table>
<table width="750" border="0" align="center" cellspacing="1"
bgcolor="#EBEBEB">
<%
try{
intpage=Integer.valueOf(request.getParameter("intpage")).intValue();
}catch(NumberFormatException e){}
ResultSet rs_ans=answer.getAnswerCount(ask_id);
if(rs_ans.next())
allrow=rs_ans.getInt(1);
int allpage = (allrow +pagesize-1)/ pagesize;
// 调整待显示的页码
if(intpage>allpage) intpage = allpage;
if(intpage<1) intpage = 1;
int startrow=(intpage-1)*pagesize;
answer.setStartpage(startrow);
answer.setPagesize(pagesize);
rs_ans=answer.getAnswer(ask_id);
String ans_name=null;
while(rs_ans.next()){
String ans_content=rs_ans.getString("ans_content");
String ans_time=rs_ans.getString("ans_time");
String ans_sort=rs_ans.getString("ans_sort");
int ans_id=rs_ans.getInt("ans_id");
int answer_id=rs_ans.getInt("answer_id");
session.setAttribute("ans_id",String.valueOf(ans_id));
session.setAttribute("ans_sort",String.valueOf(ans_sort));
session.setAttribute("ans_content",String.valueOf(ans_content));
sort="";
if(ans_sort.equalsIgnoreCase("user")){sort="同学";}
if(ans_sort.equalsIgnoreCase("teacher")){sort="老师";}
if(ans_sort.equalsIgnoreCase("admin")){sort="管理员";}
try{
ResultSet rs_sort=answer.getAnswerSortName(ans_sort,ask_id);
while(rs_sort.next()){
ans_name=rs_sort.getString(1);
ans_photo=rs_sort.getString(2);
}rs_sort.close();
%>
<tr>
<td width="22%" valign="top" bgcolor="#FFFFFF">
<div align="center"><span class="STYLE2">回复人：</span> <strong><%=ans_name %></strong><br>
<span class="STYLE2">分组：<%=sort %></span> <br>
<img
src="<%if(ans_photo!=null&&!ans_photo.equalsIgnoreCase("")){%>uploadfile/images/<%=ans_photo%><%}else{%>images/dlbj173149.gif<%}%>"
width="120" height="120"></div>
</td>
<td width="78%" valign="middle" bgcolor="#FFFFFF"><span
class="STYLE2"><%=ans_content%></span></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">
<div align="center"><span class="STYLE4">发表于：<%=ans_time %></span></div>
</td>
<td bgcolor="#FFFFFF"><a
href="show.jsp?sort=<%=ans_sort %>&&userid=<%=ans_id %>" target="_blank"
><img src="images/profile.gif" width="50"
height="18" border="0"></a> <a
href="modifyanswer.jsp?answer_id=<%=answer_id %>"><img
src="images/edit.gif" width="50" height="18" border="0"></a> <%if(sortadmin.equalsIgnoreCase("admin")){ %><a
href="Servletanswer?action=delete&ask_id=<%=ask_id %>&id=<%=answer_id %>"
onClick="return getconfirm_ans()"><img src="images/delete.gif"
width="50" height="18" border="0"></a>
<%} %>
</td>
</tr>
<%}catch(NullPointerException e){} }rs_ans.close();%>
</table>
<div align="center">
<table width="750" border="0">
<tr>
<td width="30%" height="30">
<div align="center">共<span class="STYLE6"><%=allrow %></span>条回复 当前第<span class="STYLE6"><%=intpage %></span>页/共<span class="STYLE6"><%=allpage %></span>页</div></td>
<td width="70%"><div align="center"><a href="answer.jsp?ask_id=<%=ask_id%>">首页</a>
<%
int tenpage=((int)(intpage/10))*10;
if(intpage-10>0) {%>
<a href="answer.jsp?ask_id=<%=ask_id%>&intpage=<%=intpage-10%>">上十页</a>
<%} %>
<a href="answer.jsp?ask_id=<%=ask_id%>&intpage=<%=intpage-1%>">上一页</a>
<%if(tenpage+10<=allpage){
for(int i=1;i<=10;i++){%>
<a href="answer.jsp?ask_id=<%=ask_id%>&intpage=<%=tenpage+i %>"><%=tenpage+i %></a>
<%}}if(tenpage+10>allpage){
for(int i=1;i+tenpage<=allpage;i++){%>
<a href="answer.jsp?ask_id=<%=ask_id%>&intpage=<%=tenpage+i %>"><%=tenpage+i %></a>
<%}} %>
<a href="answer.jsp?ask_id=<%=ask_id%>&intpage=<%=intpage+1%>">下一页</a>
<%if(intpage+10<=allpage) {%>
<a href="answer.jsp?ask_id=<%=ask_id%>&intpage=<%=intpage+10%>">下十页</a>
<%} %>
<a href="answer.jsp?ask_id=<%=ask_id%>&intpage=<%=allpage%>">尾页</a></div></td>
</tr>
</table></div>
<table height="2">
<tr>
<td></td>
</tr>
</table>
</div>
<div align="center">
<table height="155" width="750" border="0" cellspacing="1"
align="center">
<tr>
<td><iframe name="bottom" height="155" width="750" scrolling="no"
src="bottom.jsp" frameborder="0"></iframe></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -