easy-ui 有依赖关系的下拉列表(省市区县)

时间:2023-03-08 19:43:31

<!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);
} }