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
| private static PieDataset createDataset()
{
ResultSet rsMoyenne=null;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433", "abc", "");
PreparedStatement psMoyenne = conn.prepareStatement(" SELECT COUNT(DestHost) * 100 /(SELECT COUNT(DestHost) FROM WebProxyLog WHERE (ClientIP = '195.114.57.11')) AS pourcentage, DestHost FROM WebProxyLog WHERE (ClientIP = '195.114.57.11')GROUP BY DestHost ORDER BY pourcentage DESC;");
rsMoyenne = psMoyenne.executeQuery();
if (rsMoyenne == null)
{
System.out.println("Resultat null") ;
}
}
catch (ClassNotFoundException e)
{
System.out.println("pas de resultat !");
}
catch (SQLException e)
{
System.out.println("pas de resultat 2 !");
}
DefaultPieDataset defaultpiedataset = new DefaultPieDataset();
try {
while (rsMoyenne.next()) {
if (rsMoyenne.getInt(1) != 0)
System.out.println(rsMoyenne.getInt(1));
defaultpiedataset.setValue(rsMoyenne.getString(2), new Double(
rsMoyenne.getInt(1)));
}
rsMoyenne.close();
} catch (Exception e) {
System.out.println("PBBBB "+e.toString());
}
return defaultpiedataset;
} |