mysql 统计做饼状图_从数据库中取出数据统计后再绘制饼图

从数据库中取出数据统计后再绘制饼图

(2009-05-21 23:23:45)

标签：

杂谈

contentType="text/html;charset=GB2312"%>

org.jfree.chart.ChartUtilities,

org.jfree.chart.ChartFactory,

org.jfree.data.general.DefaultPieDataset,

java.sql.*"%>

Connection con=null;

Statement sql=null;

ResultSet rs=null;

String dataName[]=new String[]{"","","",""};

int dataValueCount[]={0,0,0,0};

//加载驱动

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

//得到数据库连接

con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabase","sa","duskleaf");

sql=con.createStatement();

//进行数据查询，并得到结果记录集

rs=sql.executeQuery("select '0-30岁' as userage,count(*) as

usercount from userTable where user_age>=0 and

user_age<30"

+"union select '30-50岁' as

userage,count(*) as usercoun