testsystemjspbean.java

java网站源代码,有数据库的操作代码,业务逻辑代码等内容

                try{
                        fos_jpg.close();
                }catch(Exception e){
                        e.printStackTrace();
                }
        }
      }

      public static void creatColPicture(HttpServletRequest request,
                                         ScoreTotleRec[] scoreTotleRec,
                                         ScoreItemsRec[] scoreItemsRec,
                                         String imagePath)
          throws Exception{

        HttpSession session = request.getSession(true);
        String sName = null;
        String sScore = null;

        for (int i=0; i<scoreTotleRec.length; i++){

             sName = scoreTotleRec[i].getTName();
             sScore = scoreTotleRec[i].getScore();
        }

        CategoryDataset dataset = getColDataSet(scoreItemsRec);
//        DefaultPieDataset data = getDataSet(scoreWholeRec);
        JFreeChart chart = ChartFactory.createBarChart3D(
                                                sName + " 总分：" + sScore, // 图表标题
                                                "", // 目录轴的显示标签
                                                "", // 数值轴的显示标签
                                                dataset, // 数据集
                                                PlotOrientation.HORIZONTAL, // 图表方向：水平、垂直
                                                true, 	// 是否显示图例(对于简单的柱状图必须是false)
                                                false, 	// 是否生成工具
                                                false 	// 是否生成URL链接
                                                );

        FileOutputStream fos_jpg = null;
        try {

                String personID = request.getParameter("selected");
                String filename= "col_fruit" + personID + ".jpg";
                fos_jpg = new FileOutputStream(imagePath + filename);
                session.setAttribute("filename", filename);
                ChartUtilities.writeChartAsJPEG(fos_jpg,
                                                100,
                                                chart,
                                                600,
                                                1000,
                                                null);
        } catch (Exception e) {
                e.printStackTrace();
        }

        finally {
                try {
                        fos_jpg.close();
                } catch (Exception e) {
                        e.printStackTrace();
                }
        }
   }


   public static void creatLinePicture(HttpServletRequest request,
                                      ScoreTotleRec[] scoreTotleRec,
                                      ScoreItemsRec[] scoreItemsRec,
                                      String imagePath)
       throws Exception{

     HttpSession session = request.getSession(true);
     String sName = null;
     String sScore = null;

     for (int i=0; i<scoreTotleRec.length; i++){

          sName = scoreTotleRec[i].getTName();
          sScore = scoreTotleRec[i].getScore();
     }

  //---------------------yx----------------------
    String sNote = "";
    for (int i=0; i<scoreItemsRec.length; i++){
         String sTName = scoreItemsRec[i].getName();
         String sTvalue = scoreItemsRec[i].getTvalue();
         double fTcount = new Double(sTvalue).doubleValue();
         //sNote = sNote + " / " + i*10 + "表示：" + sTName + "(" + fTcount + ")";
         sNote = sNote + "                  ";
    }

    XYSeries serires = new XYSeries(sNote);
    for (int i=0; i<scoreItemsRec.length; i++){
         String sTName = scoreItemsRec[i].getName();
         String sTvalue = scoreItemsRec[i].getTvalue();
         double fTcount = new Double(sTvalue).doubleValue();

         serires.add(i, fTcount);
    }
    XYSeriesCollection dataset = new XYSeriesCollection(serires);

  //---------------------yx----------------------

     JFreeChart chart = ChartFactory.createXYLineChart(sName + " 总分：" + sScore,
                                                           "",
                                                           "",
                                                           dataset,
                                                           PlotOrientation.VERTICAL,
                                                           true,
                                                           true,
                                                           false);


     FileOutputStream fos_jpg = null;
     try {
             String personID = request.getParameter("selected");
             String filename= "line_fruit" + personID + ".jpg";
             fos_jpg = new FileOutputStream(imagePath + filename);
             session.setAttribute("filename", filename);
             ChartUtilities.writeChartAsJPEG(fos_jpg,
                                             10,
                                             chart,
                                             600,
                                             600,
                                             null);


     } catch (Exception e) {
             e.printStackTrace();
     }

     finally {
             try {
                     fos_jpg.close();
             } catch (Exception e) {
                     e.printStackTrace();
             }
     }
  }


  /**
   * 获取数据集对象
   * @return
   */
  public static DefaultPieDataset getDataSet(ScoreWholeRec[] scoreWholeRec) throws SQLException{

          String sTName = null;
          String sTCount = null;

          DefaultPieDataset dataset = new DefaultPieDataset();

          for (int i=0; i<scoreWholeRec.length; i++){
               sTName = scoreWholeRec[i].getTName();
               sTCount = scoreWholeRec[i].getScore();
               double fTcount = new Double(sTCount).doubleValue();
               dataset.setValue(sTName + " " + fTcount, fTcount);
          }
          return dataset;
  }


  private static CategoryDataset getColDataSet(ScoreItemsRec[] scoreItemsRec) throws SQLException{

          DefaultCategoryDataset dataset = new DefaultCategoryDataset();

          String sTName = null;
          String sTValue = null;

          for (int i=0; i<scoreItemsRec.length; i++){
               sTName = scoreItemsRec[i].getName();
               sTValue = scoreItemsRec[i].getTvalue();
               double fTcount = new Double(sTValue).doubleValue();
               dataset.setValue(fTcount, sTName + " " + fTcount, sTName + " " + fTcount);
          }
          return dataset;


  }

  private static DefaultCategoryDataset getLineDataSet(ScoreItemsRec[] scoreItemsRec) throws SQLException{

          DefaultCategoryDataset dataset = new DefaultCategoryDataset();

          String sTName = null;
          String sTValue = null;

          for (int i=0; i<scoreItemsRec.length; i++){
               sTName = scoreItemsRec[i].getName();
               sTValue = scoreItemsRec[i].getTvalue();
               double fTcount = new Double(sTValue).doubleValue();
               dataset.setValue(fTcount, sTName + " " + fTcount, sTName + " " + fTcount);
          }


//          TimeSeries ca = new TimeSeries("");
//          for (int i=0; i<scoreItemsRec.length; i++){
//               ca.add(new TimeSeriesDataItem(new Day(1, mon + 1, i),
//                                             new Double(500 + Math.random() * 100)));
//           }



          return dataset;


  }


}