OlapColumnController.java
5.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
package com.tianbo.controller;
import com.tianbo.common.ModelAndPage;
import com.tianbo.model.TOlapColumn;
import com.tianbo.model.TOlapDataset;
import com.tianbo.service.OlapColumnService;
import com.tianbo.service.OlapDataSetService;
import com.tianbo.util.dao.Page;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.support.RedirectAttributes;
import javax.servlet.http.HttpServletRequest;
import java.math.BigDecimal;
import java.util.List;
/**
* Created by Mr.Xu on 2017/9/13.
*/
@Controller
@RequestMapping("/olapcolumn")
public class OlapColumnController {
@Autowired
private OlapColumnService olapColumnService;
@Autowired
private OlapDataSetService olapDataSetService;
@RequestMapping("showlist")
public ModelAndView findOlapColumn(@ModelAttribute Page page) throws Exception{
int pagelenth=10;
int start=0;
if(page.getBegin()>=0){start=page.getBegin();}
if(page.getLength()>0){pagelenth=page.getLength();}
ModelAndView modelAndView=new ModelAndView();
ModelAndPage modelAndPage=new ModelAndPage();
modelAndPage=olapColumnService.findOlapColumn(start,pagelenth);
List<TOlapDataset> olapDatasetList=olapDataSetService.findOlapDataSet();
modelAndView.addObject("modelAndPage",modelAndPage);
modelAndView.addObject("olapDatasetList",olapDatasetList);
modelAndView.setViewName("olapcolumn/list");
return modelAndView;
}
@RequestMapping("/selectlist")
public ModelAndView selectOlapColumn(HttpServletRequest request,BigDecimal datasetid)throws Exception{
String id=request.getParameter("datasetid");
BigDecimal bd=new BigDecimal(id);
ModelAndView modelAndView=new ModelAndView();
List<TOlapColumn> tOlapColumnList=olapColumnService.selectOlapColumn(bd);
TOlapDataset tOlapDataset=olapDataSetService.findByid(bd);
modelAndView.addObject("tOlapColumnList",tOlapColumnList);
modelAndView.addObject("tOlapDataset",tOlapDataset);
modelAndView.setViewName("olapcolumn/list");
return modelAndView;
}
@RequestMapping("/findByid")
public ModelAndView findByid(HttpServletRequest request,BigDecimal columnid) throws Exception{
ModelAndView modelAndView=new ModelAndView();
String id=request.getParameter("columnid");
BigDecimal bd=new BigDecimal(id);
TOlapColumn olapColumn=olapColumnService.findByid(bd);
List<TOlapDataset> olapDatasetList=olapDataSetService.findOlapDataSet();
modelAndView.addObject("olapDatasetList",olapDatasetList);
modelAndView.addObject("olapColumn",olapColumn);
modelAndView.setViewName("olapcolumn/edit");
return modelAndView;
}
@RequestMapping("/addColumn")
public String addOlapColumn(HttpServletRequest request,TOlapColumn olapColumn,RedirectAttributes attr){
String columnname=request.getParameter("columnname");
String datafield=request.getParameter("datafield");
String nodename=request.getParameter("nodename");
String active=request.getParameter("active");
String datasetid=request.getParameter("datasetid");
olapColumn.setActive(active);
olapColumn.setDatasetid(new BigDecimal(datasetid));
olapColumn.setNodename(nodename);
olapColumn.setColumnname(columnname);
olapColumn.setDatafield(datafield);
olapColumnService.addOlapColumn(olapColumn);
attr.addAttribute("datasetid",new BigDecimal(datasetid));
return "redirect:/olapcolumn/selectlist";
}
@RequestMapping("/deleteByPrimaryKey")
public String deleteByPrimaryKey(HttpServletRequest request,BigDecimal columnid,RedirectAttributes attr){
String id=request.getParameter("columnid");
String datasetid=request.getParameter("datasetid");
BigDecimal bd=new BigDecimal(id);
olapColumnService.deleteByPrimaryKey(bd);
attr.addAttribute("datasetid",new BigDecimal(datasetid));
return "redirect:/olapcolumn/selectlist";
}
@RequestMapping("/updateColumn")
public String updateColumn(HttpServletRequest request,TOlapColumn olapColumn,RedirectAttributes attr){
String id=request.getParameter("columnid");
BigDecimal bd=new BigDecimal(id);
String columnname=request.getParameter("columnname");
String datafield=request.getParameter("datafield");
String nodename=request.getParameter("nodename");
String datasetid=request.getParameter("datasetid");
String active=request.getParameter("active");
olapColumn.setColumnid(bd);
olapColumn.setColumnname(columnname);
olapColumn.setDatafield(datafield);
olapColumn.setNodename(nodename);
olapColumn.setDatasetid(new BigDecimal(datasetid));
olapColumn.setActive(active);
olapColumnService.updateOlapColumn(olapColumn);
attr.addAttribute("datasetid",new BigDecimal(datasetid));
return "redirect:/olapcolumn/selectlist";
}
@RequestMapping("list")
public String list(){return "olapcolumn/list";}
}