树形下拉框列出各个对应的内容

来源：互联网发布：视频解析源码编辑：程序博客网时间：2024/05/21 12:47

树形结构的下拉框

<div class="main fly-user-main layui-clear"><ul class="layui-nav layui-nav-tree layui-inline" lay-filter="user"><c:choose><c:when test="${not empty dlist}"><c:forEach items="${dlist}" var="zong" varStatus="v"><li class="layui-nav-item"><a href="javascript:;"><i class="layui-icon"></i>${zong.NAME}</a><dl class="layui-nav-child"><c:set value="0" var="zz" /><c:forEach items="${zong.subFenjiliebiao}" var="var" varStatus="vs"><dd class="layui-this">             <a href="<%=basePath%>guanli/shuanglianghuodongliebiao?FENJILIEBIAO_ID=${var.FENJILIEBIAO_ID}">${var.NAME}</a></dd></c:forEach></dl></li></c:forEach></c:when><c:otherwise><tr class="main_info"><td colspan="100" class="center">没有相关数据</td></tr></c:otherwise></c:choose></ul></div>

后台代码：

@RequestMapping(value = "/shuanglianghuodongliebiao")public ModelAndView shuanglianghuodongliebiao() throws Exception {logBefore(logger, "管理-左菜单");ModelAndView mv = this.getModelAndView();PageData pd = this.getPageData();if (Jurisdiction.getSession().getAttribute(Const.SESSION_USERNAME) == null) {// 判断是否登录，传给页面pd.put("denglu", "否");}PageData pd1 = new PageData();pd1.put("idd", pd.getString("FENJILIEBIAO_ID"));//Mapper的检索Page page1 = new Page();page1.setPd(pd1);List<Fenjiliebiao> dlist = fenjiliebiaoService.listSubfenjiliebiaoByParentId("250c827ebcdf4d639783ffae7d1f8277");//顶级IDdlist = this.readdic(dlist);List<PageData> slhd = shuanglianghuodongService.liebiao(page1);pd.put("shangcaidan", "shuanglianghuodong");mv.setViewName("guanli/ster/fuwu/office");mv.addObject("dlist", dlist);mv.addObject("shuanglianghuodongList", slhd);return mv;}

b表是要点击所要出现的内容，a表是左菜单的主键ID（根据顶级ID列出所有的子级）

<select id="listliebiao" parameterType="page" resultType="pd">    SELECT   b.FENJILIEBIAO_ID,b.XINGMING,b.FUJIANMING, a.FENJILIEBIAO_ID    FROM  GUANLI_FENJILIEBIAO a right join GUANLI_SHUANGLIANGHUODONG  b on a.FENJILIEBIAO_ID = b.FENJILIEBIAO_ID   <where>    <if test="pd.idd != null and pd.idd != ''">and ( a.FENJILIEBIAO_ID = #{pd.idd} )</if>   </where></select>

阅读全文

0 0