表1: ID 树形列表ID FolderName 树形列表名 ReferenceID 所属ID 可以设定第一级ReferenceID为0,下一级的ReferenceID为上一级的ID表2:UserID,Username,Password,DepartID--为该用户所拥有的哪些ID(ReferenceID为0)比如: 1 admin admin 1,2,用户admin就拥有由1和2组成的树形列表jsp中: sql="select DepartID from 表2 where UserName= '"+session.getAttribute("UserName")+"'" Result rs = stmt.executeQuery(sql); if(rs!=null){ String str = rs.getString("DepartID").substring(0,rs.getString("DepartID").lastIndexOf(",")); } ResultSet rs1 = stmt.executeQuery("select * from 表1 where ID in "+str+"");
FolderName 树形列表名
ReferenceID 所属ID
可以设定第一级ReferenceID为0,下一级的ReferenceID为上一级的ID表2:UserID,Username,Password,DepartID--为该用户所拥有的哪些ID(ReferenceID为0)比如: 1 admin admin 1,2,用户admin就拥有由1和2组成的树形列表jsp中:
sql="select DepartID from 表2 where UserName= '"+session.getAttribute("UserName")+"'"
Result rs = stmt.executeQuery(sql);
if(rs!=null){
String str = rs.getString("DepartID").substring(0,rs.getString("DepartID").lastIndexOf(","));
}
ResultSet rs1 = stmt.executeQuery("select * from 表1 where ID in "+str+"");