Servlet中获取数据库的数据保存到List集合中,在Servlet中(Pricels为List的一个对象)
Gson gson = new Gson();
json = gson.toJson(Pricels);
response.getWriter().print(json);
在JSP页面中
<select name="roomtype" id="roomtype" οnchange="optionChange()">//一个下拉框中实现事件
<select name="roomprice" id="roomprice">//数据传入的下拉框
用POST方式传参数
function optionChange() {
var xmlhttp;
var roomtype_typeName = roomtype.value;
if (window.XMLHttpRequest) {
xmlhttp = new XMLHttpRequest();
} else {
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function() {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
var returnJSONString = xmlhttp.responseText;
var returnJSON = JSON.parse(returnJSONString);
//加入下拉框中
for (var i = 0; i < returnJSON.length; i++) {
$("#roomprice").append(
"<option value='"+returnJSON[i].price+"'>"
+ returnJSON[i].price + "</option>")
}
}
}
xmlhttp.open("post", "/HotelManagement/AddRoomAjaxServlet", true);
xmlhttp.setRequestHeader("Content-type",
"application/x-www-form-urlencoded;charset=UTF-8");
xmlhttp.send("roomtype_typeName=" + roomtype_typeName);
}