从数据库中取出数据统计后再绘制饼图
(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 userag