JChart用法（制作饼图，柱图）

最新推荐文章于 2021-06-24 04:45:07 发布

hooligan000112003

最新推荐文章于 2021-06-24 04:45:07 发布

阅读量4.9k

点赞数

文章标签： import jfreechart dataset string exception table

本文链接：https://blog.csdn.net/hooligan000112003/article/details/603629

版权

JSP文件：

<html>
<meta http-equiv="refresh" content="5">
<script language="javascript">
function doUrl()
{
  var temp = document.form1.choice.value;

  if(temp =='pie')
  {
   window.location.href='row2.jsp?type=pie';
  }
  else
  {
   window.location.href='row2.jsp';
  }
}
</script>
<%
String temp = ((request.getParameter("type")==null)?"post":request.getParameter("type"));
%>
<body>
<form action="row2.jsp" name="form1">
<a href="chart?type=pie">饼图</a>
<a href="chart">柱型图</a>

<select name="choice" οnchange="javascript:doUrl();">
  <%
   if(temp.equals("pie"))
   {
    out.println("<option value='pie' selected>饼图</option>");
    out.println("<option value='row'>柱状图</option>");
   }

   else
   {

    out.println("<option value='pie'>饼图</option>");
    out.println("<option value='row' selected>柱状图</option>");
   }
  %>
</select>

<hidden name="type" value=<%=temp%>/>
</form>
<%
//String temp = ((request.getParameter("type")==null)?"post":request.getParameter("type"));
//out.println("-----"+temp+"<br>");

if(temp.equals("pie"))
{
%>
<img src="chart?type=pie">

<%
}else{
%>
<img src="chart">
<%
}
%>
</body>
</html>

----------------------------java servlet文件(servletChat.java)-------------------------------

package JFreeChart;

import java.io.FileOutputStream;
import java.io.IOException;

import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.jfree.chart.renderer.BarRenderer;

import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartUtilities;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.plot.*;
import org.jfree.chart.axis.*;
import org.jfree.data.DefaultCategoryDataset;
import java.awt.*;
import org.jfree.chart.labels.StandardCategoryItemLabelGenerator;
import org.jfree.chart.labels.StandardPieItemLabelGenerator;
import java.util.*;

import org.jfree.data.DefaultPieDataset;

public class servletChat extends HttpServlet {

//  public static threadService thread = new threadService();

  public void init(ServletConfig config) throws ServletException {
//   try{
//    if(!thread.isAlive())
//    {
//     thread.setSleepTime(60*1000*10);
//     thread.start();
//    }
//   }catch(Exception e)
//   {
//    e.printStackTrace();
//   }
  }


  public void doGet(HttpServletRequest req, HttpServletResponse res)
    throws ServletException, IOException {
   res.setContentType("image/jpeg");


   String type = (req.getParameter("type")==null)?"":req.getParameter("type");



   System.out.println("----------------servletChart--------------------"+type+"   ========");

   //pie图表
   if(type.equals("pie"))
   {


//    org.jfree.data.DefaultPieDataset data = new org.jfree.data.DefaultPieDataset();
    DefaultPieDataset data = new DefaultPieDataset();
    try{



     Hashtable table = DB.getSumCount();
     int number[] = (int[])table.get("sumcount");
     String name[] = (String[])table.get("name");

     for(int k=0;k<number.length;k++)
     {
      data.setValue(name[k].trim()+"="+number[k],number[k]);
     }



     JFreeChart chart = ChartFactory.createPieChart("招聘网统计图表", // 图表标题
       data, true, // 是否显示图例
       false, false); //写图表对象到文件，参照柱状图生成源码






//     chart.setTitle("招聘网统计表");
     ChartUtilities.writeChartAsJPEG(res.getOutputStream(),chart,400,300);



     System.out.println("chartServlet 饼图finish!!");

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

   //row柱图
   else
   {
    try{
     DefaultCategoryDataset dataset = new DefaultCategoryDataset();


     Hashtable table1 = DB.getSumCount();
     int i_temp[] = (int[])table1.get("sumcount");
     String s_temp[] = (String[])table1.get("name");

     for(int kk=0;kk<i_temp.length;kk++)
     {
      dataset.addValue(i_temp[kk],s_temp[kk]+"="+i_temp[kk],s_temp[kk]);
     }


     JFreeChart chart = ChartFactory.createBarChart3D("招聘网统计图表", // 图表标题
      "内容", // 目录轴的显示标签
      "人数", // 数值轴的显示标签
      dataset, // 数据集
      PlotOrientation.VERTICAL, // 图表方向：水平、垂直
      true, // 是否显示图例(对于简单的柱状图必须是false)
      false, // 是否生成工具
      false // 是否生成URL链接
      );




//     chart.setBackgroundPaint(new Color(0xBBBBDD));


     CategoryPlot plot = chart.getCategoryPlot();
     CategoryAxis domainAxis = plot.getDomainAxis();
     plot.setDomainAxis(domainAxis);
     ValueAxis rangeAxis = plot.getRangeAxis();


     BarRenderer renderer = (BarRenderer)plot.getRenderer();
     renderer.setItemMargin(0.1);
     renderer.setItemLabelGenerator(new StandardCategoryItemLabelGenerator());
     renderer.setItemLabelsVisible(true);
     plot.setRenderer(renderer);


//     CategoryPlot plot = chart.getCategoryPlot();
//
//     NumberAxis axis = (NumberAxis)plot.getRangeAxis();
//     axis.setStandardTickUnits(axis.createIntegerTickUnits());
//
//     BarRenderer render = (BarRenderer)plot.getRenderer();
//     render.setDrawBarOutline(false);
//
//     CategoryAxis ca = plot.getDomainAxis();
//     ca.setLowerMargin(0.02);
//     ca.setCategoryMargin(0.10);
//     ca.setUpperMargin(0.02);


     chart.setTitle("招聘网统计表");
     ChartUtilities.writeChartAsJPEG(res.getOutputStream(),chart,400,300);

     System.out.println("chartServlet 柱型图表 finish!!");
//     fos_jpg.close();
    }catch(Exception e)
    {
     e.printStackTrace();
    }
   }
  }

  public void doPost(HttpServletRequest req, HttpServletResponse res)
    throws ServletException, IOException {
   doGet(req, res);
  }

//  private JFreeChart getChart() {
//   DefaultCategoryDataset dataset = new DefaultCategoryDataset();
//
//
//   JFreeChart chart = ChartFactory.createBarChart3D("水果产量图", // 图表标题
//     "水果", // 目录轴的显示标签
//     "产量", // 数值轴的显示标签
//     dataset, // 数据集
//     PlotOrientation.VERTICAL, // 图表方向：水平、垂直
//     true, // 是否显示图例(对于简单的柱状图必须是false)
//     false, // 是否生成工具
//     false // 是否生成URL链接
//     );
   chart.setBackgroundPaint(java.awt.Color.white);
   // 可选，设置图片背景色
   chart.setTitle("www.SenTom.net 网站访问统计表");
   //  可选，设置图片标题
//   return chart;
//
//  }
//  private static org.jfree.data.DefaultPieDataset getDataSet() {
//   org.jfree.data.DefaultPieDataset dataset = new org.jfree.data.DefaultPieDataset();
//
//   return dataset;
//  }
}

--------------------------DB.java文件---------------------------------------

package JFreeChart;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Hashtable;

public class DB
{
private static Connection conn = null;
private static String url = "jdbc:oracle:thin:@10.1.2.103:1521:webtest";
private static String driver = "oracle.jdbc.driver.OracleDriver";

public static Hashtable table = new Hashtable();

public static Connection getConnection()
{
  try{
   Class.forName(driver);
   conn = DriverManager.getConnection(url,"wsbs","wsbs");
  }
  catch(Exception e)
  {
   e.printStackTrace();
  }
  return conn;
}

public static void main(String args[]) throws SQLException
{

  Connection conn = DB.getConnection();

  Statement stmt = conn.createStatement();
  ResultSet rs = null;

  rs = stmt.executeQuery("select name,number1,number2,sumcount from star008");

//  while(rs.next())
//  {
//   System.out.print(rs.getString("NAME")+"/t");
//   System.out.print(rs.getString("NUMBER1")+"/t");
//   System.out.print(rs.getString("NUMBER2")+"/t");
//   System.out.println(rs.getString("SUMCOUNT"));
//  }

  Hashtable t1 = getSumCount();

  int []int1 = (int[])t1.get("sumcount");
  String []str1 = (String[])t1.get("name");

  System.out.println("-----------------------------------");
  for(int ii=0;ii<int1.length;ii++)
  {
//   System.out.print(int1[ii]+"/t");
//   System.out.println(str1[ii]);
  }

}

public static Hashtable getSumCount() throws SQLException
{
  Connection conn = getConnection();
  Statement stmt = conn.createStatement();
  ResultSet rs = null;
  ResultSet rs1 = null;

  rs1 = stmt.executeQuery("select count(*) sum1 from star008");
  int countRecord = 0;
  if(rs1.next())
  {
   countRecord = rs1.getInt("sum1");
  }

  rs = stmt.executeQuery("select name,number1,number2,sumcount from star008");

  ResultSetMetaData rsmd = rs.getMetaData();

  System.out.println(rsmd.getColumnCount());

  for(int w=1;w<rsmd.getColumnCount()+1;w++)
  {
   System.out.println(rsmd.getColumnName(w)+"/t/t"+rsmd.getColumnType(w)+"/t/t"+
    rsmd.getColumnTypeName(w)+"/t/t"+rsmd.getColumnClassName(w)+
    rsmd.getCatalogName(w));
  }

  int [] array = new int[countRecord];
  String [] stringArray = new String[countRecord];
  //table = new Hashtable();

  System.out.println(table.containsKey("name")+"/t"+table.containsKey("sumcount"));

//  if(!table.containsKey("name") && !table.containsKey("sumcount"))
//  {
//   System.out.println("从数据库中得到!!!!!!!");
   int temp = 0;
   while(rs.next())
   {


//   System.out.print(rs.getString("NAME")+"/t");
//   System.out.print(rs.getString("NUMBER1")+"/t");
//   System.out.print(rs.getString("NUMBER2")+"/t");
//   System.out.println(rs.getInt("SUMCOUNT"));

    stringArray[temp] = rs.getString("NAME");
    array[temp] = rs.getInt("SUMCOUNT");
    temp++;

   }
   table.put("name",stringArray);
   table.put("sumcount",array);
//  }
//  else
//  {
//   System.out.println("缓存中得到!!!!!");
//  }

  rs1.close();
  rs.close();
  stmt.close();
  return table;
}

}

----------------------------配置web.xml文件------------------------

<servlet>
        <servlet-name>chartServlet</servlet-name>
        <servlet-class>JFreeChart.servletChat</servlet-class>
        <load-on-startup>0</load-on-startup>
</servlet>
<servlet-mapping>
        <servlet-name>chartServlet</servlet-name>
        <url-pattern>/chart</url-pattern>
</servlet-mapping>