sql = "select top " + currentPage * PAGE_MAX_ROWS;
sql = sql + " * from message order by m_Id desc ";
rs = st.executeQuery(sql);
rs.absolute((currentPage - 1) * PAGE_MAX_ROWS);
while (rs.next()) {
out.print("<ul><li align='left'>" + rs.getString("m_datetime")
+ " " + rs.getString("m_Id") + "</li>");
out.print("<ul><li align='left'>" + rs.getString("m_content")
+ "</li></ul>");
out.print("<ul><ul><li>" //这是回复
+ (rs.getString("r_content") == null ? "" : rs
.getString("r_content")) + "</ul></ul></li>");
out
.print("<li align='right'><p class='flip' >回复</p><div class='panel'><form id='form3' action='reply.jsp?m_Id="
+ rs.getString("m_Id")
+ "¤tPage="
+ currentPage
+ "' method='post'><textarea name='reply' cols='100' rows='4'></textarea><br/><input type='submit' value='提交' /></form></div></li></ul>"); }
sql = sql + " * from message order by m_Id desc ";
rs = st.executeQuery(sql);
rs.absolute((currentPage - 1) * PAGE_MAX_ROWS);
while (rs.next()) {
out.print("<ul><li align='left'>" + rs.getString("m_datetime")
+ " " + rs.getString("m_Id") + "</li>");
out.print("<ul><li align='left'>" + rs.getString("m_content")
+ "</li></ul>");
out.print("<ul><ul><li>" //这是回复
+ (rs.getString("r_content") == null ? "" : rs
.getString("r_content")) + "</ul></ul></li>");
out
.print("<li align='right'><p class='flip' >回复</p><div class='panel'><form id='form3' action='reply.jsp?m_Id="
+ rs.getString("m_Id")
+ "¤tPage="
+ currentPage
+ "' method='post'><textarea name='reply' cols='100' rows='4'></textarea><br/><input type='submit' value='提交' /></form></div></li></ul>"); }
解决方案 »
- struts2+hibernate错误
- 关于hibernate的getCurrentSession和openSession的问题。。。。
- Spring AOP问题
- 中文乱码问题如何解决(uri传递参数)(已经修改server.xml)
- 急、急等(jsp如何防盗连)????
- jsp 连接 sql server 2000的问题
- 字符显示的问题?
- 关于javascript
- JSP怎么样的程序能够把数据传到IE里的OUTLOOK邮件里去~~~~
- 保存COOKIE,定义了期限,然后期限内关闭IE,COOKIE仍然存在吗?
- CSS+DIV布局问题
- 请问jsp:useBean的scope="page",对应于servlet的什么对象?
然后按顺序读取结果集,依次输出。
回复表里的每一条记录都应该有对应的回复的那个主题的ID编号
sql = "select top " + currentPage * PAGE_MAX_ROWS;
sql = sql + " * from message order by m_Id desc ";
rs = st.executeQuery(sql);
rs.absolute((currentPage - 1) * PAGE_MAX_ROWS);
while (rs.next()) {
out.print("<ul><li align='left'>" + rs.getString("m_datetime")+ " " + rs.getString("m_Id") + "</li>");
out.print("<ul><li align='left'>" + rs.getString("m_content")
+ "</li></ul>");
Statement st1 = conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String sql1 = "select * from m_reply where m_Id="+rs.getString("m_Id");
ResultSet rs1 = st.executeQuery(sql1);
while (rs1.next()) {
out.print("<ul><ul><li>"+ (rs1.getString("r_content") == null ? "" : rs1.getString("r_content")) + "</ul></ul></li>");
}
out
.print("<li align='right'><p class='flip' >回复</p><div class='panel'><form id='form3' action='reply.jsp?m_Id="
+ rs.getString("m_Id")
+ "¤tPage="
+ currentPage
+ "' method='post'><textarea name='reply' cols='100' rows='4'></textarea><br/><input type='submit' value='提交' /></form></div></li></ul>"); }我改成这样可还是有错啊,下不考虑时间,只要显示就行啊留言表
m_Id
m_content
m_datetime回复表r_Id
m_Id
r_content
r_datetime