jsp下拉选价格区间_JSP下拉选框，级联选择

package com.wbh.wbhsq.web;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.ui.Model;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestParam;

import org.springframework.web.bind.annotation.ResponseBody;

import org.springframework.web.servlet.ModelAndView;

import com.wbh.wbhsq.entity.SqData;

import com.wbh.wbhsq.service.SqdataService;

@Controller

@RequestMapping(value = "${adminPath}/home")

public class HomeController extends BaseController {

@Autowired

private SqdataService sqdataService;

@RequestMapping(value = {"view"})

public String view(@RequestParam(required=true) String loadCode)

{

return "wbhsq/home";

}

@RequestMapping(value="getList")

public ModelAndView getList(ModelAndView model) throws Exception{

List list=sqdataService.findAll();

model.addObject("dataList", list);

model.setViewName("wbhsq/getList");

return model;

}

@RequestMapping(value="setsql")

public ModelAndView setsql(ModelAndView model) throws Exception{

List list=sqdataService.findAllTable();

model.addObject("dataList", list);

list=sqdataService.findAll();

model.addObject("fieldList", list);

model.setViewName("wbhsq/setsql");

return model;

}

/**

* 获取字段列表

* 2015年12月27日

* By hoge

* @param model

* @param rid

* @return

*/

@RequestMapping(value = {"findfields"})

public @ResponseBody List findfields(Model model,String tablename) {

Map filter = new HashMap();

filter.put("tablename", tablename);

List fieldList = sqdataService.query(filter);

return fieldList;

}

}