$(function(){
$("#province").change(function(){
var pid = $(this).val();
$("#city").html("<option value=''>--请选择--</option>");
$.post("FindCitiesServlet02",{pid:pid},function(data,status){
$(data).each(function(index,city){
$("#city").append("<option value='" + city.id + "'>" + city.cname + "</option>");
});
},"json");
});
});
package com.sigar.servlet;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.sigar.dao.CityDao;
import com.sigar.dao.impl.CityDaoImpl;
import com.sigar.util.CityBean;
import com.thoughtworks.xstream.XStream;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
/**
* Servlet implementation class FindCitiesServlet02
*/
@WebServlet("/FindCitiesServlet02")
public class FindCitiesServlet02 extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try {
int pid = Integer.parseInt(request.getParameter("pid"));
CityDao cityDao = new CityDaoImpl();
List<CityBean> cities = cityDao.getCities(pid);
JSONArray jsonArray = JSONArray.fromObject(cities);
String json = jsonArray.toString();
response.setContentType("text/html;charset=utf-8");
response.getWriter().write(json);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}