getPersonAccountInfo.jsp
4.69 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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
<%--
Created by IntelliJ IDEA.
User: zhaiyaqi
Date: 2020/3/15
Time: 7:34 PM
To change this template use File | Settings | File Templates.
--%>
<%@ page import="com.alibaba.fastjson.JSON" %>
<%@ page import="com.alibaba.fastjson.JSONObject" %>
<%@ page import="org.apache.commons.logging.Log" %>
<%@ page import="org.apache.commons.logging.LogFactory" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.io.ByteArrayOutputStream" %>
<%@ page import="java.io.InputStream" %>
<%@ page import="weaver.general.BaseBean" %>
<%@ page import="weaver.conn.RecordSet" %>
<%@ page import="com.alibaba.fastjson.JSONArray" %>
<%@ page import="weaver.conn.RecordSetDataSource" %>
<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="kry.sql.util.StringUtil" %>
<%@ page import="java.util.Collections" %>
<%@ page import="emo.macro.ob.OB" %>
<%@ page import="java.util.Vector" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
response.setContentType("application/json;charset=utf-8");
out.clear();
writeLog("【开始调用获取资金账户接口 个人】：======================");
JSONObject result = new JSONObject(true);
result.put("code", -1);
try {
String id = request.getParameter("id");
writeLog("get the param ="+JSONObject.toJSONString(id));
if (null == id || null == id){
result.put("message", "传递参数为空");
out.print(result.toJSONString());
return ;
}
RecordSet rs = new RecordSet();
String sql;
sql = "select zjcgzhzh as account from uf_zzryzjzh where id ="+id+"";
writeLog("sql = {}"+sql);
rs.execute(sql);
rs.next();
String account = rs.getString("account");
result.put("code", 0);
result.put("message", "获取数据成功");
result.put("data", account);
out.print(result.toJSONString());
} catch (Exception e) {
e.printStackTrace();
result.put("message", "获取参数异常");
out.print(result.toJSONString());
return;
}
%>
<%!
private void writeLog(Object o) {
Log var3 = LogFactory.getLog(this.getClass().getName());
if(o instanceof Exception) {
var3.info(this.getClass().getName(), (Exception)o);
} else {
var3.info(o);
}
}
private JSONObject getData(String GDZCKPH) {
JSONObject jo = new JSONObject();
RecordSetDataSource rsds = new RecordSetDataSource("HERP");
String sql;
sql = "select * from uf_gdzcb where id='" + GDZCKPH + "'";
rsds.execute(sql);
String[] fields = rsds.getColumnName();
List<String> list = new ArrayList<String>();
list.add("ID");
list.add("REQUESTID");
list.add("FORMMODEID");
list.add("MODEDATACREATER");
list.add("MODEDATACREATERTYPE");
list.add("MODEDATACREATEDATE");
list.add("MODEDATACREATETIME");
list.add("MODEUUID");
list.add("FLOOR");
list.add("LONGITUDE");
list.add("LATITUDE");
list.add("REGIONUUID");
list.add("REGIONNAME");
list.add("REGIONAREA");
list.add("NEARESTREGIONUUID");
list.add("NEARESTREGIONNAME");
list.add("NEARESTREGIONDISTANCE");
list.add("IMAGELIST");
list.add("STATUS");
while (rsds.next()) {
for (String field : fields) {
if (!list.contains(field.toUpperCase())) {
jo.put(field.toUpperCase(), Util.null2String(rsds.getString(field)));
}
}
}
return jo;
}
private String getGDZCKPH(String id) {
if (id.equals("")) {
return "";
}
RecordSetDataSource rsds = new RecordSetDataSource("HERP");
String sql;
sql = "select GDZCKPH from UF_GDZCB where id=" + id;
rsds.execute(sql);
rsds.next();
return Util.null2String(rsds.getString("GDZCKPH"));
}
private String getLastName(String id) {
RecordSet rs = new RecordSet();
String sql;
sql = "select lastname from hrmresource where id=" + id;
rs.execute(sql);
rs.next();
return Util.null2String(rs.getString(1));
}
private byte[] readInputStream(InputStream inStream) throws Exception {
ByteArrayOutputStream outSteam = new ByteArrayOutputStream();
byte[] buffer = new byte[1024];
boolean var3 = false;
int len;
while((len = inStream.read(buffer)) != -1) {
outSteam.write(buffer, 0, len);
}
outSteam.close();
inStream.close();
return outSteam.toByteArray();
}
%>