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
|
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
if (jCheckBox1.isSelected()) {
try{
con = getConnection("jdbc:mysql://localhost:3306/base_rapport_tt","root","");
Statement statement = con.createStatement(rs.TYPE_FORWARD_ONLY,rs.CONCUR_READ_ONLY);
java.sql.Date sqlDate1 = java.sql.Date.valueOf(jTextField1.getText());
java.sql.Date sqlDate2 = java.sql.Date.valueOf(jTextField2.getText());
String sql = "Select Status,(count(1) )*100/(Select count(id_incident)from incident where open_time between '"+sqlDate1+"' and'"+sqlDate2+"') from incident where open_time between '"+sqlDate1+"'and'"+sqlDate2+"'group by Status";
ResultSet rs = statement.executeQuery(sql);
while(rs.next()){
rs.getString("status");
String label = rs.getString(1);
double value = rs.getDouble(2);
DefaultPieDataset pieDataset = new DefaultPieDataset();
pieDataset.setValue( label , value);
pnl = new JPanel(new BorderLayout());
setContentPane(pnl);
setSize(450, 350);
JFreeChart pieChart = ChartFactory.createPieChart("Test camembert", pieDataset, true, true, true);
ChartPanel cPanel = new ChartPanel(pieChart);
pnl.add(cPanel);
}
}
catch (Exception e){
JOptionPane.showMessageDialog(null,e );
}
}
} |