好用的东东,
TimeSeriesCollection seriesColl = new TimeSeriesCollection();
TimeSeries totalSerie = new TimeSeries("总计");
TimeSeries CMBCSerie = new TimeSeries("招商");
TimeSeries CUPSerie = new TimeSeries("银联");
TimeSeries VnetCNSerie = new TimeSeries("Vnet全国");
TimeSeries JCardSerie = new TimeSeries("骏网");
TimeSeries YCardSerie = new TimeSeries("云网");
TimeSeries PPSerie = new TimeSeries("实卡");
TimeSeries SJQXSerie = new TimeSeries("世纪前线");
TimeSeries VnetGDSerie = new TimeSeries("Vnet广东");
TimeSeries ICBCSerie = new TimeSeries("工商");
ResultSet rs = DatabaseUtils.query(sql); while (rs.next()) {
RegularTimePeriod period = new Day(DateUtils.parseSqlDate(rs.getString("inchargeDate")));
totalSerie.add(period, rs.getFloat("total"));
CMBCSerie.add(period, rs.getFloat("CMBC"));
CUPSerie.add(period, rs.getFloat("CUP"));
VnetCNSerie.add(period, rs.getFloat("VnetCN"));
JCardSerie.add(period, rs.getFloat("JCard"));
YCardSerie.add(period, rs.getFloat("YCard"));
PPSerie.add(period, rs.getFloat("PP"));
SJQXSerie.add(period, rs.getFloat("SJQX"));
VnetGDSerie.add(period, rs.getFloat("VnetGD"));
ICBCSerie.add(period, rs.getFloat("ICBC"));
}
seriesColl.addSeries(totalSerie);
seriesColl.addSeries(PPSerie);
seriesColl.addSeries(JCardSerie);
seriesColl.addSeries(CMBCSerie);
seriesColl.addSeries(CUPSerie);
seriesColl.addSeries(VnetCNSerie);
seriesColl.addSeries(YCardSerie);
seriesColl.addSeries(SJQXSerie);
seriesColl.addSeries(VnetGDSerie);
seriesColl.addSeries(ICBCSerie);
JFreeChart chart = ChartFactory.createTimeSeriesChart("", "", "金额", seriesColl, true, true, false);
chart.setBackgroundPaint(Color.white);
BufferedImage bi = chart.createBufferedImage(567, 240);
byte[] png=ChartUtilities.encodeAsPNG(bi)
TimeSeriesCollection seriesColl = new TimeSeriesCollection();
TimeSeries totalSerie = new TimeSeries("总计");
TimeSeries CMBCSerie = new TimeSeries("招商");
TimeSeries CUPSerie = new TimeSeries("银联");
TimeSeries VnetCNSerie = new TimeSeries("Vnet全国");
TimeSeries JCardSerie = new TimeSeries("骏网");
TimeSeries YCardSerie = new TimeSeries("云网");
TimeSeries PPSerie = new TimeSeries("实卡");
TimeSeries SJQXSerie = new TimeSeries("世纪前线");
TimeSeries VnetGDSerie = new TimeSeries("Vnet广东");
TimeSeries ICBCSerie = new TimeSeries("工商");
ResultSet rs = DatabaseUtils.query(sql); while (rs.next()) {
RegularTimePeriod period = new Day(DateUtils.parseSqlDate(rs.getString("inchargeDate")));
totalSerie.add(period, rs.getFloat("total"));
CMBCSerie.add(period, rs.getFloat("CMBC"));
CUPSerie.add(period, rs.getFloat("CUP"));
VnetCNSerie.add(period, rs.getFloat("VnetCN"));
JCardSerie.add(period, rs.getFloat("JCard"));
YCardSerie.add(period, rs.getFloat("YCard"));
PPSerie.add(period, rs.getFloat("PP"));
SJQXSerie.add(period, rs.getFloat("SJQX"));
VnetGDSerie.add(period, rs.getFloat("VnetGD"));
ICBCSerie.add(period, rs.getFloat("ICBC"));
}
seriesColl.addSeries(totalSerie);
seriesColl.addSeries(PPSerie);
seriesColl.addSeries(JCardSerie);
seriesColl.addSeries(CMBCSerie);
seriesColl.addSeries(CUPSerie);
seriesColl.addSeries(VnetCNSerie);
seriesColl.addSeries(YCardSerie);
seriesColl.addSeries(SJQXSerie);
seriesColl.addSeries(VnetGDSerie);
seriesColl.addSeries(ICBCSerie);
JFreeChart chart = ChartFactory.createTimeSeriesChart("", "", "金额", seriesColl, true, true, false);
chart.setBackgroundPaint(Color.white);
BufferedImage bi = chart.createBufferedImage(567, 240);
byte[] png=ChartUtilities.encodeAsPNG(bi)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货