|
JAVA代码:
private static void getSession(ServletRequest request, ServletResponse response) throws SQLException, IOException, NamingException {
// 参数序列化
JSONObject params = (JSONObject) JSONObject.parse(request.getParameter("params"));
// 获取参数
Integer uid = params.getInteger("uid"); // 设备ID
String sql = "select * from a_user where uid = "+uid+"";//查询语句
// 获取数据源连接
Connection conn = Util.getConnection(DATASOURCE_Pubs);
PreparedStatement pstat = conn.prepareStatement(sql);
try {
ResultSet rs = pstat.executeQuery();
ResultSetMetaData metaData = rs.getMetaData();
int columnCount = metaData.getColumnCount();
JSONObject jsonObj = new JSONObject();
if(rs.next()){
// 遍历每一列
for (int i = 0; i <= columnCount; i++) {
String columnName =metaData.getColumnLabel(i);
String value = rs.getString(columnName);
jsonObj.put(columnName, value);
}
}
Util.writeJsonToResponse(response, jsonObj);
}
finally {
// pstat.close();
conn.close();
}
UI代码:
Model.prototype.data1CustomRefresh = function(event) {
var data = event.source;
var params = {
"columns" : Baas.getDataColumns(data),
"limit" : event.limit,
"offset" : event.offset,
"fidd" : "jdbc/Sql2005pubs",
"uid" : 1
};
var success = function(resultData) {
return resultData;
};
Baas.sendRequest({
"url" : "/pubs",
"action" : "getSession",
"params" : params,
"success" : success
});
};
|
|