Bonjour a tout le monde
Je viens de créer un formualaire avec l'assistance de netbaens.qui est compose des tableaux.
et je veux executer mes requetes donc les resultats je veux les affiches dans ma formulaire. La ou je suis perdus je ne sais pas comment faire.
merci de m'aider appeler afficher mes resultats dans ma formualire
voila une appercus de mon code sources.
////
private void initComponents() {
tete = new java.awt.Panel();
region = new java.awt.Label();
reg = new java.awt.TextField();
pref = new java.awt.Label();
prefect = new java.awt.TextField();
moisdecla = new java.awt.Label();
moisdec = new java.awt.TextField();
annee = new java.awt.Label();
année = new java.awt.TextField();
bureau = new java.awt.Label();
bureaudecla = new java.awt.TextField();
comm = new java.awt.Label();
commune = new java.awt.TextField();
naissdece = new java.awt.Panel();
naisdec = new java.awt.Label();
jScrollPane1 = new javax.swing.JScrollPane();
naissdeces = new javax.swing.JTable();
mariagedivorce = new java.awt.Panel();
mariagedivorces = new java.awt.Label();
jScrollPane2 = new javax.swing.JScrollPane();
mariadiv = new javax.swing.JTable();
panelnaisgroupagemere = new java.awt.Panel();
naisgroupagemere = new java.awt.Label();
jScrollPane3 = new javax.swing.JScrollPane();
jTablenaisgroupagemere = new javax.swing.JTable();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setBackground(new java.awt.Color(153, 153, 153));
setName("Presentation"); // NOI18N
tete.setName("tete"); // NOI18N
region.setFont(new java.awt.Font("Times New Roman", 1, 12));
region.setText("Région:");
pref.setFont(new java.awt.Font("Times New Roman", 1, 12));
pref.setName("pref"); // NOI18N
pref.setText("Préfecture ou Province:");
prefect.setName("pref"); // NOI18N
moisdecla.setAlignment(java.awt.Label.RIGHT);
moisdecla.setFont(new java.awt.Font("Times New Roman", 1, 12));
moisdecla.setName("mois"); // NOI18N
moisdecla.setText("Mois de Déclaration:");
moisdec.setName("moisdecla"); // NOI18N
annee.setAlignment(java.awt.Label.RIGHT);
annee.setFont(new java.awt.Font("Times New Roman", 1, 14));
annee.setName("année"); // NOI18N
annee.setText("Année:");
année.setName("annee"); // NOI18N
bureau.setAlignment(java.awt.Label.RIGHT);
bureau.setFont(new java.awt.Font("Times New Roman", 1, 12));
bureau.setName("bureau"); // NOI18N
bureau.setText("Bureau:");
bureaudecla.setName("bureau"); // NOI18N
comm.setFont(new java.awt.Font("Times New Roman", 1, 12));
comm.setName("com"); // NOI18N
comm.setText("Commune:");
commune.setName("com"); // NOI18N
javax.swing.GroupLayout teteLayout = new javax.swing.GroupLayout(tete);
tete.setLayout(teteLayout);
teteLayout.setHorizontalGroup(
teteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(teteLayout.createSequentialGroup()
.addGap(62, 62, 62)
.addGroup(teteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addGroup(teteLayout.createSequentialGroup()
.addComponent(region, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(1, 1, 1)
.addComponent(reg, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(teteLayout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(teteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addGroup(teteLayout.createSequentialGroup()
.addComponent(comm, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(commune, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(teteLayout.createSequentialGroup()
.addComponent(pref, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(prefect, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)))))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 392, Short.MAX_VALUE)
.addGroup(teteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(teteLayout.createSequentialGroup()
.addComponent(moisdecla, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(moisdec, javax.swing.GroupLayout.PREFERRED_SIZE, 156, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, teteLayout.createSequentialGroup()
.addComponent(annee, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(année, javax.swing.GroupLayout.PREFERRED_SIZE, 221, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, teteLayout.createSequentialGroup()
.addGap(10, 10, 10)
.addComponent(bureau, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(bureaudecla, javax.swing.GroupLayout.PREFERRED_SIZE, 213, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap())
);
teteLayout.setVerticalGroup(
teteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(teteLayout.createSequentialGroup()
.addGroup(teteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(teteLayout.createSequentialGroup()
.addContainerGap(14, Short.MAX_VALUE)
.addGroup(teteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(region, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(reg, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(teteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(pref, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(prefect, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(8, 8, 8)
.addGroup(teteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(comm, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(commune, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(37, 37, 37))
.addGroup(teteLayout.createSequentialGroup()
.addGap(21, 21, 21)
.addGroup(teteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(moisdecla, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(moisdec, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(teteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(année, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(annee, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(teteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(bureau, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(bureaudecla, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addContainerGap())
);
region.getAccessibleContext().setAccessibleName("region");
reg.getAccessibleContext().setAccessibleName("reg");
pref.getAccessibleContext().setAccessibleName("prefect");
prefect.getAccessibleContext().setAccessibleName("prefct");
moisdecla.getAccessibleContext().setAccessibleName("mois");
moisdec.getAccessibleContext().setAccessibleName("moisdecla");
annee.getAccessibleContext().setAccessibleName("annee");
année.getAccessibleContext().setAccessibleName("annéedecla");
bureau.getAccessibleContext().setAccessibleName("bureau");
bureaudecla.getAccessibleContext().setAccessibleName("bureau");
comm.getAccessibleContext().setAccessibleName("commune");
commune.getAccessibleContext().setAccessibleName("com");
naissdece.setName("naisdec"); // NOI18N
naisdec.setFont(new java.awt.Font("Times New Roman", 1, 12));
naisdec.setText("Naissance et Décès:");
naissdeces.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{"Naissances dans le delai légal",
"54",
"12"},
{"Jugement Naissances Année En cours", null, null},
{"Jugement Naissances Année Anterieurs", null, null},
{"TOTAL NAISSANCES", null, null},
{"Décès dans le delai légal", null, null},
{"Jugement décès Année Anterieurs", null, null},
{"TOTAL DECES", null, null}
},
new String [] {
"Evénement", "Masculin", "Feminin"
}
) {
Class[] types = new Class [] {
java.lang.String.class, java.lang.Integer.class, java.lang.Integer.class
};
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
});
jScrollPane1.setViewportView(naissdeces);
naissdeces.getAccessibleContext().setAccessibleName("naisdec");
javax.swing.GroupLayout naissdeceLayout = new javax.swing.GroupLayout(naissdece);
naissdece.setLayout(naissdeceLayout);
naissdeceLayout.setHorizontalGroup(
naissdeceLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(naissdeceLayout.createSequentialGroup()
.addContainerGap()
.addComponent(naisdec, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(858, Short.MAX_VALUE))
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 976, Short.MAX_VALUE)
);
naissdeceLayout.setVerticalGroup(
naissdeceLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(naissdeceLayout.createSequentialGroup()
.addComponent(naisdec, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(1, 1, 1)
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 142, Short.MAX_VALUE)
.addContainerGap())
);
naisdec.getAccessibleContext().setAccessibleName("naisdec");
mariagedivorce.setName("mariagedivorce"); // NOI18N
mariagedivorces.setFont(new java.awt.Font("Times New Roman", 1, 12));
mariagedivorces.setText("Mariages et divorces:");
mariadiv.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{"Mariages", null, null},
{"Divorces", null, null}
},
new String [] {
"Evénement", "Masculin", "Féminin"
}
) {
Class[] types = new Class [] {
java.lang.String.class, java.lang.Integer.class, java.lang.Integer.class
};
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
});
jScrollPane2.setViewportView(mariadiv);
javax.swing.GroupLayout mariagedivorceLayout = new javax.swing.GroupLayout(mariagedivorce);
mariagedivorce.setLayout(mariagedivorceLayout);
mariagedivorceLayout.setHorizontalGroup(
mariagedivorceLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(mariagedivorceLayout.createSequentialGroup()
.addComponent(mariagedivorces, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(861, Short.MAX_VALUE))
.addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 976, Short.MAX_VALUE)
);
mariagedivorceLayout.setVerticalGroup(
mariagedivorceLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(mariagedivorceLayout.createSequentialGroup()
.addComponent(mariagedivorces, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(1, 1, 1)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 58, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
mariagedivorces.getAccessibleContext().setAccessibleName("Mariafedivorce");
panelnaisgroupagemere.setName("naisgroupagemere"); // NOI18N
naisgroupagemere.setFont(new java.awt.Font("Times New Roman", 1, 12));
naisgroupagemere.setText("Naissances par groupe d'âge de la mère:");
jTablenaisgroupagemere.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{"-18", "Plus 1989", null, null},
{"18 - 19", "1987 - 1988", null, null},
{"20 - 24", "1982 - 1986", null, null},
{"25 - 29", "1977 - 1981", null, null},
{"30 - 34", "1972 - 1976", null, null},
{"345- 39 ", "1967- 1971", null, null},
{"40 - 44", "1962 - 1966", null, null},
{"45 - 49", "1947 - 1961", null, null},
{"+50", "Moins 1956", null, null}
},
new String [] {
"Groupe d'âges", "", "Masculin", "Feminin"
}
) {
Class[] types = new Class [] {
java.lang.String.class, java.lang.String.class, java.lang.Integer.class, java.lang.Integer.class
};
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
});
jScrollPane3.setViewportView(jTablenaisgroupagemere);
javax.swing.GroupLayout panelnaisgroupagemereLayout = new javax.swing.GroupLayout(panelnaisgroupagemere);
panelnaisgroupagemere.setLayout(panelnaisgroupagemereLayout);
panelnaisgroupagemereLayout.setHorizontalGroup(
panelnaisgroupagemereLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(panelnaisgroupagemereLayout.createSequentialGroup()
.addComponent(naisgroupagemere, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
.addComponent(jScrollPane3, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 976, Short.MAX_VALUE)
);
panelnaisgroupagemereLayout.setVerticalGroup(
panelnaisgroupagemereLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(panelnaisgroupagemereLayout.createSequentialGroup()
.addComponent(naisgroupagemere, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 180, Short.MAX_VALUE))
);
naisgroupagemere.getAccessibleContext().setAccessibleName("naisgroupagemere");
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(naissdece, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(tete, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(panelnaisgroupagemere, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(mariagedivorce, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addGap(53, 53, 53)
.addComponent(tete, javax.swing.GroupLayout.PREFERRED_SIZE, 109, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(naissdece, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(29, 29, 29)
.addComponent(mariagedivorce, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(25, 25, 25)
.addComponent(panelnaisgroupagemere, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(158, 158, 158))
);
naissdece.getAccessibleContext().setAccessibleName("naidece");
mariagedivorce.getAccessibleContext().setAccessibleName("mariagedivorce");
panelnaisgroupagemere.getAccessibleContext().setAccessibleName("naisgroupagemere");
getAccessibleContext().setAccessibleName("Fichededepouillement");
pack();
}// </editor-fold>
public static void main(String[] args) throws ClassNotFoundException {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Presentation().setVisible(true);
//new Presentation().setSize(500, 500);
}
});
// TODO code application logic here
//Connexion à ma base mysql avec mon login et mot de passe
Connection conx=databaseConnection("localhost","efesnew","root","azerty") ;
}
private static void affiche(String message) {
System.out.println(message);
}
private static void arret(String message) {
System.err.println(message);
System.exit(99);
}
public static Connection databaseConnection(String server, String databaseName, String user, String password) throws
ClassNotFoundException {
Connection connection=null;
String requete = "";
ResultSet resultats = null;
try {
//Chargement de pilote
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://" + server + "/" + databaseName, user, password);
//selection des données dans la base de donnée
affiche("Naissances dans le delai légal");
requete ="SELECT sexe,count(*) as nombre FROM efesnew.citoyen where typedecla =1 and datedeclafr between datenaissfr and datecreation group by sexe";
try {
Statement stmt = connection.createStatement();
resultats = stmt.executeQuery(requete);
} catch (SQLException e) {
arret("Anomalie lors de l'execution de la réquete");
}
//parcours des données retournées
try{
ResultSetMetaData rsmd = resultats.getMetaData();
int nbCols = rsmd.getColumnCount();
boolean encore = resultats.next();
while(encore){
for(int i =1; i <= nbCols; i++ )
System.out.print(resultats.getString(i) + " ");
System.out.println();
encore = resultats.next();
}
resultats.close();
} catch (SQLException e) {
arret(e.getMessage());
}
//selection de donnée dans la base de donnée
affiche("Jugement Naissances année en Cours");
requete ="SELECT sexe,count(*) as nombres FROM efesnew.citoyen where typedecla=2 and datedeclafr between datenaissfr and datecreation group by sexe";
try {
Statement stmt = connection.createStatement();
resultats = stmt.executeQuery(requete);
} catch (SQLException e) {
arret("Anomalie lors de l'execution de la requéte");
}
//parcours des données retournées
try {
ResultSetMetaData rsmd = resultats.getMetaData();
int nbCols = rsmd.getColumnCount();
boolean encore = resultats.next();
while (encore) {
//parcours les donnes dans le tableau
for (int i = 1; i <= nbCols; i++)
System.out.print(resultats.getString(i) + " ");
System.out.println();
encore = resultats.next();
}
resultats.close();
} catch (SQLException e) {
arret(e.getMessage());
}
// selection de donnée dans la base de donnée
affiche("Jugement Naissances Année Anterieurs");
requete = "SELECT sexe,count(*) as nombre FROM efesnew.citoyen where typedecla=2 and datedeclafr > datenaissfr and anneedecla > datenaissfr group by sexe";
try {
Statement stmt = connection.createStatement();
resultats = stmt.executeQuery(requete);
} catch (SQLException e) {
arret("Anomalie lors de l'execution de la réquete");
}
//parcours des données retournées
try{
ResultSetMetaData rsmd = resultats.getMetaData();
int nbCols = rsmd.getColumnCount();
boolean encore = resultats.next();
while(encore){
for(int i =1; i <= nbCols; i++ )
System.out.print(resultats.getString(i) + " ");
System.out.println();
encore = resultats.next();
}
resultats.close();
} catch (SQLException e) {
arret(e.getMessage());
}
//selection des données dans la base de donnée
affiche("ToTal Naissances");
requete ="select sexe, count(*) as total_naissances FROM efesnew.citoyen group by sexe";
try {
Statement stmt = connection.createStatement();
resultats = stmt.executeQuery(requete);
} catch (SQLException e) {
arret("Anomalie lors de l'execution de la réquete Décès dans le delai légal");
}
//parcours des données retournées
try{
ResultSetMetaData rsmd = resultats.getMetaData();
int nbCols = rsmd.getColumnCount();
boolean encore = resultats.next();
while(encore){
for(int i =1; i <= nbCols; i++ )
System.out.print(resultats.getString(i) + " ");
System.out.println();
encore = resultats.next();
}
resultats.close();
} catch (SQLException e) {
arret(e.getMessage());
}
//selection des données dans la base de donnée
affiche("Décès dans le delai légal");
requete ="SELECT sexe,count(*) as nombre FROM efesnew.citoyen, efesnew.mentiondeces where type=1 and efesnew.citoyen.citoyenid = efesnew.mentiondeces.citoyenid group by sexe";
try {
Statement stmt = connection.createStatement();
resultats = stmt.executeQuery(requete);
} catch (SQLException e) {
arret("Anomalie lors de l'execution de la réquete Décès dans le delai légal");
}
//parcours des données retournées
try{
ResultSetMetaData rsmd = resultats.getMetaData();
int nbCols = rsmd.getColumnCount();
boolean encore = resultats.next();
while(encore){
for(int i =1; i <= nbCols; i++ )
System.out.print(resultats.getString(i) + " ");
System.out.println();
encore = resultats.next();
}
resultats.close();
} catch (SQLException e) {
arret(e.getMessage());
}
//selection de donnée dans la base de donnée
affiche("Jugement Décès année en Cours");
requete ="SELECT sexe,count(*) as nombre FROM efesnew.citoyen, efesnew.mentiondeces where type=2 and datefr between decesdatefr and datereceptionfr and efesnew.citoyen.citoyenid = efesnew.mentiondeces.citoyenid group by sexe";
try {
Statement stmt = connection.createStatement();
resultats = stmt.executeQuery(requete);
} catch (SQLException e) {
arret("Anomalie lors de l'execution de la requéte");
}
//parcours des données retournées
try {
ResultSetMetaData rsmd = resultats.getMetaData();
int nbCols = rsmd.getColumnCount();
boolean encore = resultats.next();
while (encore) {
//parcours les donnes dans le tableau
for (int i = 1; i <= nbCols; i++)
System.out.print(resultats.getString(i) + " ");
System.out.println();
encore = resultats.next();
}
resultats.close();
} catch (SQLException e) {
arret(e.getMessage());
}
// selection de donnée dans la base de donnée
affiche("Jugement Décès Année Anterieurs");
//requete = "SELECT sexe,count(*) as nombre FROM efesnew.citoyen where typedecla=2 and datedeclafr > datenaissfr and anneedecla > datenaissfr group by sexe";
requete="SELECT sexe,count(*) as nombre FROM efesnew.citoyen, efesnew.mentiondeces where type=2 and datereceptionfr and efesnew.citoyen.citoyenid = efesnew.mentiondeces.citoyenid group by sexe";
try {
Statement stmt = connection.createStatement();
resultats = stmt.executeQuery(requete);
} catch (SQLException e) {
arret("Anomalie lors de l'execution de la réquete");
}
//parcours des données retournées
try{
ResultSetMetaData rsmd = resultats.getMetaData();
int nbCols = rsmd.getColumnCount();
boolean encore = resultats.next();
while(encore){
for(int i =1; i <= nbCols; i++ )
System.out.print(resultats.getString(i) + " ");
System.out.println();
encore = resultats.next();
}
resultats.close();
} catch (SQLException e) {
arret(e.getMessage());
}
//selection des données dans la base de donnée
affiche("ToTal Décès");
requete ="select sexe,count(*) as nombre FROM efesnew.citoyen,efesnew.mentiondeces where efesnew.citoyen.citoyenid = efesnew.mentiondeces.citoyenid group by sexe";
try {
Statement stmt = connection.createStatement();
resultats = stmt.executeQuery(requete);
} catch (SQLException e) {
arret("Anomalie lors de l'execution de la réquete Décès dans le delai légal");
}
//parcours des données retournées
try{
ResultSetMetaData rsmd = resultats.getMetaData();
int nbCols = rsmd.getColumnCount();
boolean encore = resultats.next();
while(encore){
for(int i =1; i <= nbCols; i++ )
System.out.print(resultats.getString(i) + " ");
System.out.println();
encore = resultats.next();
}
resultats.close();
} catch (SQLException e) {
arret(e.getMessage());
}