package action;
import java.awt.Font;
import java.io.File;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.Map.Entry;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.plot.PiePlot;
import org.jfree.chart.title.LegendTitle;
import org.jfree.chart.title.TextTitle;
import org.jfree.data.general.DefaultPieDataset;
import DAO.ScoreDAO;
import DAOImp.ScoreDAOImp;
import Util.getObject;
public class ReportAction extends BaseAction{
Object obj = getObject.getObject("ScoreDAO");
ScoreDAO sd = (ScoreDAOImp)obj;
private String month;
private String year;
private Map<String,Double> srmMap;
private Map<String,Double> sraMap;
private Map<String,Double> rdMap;
private Map<String,Double> rmMap;
private Map<String,Double> ryMap = new HashMap<String,Double>();
private JFreeChart jfchart;
public String srmchar(){
srmMap = sd.srm(month);
DefaultPieDataset dataset = new DefaultPieDataset();
Set<Entry<String,Double>> set = srmMap.entrySet();
List<Entry<String,Double>> list = new ArrayList<Entry<String,Double>>(set);
for(Entry<String,Double> e:list){
dataset.setValue(e.getKey(),e.getValue());
}
jfchart = ChartFactory.createPieChart3D("员工月销售成绩",
dataset,
true,
true,
false
);
jfchart.setTitle(new TextTitle("员工月销售成绩", new Font("黑体", Font.ITALIC,22)));
LegendTitle legend = jfchart.getLegend(0);
legend.setItemFont(new Font("宋体", Font.BOLD, 14));
PiePlot plot = (PiePlot) jfchart.getPlot();
plot.setLabelFont(new Font("隶书", Font.BOLD, 12));
plot.setBackgroundAlpha(0.9f);
plot.setForegroundAlpha(0.50f);
return "srmchar";
}
public String srachar(){
sraMap = sd.sra();
DefaultPieDataset dataset = new DefaultPieDataset();
Set<Entry<String,Double>> set = sraMap.entrySet();
List<Entry<String,Double>> list = new ArrayList<Entry<String,Double>>(set);
for(Entry<String,Double> e:list){
dataset.setValue(e.getKey(),e.getValue());
}
jfchart = ChartFactory.createPieChart3D("员工入职以来销售成绩",
dataset,
true,
true,
false
);
jfchart.setTitle(new TextTitle("员工入职以来销售成绩", new Font("黑体", Font.ITALIC,22)));
LegendTitle legend = jfchart.getLegend(0);
legend.setItemFont(new Font("宋体", Font.BOLD, 14));
PiePlot plot = (PiePlot) jfchart.getPlot();
plot.setLabelFont(new Font("隶书", Font.BOLD, 12));
plot.setBackgroundAlpha(0.9f);
plot.setForegroundAlpha(0.50f);
return "srachar";
}
public String rdchar(){
rdMap = sd.rd(year, month);
DefaultPieDataset dataset = new DefaultPieDataset();
Set<Entry<String,Double>> set = rdMap.entrySet();
List<Entry<String,Double>> list = new ArrayList<Entry<String,Double>>(set);
for(Entry<String,Double> e:list){
dataset.setValue(e.getKey(),e.getValue());
}
jfchart = ChartFactory.createPieChart3D("日销售统计",
dataset,
true,
true,
false
);
jfchart.setTitle(new TextTitle("日销售统计", new Font("黑体", Font.ITALIC,22)));
LegendTitle legend = jfchart.getLegend(0);
legend.setItemFont(new Font("宋体", Font.BOLD, 14));
PiePlot plot = (PiePlot) jfchart.getPlot();
plot.setLabelFont(new Font("隶书", Font.BOLD, 12));
plot.setBackgroundAlpha(0.9f);
plot.setForegroundAlpha(0.50f);
return "rdchar";
}
public String rmchar(){
rmMap = sd.rm(year);
DefaultPieDataset dataset = new DefaultPieDataset();
Set<Entry<String,Double>> set = rmMap.entrySet();
List<Entry<String,Double>> list = new ArrayList<Entry<String,Double>>(set);
for(Entry<String,Double> e:list){
dataset.setValue(e.getKey(),e.getValue());
}
jfchart = ChartFactory.createPieChart3D("月销售统计",
dataset,
true,
true,
false
);
jfchart.setTitle(new TextTitle("月销售统计", new Font("黑体", Font.ITALIC,22)));
LegendTitle legend = jfchart.getLegend(0);
legend.setItemFont(new Font("宋体", Font.BOLD, 14));
PiePlot plot = (PiePlot) jfchart.getPlot();
plot.setLabelFont(new Font("隶书", Font.BOLD, 12));
plot.setBackgroundAlpha(0.9f);
plot.setForegroundAlpha(0.50f);
return "rmchar";
}
public String rychar(){
ryMap = sd.ry();
DefaultPieDataset dataset = new DefaultPieDataset();
Set<Entry<String,Double>> set = ryMap.entrySet();
List<Entry<String,Double>> list = new ArrayList<Entry<String,Double>>(set);
for(Entry<String,Double> e:list){
dataset.setValue(e.getKey(),e.getValue());
}
jfchart = ChartFactory.createPieChart3D("年销售统计",
dataset,
true,
true,
false
);
jfchart.setTitle(new TextTitle("年销售统计", new Font("黑体", Font.ITALIC,22)));
LegendTitle legend = jfchart.getLegend(0);
legend.setItemFont(new Font("宋体", Font.BOLD, 14));
PiePlot plot = (PiePlot) jfchart.getPlot();
plot.setLabelFont(new Font("隶书", Font.BOLD, 12));
plot.setBackgroundAlpha(0.9f);
plot.setForegroundAlpha(0.50f);
return "rychar";
}
public String toRyExcel(){
try{
ryMap = sd.ry();
WritableWorkbook book = Workbook.createWorkbook(new File("E:\\tomcat\\webapps\\lunwen\\excel\\年销售成绩.xls"));
WritableSheet sheet = book.createSheet("年销售成绩", 0);
sheet.addCell(new Label(0,0,"年"));
sheet.addCell(new Label(1,0,"销售额"));
int i=1;
Set<Entry<String,Double>> set = ryMap.entrySet();
List<Entry<String,Double>> list = new ArrayList<Entry<String,Double>>(set);
for(Entry<String,Double> e:list){
sheet.addCell(new Label(0,i,e.getKey()));
sheet.addCell(new Label(1,i,e.getValue()+""));
i++;
}
book.write();
book.close();
}catch(Exception e){
e.printStackTrace();
}
return "ry";
}
public String toRmExcel(){
try{
rmMap = sd.rm(year);
WritableWorkbook book = Workbook.createWorkbook(new File("E:\\tomcat\\webapps\\lunwen\\excel\\月销售成绩.xls"));
WritableSheet sheet = book.createSheet("月销售成绩", 0);
sheet.addCell(new Label(0,0,"月"));
sheet.addCell(new Label(1,0,"销售额"));
int i=1;
Set<Entry<String,Double>> set = rmMap.entrySet();
List<Entry<String,Double>> list = new ArrayList<Entry<String,Double>>(set);
for(Entry<String,Double> e:list){
sheet.addCell(new Label(0,i,e.getKey()));
sheet.addCell(new Label(1,i,e.getValue()+""));
i++;
}
book.write();
book.close();
}catch(Exception e){
e.printStackTrace();
}
return "rm";
}
public String toRdExcel(){
try{
rdMap = sd.rd(year, month);
WritableWorkbook book = Workbook.createWorkbook(new File("E:\\tomcat\\webapps\\lunwen\\excel\\日销售成绩.xls"));
WritableSheet sheet = book.createSheet("日销售成绩", 0);
sheet.addCell(new Label(0,0,"日"));
sheet.addCell(new Label(1,0,"销售额"));
int i=1;
Set<Entry<String,Double>> set = rdMap.entrySet();
List<Entry<String,Double>> list = new ArrayList<Entry<String,Double>>(set);
for(Entry<String,Double> e:list){
sheet.addCell(new Label(0,i,e.getKey()));
sheet.addCell(new Label(1,i,e.getValue()+""));
i++;
}
book.write();
book.close();
}catch(Exception e){
e.printStackTrace();
}
return "rd";
}
public String toSraExcel(){
try{
sraMap = sd.sra();
WritableWorkbook book = Workbook.createWorkbook(new File("E:\\tomcat\\webapps\\lunwen\\excel\\员工入职以来成绩.xls"));
WritableSheet sheet = book.createSheet("员工入职以来成绩", 0);
sheet.addCell(new Label(0,0,"员工姓名"));
sheet.addCell(new Label(1,0,"销售额"));
int i=1;
Set<Entry<String,Double>> set = sraMap.entrySet();
List<Entry<String,Double>> list = new ArrayList<Entry<String,Double>>(set);
for(Entry<String,Double> e:lis
spring，hibernate，struts2做的一个系统 （208个子文件） 
ScriptResource.axd 254KB ScriptResource(1).axd 64KB WebResource(1).axd 21KB WebResource.axd 21KB ReportAction.class 11KB ScoreDAOImp.class 4KB ClientAction.class 4KB SellAction.class 4KB GoodAction.class 4KB ClientDAOImp.class 3KB Client.class 3KB Good.class 3KB Sell.class 3KB StaffDAOImp.class 3KB StaffAction.class 2KB GoodDAOImp.class 2KB SellDAOImp.class 2KB LoginAction.class 2KB Staff.class 2KB Score.class 2KB AdminDAOImp.class 2KB LoginInterceptor.class 1KB Admin.class 1KB MD5Util.class 1007B LoadClassName.class 999B HibernateUtil.class 839B getObject.class 815B BaseAction.class 662B ScoreDAO.class 597B ExitAction.class 463B StaffDAO.class 403B ClientDAO.class 389B GoodDAO.class 316B SellDAO.class 316B AdminDAO.class 215B .classpath 3KB org.eclipse.wst.jsdt.ui.superType.container 49B style.css 21KB invalid.css 2KB reset.css 1KB
bg-sidebar.gif 32KB bg-body.gif 21KB bg-radial-gradient.gif 17KB bg-login.gif 13KB login_1.gif 9KB jquery.wysiwyg.gif 4KB bg-menu-item-green.gif 3KB login_button.gif 2KB shortcut-button-bg.gif 1KB bg-menu-item-current.gif 315B bg-button-green.gif 169B bg-content-box.gif 126B bg-form-field.gif 97B menu-current-arrow.gif 59B img_0_0_1 4KB
groovy-all-1.7.5.jar 5.23MB jasperreports-3.5.2.jar 2.35MB hibernate3.jar 2.17MB ojdbc14_11g.jar 1.79MB poi-3.7-20101029.jar 1.6MB xwork-core-2.1.6.jar 1.49MB oracle10g.jar 1.47MB jfreechart-1.0.12.jar 1.31MB jdt-compiler-3.1.1.jar 1.16MB jsf-impl.jar 1.15MB iText-2.1.7.jar 1.08MB freemarker-2.3.15.jar 859KB struts2-core-2.1.8.jar 738KB jxl.jar 687KB commons-collections.jar 558KB antlr-2.7.6.jar 433KB jstl-1.2.jar 405KB standard.jar 384KB jsf-api.jar 314KB dom4j-1.6.1.jar 307KB jcommon-1.0.15.jar 302KB cglib-2.1.3.jar 276KB commons-lang.jar 237KB ognl-2.7.3.jar 234KB commons-digester-2.1.jar 192KB commons-beanutils.jar 184KB junit-4.4.jar 158KB json-lib-2.2.3-jdk15.jar 145KB commons-javaflow-20060411.jar 94KB ezmorph-1.0.6.jar 84KB commons-fileupload-1.2.1.jar 56KB commons-logging.jar 52KB struts2-json-plugin-2.1.8.jar 50KB asm.jar 26KB struts2-jasperreports-plugin-2.1.8.jar 17KB asm-attrs.jar 16KB struts2-jfreechart-plugin-2.1.8.jar 10KB jta.jar 9KB ReportAction.java 10KB ScoreDAOImp.java 3KB GoodAction.java 3KB SellAction.java 3KB ClientAction.java 2KB Client.java 2KB Good.java 2KB共 208 条
- 1
- 2
- 3
资源评论
single_girl2012-12-25比较简单，，
guolovejie
- 粉丝: 7
- 资源: 12
最新资源
- Cocos2d-x教程视频Cocos2d-x常用功能-Cocos2d-x常用工具计时器数据读写文件读写
- (源码)基于Arduino的宠物自动喂食系统.zip
- 毕业设计《基于SSM养老院房间入住管理响应式网站（可升级SpringBoot）》+Java源码+文档说明
- (源码)基于JDBC和Servlet的在线问答系统.zip
- 游戏自动化脚本基本操作DEMO，实现基本的鼠标移动，点击，键盘按键，组合按键，自动化识别图像并点击
- windows一个dbf文件转excel文件的工具
- 在VS Code中开始使用GitHub Copilot.pdf
- Cocos2d-x教程视频Cocos2d-x v3基础数据类型
- vim主题及插件包，使用solarized主题风格，插件包含python代码补全，nedtree等
- (源码)基于C++的登机口分配优化系统.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
