请jsp高手帮忙解释下这段代码是什么意思？万分感谢！！

shaiyalijia 2008-04-15 08:30:08

String Board_Name,Board_Id,Note_Id;%>
<%
Board_Id=request.getParameter("fid");
Note_Id=request.getParameter("noteid");
Connection con=yy.getConn();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=null;
String sql="Select 论坛名称 from 论坛栏目 Where 论坛id="+Board_Id;
rs=stmt.executeQuery(sql);
while(rs.next())
{
Board_Name=rs.getString("论坛名称");
}
%>
<td width="62%"> <a href="../default1.jsp">首页</a>>><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="post.jsp?fid=<%=Board_Id%>"><img src="IMAGES/TOPIC.GIF" border="0"></a> <a href="post.jsp?fid=<%=Board_Id%>&Returnid=<%=Note_Id%>"><img src="IMAGES/REPLY.GIF" border="0" ></a> <a href='javascript:print()'><img src="IMAGES/PRINT.GIF" border="0" ></a></td>
</tr></table>

<table cellspacing="0" cellpadding="0" border="0" width="754" align="center">

<tr>
<td bgcolor="#009ACE">
<table border="0" cellspacing="1" cellpadding="6" width="100%">
<%
sql="update 贴子 set 点击次数=点击次数+1 where 贴子id="+Note_Id;
stmt.executeUpdate(sql);
int PageSize=10;
int RecordCount=0;
int PageCount=0;
int ShowPage=1;
sql="Select * from 用户表,贴子 where 贴子.贴子作者=用户表.用户名 And 贴子.贴子id="+Note_Id+" And 版块id="+Board_Id+" or 贴子.贴子作者=用户表.用户名 And 贴子.回复id="+Note_Id+" And 版块id="+Board_Id+" order by 贴子.贴子id";
//out.println(sql);
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-1)*PageSize+1);
for (int i=1;i<PageSize;i++)
{
String Note_Title=rs.getString("贴子名称");
String User_Name=rs.getString("用户名");
String Noteall_Id=rs.getString("贴子id");
String User_Level=rs.getString("用户等级");
String Sing_Id=rs.getString("显示签名");

...全文