当前页面: 开发资料首页 → JSP 专题 → 一种新的编程思路（下）：附 bbs之forum.jsp
一种新的编程思路（下）：附 bbs之forum.jsp
摘要: java jsp sql
forum.jsp
--------------------------------------------------------------------------
<%@page contentType="text/html;charset=GBK" %>
<%@include file="head.jsp"%>
<%@include file="ntGBDP2002_Define.jsp" %>
<%
file://全局变量定义
globalTableName = "bbs_article";
parentKey = "帖子";
parentValue = "";
dbName = "mhoa";
%>
<%
int forumId = 0;
if( request.getParameter("forumId") == null )
{
out.println("<script>alert('没有指定论坛: forumId ！');history.back();</script>");
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("
<%@include file="ntPage.jsp"%>
<head>
<link> rel="stylesheet" href="../css/mhs.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="750" border="0" cellspacing="1" cellpadding="0" bgcolor="#345487" align="center">
<tr>
<td></td>
</tr>
</table>
<table width="750" border="0" cellspacing="1" cellpadding="0" bgcolor="#345487" align="center">
<tr>
<td bgcolor="#EEF2F7" height="20">
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首页
</td>
</tr>
</table>
<table width="750" border="0" cellspacing="0" cellpadding="3" align="center">
<tr>
<td width="31"></td>
<td width="371">
<%@include file="forum_jump_select.jsp"%>
</td>
<td width="372">
</td>
</tr>
<tr>
<td colspan="3">
<table width="750" border="0" cellspacing="1" cellpadding="0" bgcolor="#345487" align="center">
<tr>
<td background="images/tile_back.gif">
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center" height="20">
<tr>
<td background="images/tile_back.gif" width="31">
</td>
<td background="images/tile_back.gif" width="744"> <%= nt.getKV( dbName,"forumDefine", forumId ,"论坛名称") %> > ( 版主: <%= nt.getKV( dbName,"forumDefine", forumId ,"斑竹") %> )</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="750" border="0" cellspacing="1" cellpadding="0" bgcolor="#345487" align="center">
<tr>
<td bgcolor="#FFFFFF">
<table width="750" border="0" cellspacing="1" cellpadding="2">
<tr>
<td colspan="2" bgcolor="#B5CBEA">
</td>
<td width="69" bgcolor="#B5CBEA">
</td>
<td width="65" bgcolor="#B5CBEA">
</td>
<td width="66" bgcolor="#B5CBEA">
</td>
<td width="145" bgcolor="#B5CBEA">
</td>
</tr>
<%
for(int i=iStart;i
String _name = nt.getKV( dbName,globalTableName ,_pid ,"贴子标题");
if( _name.equals("") )
_name = "( 空 )";
if( !nt.getKV( dbName,globalTableName+"_int" ,_pid ,"父贴id").equals("0") )
_name = " "+_name;
%>
<tr>
<td width="27" bgcolor="#E4EAF2">
</td>
<td width="373" bgcolor="#E4EAF2">&id=<%=_pid%>"><%= _name %> </td>
<td width="69" bgcolor="#E4EAF2" align="center" >
<%=
nt.getKV( dbName,"bbs_users" ,nt.getKV( dbName,globalTableName+"_int" ,_pid ,"发贴人id"),"用户名")
%>
</td>
<td width="65" bgcolor="#E4EAF2">
nt.executeQuery( dbName,
" select * from bbs_article_int where k ='父贴id' and v= "+ _pid +" ")
%>
</td>
<td width="66" bgcolor="#E4EAF2">
</td>
<td width="145" bgcolor="#E4EAF2">
</td>
</tr>
<% } %>
<tr bgcolor="#E4EAF2">
<td colspan="6">
<%@include file="ntPageShow.jsp"%>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="31"></td>
<td width="371">
<%@include file="forum_jump_select.jsp"%>
</td>
<td width="372">
</td>
</tr>
<form name="form1" method="post" action="">
</form>
</table>
</body>