<title>留言内容</title>
这里的留言内容怎么把他改成当前帖子的标题啊!!!

解决方案 »

  1.   

    <title><%=rs.getString("title")%></title>
      

  2.   

    <title></title>
    不在循环内啊,楼上的肯定不对
      

  3.   

    <%@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(" ","&nbsp;");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>&nbsp;&nbsp;&nbsp; <a href="add.jsp?type=reply&id=<%=id%>">我要回帖</a></p></body></html>