前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >三级下拉选

三级下拉选

作者头像
唐怀瑟
发布2018-12-14 17:01:18
1K0
发布2018-12-14 17:01:18
举报
文章被收录于专栏:Java面试笔试题Java面试笔试题

1、建表

image.png

一级下拉选没有father_id,二级下拉选的father_id是一级下拉选的id,三级下拉选的father_id是二级下拉选的id,以此类推。 2、SQL

代码语言:javascript
复制
<!-- 报修工单 1级下拉选-->
      <select id="findFirst1" resultMap="BaseResultMap">
          SELECT
                id,
                "name",
                father_id
          FROM
                out_dictionary
          WHERE
              father_id IS NULL
    </select>
    <!-- 报修工单 2级下拉选-->
    <select id="findSecond2" resultMap="BaseResultMap">
        SELECT  
            id,
            "name" ,
            "type",
            father_id  
        FROM  
            out_dictionary  
        WHERE  
            father_id =#{fatherId}
    </select>
    <!-- 报修工单 3级下拉选-->
    <select id="findThird3" resultMap="BaseResultMap">
        SELECT  
            id,
            "name",
            "type",
            father_id  
        FROM  
            out_dictionary  
        WHERE  
            father_id =#{fatherId}
    </select>

3、Dao、Service

代码语言:javascript
复制
/**
     * 报修工单 一级下拉选
     * @param domainId
     * @return
     */
    List<OutDictionary> findFirst1();
    /**
     * 报修工单 二级下拉选
     * @param fatherId
     * @return
     */
    List<OutDictionary> findSecond2(Integer fatherId);
    /**
     * 报修工单 三级下拉选
     * @param fatherId
     * @return
     */
    List<OutDictionary> findThird3(Integer fatherId);

4、impl

代码语言:javascript
复制
@Autowired
    private OutDictionaryDao OutDictionaryMapper;

    //报修工单 一级下拉选
    @Override
    public List<OutDictionary> findFirst1() {
        
        return OutDictionaryMapper.findFirst1();
    }
    //报修工单 二级下拉选
    @Override
    public List<OutDictionary> findSecond2(Integer fatherId) {
        
        return OutDictionaryMapper.findSecond2(fatherId);
    }
    //报修工单 三级下拉选
    @Override
    public List<OutDictionary> findThird3(Integer fatherId) {
        
        return OutDictionaryMapper.findThird3(fatherId);
    }

5、Controller层

代码语言:javascript
复制
/**
         * 报修工单一级下拉选
         * @param req
         * @return
         */
        @RequestMapping(value = "/inFirst1", method = RequestMethod.POST)
        @ResponseBody
        public JSONArray inFirst1( HttpServletRequest   req) {
           //Integer domainId =  Integer.parseInt(req.getSession().getAttribute("domainId").toString());
            List<OutDictionary> first = outDictionaryService.findFirst1();
            JSONArray jsonArr = JSONArray.fromObject(first);
            return jsonArr;
        }
        /**
         * 报修工单二级下拉选
         * @param req
         * @return
         */
        @RequestMapping(value = "/inSecond2", method = RequestMethod.POST)
        @ResponseBody
        public JSONArray inSecond2(Integer fatherId,HttpServletRequest   req) {
            //Integer domainId =  Integer.parseInt(req.getSession().getAttribute("domainId").toString());
            List<OutDictionary> second = outDictionaryService.findSecond2(fatherId);
            JSONArray jsonArr = JSONArray.fromObject(second);
            return jsonArr;
        }
        /**
         * 报修工单三级下拉选
         * @return
         */
        @RequestMapping(value = "/inThird3", method = RequestMethod.POST)
        @ResponseBody
        public JSONArray inThird3(Integer fatherId,HttpServletRequest   req) {
            //Integer domainId =  Integer.parseInt(req.getSession().getAttribute("domainId").toString());
            List<OutDictionary> third = outDictionaryService.findThird3(fatherId);
            JSONArray jsonArr = JSONArray.fromObject(third);
            return jsonArr;
        }

6、JS

代码语言:javascript
复制
//一二三级分类  下拉选
        $('#select_first_rep').combobox({
                    url : '${path }' + '/dictionary/inFirst1',
                    valueField : 'id',
                    textField : 'name',
                    onSelect : function() {
                        var xqmc = $('#select_first_rep').combobox('getText');//获取当前选中的
                        var pccode = $('#select_first_rep').combobox('getValues')[0];//获取当前选
                        $('#select_second_rep').combobox({
                             url : '${path }'+'/dictionary/inSecond2?fatherId='+pccode,
                             valueField : 'id',
                             textField : 'name',
                             onSelect : function() {
                                var pccode1 = $('#select_second_rep').combobox('getValues');
                                var fId;
                                if(pccode1!=null){
                                    fId=pccode1[0];
                                }
                                $('#select_third_rep').combobox({
                                    url : '${path }'+'/dictionary/inThird3?fatherId='+fId,
                                     valueField : 'id',
                                     textField : 'name',
                                     onSelect : function() {}
                                     }) 
                             }
                             })
                    }
        })
本文参与 腾讯云自媒体分享计划,分享自作者个人站点/博客。
原始发表:2018.11.22 ,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体分享计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档