用Struts2+Spring+Hibernate三大框架完成的级联操作

package org.lxh.action; import java.io.PrintWriter; import java.util.List; import javax.servlet.http.HttpServletResponse; import net.sf.json.JSONArray; import net.sf.json.JSONObject; import org.apache.struts2.ServletActionContext; import org.lxh.pojo.City; import org.lxh.pojo.Country; import org.lxh.pojo.Province; import org.lxh.service.CascadeService; import com.opensymphony.xwork2.ActionSupport; public class CascadeAction extends ActionSupport { /** * */ private static final long serialVersionUID = 1L; private CascadeService cascadeService; private List<Province> provinces; private String province_id; private String city_id; private String jsonData; public CascadeService getCascadeService() { return cascadeService; } public void setCascadeService(CascadeService cascadeService) { this.cascadeService = cascadeService; } public List<Province> getProvinces() { return provinces; } public void setProvinces(List<Province> provinces) { this.provinces = provinces; } public String getProvince_id() { return province_id; } public void setProvince_id(String province_id) { this.province_id = province_id; } public String getCity_id() { return city_id; } public void setCity_id(String city_id) { this.city_id = city_id; } public String getJsonData() { return jsonData; } public void setJsonData(String jsonData) { this.jsonData = jsonData; } public String queryProvinces(){ String hql="from Province"; String[] parameters=null; provinces=cascadeService.getProvinces(hql, parameters); return SUCCESS; } public String queryCities(){ String hql1="from Province where id=?"; String[] parameters1={province_id}; Province province=cascadeService.getProvinceByProvinceId(hql1, parameters1); String hql2="from City where province_selfnum=?"; String[] parameters2={province.getSelfnum()}; List<City> cities=cascadeService.getCitiesByProvinceSelfnum(hql2, parameters2); JSONArray array=new JSONArray(); for(City city:cities){ // 遍历,转成json数组 JSONObject json=new JSONObject(); json.put("id", city.getId()); json.put("selfnum", city.getSelfnum()); json.put("name", city.getName()); json.put("province_selfnum", city.getProvince_selfnum()); array.add(json); } jsonData=array.toString(); //System.out.println(jsonData); /** Map<String,Object> session=ActionContext.getContext().getSession(); session.put("jsonData", jsonData); */ try { HttpServletResponse response=ServletActionContext.getResponse(); response.setContentType("application/json;charset=UTF-8"); response.setCharacterEncoding("UTF-8"); PrintWriter pw=response.getWriter(); pw.write(jsonData); pw.flush(); pw.close(); } catch (Exception e) { e.printStackTrace(); } return SUCCESS; } public String queryCountries(){ String hql1="from City where id=?"; String[] parameters1={city_id}; City city=cascadeService.getCityByCityId(hql1, parameters1); String hql2="from Country where city_selfnum=? and province_selfnum=?"; String[] parameters2={city.getSelfnum(),city.getProvince_selfnum()}; List<Country> countries=cascadeService.getCountriesByProvinceSelfnumCitySelfnum(hql2, parameters2); /** for(Country country:countries){ System.out.println(country.getName()); } */ JSONArray array=new JSONArray(); for(Country country:countries){ // 遍历,转成json数组 JSONObject json=new JSONObject(); json.put("id", country.getId()); json.put("selfnum", country.getSelfnum()); json.put("name", country.getName()); json.put("province_selfnum", country.getProvince_selfnum()); json.put("city_selfnum", country.getCity_selfnum()); array.add(json); } jsonData=array.toString(); //System.out.println(jsonData); try { HttpServletResponse response=ServletActionContext.getResponse(); response.setContentType("application/json;charset=UTF-8"); response.setCharacterEncoding("UTF-8"); PrintWriter pw=response.getWriter(); pw.write(jsonData); pw.flush(); pw.close(); } catch (Exception e) { e.printStackTrace(); } return SUCCESS; } }