rss.jsp

本论坛开发环境：jdk1.5+Tomcat5.5.17+sql server2000+Windows 2000 1、支持HTML内容编辑,支持网络贴图与附件上传等,支持多种版面风格. 2、论坛

<%@ page contentType="text/xml; charset=gb2312"%>
<%@ page import="java.sql.*"%> 
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ include file="../inc/conn.jsp"%>
<%!ResultSet rs,rs1;%>
<%
String sql="select top 1 * from ftbbsconfig where id=1";
rs=stmt.executeQuery(sql);
rs.next();
%>
<?xml version="1.0" encoding="gb2312"?>
<?xml-stylesheet type="text/xsl" href="rss.xsl" version="1.0"?>
<rss version="2.0">
<channel>
<link><%=rs.getString("bbs_domain")%></link>
<description><%=rs.getString("bbs_name")%></description>
<%
String layer_1=request.getParameter("layer_1");
String layer_2=request.getParameter("layer_2");
String str;
if(layer_1=="null"){
   str=" where BoardID_1='"+layer_1+"' order by id desc";
}
else{
   str=" order by id desc";
}

String sqlstr = "select top 10 * from bbstitle"+str;
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs1=stmt1.executeQuery(sqlstr);

while(rs1.next()) {
    out.println("<item>");
	out.println("<title><![CDATA["+rs1.getString("title")+"]]></title>");
	out.println("<link>"+rs.getString("bbs_domain")+"bbs/ftbbs.jsp?id="+rs1.getString("id")+"</link>");
	out.println("<author>"+rs1.getString("name")+"</author>");
	out.println("<pubDate>"+rs1.getString("dateh")+"</pubDate>");
 	out.println("<description><![CDATA["+rs1.getString("menu")+"]]></description>");
	out.println("</item>");    
}
rs1.close();
stmt1.close();                  
stmt.close();
conn.close();
%>
</channel>
</rss>