问一个问题拉,请帮忙啊! <title>留言内容</title>这里的留言内容怎么把他改成当前帖子的标题啊!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <title><%=rs.getString("title")%></title> <title></title>不在循环内啊,楼上的肯定不对 <%@page contentType="text/html;charset=gb2312"%><%@page import="java.sql.*"%><%String id=request.getQueryString();Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection conn=DriverManager.getConnection("jdbc:odbc:checkuser");Statement sqlStatement=conn.createStatement();String sql="select * from main where id="+id+" or class='"+id+"'";ResultSet rs=sqlStatement.executeQuery(sql);StringBuffer bodyString=new StringBuffer("");String title="";while(rs.next()){String s=rs.getString("content");title=rs.getString("title");s=s.replaceAll("\n","<br>");s=s.replaceAll(" "," ");bodyString.append(" <tr>");bodyString.append(" <td width=\"20%\" bgcolor=\"#FFFFFF\" bordercolordark=\"#FFFFFF\" align=\"center\" height=\"20\">"+rs.getString("author")+"</td>");bodyString.append(" </center>");bodyString.append(" <td width=\"60%\" height=\"20\" align=\"center\">");bodyString.append(" <p align=\"left\">"+s+"</td>");bodyString.append(" <center>");bodyString.append(" <td width=\"20%\" height=\"20\" align=\"center\">"+rs.getString("addtime")+"</td>");bodyString.append(" </tr>");}%><html><head><meta http-equiv="Content-Language" content="zh-cn"><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title><%=title%></title><link href="text.css" rel="stylesheet" type="text/css"></head><body><p align="center">帖子标题:<div align="center"> <center> <table border="1" width="80%" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="0" bordercolorlight="#000000"> <tr> <td width="20%" bgcolor="#9C9C63" bordercolordark="#9C9C63" align="center" height="20"><b><font size="2" color="#FFFFFF">作者</font></b></td> <td width="60%" height="20" align="center" bordercolordark="#9C9C63" bgcolor="#9C9C63"><b><font color="#FFFFFF">内容</font></b></td> <td width="20%" height="20" align="center" bordercolordark="#9C9C63" bgcolor="#9C9C63"><b><font color="#FFFFFF">发表时间</font></b></td> </tr><%=bodyString%> </table> </center></div><p align="center"><a href="add.jsp?type=new">我要发帖</a> <a href="add.jsp?type=reply&id=<%=id%>">我要回帖</a></p></body></html> 麻烦大家给看下Tomcat报错!?!多谢! %>转义的问题 如何能够在记事本中输出在运行tomcat时程序的出错信息? jsp页面上能不能使用泛性编程 jspsmart在javabean中怎么初始化 tomcat 4.1 的 Connection Pool怎么配置? JSP 如何输出打印页面? 日期转换的问题给我看下: 98下不用PWS能不能配JSP环境,用什么服务器软件,怎么配置 求转为脚本 真诚请教:如何切换不同的tomcat,望牛人不吝啬回答,分数封上????? 急求以3DES按ECB模式加密算法,请各位老大帮忙(在线等候,急!!!)
不在循环内啊,楼上的肯定不对
<%@page import="java.sql.*"%>
<%
String id=request.getQueryString();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:checkuser");
Statement sqlStatement=conn.createStatement();
String sql="select * from main where id="+id+" or class='"+id+"'";
ResultSet rs=sqlStatement.executeQuery(sql);StringBuffer bodyString=new StringBuffer("");
String title="";while(rs.next())
{
String s=rs.getString("content");
title=rs.getString("title");s=s.replaceAll("\n","<br>");
s=s.replaceAll(" "," ");bodyString.append(" <tr>");
bodyString.append(" <td width=\"20%\" bgcolor=\"#FFFFFF\" bordercolordark=\"#FFFFFF\" align=\"center\" height=\"20\">"+rs.getString("author")+"</td>");
bodyString.append(" </center>");
bodyString.append(" <td width=\"60%\" height=\"20\" align=\"center\">");
bodyString.append(" <p align=\"left\">"+s+"</td>");
bodyString.append(" <center>");
bodyString.append(" <td width=\"20%\" height=\"20\" align=\"center\">"+rs.getString("addtime")+"</td>");
bodyString.append(" </tr>");
}
%><html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=title%></title>
<link href="text.css" rel="stylesheet" type="text/css">
</head><body>
<p align="center">帖子标题:
<div align="center">
<center>
<table border="1" width="80%" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="0" bordercolorlight="#000000"> <tr>
<td width="20%" bgcolor="#9C9C63" bordercolordark="#9C9C63" align="center" height="20"><b><font size="2" color="#FFFFFF">作者</font></b></td>
<td width="60%" height="20" align="center" bordercolordark="#9C9C63" bgcolor="#9C9C63"><b><font color="#FFFFFF">内容</font></b></td>
<td width="20%" height="20" align="center" bordercolordark="#9C9C63" bgcolor="#9C9C63"><b><font color="#FFFFFF">发表时间</font></b></td>
</tr>
<%=bodyString%>
</table>
</center>
</div><p align="center"><a href="add.jsp?type=new">我要发帖</a> <a href="add.jsp?type=reply&id=<%=id%>">我要回帖</a></p></body></html>