请求对象与JS脚本
以下是DAO里的方法:
//根据人员工号(managerCode)查询权限表中的权限编号(FK_Right_id)
public List<TRight> findByRightId(String managerCode) throws ClassNotFoundException, SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@132.232.36.206:1521:ywdb", "olws", "olws1234");
List<TRight> list=new ArrayList<TRight>();
String sql="select * from t_right t where t.right_id in (select distinct(t.fk_right_id) from t_role_right t where t.fk_role_id in( select t.fk_role_id from t_manager_role t where t.fk_manager_id=( select t.manager_id from t_manager t where t.manager_code='"+managerCode+"')))";
System.out.println("sql==="+sql);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
TRight right=new TRight();
right.setRightId(rs.getLong(1));
right.setRightName(rs.getString(2));
right.setRightLevel(rs.getLong(3));
right.setRightFatherId(rs.getLong(4));
list.add(right);
}
System.out.println("list===="+list);
return list;
}
以下是Action里的一个请求对象:
List<TRight> roleList=user.findByRightId(code);
request.setAttribute("roleList", roleList);
问题:我怎么在页面JS脚本里循环输出请求对象里的值,请高手指点。(我要值的目的要生成一个动态树,判断是根结点还是子结点)
PS:我是新手,没有可用分值,请高手们见谅