private StringBuffer TreeStr;
private void makeTree(int parent) throws Exception {
try{
String SQL = "select * from table where parent= " + parent;
ResultSet rs = DB.executeQuery(SQL);
if (rs.next()){
TreeStr.append("<table border=1 width=100%>");
do{
TreeStr.append("<tr>");
TreeStr.append("<td width=0>-></td>");
TreeStr.append("<td>");
makeTree(rs.getInt("id"),i+1);
TreeStr.append("</td></tr>");
}while (rs.next());
TreeStr.append("</table>");
rs.close();
rs = null;
}
}
catch(SQLException e){System.out.println(e.getMessage());}
}
private void makeTree(int parent) throws Exception {
try{
String SQL = "select * from table where parent= " + parent;
ResultSet rs = DB.executeQuery(SQL);
if (rs.next()){
TreeStr.append("<table border=1 width=100%>");
do{
TreeStr.append("<tr>");
TreeStr.append("<td width=0>-></td>");
TreeStr.append("<td>");
makeTree(rs.getInt("id"),i+1);
TreeStr.append("</td></tr>");
}while (rs.next());
TreeStr.append("</table>");
rs.close();
rs = null;
}
}
catch(SQLException e){System.out.println(e.getMessage());}
}
解决方案 »
- include指令的问题
- 关于hibernate连接数据库问题
- 紧急求救:编写一个购车综合计算器applet程序
- 基于struts1.x开发一个论坛
- 怎样将选择的多个checkbox保存到数据库中?
- 我想下jasperreports-3.0.0.jar的源代码,谁有?谁知道在哪里下?
- Tomcat 后台的出错。。
- 求一个ftp多线程 断点续传的下载的源码
- 幼稚servlet部分问题(回答就有分100分)
- 请问:Statement、CallableStatement、PreparedStatement有什么区别????
- 100分求助,tomcat跟iis整合之后,日志太多。显示那个ajp13的错误...一分钟有好几条
- 这样将图片写入数据库,然后再从数据库中显示到页面上来
private StringBuffer TreeStr;
private void makeTree(int parent) throws Exception {
try{
String SQL = "select * from table where parent= " + parent;
ResultSet rs = DB.executeQuery(SQL);
if (rs.next()){
TreeStr.append("<table border=1 width=100%>");
do{
TreeStr.append("<tr>");
TreeStr.append("<td>-></td>");
TreeStr.append("<td>");
makeTree(rs.getInt("id"));
TreeStr.append("</td></tr>");
}while (rs.next());
TreeStr.append("</table>");
rs.close();
rs = null;
}
}
catch(SQLException e){System.out.println(e.getMessage());}
}
小弟愚笨,没看懂,
页面应该是
1000
100001
10000101
100002
1001
在请教,谢谢
------------------
这个程序得到的就是这个效果
import db.DbTrans; //数据库操作
public class Tree {
private DbTrans DB;
public StringBuffer TreeStr = new StringBuffer();
public Tree() {
this.DB = new DbTrans();
}
public StringBuffer getTree() throws Exception {
makeTree(0);
return TreeStr;
} private void makeTree(int parent_id) throws Exception {
try{
String SQL = "select * from table where studentid= " + parent;
ResultSet rs = DB.executeQuery(SQL);
if (rs.next()){
TreeStr.append("<table border=1 width=100%>");
do{
TreeStr.append("<tr>");
TreeStr.append("<td>-></td>");
TreeStr.append("<td>");
if (rs.getInt("endflag")) == 1)//有下级分类
makeTree(rs.getInt("id"),i+1);
TreeStr.append("</td></tr>");
}while (rs.next());
TreeStr.append("</table>");
rs.close();
rs = null;
}
}
catch(SQLException e){System.out.println(e.getMessage());}
}
}
我也是初学者,大家一起研究import java.sql.*;
import db.DbTrans; //数据库操作
public class Tree {
private DbTrans DB;
public StringBuffer TreeStr = new StringBuffer();
public Tree() {
this.DB = new DbTrans();
}
public StringBuffer getTree() throws Exception {
makeTree(0);
return TreeStr;
} private void makeTree(int parent_id) throws Exception {
try{
String SQL = "select * from table where studentid= " + parent;
ResultSet rs = DB.executeQuery(SQL);
if (rs.next()){
TreeStr.append("<table border=1 width=100%>");
do{
TreeStr.append("<tr>");
TreeStr.append("<td>-></td>");
TreeStr.append("<td>");
TreeStr.append(rs.getString("studentname);
if (rs.getInt("endflag")) == 1)//有下级分类
makeTree(rs.getInt("studentid"));
TreeStr.append("</td></tr>");
}while (rs.next());
TreeStr.append("</table>");
rs.close();
rs = null;
}
}
catch(SQLException e){System.out.println(e.getMessage());}
}
}
makeTree函数没有返回值,能在jsp中显示吗?
=----------------------
调用getTree()