springmvc 多下拉框检索列表

 如图所示：

1.SQL语句：

<select id="listSelect" parameterType="pd" resultType="pd">
		SELECT DISTINCT	LEIXING AS name, 'LEIXING' AS type, LEIXING AS value FROM dongtaizixun_new_jinrongfuwu WHERE LEIXING IS NOT NULL
		UNION
		SELECT DISTINCT	CHANPIN AS name, 'CHANPIN' AS type, CHANPIN AS value FROM dongtaizixun_new_jinrongfuwu WHERE CHANPIN IS NOT NULL
		UNION
		SELECT DISTINCT	DAIKUANEDU AS name, 'DAIKUANEDU' AS type, DAIKUANEDU AS value FROM dongtaizixun_new_jinrongfuwu WHERE DAIKUANEDU IS NOT NULL
		UNION
		SELECT DISTINCT	DAIKUANQIXIAN AS name, 'DAIKUANQIXIAN' AS type, DAIKUANQIXIAN AS value FROM dongtaizixun_new_jinrongfuwu WHERE DAIKUANQIXIAN IS NOT NULL
		UNION
		SELECT DISTINCT	DANBAOFANGSHI AS name, 'DANBAOFANGSHI' AS type, DANBAOFANGSHI AS value FROM dongtaizixun_new_jinrongfuwu WHERE DANBAOFANGSHI IS NOT NULL
		UNION
		SELECT DISTINCT	YINHANGMINGCHENG AS name, 'YINHANGMINGCHENG' AS type, YINHANGMINGCHENG AS value FROM dongtaizixun_new_jinrongfuwu WHERE YINHANGMINGCHENG IS NOT NULL
	</select>

//语句运行如下图：根据type值判断。 

2.Controller

@RequestMapping(value = "/new_jinrongfuwu")
	public ModelAndView new_jinrongfuwu(Page page) throws Exception{
		ModelAndView mv = this.getModelAndView();
		PageData pd = this.getPageData();
		page.setPd(pd);
		List<PageData> newList = new_jinrongfuwuService.list(page);
		List<PageData> selectList = new_jinrongfuwuService.listSelect(pd);
		mv.addObject("selectList", selectList);
		mv.addObject("newList", newList);
		mv.setViewName("yjhlsme/new_jinrongfuwu");
		mv.addObject("pd", pd);
		return mv;
	}

3.jsp

<form action="<%=basePath%>qiantai/new_jinrongfuwu.do" name="Form" id="Form" method=&