jfreechart mysql_jfreechart柱形图如何从mysql数据库中添加到数据集中

满意答案

manzhu5454

2013.11.17

采纳率：51%    等级：11

已帮助：6442人

图显IP：

只要从数据库中读取数据出来，然后循环记录，把数据填入jfreechart中的数据集就可以啦！

ds = this.getDataSource(request,"ds");

conn = ds.getConnection();

ReportInfoBean infoBean = CommonUtil.getReportInfo(conn, SysConfig.REPORT_TYPE_LIVEDENSITY);

String sqlParam = "";

if(sels == null || sels.equals("")){

sqlParam = infoBean.getControlCamIDs();

}else{

sqlParam = sels;

}

url = SysConfig.WEB_APPNAME_PATH+"reportLiveDensityAction.do?method=toSearchRecord&begintime="+beginTime+"&endtime="+endTime+"&sels="+sels;

projectName = infoBean.getProjectName();

dataOper.setCon(conn);

String sql = "exec Sp_PeopleDensity '"

+userInfo.getUserID()+"'," //用户ID

+"'','"//工程ID

+beginTime+"','"//开始日期

+endTime+"','"//结束日期

+"00:"+infoBean.getXinterval()+":00"+"',"//时间间隔

+infoBean.getMultiple()+","//倍数

+"0"+","//0表示所有出入口，1表示部分出入口(此参数在该存储过程中暂无用)

+infoBean.getAlarmNum()+","//警戒线

+"'"+sqlParam+"'";//镜头号

System.out.println("sql="+sql);

ReportChartFactory factory = new ReportChartFactory();

List list = dataOper.queryToList(sql);

factory.generateLiveDensityMap(list);

JFreeChart jfreechart = factory.createLiveDensityChart(factory.createLiveDensityDataset(list,confBean),infoBean,confBean);

ChartRenderingInfo info = new ChartRenderingInfo(new StandardEntityCollection());

ChartUtilities.saveChartAsJPEG(new File(filePath+fileName),jfreechart,width,height,info);//宽1000，高600

useMapStr = ChartUtilities.getImageMap(fileName,info);

useMapStr = factory.replaceImageMap(useMapStr);

00分享举报