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
| public BaremeInfDTO add(BaremeInfDTO entity) throws Exception {
Statement stmt = getConnection().createStatement();
ResultSet rs = stmt.executeQuery("SELECT NEXT VALUE FOR BINFGENERATOR FROM RDB$DATABASE");
if(rs.next()){/////<======CRASH ICI APRES QQ APPELS A LA FONCTION
// System.err.println(rs.getLong(1));
entity.setId(rs.getLong(1));
}else{
throw new Exception();
}
PreparedStatement pstmt = getConnection().prepareStatement("insert into BAREMEINF(ID,BEGDA,ENDDA,MODDA,ADDDA, BRUT,ISOLEMEN2REV,MEN1REV) values(?,?,?,?,?,?,?,?)");
pstmt.setLong(1, entity.getId());
pstmt.setDate(2, entity.getBegda());
pstmt.setDate(3, entity.getEndda());
pstmt.setDate(4, entity.getModda());
pstmt.setDate(5, entity.getAddda());
pstmt.setDouble(6, entity.getBrut());
pstmt.setDouble(7, entity.getIsoleMen2Rev());
pstmt.setDouble(8, entity.getMen2Rev());
Boolean ret = pstmt.execute();
if(ret)
return entity;
else
return null;
} |
Partager