Statement JSP JDBC

**bizounourse** · 14/06/2013, 10h47

Bonjour à tous,

Je voudrais savoir comment puis-je simplifier ce code:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
61
62
63
64
65
66
67
68
String requete1, requete2, requete3, requete4, requete5, requete6, requete7, requete8, requete9, requete10, requete11, requete12, requete13, requete14, requete15, requete16, requete17, requete18, requete19, requete20, requete21, requete22, requete23;
 
requete1 = "SELECT ... FROM ... Were ...";
requete2 = "SELECT ... FROM ... Were ...";
requete3 = "SELECT ... FROM ... Were ...";
requete4 = "SELECT ... FROM ... Were ...";
-
-
-
-
-
-
....
 
try {
            Statement stmt1  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt2  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt3  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt4  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt5  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt6  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt7  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt8  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt9  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt10  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt11  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt12  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt13  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt14  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt15  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt16  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt17  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt18  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt19  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt20  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt21  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt22  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            Statement stmt23  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
 
         Connection_Bdd.resultats1 = ((java.sql.Statement) stmt1).executeQuery(requete1);
            Connection_Bdd.resultats2 = ((java.sql.Statement) stmt2).executeQuery(requete2);
            Connection_Bdd.resultats3 = ((java.sql.Statement) stmt3).executeQuery(requete3);
            Connection_Bdd.resultats4 = ((java.sql.Statement) stmt4).executeQuery(requete4);
            Connection_Bdd.resultats5 = ((java.sql.Statement) stmt5).executeQuery(requete5);
            Connection_Bdd.resultats6 = ((java.sql.Statement) stmt6).executeQuery(requete6);
            Connection_Bdd.resultats7 = ((java.sql.Statement) stmt7).executeQuery(requete7);
            Connection_Bdd.resultats8 = ((java.sql.Statement) stmt8).executeQuery(requete8);
            Connection_Bdd.resultats9 = ((java.sql.Statement) stmt9).executeQuery(requete9);
            Connection_Bdd.resultats10 = ((java.sql.Statement) stmt10).executeQuery(requete10);
            Connection_Bdd.resultats11 = ((java.sql.Statement) stmt11).executeQuery(requete11);
            Connection_Bdd.resultats12 = ((java.sql.Statement) stmt12).executeQuery(requete12);
            Connection_Bdd.resultats13 = ((java.sql.Statement) stmt13).executeQuery(requete13);
            Connection_Bdd.resultats14 = ((java.sql.Statement) stmt14).executeQuery(requete14);
            Connection_Bdd.resultats15 = ((java.sql.Statement) stmt15).executeQuery(requete15);
            Connection_Bdd.resultats16 = ((java.sql.Statement) stmt16).executeQuery(requete16);
            Connection_Bdd.resultats17 = ((java.sql.Statement) stmt17).executeQuery(requete17);
            Connection_Bdd.resultats18 = ((java.sql.Statement) stmt18).executeQuery(requete18);
            Connection_Bdd.resultats19 = ((java.sql.Statement) stmt19).executeQuery(requete19);
            Connection_Bdd.resultats20 = ((java.sql.Statement) stmt20).executeQuery(requete20);
            Connection_Bdd.resultats21 = ((java.sql.Statement) stmt21).executeQuery(requete21);
            Connection_Bdd.resultats22 = ((java.sql.Statement) stmt22).executeQuery(requete22);
            Connection_Bdd.resultats23 = ((java.sql.Statement) stmt23).executeQuery(requete23);
 
            stmt1.close();stmt2.close();stmt3.close();stmt4.close();stmt5.close();stmt6.close();stmt7.close();stmt8.close();stmt9.close();stmt10.close();stmt11.close();stmt12.close();stmt13.close();stmt14.close();stmt15.close();stmt16.close();stmt17.close();stmt18.close();stmt19.close();stmt20.close();stmt21.close();stmt22.close();stmt23.close();
 
        } catch (SQLException e) {
            System.out.println("Anomalie lors de l'execution de la requête");
        }

J'ai essayé de cette manière:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
String tabReq[] = null ; 
 
tabReq[1] = "SELECT ... FROM ... Were ...";
tabReq[2] = "SELECT ... FROM ... Were ...";
-
-
-
....
tabReq[23] = "SELECT ... FROM ... Were ...";
 
try {
 
 
            Statement stmt  = (Statement) Connection_Bdd.cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
 
			ResultSet tabRes[] = null ;
 
			for (int i =1 ; i <= 23 ; i++){
			tabRes[i] = ((java.sql.Statement) stmt).executeQuery(tabReq[i]);
 
			}
 
 
 
            stmt.close();
 
        } catch (SQLException e) {
            System.out.println("Anomalie lors de l'execution de la requête");
        }

En faisant cette modification, quand je veux exécuter ma page jsp où j'appelle une méthode contenant ce code, j'ai une erreur "http 500, avec ce message. Le serveur a rencontré une erreur interne () qui l'a empêché de satisfaire la requête" par contre sans la modification, ça fonctionne.
Normalement, il n'est pas nécessaire de créer plusieurs Statement, mais si je n'en créer seulement 1 (partie sans modification), ça ne fonctionne pas non plus. Pouvez-vous m'aider svp ?

Statement JSP JDBC

Servlets/JSP Java

Mode arborescent

Discussions similaires

Partager

Partager