package?com.zhuxiaoxuan.action;
import?java.awt.Color;
import?java.sql.Connection;

import?org.apache.poi.ss.usermodel.Chart;
import?org.jfree.chart.ChartFactory;
import?org.jfree.chart.JFreeChart;
import?org.jfree.chart.labels.ItemLabelAnchor;
import?org.jfree.chart.labels.ItemLabelPosition;
import?org.jfree.chart.labels.StandardCategoryItemLabelGenerator;
import?org.jfree.chart.plot.CategoryPlot;
import?org.jfree.chart.plot.PlotOrientation;
import?org.jfree.chart.renderer.category.BarRenderer3D;
import?org.jfree.data.category.CategoryDataset;
import?org.jfree.data.category.DefaultCategoryDataset;
import?org.jfree.data.general.DatasetUtilities;
import?org.jfree.ui.TextAnchor;

import?com.opensymphony.xwork2.ActionSupport;
import?com.zhuxiaoxuan.dao.MailDao;
import?com.zhuxiaoxuan.dao.OutdbDao;
import?com.zhuxiaoxuan.util.DButil;


public?class?BarChartAction?extends?ActionSupport{

	private?JFreeChart?chart;
	private?String?mailId;
	public?String?getMailId（）?{
		return?mailId;
	}
	public?void?setMailId（String?mailId）?{
		this.mailId?=?mailId;
	}
	public?JFreeChart?getChart（）?{
		return?chart;
	}
	DButil?dbutil=new?DButil（）;
	MailDao?maildao=new?MailDao（）;
	OutdbDao?outdbdao=new?OutdbDao（）;
	@Override
	public?String?execute（）?throws?Exception?{
		Connection?con=null;
		con=dbutil.getCon（）;
		String?mailname?=?maildao.getMailNameById（con?mailId）;
		double?[][]data=outdbdao.getOutDb（conmailId）;
		String?[]rowKeys?=?{“第一季度““第二季度““第三季度““第四季度“};?
		String?[]columnKeys={mailname};
????	CategoryDataset?dataset?=?DatasetUtilities.createCategoryDataset（rowKeys?columnKeysdata）;
????	chart?=?ChartFactory.createBarChart3D（“商品銷售統計圖“?“商品“?“銷售“?
????			dataset?PlotOrientation.VERTICAL?true?true?true）;
????	CategoryPlot?plot?=?chart.getCategoryPlot（）;
????	//?設置網格背景顏色
		plot.setBackgroundPaint（Color.white）;
		//?設置網格豎線顏色
		plot.setDomainGridlinePaint（Color.pink）;
		//?設置網格橫線顏色
		plot.setRangeGridlinePaint（Color.pink）;
		
		//?顯示每個柱的數值，并修改該數值的字體屬性
		BarRenderer3D?renderer=new?BarRenderer3D（）;
		renderer.setbaseItemLabelGenerator（new?StandardCategoryItemLabelGenerator（））;
		renderer.setbaseItemLabelsVisible（true）;
		
		renderer.setbasePositiveItemLabelPosition（new?ItemLabelPosition（ItemLabelAnchor.OUTSIDE12?TextAnchor.baseLINE_LEFT））;
		renderer.setItemLabelAnchorOffset（10D）;??
		
		//?設置平行柱的之間距離
		renderer.setItemMargin（0.4）;
		
		plot.setRenderer（renderer）;
		return?SUCCESS;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????661??2014-02-27?10:00??庫存管理系統\kucunManage\.classpath

?????文件???????1044??2014-01-22?12:03??庫存管理系統\kucunManage\.project

?????文件????????503??2014-01-22?12:03??庫存管理系統\kucunManage\.settings\.jsdtscope

?????文件????????598??2014-02-27?10:58??庫存管理系統\kucunManage\.settings\org.eclipse.jdt.core.prefs

?????文件????????487??2014-01-22?12:03??庫存管理系統\kucunManage\.settings\org.eclipse.wst.common.component

?????文件????????345??2014-01-22?12:03??庫存管理系統\kucunManage\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-01-22?12:03??庫存管理系統\kucunManage\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-01-22?12:03??庫存管理系統\kucunManage\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3896??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\action\BarChartAction.class

?????文件???????6868??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\action\CustomerAction.class

?????文件???????4808??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\action\IndbAction.class

?????文件???????2106??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\action\IndexAction.class

?????文件???????9747??2014-03-01?18:24??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\action\MailAction.class

?????文件???????6170??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\action\MailTypeAction.class

?????文件???????6508??2014-03-01?19:58??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\action\OutdbAction.class

?????文件???????4516??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\action\StockAction.class

?????文件????????301??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\action\TestAction.class

?????文件???????2584??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\action\UserAction.class

?????文件???????4181??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\dao\CustomerDao.class

?????文件???????4035??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\dao\IndbDao.class

?????文件???????6535??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\dao\MailDao.class

?????文件???????5123??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\dao\MailTypeDao.class

?????文件???????6023??2014-03-01?19:59??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\dao\OutdbDao.class

?????文件???????3436??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\dao\StockDao.class

?????文件???????1525??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\dao\UserDao.class

?????文件???????1561??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\model\Customer.class

?????文件???????1804??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\model\InDb.class

?????文件???????1806??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\model\Mail.class

?????文件????????990??2014-03-01?18:21??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\model\MailType.class

?????文件???????1819??2014-03-01?19:56??庫存管理系統\kucunManage\build\classes\com\zhuxiaoxuan\model\OutDb.class

............此處省略795個文件信息