jeesite框架二级联动最全代码

jeesite框架页面二级联动

<div class="row">
					<div class="col-xs-6">
						<div class="form-group">
							<label class="control-label col-sm-4" title="${text('监控内容')}">${text('监控内容')}：<i class="fa icon-question"></i></label>
							<div class="col-sm-8" >
								<div class="col-xs-6 control-inline width-150" style="float: left;margin-left: -15px;"  >
									  <#form:select path="formNo" id="brandids" blankOption="true" class="form-control" />
								</div>
								<div class="col-xs-6 control-inline width-150" style="float: left">
									<#form:select path="appwd" id="tobaccoId" blankOption="true" class="form-control" />
								</div>
							</div>
						</div>
					</div>
				</div>

$(function (){

	var formNo = "${bzEarlyWarningTeam.formNo}";
	var appwd = "${bzEarlyWarningTeam.appwd}";
	//debugger
		$.ajax({
			url:'${ctx}/questionBank/bzEarlyWarningTeam/queryBzEvaluationTemplate',
				type: "post" ,
				dataType: "json" ,
				success: function (result){
				//console.log(result)
			var str="<option >--请选择--</option>";
			for (var i=0;i<result.length;i++){
				if(result[i].formNo == formNo){

					factor(formNo);
					str+= "<option selected value="+result[i].formNo+">"+result[i].formName+"</option>" ;

				}else {

					str+= "<option value="+result[i].formNo+">"+result[i].formName+"</option>" ;

				}
				$( "#brandids" ).html(str);
			}
		}
	});

	$( "#brandids" ).change( function(){
		factor($("#brandids" ).val());
	});

});


function  factor(formNo) {
	var appwd = "${bzEarlyWarningTeam.appwd}";
	var brandid=formNo;
	$.ajax({
		url:"${ctx}/questionBank/bzEarlyWarningTeam/queryFactorAndDismension",
		type: 'post' ,
		data:{
			'id' :brandid
		},
		dataType: 'json' ,
		success: function (result){
			var str1="<option >--请选择--</option>";
			for (var i=0;i<result.length;i++){
				if(result[i].appwd == appwd){
					str1+= "<option selected value="+result[i].appwd+" >"+result[i].NAME+ "</option>";
				}else {
					str1+= "<option value="+result[i].appwd+" >"+result[i].NAME+ "</option>";
				}
				$( "#tobaccoId" ).html(str1);
			}
		}
	});
}

Controller层 查询第一层

	@RequiresPermissions("warningteam:bzEarlyWarningTeam:view")
	@RequestMapping(value = "queryBzEvaluationTemplate")
	@ResponseBody
	public List<BzEvaluationTemplate> queryBzEvaluationTemplate(Model model,String id) {

		return bzEvaluationTemplateService.findList(new BzEvaluationTemplate());
	}

根据第一层id查取第二层数据

	@RequiresPermissions("warningteam:bzEarlyWarningTeam:view")
	@RequestMapping(value = "queryFactorAndDismension")
	@ResponseBody
	public List<Map<String, Object>> queryFactorAndDismension(String id) {
		List list = bzEarlyWarningTeamService.queryformNo(id);
		return list;
	}

第二层查询的sql语句

<select id="queryformNo" resultType="java.util.Map">
			SELECT
	a.id AS appwd,
	a.`name` AS NAME
FROM
	bz_factor_message a
WHERE
	a.id IN (
		SELECT
			dismension_id
		FROM
			bz_template_detail
		WHERE
			pid =#{id}
	)
UNION
	SELECT
		b.id AS CODE,
		b. NAME AS NAME
	FROM
		bz_dismension_message b
	WHERE
		b.id IN (
			SELECT
				dismension_id
			FROM
				bz_template_detail
			WHERE
				pid =#{id})
	</select>