一种新的编程思路（下）：附 bbs之forum.jsp (转)-优快云博客

本文介绍了一种针对论坛系统的新型JSP编程方法，通过定义全局变量和SQL查询实现帖子的高效检索与展示。该方法关注于如何组织SQL查询语句以达到优化目的。

一种新的编程思路（下）：附 bbs之forum.jsp (转)[@more@]

forum.JSP

--------------------------------------------------------------------------

file://全局变量定义
globalTableName = "bbs_article";
parentKey = "帖子";
parentValue = "";
dbName = "mhoa";
%>

int forumId = 0;
if( request.getParameter("forumId") == null )
{
out.println("");
return;
}
forumId = Integer.parseInt(request.getParameter("forumId"));

sql =
" select top "+ maxReturnRows +" * from " + globalTableName + "_datetime " +
" where k ='改贴时间' "+
" and pid in ( select id from " + globalTableName + "_main "+
" where k='"+parentKey+"' and v='"+parentValue+"' ) "+
" and pid in ( select pid from " + globalTableName + "_int "+
" where k='论坛id' and v = "+ forumId +" ) "+
" and pid in ( select pid from " + globalTableName + "_int "+
" where k='父贴id' and v = 0 ) "+
" order by v desc "+
"";
ntP.executeQuery( dbName , sql);

file://校正次序

out.println("<!-- "+ sql +" --&gt");
%>

闵行办公自动化系统BBS

title=Search
src="images/top10.gif"
align=absMiddle border=0 name=search width="15" height="15"> 注册
| title=Search
src="images/userlist.gif"
align=absMiddle border=0 name=search width="16" height="16"> 个人资料
| title="Members List"
src="images/yj.gif"
align=absMiddle border=0 name=members width="16" height="16"> 用户登入
| title=Search
src="images/icon_search.gif"
align=absMiddle border=0 name=search width="16" height="15"> 论坛搜索
| title=Search
src="images/gohome.gif"
align=absMiddle border=0 name=search width="15" height="15"> 返回论坛首页
| title=Search
src="images/gohome.gif"
align=absMiddle border=0 name=search width="15" height="15"> 返回OA首页

> ( 版主: )

主题

作者

回复数

人气指数

最后发表

String _name = nt.getKV( dbName,globalTableName ,_pid ,"贴子标题");
if( _name.equals("") )
_name = "( 空 )";
if( !nt.getKV( dbName,globalTableName+"_int" ,_pid ,"父贴id").equals("0") )
_name = " "+_name;
%>

<%=%20nt.getKV(%20dbName,globalTableName%20,_pid%20,

" width="20" height="20" border=0>

nt.getKV( dbName,"bbs_users" ,nt.getKV( dbName,globalTableName+"_int" ,_pid ,"发贴人id"),"用户名")
%>

nt.executeQuery( dbName,
" select * from bbs_article_int where k ='父贴id' and v= "+ _pid +" ")
%>

RM name="form1" method="post" action="">

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10752043/viewspace-991643/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10752043/viewspace-991643/