ReverseCreateCodeController.java
3.83 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
118
119
120
121
122
123
124
125
126
127
package com.fh.controller.system.createcode;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;
import com.fh.controller.base.BaseController;
import com.fh.util.AppUtil;
import com.fh.util.DbFH;
import com.fh.util.Jurisdiction;
import com.fh.util.PageData;
/**
* 类名称： 反向生成
* 创建人：FH Q313596790
* 修改时间：2016年4月15日
* @version
*/
@Controller
@RequestMapping(value="/recreateCode")
public class ReverseCreateCodeController extends BaseController {
String menuUrl = "recreateCode/list.do"; //菜单地址(权限用)
/**列表
* @return
*/
@RequestMapping(value="/list")
public ModelAndView list() throws Exception{
if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){} //校验权限
ModelAndView mv = this.getModelAndView();
mv.setViewName("system/createcode/recreatecode_list");
mv.addObject("QX",Jurisdiction.getHC()); //按钮权限
return mv;
}
/**列出所有表
* @param
* @throws Exception
*/
@SuppressWarnings("unchecked")
@RequestMapping(value="/listAllTable")
@ResponseBody
public Object listAllTable(){
if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;} //校验权限
PageData pd = new PageData();
pd = this.getPageData();
Map<String,Object> map = new HashMap<String,Object>();
List<PageData> pdList = new ArrayList<PageData>();
List<String> tblist = new ArrayList<String>();
try {
Object[] arrOb = DbFH.getTables(pd);
tblist = (List<String>)arrOb[1];
pd.put("msg", "ok");
} catch (ClassNotFoundException e) {
pd.put("msg", "no");
e.printStackTrace();
} catch (SQLException e) {
pd.put("msg", "no");
e.printStackTrace();
}
pdList.add(pd);
map.put("tblist", tblist);
map.put("list", pdList);
return AppUtil.returnObject(pd, map);
}
/**去代码生成器页面(进入弹窗)
* @return
* @throws Exception
*/
@RequestMapping(value="/goProductCode")
public ModelAndView goProductCode() throws Exception{
ModelAndView mv = this.getModelAndView();
PageData pd = new PageData();
pd = this.getPageData();
String fieldType = "";
StringBuffer sb = new StringBuffer("");
List<Map<String,String>> columnList = DbFH.getFieldParameterLsit(DbFH.getFHCon(pd),pd.getString("table")); //读取字段信息
for(int i=0;i<columnList.size();i++){
Map<String,String> fmap = columnList.get(i);
sb.append(fmap.get("fieldNanme").toString().toUpperCase()); //字段名称
sb.append(",fh,");
fieldType = fmap.get("fieldType").toString().toLowerCase(); //字段类型
if(fieldType.contains("int")){
sb.append("Integer");
}else if(fieldType.contains("NUMBER")){
if(Integer.parseInt(fmap.get("fieldSccle")) > 0){
sb.append("Double");
}else{
sb.append("Integer");
}
}else if(fieldType.contains("double") || fieldType.contains("numeric")){
sb.append("Double");
}else if(fieldType.contains("date")){
sb.append("Date");
}else{
sb.append("String");
}
sb.append(",fh,");
sb.append("备注"+(i+1)); //备注
sb.append(",fh,");
sb.append("是"); //是否前台录入
sb.append(",fh,");
sb.append("无"); //默认值
sb.append(",fh,");
sb.append(fmap.get("fieldLength").toString()); //长度
sb.append(",fh,");
sb.append(fmap.get("fieldSccle").toString()); //小数点右边的位数
sb.append("Q313596790");
}
pd.put("FIELDLIST", sb.toString());
mv.addObject("msg", "edit");
mv.addObject("pd", pd);
mv.setViewName("system/createcode/productCode");
return mv;
}
}
//FHQ 3 1 3 5 9 6 7 9 0