SqlOperateCtrl.java
2.89 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
package com.ui.ctrl;
import com.ui.contants.HttpUriContants;
import com.ui.http.HttpRestClient;
import com.ui.model.BaseResponse;
import com.ui.model.domain.SqlOperateModel;
import com.ui.model.req.PageRequest;
import com.ui.model.req.SqlOpLogsReq;
import com.ui.model.req.User;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.core.ParameterizedTypeReference;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.ModelAndView;
import javax.servlet.http.HttpSession;
import java.util.List;
/**
* Created by craig.qin on 2017/6/26.
* SQL通用操作-查询
*/
@RestController
@RequestMapping("/sqlOperate")
public class SqlOperateCtrl {
Logger log = LoggerFactory.getLogger(SqlOperateCtrl.class);
@Autowired
private HttpRestClient httpClient;
/*
跳转到sql通用查询界面
*/
@RequestMapping("/toSqlOperate")
public ModelAndView toSqlOperate(Model model){
//查询dbsource
BaseResponse dbSourceResponse=httpClient.defaultGet(HttpUriContants.SQLOPERATE_QUERY_DB_SOURCE_LIST,BaseResponse.class);
if(dbSourceResponse!=null&&dbSourceResponse.getCode()==200){
model.addAttribute("dbSourceList",dbSourceResponse.getData());
}
return new ModelAndView("sqloperate/sqloperate");
}
/*
查询
*/
@RequestMapping("/queryDbList")
@ResponseBody
public BaseResponse queryDbList( HttpSession session,SqlOperateModel sqlOperateModel){
BaseResponse res = httpClient.defaultPost(HttpUriContants.SQLOPERATE_QUERY_DBLIST, sqlOperateModel, BaseResponse.class);
return res;
}
/*
查询
*/
@RequestMapping("/query")
@ResponseBody
public BaseResponse query( HttpSession session,SqlOperateModel sqlOperateModel){
User u = (User) session.getAttribute("user");
sqlOperateModel.setUserId(u.getId());
sqlOperateModel.setUserName(u.getName());
BaseResponse res = httpClient.defaultPost(HttpUriContants.SQLOPERATE_QUERY, sqlOperateModel, BaseResponse.class);
return res;
}
@RequestMapping("/sqlLogs")
public ModelAndView sqlOperateLogs(){
ModelAndView mv = new ModelAndView("sqloperate/sqlOperateLogs");
BaseResponse<List<User>> resp = httpClient.defaultPost(HttpUriContants.GET_All_USER,null, BaseResponse.class);
mv.addObject("users",resp.getData());
return mv;
}
@RequestMapping("/querySqlLogs")
@ResponseBody
public BaseResponse querySqlLogs(SqlOpLogsReq req){
BaseResponse resp = httpClient.defaultPost(HttpUriContants.SQLOPERATE_LOGS_QUERY, req, BaseResponse.class);
return resp;
}
}