尚学堂BBS2007疑问解答
<%!private void tree(Set<Article> articles, Connection con, int id, int grade) {
		String sql = "select * from article where pid = " + id;
		Statement stmt = DB.createStmt(conn);
		ResultSet rs = DB.executeQuery(stmt, sql);
		try {
			while (rs.next()) {
				Article a = new Article();
				a.setId(rs.getInt("id"));
				a.setPid(rs.getInt("pid"));
				a.setRootId(rs.getInt("rootid"));
				a.setTitle(rs.getString("title"));
				a.setLeaf(rs.getInt("isleaf") == 0 ? true : false);
				a.setPdate(rs.getTimestamp("pdate"));
				a.setGrade(grade + 1);
				articles.add(a);
				if (!a.isLeaf()) {
					tree(articles, conn,a.getId(), grade + 1);
				}
			}
		} catch (
SQLException e) {
			e.printStackTrace();
		}
	}%>
<%
	Set<Article> articles = new HashSet<Article>();
	Connection conn = DB.getConn();
	tree(articles, conn, 0, 0);
	DB.close(conn);
%>
不太会提问,我是跟着尚学堂BBS2007做下来的,其中在树状结构展现1的视频中,遇到上述问题,出现红色字体,有错误,报错如下:
严重: Error compiling file: /C:/Program Files/Apache Software Foundation/Tomcat 5.0/work/Catalina/localhost/ShoolWeb//org/apache/jsp\bbs_jsp.java     [javac] Compiling 1 source file
C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\ShoolWeb\org\apache\jsp\bbs_jsp.java:16: 找不到符号
符号: 变量 conn
位置: 类 org.apache.jsp.bbs_jsp
		Statement stmt = DB.createStmt(conn);
		                               ^
C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\ShoolWeb\org\apache\jsp\bbs_jsp.java:30: 找不到符号
符号: 变量 conn
位置: 类 org.apache.jsp.bbs_jsp
					tree(articles, conn,a.getId(), grade + 1);
					               ^
2 错误
我按照视频做的 ,其他的也封装好了,找不出问题,求助高手了~~~~~
------解决方案--------------------Connection con, 
Statement stmt = DB.createStmt(conn);
对比一下,con == conn ?
------解决方案--------------------