forumthread.java

一个用jsp技术实现的新闻发布系统

package net.ijsp.news.forum;

import net.ijsp.news.database.*;
import java.sql.*;

public class ForumThread {

	public static String showBBS(){
		StringBuffer buf = new StringBuffer();
		DBConnect dbc = null;
		
		try{
		dbc = new DBConnect();
		dbc.prepareStatement("Select * from bbs where ParentID=0 order by DateAndTime DESC LIMIT 0,15");
		ResultSet rs = dbc.executeQuery();
//		buf.append("<table border='0' width='100%' cellpadding='2' cellspacing='3'>");
		while(rs.next()){
			String topic    = rs.getString("Topic");
			String userName = rs.getString("UserName");
			int hits		= rs.getInt("hits");
			int id			= rs.getInt("AnnounceID");
			int boardid       = rs.getInt("BoardID");
			if(topic.length()>22) topic = topic.substring(0,20) +"...";
			buf.append("<li><a href=../../bbs/dispbbs.jsp?board="+boardid+"&id="+id+" target='_blank'>"+topic+"</a>&nbsp;("+userName+",<font color=#008000>"+hits+"</font>)<br>");
		}
		}catch(Exception e){
			System.err.println(e);
		}finally{
			try{
				if(dbc!=null)
					dbc.close();
			}catch(Exception e){
			
			}
		}
//		buf.append("</table>");
	return buf.toString();
	}

}