【myApps/OBPM版本号】:v5.0- sp XX
【浏览器类型】:Chrome/其他
【联系方式-QQ】:2587531248
【联系电话】: 请留下您的联系电话,以便技术同事更好解决您的问题
【问题描述】:
统计图脚本有问题,我的 表名是tlk_信息表
数据源的名字是表单数据源
启动之后访问会报错误(附加在图片上)
我想要实现的效果就是横轴为姓名,纵轴为年龄
(function(){
//定义一个数组
var nameList = [];
var genderList = [];
var ageList = [];
//var mathsList = [];
try{
var sql = "select * from tlk_信息表";
var service =Packages.cn.myapps.designtime.common.service.DesignTimeServiceFactory.resolve("cn.myapps.designtime.datasource.service.DataSourceDesignTimeService");
//var datas = queryByDSName("obpm2_testcase",sql);
var datas =service.queryDataSourceSQL("表单数据源",sql,getApplication());
//var datas = queryBySQL(sql);
if(datas!=null){
for(var iterator = datas.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
var name= map1.get("ITEM_姓名");
var gender = map1.get("ITEM_性别");
var age = map1.get("ITEM_年龄");
//var maths = map1.get("item_数学");
//往数组里塞值
nameList.push(new String(name));
genderList.push(new String(gender));
ageList.push(new String(age));
//mathsList.push(new String(maths));
}
}
}catch(e){}
println("nameList4:" + nameList);
println("ageList:" + ageList);
var option = {
title : {
text: "年龄统计图",
},
tooltip : {
trigger: 'axis'
},
legend: {
data:nameList
},
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',
boundaryGap : false,
data : nameList
}
],
yAxis : [
{
type : 'value',
axisLabel : {
formatter: '{value}'
}
}
],
series : [
{
name:'年龄',
type:'line',
data:ageList,
markPoint : {
data : [
{type : 'max', name: '最大值'},
{type : 'min', name: '最小值'}
]
},
markLine : {
data : [
{type : 'average', name: '平均值'}
]
}
}
}
]
};
return option;
})();
1、问题描述最好图文并茂,如有视频/脚本可直接放出,这样技术同事在处理该问题时效率更加高效哦~
2、如果该问题已得到解决,请在该帖子下回复\"已解决可结帖\"
|