http://www.chinaz.com/download/query.asp
以下网址，可以有很多的bbs源码下载,绝对是物超所值！
以下网址，可以有很多的bbs源码下载,绝对是物超所值！
解决方案 »
- ERP系统的订单子系统
- JPA+JSF延迟加载问题解决
- xsl取的value-of取值问题
- 新手做的一个B/S软件系统构架图,这样合理么?
- rar文件如何读出转换成byte[]?
- 请问Xdoclet1.2.3支不支持hibernate3.2.3呀??
- 有谁知道搞java开发有那些职称可以考？
- 请问我的tomcat为什么不显示错误提示？
- 最近事真多﹐新問題又產生了﹗
- struts1.1的验证问题，在线
- 请帮一下, tomcat 5.0.25 配置连接池时总是报错,不能取得连接,以下是配置文件,测试文件和错误信息.
- 我安装了jdbc也配置了，而且复制到了lib目录下，但我的一个例子(书上的)总显示如下错误，是怎么回事？
<%@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("<!-- "+ sql +" -->");
%><%@include file="ntPage.jsp"%><html>
<head>
<title>闵行办公自动化系统BBS</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<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><img src="images/bbs_top.gif" width="750" height="59"></td>
</tr>
</table>
<table width="750" border="0" cellspacing="1" cellpadding="0" bgcolor="#345487" align="center">
<tr>
<td bgcolor="#EEF2F7" height="20">
<div align="right"><img
title=Search
src="images/top10.gif"
align=absMiddle border=0 name=search width="15" height="15"> <a href="register.jsp">注册</a>
| <img
title=Search
src="images/userlist.gif"
align=absMiddle border=0 name=search width="16" height="16"> <a href="data.jsp">个人资料</a>
| <img
title="Members List"
src="images/yj.gif"
align=absMiddle border=0 name=members width="16" height="16"> <a href="login.jsp">用户登入</a>
| <img
title=Search
src="images/icon_search.gif"
align=absMiddle border=0 name=search width="16" height="15"> <a href="bbs_search.jsp">论坛搜索</a>
| <img
title=Search
src="images/gohome.gif"
align=absMiddle border=0 name=search width="15" height="15"> <a href="bbs.jsp">返回论坛首页</a>
| <img
title=Search
src="images/gohome.gif"
align=absMiddle border=0 name=search width="15" height="15"> <a href="../index.jsp">返回OA首页</a>
</div>
</td>
</tr>
</table>
<table width="750" border="0" cellspacing="0" cellpadding="3" align="center">
<tr>
<td width="31"><img src="images/nav.gif" width="21" height="21"></td>
<td width="371">
<%@include file="forum_jump_select.jsp"%>
</td>
<td width="372">
<div align="right"><a href="newthread.jsp?forumId=<%= request.getParameter("forumId")%>"><img src="images/t_new.gif" width="89" height="25" border="0"></a> </div>
</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">
<div align="center"><img src="images/nav_m.gif" width="8" height="8"></div>
</td>
<td background="images/tile_back.gif" width="744"> <font color="#FFFFFF"><%= nt.getKV( dbName,"forumDefine", forumId ,"论坛名称") %> > ( 版主: <%= nt.getKV( dbName,"forumDefine", forumId ,"斑竹") %> )</font></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">
<div align="center"><font color="#3A4F6C">主 题</font></div>
</td>
<td width="69" bgcolor="#B5CBEA">
<div align="center"><font color="#3A4F6C">作者</font></div>
</td>
<td width="65" bgcolor="#B5CBEA">
<div align="center"><font color="#3A4F6C">回复数</font></div>
</td>
<td width="66" bgcolor="#B5CBEA">
<div align="center"><font color="#3A4F6C">人气指数</font></div>
</td>
<td width="145" bgcolor="#B5CBEA">
<div align="center"><font color="#3A4F6C">最后发表</font></div>
</td>
</tr>
<%
for(int i=iStart;i<iCount;i++) {
int _pid = Integer.parseInt( ntP.data(i,"pid")); 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">
<div align="center"><a href="newthread.jsp?forumId=<%= forumId %>&id=<%=_pid%>"><img src="face/<%= nt.getKV( dbName,globalTableName ,_pid ,"表情图标") %>" width="20" height="20" border=0></a>
</div>
</td>
<td width="373" bgcolor="#E4EAF2"><a href="showthread.jsp?forumId=<%= forumId %>&id=<%=_pid%>"><%= _name %> </a></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">
<div align="center"><%=
nt.executeQuery( dbName,
" select * from bbs_article_int where k ='父贴id' and v= "+ _pid +" ")
%></div>
</td>
<td width="66" bgcolor="#E4EAF2">
<div align="center"><%= nt.getKV( dbName,globalTableName+"_int" , _pid ,"人气") %></div>
</td>
<td width="145" bgcolor="#E4EAF2">
<div align="center"><%= nt.getKV( dbName,globalTableName+"_datetime" ,_pid ,"发贴时间",0,19) %></div>
</td>
</tr>
<% } %>
<tr bgcolor="#E4EAF2">
<td colspan="6"> <br>
<%@include file="ntPageShow.jsp"%>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="31"><img src="images/nav.gif" width="21" height="21"></td>
<td width="371">
<%@include file="forum_jump_select.jsp"%>
</td>
<td width="372">
<div align="right"><a href="newthread.jsp?forumId=<%= request.getParameter("forumId")%>"><img src="images/t_new.gif" width="89" height="25" border="0"></a> </div>
</td>
</tr>
<form name="form1" method="post" action="">
</form>
</table>
<br>
</body>
</html>
数据库Mysql;
不过怕原来公司找我麻烦
不敢给