实现与数据库交互，动态获取下拉框数据

html代码

<div class="form-group">
							<label class="col-sm-2 control-label">材料1 </label>
							<div class="layui-input-inline col-sm-1" style="display: inline-block; padding: 0">
								<select id="cailaio1" name="cailiao1"  lay-search="" style="width:80px; height: 25px; border: 1px solid #ccc">
									<option value="" >请选择</option>
									<option th:each="a:${wuliaoxinxiDO}" th:value="${a.id}" th:text="${a.name}"></option>
								</select>
							</div>
							<label class="col-sm-4 control-label " style="text-align: right">数量：</label>
							<div class="col-sm-2">
								<input id="cl1shuliang" name="cl1shuliang" class="form-control" type="text" style="height:25px">
							</div>
						</div>

后端代码

controller

@GetMapping("/add")
	@RequiresPermissions("wuliao:gongyidan:add")
	public String add(ModelMap map){
		//查询列表数据
		List<WuliaoxinxiDO> list=wuliaoxinxiService.queryList();
		map.addAttribute("wuliaoxinxiDO",list);
		return "wuliao/gongyidan/add";
	}

service

@Override
	public List<WuliaoxinxiDO> queryList() {
		return wuliaoxinxiDao.queryList();
	}

dao接口

List<WuliaoxinxiDO> queryList();

mapper.xml

<select id="queryList" resultType="com.bootdo.system.domain.WuliaoxinxiDO" parameterType="java.lang.Integer">
	select  A.id, A.name
	from tb_wuliaoxinxi AS A

	</select>

注：dao层接口名与mapper.xml里的id值要对应，否则无法映射，另返回值类型与dao层也要保持一致。