1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
| public class PieChart extends ApplicationFrame {
public PieChart(String title) {
super(title);
JPanel panel = new JPanel(new GridLayout(2, 2));
DefaultPieDataset dataset = new DefaultPieDataset();
//**************************************************************
String url = "jdbc:mysql://localhost/snmp";
Connection con = null;
try {
Class.forName("org.gjt.mm.mysql.Driver");
con = (Connection) DriverManager.getConnection(url,"root","");
Statement requete = (Statement) con.createStatement();
ResultSet resultat = requete.executeQuery("select ip,ram from snmp.oid");
int d;
String ch;
while (resultat.next()) {
ch=resultat.getString(2);
d=resultat.getInt(1);
System.out.println(ch);
dataset.setValue(ch, d);
}}
catch(Exception e) { System.out.println("Exception"); }
finally {
try {con.close();}
catch(SQLException e) {e.printStackTrace() ;}}
JFreeChart chart2 = ChartFactory.createPieChart("Partition", dataset, true, true, true);
PiePlot plot2 = (PiePlot) chart2.getPlot();
plot2.setCircular(false);
panel.add(new ChartPanel(chart2));
panel.setPreferredSize(new Dimension(800, 600));
setContentPane(panel);
}
public static void main(String[] args) {
PieChart demo = new PieChart("Pie Chart Demo 7");
demo.pack();
RefineryUtilities.centerFrameOnScreen(demo);
demo.setVisible(true);
}
} |
Partager