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
|
CallableStatement proc = storedProcedureExecution.getCallableStatement();
int parameterIndex = 1;
// code retour
proc.registerOutParameter( parameterIndex++, Types.INTEGER );
proc.registerOutParameter( parameterIndex++, Types.INTEGER );
proc.registerOutParameter( parameterIndex++, Types.DATE );
if ( a != null )
{
proc.setString( parameterIndex++, a );
}
else
{
proc.setNull( parameterIndex++, Types.CHAR );
}
if ( b != null )
{
proc.setString( parameterIndex++, b );
}
else
{
proc.setNull( parameterIndex++, Types.CHAR );
}
JDBCUtils.handleCallableStatement( proc, parameterIndex++, sd );
JDBCUtils.handleCallableStatement( proc, parameterIndex++, ed);
JDBCUtils.handleCallableStatement( proc, parameterIndex++, i);
JDBCUtils.handleCallableStatement( proc, parameterIndex++, nb); |
Partager