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