package cn.itcast.utils;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.jfree.data.category.CategoryDataset;

public class Diagram {
	
	private CreateCharService cs =new CreateCharService();
	private static DBManager db=new DBManager();
	private static ResultSet rs = null;
	private static Connection con=null;
	private static PreparedStatement pstmt=null;
	static{
		con=db.getConnection();
	}
	public static void main(String[] args) {
		Diagram dg=new Diagram();
		dg.makeBarChart();
		db.freeResources(rs, pstmt, con);
		System.out.println("11111");
	}
	private Integer getCH_RES(){
		StringBuffer sql=new StringBuffer();
		int i=0;
		sql.append(" select sum(CH_RES) from usertable where Time>'2008-2-3' and Time<'2008-2-5'");
		try {
			pstmt=con.prepareStatement(sql.toString());
			rs =pstmt.executeQuery();
			while(rs.next()){
				 i= rs.getInt(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return i;
	}
	private Integer getQUEUED_CH_RES(){
		StringBuffer sql=new StringBuffer();
		int x=0;
		sql.append(" select sum(QUEUED_CH_RES) from usertable where Time>'2008-2-3' and Time<'2008-2-5'");
		try {
			pstmt=con.prepareStatement(sql.toString());
			rs =pstmt.executeQuery();
			while(rs.next()){
				 x= rs.getInt(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return x;
	}
	private Integer getTBSCallTime(){
		StringBuffer sql=new StringBuffer();
		int y=0;
		sql.append(" select sum(TBSCallTime) from usertable where Time>'2008-2-3' and Time<'2008-2-5'");
		try {
			pstmt=con.prepareStatement(sql.toString());
			rs =pstmt.executeQuery();
			while(rs.next()){
				 y= rs.getInt(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return y;
	}
	  /**  
     * 生成柱狀圖  
     */  
    public void makeBarChart() {   
        double[][] data = new double[][]{   
            {getCH_RES(), getQUEUED_CH_RES(), getTBSCallTime()}   
        };   
        String[] rowKeys = {"數值"};   
        String[] columnKeys = {"CH_RES", "QUEUED_CH_RES", "TBSCallTime"};   
        CategoryDataset dataset = cs.getBarData(data, rowKeys, columnKeys);   
        cs.createBarChart(dataset, "時間:2008-2-3到2008-2-5", "數值", "柱狀圖", "bar.png");   
    }   
}