浏览 1619 次
锁定老帖子 主题:递归读取数据库记录
该帖已经被评为新手帖
|
|
---|---|
作者 | 正文 |
发表时间:2008-11-11
最后修改:2008-11-11
表结构:organId int;organName String;superId int(上一级代码,根目录上级代码为0); package service; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import DbUtil.DBConnectionManager; public class organService{ public String getOrgan() { String returnStr="<List>"; DBConnectionManager connectionMan = DBConnectionManager.getInstance(); Connection con = connectionMan.getConnection("report"); try { Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("select * from organ where superId=0"); while (rs.next()) { returnStr=returnStr+"<rogan id='"+rs.getInt("organId")+"' name='"+rs.getString("organName")+"' superid='"+rs.getInt("superId")+"'>"; returnStr=returnStr+getSub(con,rs.getInt("organId")); returnStr=returnStr+"</rogan>"; } rs.close(); rs=null; stmt.close(); stmt=null; } catch (SQLException e) { System.out.println("SQLException error:" + e); } finally { connectionMan.freeConnection("report", con); } returnStr=returnStr+"</List>"; return returnStr; } public String getSub(Connection con,int superId)throws SQLException { String Str=""; Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("select * from organ where superId="+superId); while(rs.next()){ Str=Str+"<rogan id='"+rs.getInt("organId")+"' name='"+rs.getString("organName")+"' superid='"+rs.getInt("superId")+"'>"; Str=Str+getSub(con,rs.getInt("organId")); Str=Str+"</rogan>"; } rs.close(); rs=null; stmt.close(); stmt=null; return Str; } } 声明:ITeye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
推荐链接
|
|
返回顶楼 | |