public void removePath ( int pathId ) { PreparedStatement statement = null ; try ( Connection sqlConnection = sqlService . getConnection ( ) ) { // remove any enabled overrides with this path statement = sqlConnection . prepareStatement ( "DELETE FROM " + Constants . DB_TABLE_ENABLED_OVERRIDE + " WHERE " + Constants . ENABLED_OVERRIDES_PATH_ID + " = ?" ) ; statement . setInt ( 1 , pathId ) ; statement . executeUpdate ( ) ; statement . close ( ) ; // remove path statement = sqlConnection . prepareStatement ( "DELETE FROM " + Constants . DB_TABLE_PATH + " WHERE " + Constants . GENERIC_ID + " = ?" ) ; statement . setInt ( 1 , pathId ) ; statement . executeUpdate ( ) ; statement . close ( ) ; //remove path from responseRequest statement = sqlConnection . prepareStatement ( "DELETE FROM " + Constants . DB_TABLE_REQUEST_RESPONSE + " WHERE " + Constants . REQUEST_RESPONSE_PATH_ID + " = ?" ) ; statement . setInt ( 1 , pathId ) ; statement . executeUpdate ( ) ; statement . close ( ) ; } catch ( SQLException e ) { e . printStackTrace ( ) ; } finally { try { if ( statement != null ) { statement . close ( ) ; } } catch ( Exception e ) { } } }
Remove a path