从表中查的步骤省略
controller层
@RequestMapping("/typeUI")
public @ResponseBody List findType() {
List<SomeType> typeList = lostService.findType();//查到数据
return typeList;
}
script和html
<div class="col">
<select name="main_id" id="main_id" class="form-select" aria-label="Default select example">
<option selected>物品类别</option>
</select>
</div>
......
<script type="text/javascript">
$(function () {
$.ajax({
type: 'post',
url: "/lost_found_war_exploded/lost/typeUI",
dataType: "json",
success: function (data) {
$("#main_id").empty();
$("#main_id").append("<option value=''>请选择</option>");
for (var i = 0; i < data.length; i++) {
$("#main_id").append('<option value=' + data[i].id + '>' + data[i].name + '</option>');
}
}
});
});
</script>
如果运行出现报错
这是因为springmvc默认是没有对象转换成json的转换器的,需要手动添加jackson依赖。
<!--对象转换成json-->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.12.5</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.12.5</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.12.5</version>
</dependency>
。。。就很奇怪,原本我也没有添加这个jackson依赖也没有报错,不知道咋回事突然就有这个问题