jsp刷新问题 写了个jsp程序,输出一个表格,但每次刷新页面之后,不是重新替换表格,而是在原有的基础上又出现一个,每刷新一次,增加一个,请问是怎么回事 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <%@ page language="java" contentType="text/html; charset=gbk" pageEncoding="gbk"%><%@ page import="java.sql.*" %> <%! String str=""; private void tree(Connection conn,int id,int level) { Statement stmt=null; ResultSet rs=null; String preStr=""; for(int i=0;i<level;i++) { preStr+="——"; } try{ stmt=conn.createStatement(); String sql="select * from article where pid="+id; rs=stmt.executeQuery(sql); while(rs.next()) { str +="<tr><td>"+rs.getInt("id")+"</td><td>"+preStr+ "<a href ='ShowArticleDetail.jsp?id="+rs.getInt("id")+"'>"+ rs.getString("title")+"</a>"+"</td></tr>"; if(rs.getInt("isleaf")!=0) { tree(conn,rs.getInt("id"),level++); } } }catch(SQLException e) { e.printStackTrace(); } } %> <% Class.forName("com.mysql.jdbc.Driver"); String url="jdbc:mysql://localhost/bbs?user=root&password=zhao888"; //Connection conn=DriverManager.getConnection("jdbc:mysql://172.19.104.2:8080/bbs","root","zhao888"); Connection conn=DriverManager.getConnection(url); Statement stmt=conn.createStatement(); //找到主题帖先输出,之后再输出孩子 ResultSet rs=stmt.executeQuery("select * from article where pid=0"); while(rs.next()) { str +="<tr><td>"+rs.getInt("id")+ "</td><td><a href ='ShowArticleDetail.jsp?id="+rs.getInt("id")+"'>"+rs.getString("title")+"</a></td></tr>"; if(rs.getInt("isleaf")!=0){ tree(conn,rs.getInt("id"),1); } } rs.close();stmt.close();conn.close(); %><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=gbk"><title>Insert title here</title></head><body><table border="1"><%=str %></table></body></html> Hql多表删除语句怎么写? tomcat下的log4j每天一日志问题 DWR的问题。 关于OBPM中的FORM无法显示 JBuilder 开发的struts 程序打成war包时都需要把什么打进去? "上海java面试记",新人看看,里面有该公司面试题! struts2 标签库 <s:iterator> 的迭代问题 请问在sun网站上的什么地方可以下载j2ee? 我怎么找不到呢? JDBC的连接问题 怎样取得数据库中多条数据? String转为Date型 跪求org.apache.axis.client.Call的用法和说明,看别人的源码看不懂啊
<%@ page language="java" contentType="text/html; charset=gbk"
pageEncoding="gbk"%>
<%@ page import="java.sql.*" %>
<%!
String str="";
private void tree(Connection conn,int id,int level)
{
Statement stmt=null;
ResultSet rs=null;
String preStr="";
for(int i=0;i<level;i++)
{
preStr+="——";
}
try{
stmt=conn.createStatement();
String sql="select * from article where pid="+id;
rs=stmt.executeQuery(sql);
while(rs.next())
{
str +="<tr><td>"+rs.getInt("id")+"</td><td>"+preStr+
"<a href ='ShowArticleDetail.jsp?id="+rs.getInt("id")+"'>"+
rs.getString("title")+"</a>"+"</td></tr>";
if(rs.getInt("isleaf")!=0)
{
tree(conn,rs.getInt("id"),level++);
}
}
}catch(SQLException e)
{
e.printStackTrace();
}
}
%>
<%
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost/bbs?user=root&password=zhao888";
//Connection conn=DriverManager.getConnection("jdbc:mysql://172.19.104.2:8080/bbs","root","zhao888");
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
//找到主题帖先输出,之后再输出孩子
ResultSet rs=stmt.executeQuery("select * from article where pid=0");
while(rs.next())
{
str +="<tr><td>"+rs.getInt("id")+
"</td><td><a href ='ShowArticleDetail.jsp?id="+rs.getInt("id")+"'>"+rs.getString("title")+"</a></td></tr>";
if(rs.getInt("isleaf")!=0){
tree(conn,rs.getInt("id"),1);
}
}
rs.close();
stmt.close();
conn.close();
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>Insert title here</title>
</head>
<body>
<table border="1"><%=str %></table>
</body>
</html>