finddata.java

本程序主要是实现了JFreeChart的图形显示！

package com.kai.jfc.conn;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import com.kai.bean.DateBean;

/**
 *****************************************
 *********** 与其坐而议，不如起而行 **********
 *****************************************
 * 类文件：FindData.java
 * @author 作者: 王凯 E-mail: [e-mail]
 * @version 创建时间：Jan 19, 2009 3:03:36 PM
 * 类 FindData 的作用：
 */

public class FindData {

	private String sql = "";
	private Connection conn;
	private Statement st;
	private ResultSet rs;
	private ArrayList lists;
	
	public ArrayList findData(){
		//声明SQL语句
		sql = "select cast(substring(t,1,4) as signed) as dy,cast(substring(t,6,7) as signed) as dm,wtgsyf_c  from czjrbx_3700_1_czzhichu where cast(substring(t,6,7) as signed)!=0 order by dy asc,dm asc;";
		
		conn = new ConnDb().getConn();
		try {
			st = conn.createStatement();
			rs = st.executeQuery(sql);
			lists = new ArrayList();
			while(rs.next())
			{
				DateBean bean = new DateBean();
				for(int i = 1;i<rs.getMetaData().getColumnCount();i++){
					bean.setYear(rs.getInt(1));
					bean.setMonth(rs.getInt(2));
					bean.setDate(rs.getDouble(3));
				}
				lists.add(bean);
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block    bean.getDate() == 0? null : bean.getDate()
			e.printStackTrace();
		} finally {
			this.close();
		}
		return lists;
	}
	
	public void close()	{
		try{
			if(rs != null || !rs.isClosed()){
				rs.close();
			}
			if(st != null || !st.isClosed()){
				st.close();
			}
			if(conn != null || !conn.isClosed()){
				conn.close();
			}
		} catch (Exception e) {
			e.printStackTrace();//
		}
	}
	
	
	public void test()
	{
		ArrayList lists = this.findData();
		for(int i = 0;i<lists.size();i++){
			DateBean bean = (DateBean) lists.get(i);
			System.out.println(bean.getYear()+"年"+bean.getMonth()+"月 数据为："+bean.getDate());
		}		
	}
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		new FindData().test();
	}
}