<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<%! String Board_Name,Board_Id,Note_Id;%>
<%
Board_Id=request.getParameter("fid");
Note_Id=request.getParameter("noteid");
Connection con=yy.getConn();
Statement stmt=createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=null;
String sql="Select Forum_Name from Forum where Forum_Id="+Board_Id;
rs=stmt.executeQuery(sql);
while(rs.next()){
Board_Name=rs.getString("Forum_Name");
}
%>
<td width="62%"><a href="index.jsp">梦幻论坛</a>>><a href=board.jsp?fid=<%=Board_Id%>><%=Board_Name%></a>>>浏览帖子
</td>
<td class="post" align="right" width="38%"><a href="posr.jsp?fid=<%Board_Id%>"><img src="IMAGES/TOP.GIF" border="0"></a> <a href="post.jsp?fid=<%=Board_Id%>&Returnid=<%Note_Id%>"><img src="IMAGES/REPLY.GIF" border="0"></a> </td></tr></table>
<table cellspacing="0" cellpadding="0" border="0" width="100%" align="center">
<tr>
<td bgcolor="#009ace">
<table border="0" cellspacing="1" cellpadding="6" width="100%">
<%
sql="update Card set Click_Times=Click_Times+1 where Card_Id="+Note_Id;
stmt.executeUpdate(sql);
int PageSize=10;
int RecordCount=0;
int PageCount=0;
int ShowPage=1;
sql="Select * from Users,Card where Card.Card_Author=Users.Users_Name And Card.Card_Id="+Note_Id+" And Board_Id="+Board_Id+"or Card.Card_Author=Users.Users_Name And Card.Reply_Id="+Note_Id+"And Board_Id="+Board_Id+" order by Card.Card_Id";
rs=stmt.executeQuery(sql);
rs.last();
RecordCount=rs.getRow();
PageCount=(RecordCount%PageSize==0)?(RecordCount/PageSize):(RecordCount/PageSize+1);
String Page=request.getParameter("page");
if(Page!=null){
ShowPage=Integer.parseInt(Page);
if(ShowPage>PageCount)
ShowPage=PageCount;
else if(ShowPage<0)
ShowPage=1
}
else
ShowPage=1;
if(RecordCount>0){
rs.absolute((ShowPage)*PageSize+1);
for(int i=1;i<PageSize;i++){
String Note_Title=rs.getString("Card_Name");
String User_Name=rs.getString("User_Name");
String Noteall_Id=rs.getString("Card_Id");
String User_Level=rs.getString("User_Grade");
String Sing_Id=rs.getString("Show_Sign");
%>
<tr>
<td width="22%" align="center" bgcolor="#66cc99">作者</td>
<td bgcolor="#66cc99">文章标题<span class="postauthor"><%=Note_Title%></span></td>
</tr>
<tr>
<td rowspan="top" bgcolor="#f7fbff"><span class="postauthor"><%=User_Name%></span><br/>
<br/><div><center>
<span class="postauhtor"><img src="./<%=rs.getString("User_Icon")%>"></span><br/>
<br/>
<%=User_Level%><br/>
<%//用户等级
if(User_Level.equals("新手上路"))
out.println(" <IMG SRC=IMAGES/STAR.GIF>");
else if(User_Level.equals("初级会员"))
out.println()out.println(" <IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF>");
else if(User_Level.equals("中级会员"))
out.println()out.println(" <IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF>");
else if(User_Level.equals("高级会员"))
out.println()out.println(" <IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF>");
else if(User_Level.equals("资深会员"))
out.println()out.println(" <IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF>");
else if(User_Level.equals("版主"))
out.println()out.println(" <IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF>");
else if(User_Level.equals("系统管理员"))
out.println()out.println(" <IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF>");
%>
<br/><br/></center><br/>
帖子数量:<span class="postauthor"><%=rs.getString("SC_Times")%></span><br/>
注册日期:<span class="postauthor"><%=rs.getString("Reg_Time").substring(0,10)%></span></div>
</td>
<td valign="top" bgcolor="#f7fbff"><img src="IMAGE/<%=rs.getString("Card_Image")%>.GIF"/>
发表于:<span class="postauthor"><%=rs.getString("Create_Time").substring(0,16)%></span></td>
</tr>
<tr>
<td height="120" valign="top" bgcolor="#f7fbff"> <%=li.yyBBCODE(li.HTMLEncode(rs.getString("Card_Content")))%>
<%
if((Sing_Id!=null)&&Sing_Id.equals("1"))
out.println("<hr size=1 color=#000000 noshade>签名<br> "+li.yyBBCODE(li.HTMLEncode(rs.getString("USer_Sign"))));
%>
</td>
</tr>
<tr>
<td valign="top" bgcolor="#f7fbff">
<table border="0" cellspacing="0" cellpadding="0" align="left" width="378" height="20">
<tr>
<td><a href="member.jsp?member=<%=User_Name%>"><img src="IMAGE/PROFILE.GIF" border="0" alt="查看此人的个人资料" width="45" height="18"></a>
<a href="post.jsp?fid=<%=Board_Id%>¬eid=<%=Noteall_Id%>&returnid=<%=Note_Id%>"><img src="IMAGE/QUOTE.GIF" border="0" alt="引用回复" width="45" height="18" /></a>
<a href="edit.jsp?fid=<%=Board_Id%>¬eid=<%=Note_Id%>&editid=<%=Noteall_Id%>"><img src="IMAGE/EDIT.GIF" border="0" alt="编辑帖子" width="47" height="18" /></a>
<a href="quermodify.jsp?fid=<%Board_Id%>&deleteid=<%=Noteall_Id%>"><img src="OMAGE/DELETE.GIF" onclick="{if(confirm('确定删除选定的记录吗?')){return true;}return false;}" width="45" height="18" alt="删除帖子" border="0"></a>
<%
//End if
%>
</td>
</tr>
</table>
</td>
</tr>
<%
if(!rs.next())
break;
}
}
%>
</table>
</td><tr>
</table>
</body>
</html>