<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>修改</title>
<!-- 1jQuery的js包 -->
<script type="text/javascript" src="jquery-easyui-1.4.4/jquery.min.js"></script>
<!-- 2css资源 -->
<link rel="stylesheet" type="text/css" href="jquery-easyui-1.4.4/themes/default/easyui.css">
<!-- 3图标资源 -->
<link rel="stylesheet" type="text/css" href="jquery-easyui-1.4.4/themes/icon.css">
<!-- 4easyui的js包 -->
<script type="text/javascript" src="jquery-easyui-1.4.4/jquery.easyui.min.js"></script>
<!-- 5本地语言包 -->
<script type="text/javascript" src="jquery-easyui-1.4.4/locale/easyui-lang-zh_CN.js"></script>
</head>
<body>
修改页面
<input id="cc2" class="easyui-combobox"
data-options="valueField:'id',textField:'text',
url:'json/combo.json'" />
<br><br>
省：<input id="sheng" class="easyui-combobox" style="width:100px"
data-options="
url:'RegionServlet?parentid=0',
valueField:'regionID',
textField:'regionName',
onSelect:function(region){
$('#shi').combobox('clear');
$('#shi').combobox('reload','RegionServlet?parentid='+region.regionID);
//清理原有项
$('#qu').combobox('clear');
//清理下拉项
$('#qu').combobox('reload','RegionServlet');
}
"/>
<br><br>
市：<input id="shi" class="easyui-combobox" style="width:100px"
data-options="
url:'RegionServlet',
valueField:'regionID',
textField:'regionName',
onSelect:function(region){
$('#qu').combobox('clear');
$('#qu').combobox('reload','RegionServlet?parentid='+region.regionID);
}
"/>
<br><br>
区县：<input id="qu" class="easyui-combobox" style="width:100px"
data-options="
url:'RegionServlet',
valueField:'regionID',
textField:'regionName',
"/>
</body>
</html>
package com.hanqi.dao;
import java.util.ArrayList;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import com.hanqi.entity.Region;
public class RegionDAO {
Configuration cfg=null;
ServiceRegistry sr=null;
SessionFactory sf=null;
Session se=null;
Transaction tr=null;
public RegionDAO(){
//加载配置文件
cfg=new Configuration().configure();
//注册服务
sr=new StandardServiceRegistryBuilder()
.applySettings(cfg.getProperties()).build();
}
//初始化
private void init()
{
sf=cfg.buildSessionFactory(sr);
se=sf.openSession();
tr=se.beginTransaction();
}
//提交和释放资源
private void destory()
{
tr.commit();
se.close();
sf.close();
}
//获取数据列表
public List<Region> getList(String parentid)
{
List<Region> rtn=new ArrayList<>();
init();
//查询数据
rtn=se.createQuery("from Region where parentRegionID = ?")
.setString(0, parentid).list();
destory();
return rtn;
}
}
package com.hanqi.Service;
import java.util.List;
import com.hanqi.dao.RegionDAO;
import com.hanqi.entity.Region;
public class RegionService {
//获取
public List<Region> getList(String parentid){
return new RegionDAO().getList(parentid);
}
}
package com.hanqi.Servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.alibaba.fastjson.JSONArray;
import com.hanqi.Service.RegionService;
import com.hanqi.entity.Region;
public class RegionServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public RegionServlet() {
super();
// TODO Auto-generated constructor stub
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html");
//接收参数
String parentid=request.getParameter("parentid");
if(parentid!=null)
{
//读取地区列表
List<Region> lr=new RegionService().getList(parentid);
//返回JSON格式的数据
String json=JSONArray.toJSONString(lr);
response.getWriter().print(json);
}
else
{
response.getWriter().print("[]");
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
