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 52 53 54 55 56 57 58 59 60
| package org.apache.commons.math3.stat.descriptive;
import java.sql.*;
import java.lang.Math;
public class TestCon {
public static void main(String[] args) {
String url="jdbc:mysql://localhost/leodica10?";
String user="root";
String pwd="";
int i=0,pos=0,j=0;
double Q1=0,Q2=0,Q3=0,min=0,max=0,somme=0,som_avg=0,moyenne=0,variance=0,ecart_type=0;
Connection cn=null;
Statement st=null;
ResultSet rs=null;
ResultSetMetaData metadata=null;
try {
// Class.forName("com.mysql.jdbc.Driver");
cn=DriverManager.getConnection(url, user, pwd);
st=cn.createStatement();
String sql="SELECT vapo FROM leodica10.leodouze WHERE secteur IN ('01','02','03') and vapo IS NOT NULL ORDER BY vapo;";
rs=st.executeQuery(sql);
metadata=rs.getMetaData();
rs.last();
int nb_lgn=rs.getRow();
rs.beforeFirst();
double vapo[]=new double[nb_lgn];
System.out.println("Nombre de valeurs : "+nb_lgn);
while(rs.next()) {
vapo[i]=rs.getDouble("vapo");
somme+=vapo[i];
i++;
}
System.out.println("Total vapo : "+Math.floor(somme));
moyenne=somme/nb_lgn;
pos=(int) Math.floor(nb_lgn/4);
Q1=vapo[pos];
pos=(int) Math.floor(nb_lgn/2);
Q2=vapo[pos];
pos=(int) Math.floor(nb_lgn/2+nb_lgn/4);
Q3=vapo[pos];
for(i=0;i<nb_lgn-1;i++)
som_avg+=Math.pow((vapo[i]-(somme/nb_lgn)),2);
variance=som_avg/nb_lgn;
ecart_type=Math.sqrt(variance);
System.out.println("\nMoyenne : "+moyenne+"\nMinimum : "+vapo[0]+"\nQuartile 1 : "+Q1+"\nMédiane : "+Q2+"\nQuartile 3 :"+Q3+"\nMaximum : "+vapo[nb_lgn-1]+"\nVariance : "+variance+"\nEcart-type : "+ecart_type);
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
cn.close();
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
} |
Partager