select标签实现从后端数据库查询并显示到前端

喜欢ヅ旅行 2023-07-04 14:17 41阅读 0赞

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZyaXN0amNqZG5jZw_size_16_color_FFFFFF_t_70]  
**效果如上图。  
下边上代码：**  
**java代码都是在Controller中**

private void setAgentName (Model model){ 
            List<DicAgentName> list = new ArrayList<>();
    
            List<Agent> agents = agentService.selectByIdReturnAll();
            System.out.println(agents.toString());
            Iterator<Agent> iterator = agents.iterator();
    
            while(iterator.hasNext()){ 
                Agent agent = iterator.next();
                DicAgentName name = new DicAgentName();
                name.setCode(agent.getId());
                name.setMsg(agent.getAgentName());
                list.add(name);
            }
            model.addAttribute("dicNames",list);
        }

在跳转到该方法上之前执行该方法

/** * 添加跳转页面 * @return */
        @GetMapping("saleBefore/{id}")
        public String saleBefore(Model model,@PathVariable("id")Long id){ 
            model.addAttribute("ticket",ticketService.getById(id));
            setTicketTypeStatus(model);
            setAgentName(model);
            return prefix+"sale";
        }

**前端代码：**

<div class="layui-form-item"> <label class="layui-form-label"><span class="c-red">*</span>持卡人：</label> <div class="layui-input-inline"> <select name="holder" title="选择持卡人" id="holder"> <option th:text="未选择" value=""></option> <option th:each="dicn : ${ dicNames}" th:value="${ dicn.code}" th:text="${ dicn.msg}" th:field="${ ticket.holder}">
                    </select>
             </div>'

实现了从数据库查询出对象的list，然后通过遍历器去遍历，最后，通过一个list实现前后端的数据传送，显示到页面。  
**一起进步加油！！！**

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZyaXN0amNqZG5jZw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200211215426936.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZyaXN0amNqZG5jZw==,size_16,color_FFFFFF,t_70