81,092
社区成员
发帖
与我相关
我的任务
分享问一个问题拉，请帮忙啊！
<%@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);
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<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>
<%
while(rs.next())
{
String s=rs.getString("content");
String title=rs.getString("title");
s=s.replaceAll("\n","<br>");
s=s.replaceAll(" "," ");
%>
<tr>
<td width="20%" bgcolor="#FFFFFF" bordercolordark="#FFFFFF" align="center" height="20"><%=rs.getString("author")%></td>
</center>
<td width="60%" height="20" align="center">
<p align="left"><%=s%></td>
<center>
<td width="20%" height="20" align="center"><%=rs.getString("addtime")%></td>
</tr>
<%
}
%>
</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>
<%@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);
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<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>
<%
while(rs.next())
{
String s=rs.getString("content");
String title=rs.getString("title");
s=s.replaceAll("\n","<br>");
s=s.replaceAll(" "," ");
%>
<tr>
<td width="20%" bgcolor="#FFFFFF" bordercolordark="#FFFFFF" align="center" height="20"><%=rs.getString("author")%></td>
</center>
<td width="60%" height="20" align="center">
<p align="left"><%=s%></td>
<center>
<td width="20%" height="20" align="center"><%=rs.getString("addtime")%></td>
</tr>
<%
}
%>
</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>
...全文
请发表友善的回复…
发表回复
survive 2004-04-14
- 打赏
- 举报
<%@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>
<%@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>
daeren 2004-04-14
- 打赏
- 举报
up
daeren 2004-04-14
- 打赏
- 举报
<title></title>
不在循环内啊，楼上的肯定不对
不在循环内啊，楼上的肯定不对
cucuchen 2004-04-13
- 打赏
- 举报
同意
zljblue 2004-04-13
- 打赏
- 举报
<title><%=rs.getString("title")%></title>
daeren 2004-04-13
- 打赏
- 举报
<title>留言内容</title>
这里的留言内容怎么把他改成当前帖子的标题啊！！！
这里的留言内容怎么把他改成当前帖子的标题啊！！！
