?? subject_display.jsp
字號:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*,java.lang.*" %>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<SCRIPT language=JavaScript>
function commitForm(destJsp){
document.form1.action=destJsp;
document.form1.submit();
}
function icon(theicon) {
document.input.content.value+= " "+theicon;
document.input.content.focus();
}
</script>
<link rel='stylesheet' type='text/css' href='imbed/forum.css'>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/qtop5.jpg" width="432" height="55"> <img src="images/dot.gif" width="12" height="11">
<font size="2">
<a href="javascript:window.external.addFavorite('http://59.64.156.13','911論壇')" title="911論壇">收藏本站</a>
<img src="images/dot.gif" width="12" height="11"> <a href="index.jsp">返回首頁</a></font></td>
</tr>
</table>
<br>
<%
String subject_id=request.getParameter("sid");
int id=0;
int nid=0;
int bid=0;
if(subject_id!=null)
id=Integer.parseInt(request.getParameter("sid"));
nid=id+1;
bid=id-1;
String publish_time="";
String subject_title="";
String subject_content="";
String author="";
String community_id="";
Connection con=yy.getConn();
Statement stmt=con.createStatement();
ResultSet rs=null;
String sql="select subject_title,subject_content,publish_time,author,community_id from subject where subject_id="+subject_id;
rs=stmt.executeQuery(sql);
if(rs.next())
{
subject_title=rs.getString("subject_title");
subject_content=rs.getString("subject_content");
publish_time=rs.getString("publish_time");
author=rs.getString("author");
community_id=rs.getString("community_id");
}
if(publish_time.equals(""))
publish_time="";
%>
<a href="new_reply.jsp?subject_id=<%=subject_id%>&community_id=<%=community_id%>"><img src="images/REPLY.GIF" width="84" height="29" border="0"></a>
<a href="new_subject.jsp?community_id=<%=community_id%>&nid=<%=nid%>"><img src="images/TOPIC.GIF" width="84" height="29" border="0"></a>
<table width="90%" border="1">
<tr>
<td width="100%" height="41" align="center" bordercolor="#CCCCCC" ><font size='2'>標(biāo)題:<%=subject_title%>
<br>
作者: <a href="member.jsp?member=<%=author%>"><%=author%></a> 發(fā)表日期:<%=publish_time.trim().substring(0,10)%></font></td>
</tr>
<tr>
<td bordercolor="#CCCCCC"><font size='2'><%=subject_content%></font></td>
</tr>
<%
int n=0;
int count=0;
int pages=1;//當(dāng)前頁數(shù)，默認為1
int pagesize=4;
String nowpage=request.getParameter("pages");
if((nowpage!=null)&&(nowpage!=""))
pages=Integer.parseInt(request.getParameter("pages"));
//out.println(pages);
if(pages>0)
{
try{
sql="select count(*) as id1 from Reply where subject_id="+subject_id;
rs=yy.executeQuery(sql);
}catch(Exception e)
{
out.println(e.getMessage());
}
}if(rs.next())
count=rs.getInt("id1");
if(count>0)
{
String reply_title,reply_content,reply_time,reply_author,reply_topic;
sql="Select reply_id,reply_title,reply_content,reply_time,reply_author,reply_topic From Reply where subject_id="+subject_id;
rs=stmt.executeQuery(sql);
for(int i=1;i<=(pages-1)*pagesize;i++)
rs.next();
for(int j=0;j<pagesize;j++)
{
if (rs.next())
{
reply_title=rs.getString("reply_title");
reply_content=rs.getString("reply_content");
reply_time=rs.getString("reply_time");
reply_author=rs.getString("reply_author");
reply_topic=rs.getString("reply_topic");
%>
<tr>
<td width="100%" bordercolor="#CCCCCC" ><div align="center"><font size='2'>回復(fù)標(biāo)題:<%=reply_title%><br>
作者:<a href="member.jsp?member=<%=reply_author%>"> <%=reply_author%></a> 發(fā)表日期:<%=reply_time.trim().substring(0,10)%></font></div></td>
</tr>
<tr>
<td bordercolor="#CCCCCC"><font size='2'><%=reply_content%></font></td>
</tr>
<%}
}n=(int)(count/pagesize);
if(n*pagesize<count)
n++;
if(n>=1)
{%><table><tr><td><font size='2'>共<%=n%>頁:
<%
for(int i=1;i<=n;i++)
out.println("<a href=subject_display.jsp?pages="+i+"&sid="+subject_id+">"+i+" </a>");
}}
%></font></td></tr>
</table></table>
<%
int mid=0;
sql="select max(subject_id) from Subject";
rs=stmt.executeQuery(sql);
if(rs.next())
{
mid=Integer.parseInt(rs.getString(1));
}
if((nid<=mid)&&( bid>=1))
{
%>
<p align="center">
<a href="subject_display.jsp?sid=<%=bid%>"><font size='2'>上一主題</font></a> <a href="subject_display.jsp?sid=<%=nid%>"><font size='2'>下一主題</font></a>
</p>
<%}
else if((nid>mid)&&(bid>=1))
{%>
<p align="center"><a href="subject_display.jsp?sid=<%=bid%>"><font size='2'>上一主題</font></a> </p>
<%}
else if ((nid<=mid)&&(bid==0))
{%>
<p align="center">
<a href="subject_display.jsp?sid=<%=nid%>"><font size='2'>下一主題</font></a>
</p>
<%}%>
<form name="form1" method="post" action="">
<table width="90%" border="1" cellspacing="0" cellpadding="0" >
<tr>
<td width="100%" height="37" bordercolor="#96CBA0" background="images/qback.gif"><br>
<strong><font size='2'> 快速回復(fù) </font></strong></td>
</tr>
<tr>
<td height="49" bordercolor="#96CBA0">
<br>
<font size="2" face="Arial, Helvetica, sans-serif">標(biāo)題：</font>
<input name="title" type="text" size="50">
<font size="2"> （可選）</font><font size="2"> </font>
</td>
</td>
</tr>
<tr>
<input type="hidden" name="subject_id" value=<%=subject_id%>>
<input type="hidden" name="community_id" value=<%=community_id%>>
<td height="33" bordercolor="#96CBA0">
<div align="center">
<textarea name="content" cols="90" rows="8"></textarea>
</div>
<div align="center"><img src="images/03-01-02-1799.gif" width="31" height="31" onClick="commitForm('save.jsp?act=quick_reply')"><font color="#009966" size="2">帖子快速回復(fù)</font>
<img src="images/03-01-02-1799.gif" width="31" height="31" onClick="commitForm('new_reply.jsp')"></a><font color="#009966" size="2">進入高級模式</font></div>
</td>
</tr>
</table>
</form>
</body>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -