jfreeChart+ struts+数据库,柱形图开发，直接能用

package com.yang.dbBean; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.util.ArrayList; public class DBbeans { private int id; private String name; private double number; private String dates; private String address; private java.sql.Connection con = null; private java.sql.PreparedStatement pstm = null; private java.sql.ResultSet rs = null; private java.sql.Statement stm = null; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public double getNumber() { return number; } public void setNumber(double number) { this.number = number; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public String getDates() { return dates; } public void setDates(String dates) { this.dates = dates; } public Connection getDB(){ try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=sellanal","sa",""); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return con; } public ArrayList Sel(String time){ con = this.getDB(); ArrayList list = new ArrayList(); String sql ="select * from costermonger where dates=?"; try { pstm = con.prepareStatement(sql); pstm.setString(1,time); rs = pstm.executeQuery(); while(rs.next()){ DBbeans bean = new DBbeans(); bean.setAddress(rs.getString("address")); bean.setName(rs.getString("name")); bean.setNumber(rs.getDouble("number")); list.add(bean); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } // public static void main(String []args){ // DBbeans db = new DBbeans(); // Connection con = null; // con = db.getDB(); // if(con!=null){ // System.out.println("ok"); // } // ArrayList list = new ArrayList(); // list = db.Sel(1002); // // System.out.println(list.size()); // try { // con.close(); // } catch (SQLException e) { // // TODO Auto-generated catch block // e.printStackTrace(); // } // // // } // }