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
| public static int getNoSeq(OracleConnection oracleConnection) throws Exception {
if (logger.isDebugEnabled()) {
logger.debug("Debut getNoSeq");
}
int noSeq = 0;
// creation de la connexion
Connection connexion = oracleConnection.getConnection();
Statement stmt = null;
if (logger.isDebugEnabled()) {
logger.debug("Avant requete");
}
String sqlRequest = "select SFR_PAYMENTCB_SEQ.nextval from dual";
if (logger.isDebugEnabled()) {
logger.debug("Apres requete");
}
//le resultat de la requete est stocké ds stmt
stmt = connexion.createStatement();
//
//String iccIdPrefixe = prefixeIccId + "%";
//stmt.setString(1, iccIdPrefixe);hn
ResultSet rs = stmt.executeQuery(sqlRequest);
if (rs.next()) {
noSeq = rs.getInt(1);
}
if (logger.isDebugEnabled()) {
logger.debug("No_seq = " + noSeq);
}
stmt.close();
connexion.close();
if (logger.isDebugEnabled()) {
logger.debug("Fin getNoSeq");
}
return noSeq;
} |
