从数据库填充achartengine图
我一直在研究这个并没有找到太多东西 - 可能是因为它非常简单。我正试图用我的光标在agraphengine中填充条形图。我已经确认光标会拉回30行（预期），但我不知道从哪里开始。
这是我正在填充的数组：
public static List<double[]> getChartData(int iDays){
List<double[]> values = new ArrayList<double[]>();
Cursor graphData = db.query(CS_Table, new String [] {"count(*)-1"}, null, null, "strftime('%Y-%m-%d', " + Time + ")", "strftime('%Y-%m-%d', " + CS_Drink_Time + ") BETWEEN strftime('%Y-%m-%d', date('now','-" + iDays + " day')) and strftime('%Y-%m-%d','now')", Time , null);
for(graphData.moveToFirst(); graphData.moveToNext(); graphData.isAfterLast()) {
values.add(new double[] {graphData.getInt(0)});
graphData.moveToNext();
}
graphData.close();
return values;
}
public Intent execute(Context context) {
String[] titles = new String[] { "total" };
List<double[]> values = new ArrayList<double[]>(DBhelper.getChartData(30));
values.addAll(DBhelper.getChartData(30));
int[] colors = new int[] { Color.BLUE};
XYMultipleSeriesRenderer renderer = buildBarRenderer(colors);
setChartSettings(renderer, "Drinks in the past " + DBhelper.getChartData(30) + " days", "Date", DBhelper.CS_YDrinks, 0,
/*y axis*/32, 0, /*x axis*/10, Color.GRAY, Color.LTGRAY);
renderer.setXLabels(12);
renderer.setYLabels(10);
renderer.setDisplayChartValues(true);
renderer.setXLabelsAlign(Align.LEFT);
renderer.setYLabelsAlign(Align.LEFT);
// renderer.setPanEnabled(false);
// renderer.setZoomEnabled(false);
renderer.setZoomRate(1.1f);
renderer.setBarSpacing(0.5);
return ChartFactory.getBarChartIntent(context, buildBarDataset(titles, values), renderer,
Type.STACKED);
没有找到相关结果
已邀请:
1 个回复
阀傻