【myApps/OBPM版本号】:v4.4- sp XX
【浏览器类型】:Chrome/其他
【联系方式-QQ】:请留下您的QQ号码
【联系电话】: 请留下您的联系电话,以便技术同事更好解决您的问题
【问题描述】:
这是我写的统计图脚本,为啥它报连接不上数据库,显示表不存在,但是数据库里是有这张表的,数据源配置也是对的,就是报错
(function () {
//定义一个数组
var nameList = [];
var clazzList = [];
var chineseList = [];
var mathsList = [];
var mapList = [];
try {
var sql = "SELECT * FROM TLK_资产入库";
println("22222222222" + sql);
var service = Packages.cn.myapps.designtime.common.service.DesignTimeServiceFactory.resolve("cn.myapps.designtime.datasource.service.DataSourceDesignTimeService");
var query = service.queryDataSourceSQL("北京人社局",sql, getApplication());
println("11111111111111111" + query);
if(query!=null){
for(var iterator = query.iterator();iterator.hasNext();){
var doc = iterator.next();//取值
var rtn= doc.get("ITEM_资产类别");
println("图号-------->"+ rtn);
var rtn1 = doc.get("ITEM_数量");
println("图号-------->"+Count);
//往数组里塞值
mapList.push(new String(rtn));
nameList.push(new String(rtn1));
}
}
} catch (e) { }
var option = {
title: {
text: '资产分类统计图',
subtext: '资产分类情况'
},
tooltip: {
trigger: 'axis'
},
legend: {
data: ['数量']
},
toolbox: {
show: true,
feature: {
mark: { show: true },
dataView: { show: true, readOnly: false },
magicType: { show: true, type: ['line', 'bar'] },
restore: { show: true },
saveAsImage: { show: true }
}
},
calculable: true,
xAxis: [
{
type: 'category',
data: mapList
}
],
yAxis: [
{
type: 'value'
}
],
series: [
{
name: '数量',
type: 'bar',
data: mapList,
markPoint: {
data: [
{ type: 'max', name: '最大值' },
{ type: 'min', name: '最小值' }
]
},
markLine: {
data: [
{ type: 'average', name: '平均值' }
]
}
}
]
};
return option;
})()
1、问题描述最好图文并茂,如有视频/脚本可直接放出,这样技术同事在处理该问题时效率更加高效哦~
2、如果该问题已得到解决,请在该帖子下回复\"已解决可结帖\"
|