detail.jsp

news文件夹包含的是新闻发布系统的源代码。新闻发布系统分为普通用户访问界面和管理员访问界面两部分。普通用户访问界面使用index.jsp页面进入

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%!
StringBuffer fragment(StringBuffer c)
{
	for(int i=0;i<c.length();i++)
	{
		if(c.charAt(i)=='\n')
		{
			c.delete(i,i+1);
			c.insert(i,"<p>");
		}
	}
	return c;
}
%>
<%
	request.setCharacterEncoding("gb2312");
	String id=request.getParameter("id");
	ResultSet rs=null;
	String sql="select * from news where id="+id;
	rs=conn.executeQuery(sql);	
	if(!rs.next())
		out.println("对不起，没有相关的新闻！");
	else
	{
		StringBuffer content=new StringBuffer(rs.getString("content"));
		content=fragment(content);
%>
<center>
<table border="1" borderColorDark="#ffffec" borderColorLight="#5e5e00" width="100%">
<tr bgcolor="#FFCC99" align="center">
<th><%=rs.getString("title")%></th>
<tr>
<td><%=content%></td>
</table>
<font size="2" color="blue"><%=rs.getString("author")%>&nbsp;发布于&nbsp;<%=rs.getString("pubdate")%>
</center>
<%
	}
	rs.close();
	conn.close();
%>