解决方案 »
- struts+jquery报错$("#remotetabs").tabs is not a function什么情况啊?
- 弹出层中动态加载数据库信息
- js中的innerHTML问题
- 请大家对EXT进行一下评价
- onkeydown 事件 有关输入验证 高手请进。。。
- <html dir="rtl">后,IE下Javascript取坐标出错
- 高分求一代码:textarea如何与grid结合起来,实现我所需要的功能(UP者有分)!
- 如何根据指定的日期格式用正则表达式从字符串中提取出年、月、日?
- 50分求解!document.all中的all指的是什么啊?
- 简单问题高分求---点击后出现新的输入框
- 关于bootstrap和zTree的整合问题
- jqplot 插件问题显示时间问题
public static List<Map<String, Object>> read(String sql) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
conn = DBUtil.getConnection();
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
// 取得结果集列数
int columnCount = rsmd.getColumnCount();
// 构造泛型结果集
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
Map<String, Object> data = null;
// 循环结果集
while(rs.next()){
data = Collections.synchronizedMap(new LinkedHashMap<String, Object>());
// 每循环一条将列名和列值存入Map
for (int i = 1; i <= columnCount; i++) {
String key = rsmd.getColumnLabel(i);
Object value = rs.getObject(rsmd.getColumnLabel(i));
data.put(key,value);
}
// 将整条数据的Map存入到List中
list.add(data);
// System.out.println(list);
}
return list;
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException();
}finally {
DBUtil.closeConnection();
}
}
JsonArray arr = new JsonArray();
JsonObject job = null;for(xx. xx. mapArr){
job = new JsonObject();
job.put("name",xx);
job.put("value",xx);
arr.add(job);
}
return arr.toString();
var arr = [];
for(var key in result){
arr.push({
name:key,
value:result[key]
});
}
console.log(arr); //"[{"name":"8月","value":200},{"name":"6月","value":600},{"name":"7月","value":700},{"name":"1月","value":100},{"name":"5月","value":500},{"name":"3月","value":300},{"name":"2月","value":200},{"name":"11月","value":1100},{"name":"9月","value":900},{"name":"4月","value":400},{"name":"12月","value":1200},{"name":"10月","value":1000}]"
var arr = [];
for(var key in result){
arr.push({
name:key,
value:result[key]
});
}
console.log(arr); //"[{"name":"8月","value":200},{"name":"6月","value":600},{"name":"7月","value":700},{"name":"1月","value":100},{"name":"5月","value":500},{"name":"3月","value":300},{"name":"2月","value":200},{"name":"11月","value":1100},{"name":"9月","value":900},{"name":"4月","value":400},{"name":"12月","value":1200},{"name":"10月","value":1000}]"