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
| public int insertLieu(Lieu l) {
int idxRet = -1;
String sql = "INSERT INTO t_lieu (l_npa, l_ville) " +
"VALUES ('" + l.getL_npa() + "', '" + l.getL_ville() +"')";
int nbrRec = dbc.executeSQL(sql);
if (nbrRec == 1) {
// recherche de l'index
String rsql = "SELECT l_id FROM t_lieu WHERE l_ville = '" + l.getL_ville() +
"' AND l_npa = '" + l.getL_npa() + "'";
ResultSet rs = dbc.createResultSet(rsql);
try {
if (rs != null) {
rs.next();
idxRet = rs.getInt(1);
}
}
catch (SQLException se) {
dbc.showListSqlExceptions(se);
}
try {
if (rs != null) {
rs.close();
}
}
catch (SQLException se) {
dbc.showListSqlExceptions(se);
}
}
return idxRet;
} |
Partager