有如下代码
html
所在省份:<s:select list="#provinceBean.selectAll()" name="province" listKey="id" listValue="name" id="province"></s:select><p>
所在城市:<select id="city"></select><p>
js
var p = $('#province').val();
$('#province').change(function(){
p = $('#province').val();
$.ajax({
type:"post",
url:"ajax.action",
data:{"id":p},
dataType:"html",
success:{
}
});
jsp
String id = request.getParameter("id");
String sql = "select * from city where city.province="+id;
ResultSet rs = stmt.executeQuery(sql);
我想在jsp中把从数据库中查出来的数据解析成json格式再返回前台显示,应该怎么写JSPJSONSQLHTMLselect
html
所在省份:<s:select list="#provinceBean.selectAll()" name="province" listKey="id" listValue="name" id="province"></s:select><p>
所在城市:<select id="city"></select><p>
js
var p = $('#province').val();
$('#province').change(function(){
p = $('#province').val();
$.ajax({
type:"post",
url:"ajax.action",
data:{"id":p},
dataType:"html",
success:{
}
});
jsp
String id = request.getParameter("id");
String sql = "select * from city where city.province="+id;
ResultSet rs = stmt.executeQuery(sql);
我想在jsp中把从数据库中查出来的数据解析成json格式再返回前台显示,应该怎么写JSPJSONSQLHTMLselect
JSONObject json = new JSONObject();
JSONObject json = new JSONObject();
$.ajax({
type:'POST',
async:false,
url:,
global:false,
success: function(data){
var dataObj=eval("("+data+")");
if(dataObj.result =="success"){
fal=true;
}else{
}
}
});