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

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.general.DatasetUtilities;
import?org.jfree.ui.TextAnchor;

import?com.dyj.dao.GoodDao;
import?com.dyj.dao.OutstockDao;
import?com.dyj.util.DbUtil;
import?com.opensymphony.xwork2.ActionSupport;


public?class?BarCharAction?extends?ActionSupport{

	/**
	?*?
	?*/
	private?static?final?long?serialVersionUID?=?1L;
???????private?JFreeChart?chart;
???????private?String?goodid;
???????
	public?JFreeChart?getChart（）?{
		return?chart;
	}
	
	public?String?getGoodid（）?{
		return?goodid;
	}

	public?void?setGoodid（String?goodid）?{
		this.goodid?=?goodid;
	}

	DbUtil?dbUtil=new?DbUtil（）;
	GoodDao?gooddao=new?GoodDao（）;
????OutstockDao?outstockdao?=?new?OutstockDao（）;
	@Override
	public?String?execute（）?throws?Exception?{
		Connection?con=null;
		con=dbUtil.getCon（）;
		String?goodname?=?gooddao.getGoodById（con?goodid）;
		double?[][]data=outstockdao.getOutstock（congoodid）;
		String?[]rowKeys?=?{“第一季度““第二季度““第三季度““第四季度“};?
		String?[]columnKeys={goodname};
????	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;
	}

}

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

?????文件????????725??2013-11-24?16:17??JavaWeb庫存管理系統V1.1\Ccgl\.classpath

?????文件???????1037??2013-11-24?16:17??JavaWeb庫存管理系統V1.1\Ccgl\.project

?????文件????????503??2013-11-24?16:17??JavaWeb庫存管理系統V1.1\Ccgl\.settings\.jsdtscope

?????文件????????215??2013-11-26?21:25??JavaWeb庫存管理系統V1.1\Ccgl\.settings\org.eclipse.core.resources.prefs

?????文件????????395??2013-11-24?16:17??JavaWeb庫存管理系統V1.1\Ccgl\.settings\org.eclipse.jdt.core.prefs

?????文件????????440??2013-11-24?16:17??JavaWeb庫存管理系統V1.1\Ccgl\.settings\org.eclipse.wst.common.component

?????文件????????305??2013-11-24?16:17??JavaWeb庫存管理系統V1.1\Ccgl\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2013-11-24?16:17??JavaWeb庫存管理系統V1.1\Ccgl\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-11-24?16:17??JavaWeb庫存管理系統V1.1\Ccgl\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3905??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\action\BarCharAction.class

?????文件???????7501??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\action\GoodAction.class

?????文件???????6552??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\action\GoodcategoriesAction.class

?????文件???????1967??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\action\IndexAction.class

?????文件???????4630??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\action\LineCharAction.class

?????文件???????3952??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\action\LoginAction.class

?????文件???????8559??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\action\OutStockAction.class

?????文件???????2914??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\action\PieCharAction.class

?????文件???????8757??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\action\StockAction.class

?????文件???????8516??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\action\StorageAction.class

?????文件???????7071??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\action\SupplierAction.class

?????文件???????4010??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\dao\GoodcategoriesDao.class

?????文件???????5797??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\dao\GoodDao.class

?????文件???????5421??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\dao\OutstockDao.class

?????文件???????5211??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\dao\StockDao.class

?????文件???????4708??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\dao\StorageDao.class

?????文件???????3375??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\dao\SupplierDao.class

?????文件???????1419??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\dao\UserDao.class

?????文件???????1905??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\model\Good.class

?????文件????????953??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\model\Goodcategories.class

?????文件???????1844??2018-03-26?10:12??JavaWeb庫存管理系統V1.1\Ccgl\build\classes\com\dyj\model\OutStock.class

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