public void setCustomRequest ( int pathId , String customRequest , String clientUUID ) { PreparedStatement statement = null ; try ( Connection sqlConnection = sqlService . getConnection ( ) ) { int profileId = EditService . getProfileIdFromPathID ( pathId ) ; statement = sqlConnection . prepareStatement ( "UPDATE " + Constants . DB_TABLE_REQUEST_RESPONSE + " SET " + Constants . REQUEST_RESPONSE_CUSTOM_REQUEST + "= ?" + " WHERE " + Constants . GENERIC_PROFILE_ID + "= ?" + " AND " + Constants . GENERIC_CLIENT_UUID + "= ?" + " AND " + Constants . REQUEST_RESPONSE_PATH_ID + "= ?" ) ; statement . setString ( 1 , customRequest ) ; statement . setInt ( 2 , profileId ) ; statement . setString ( 3 , clientUUID ) ; statement . setInt ( 4 , pathId ) ; statement . executeUpdate ( ) ; } catch ( Exception e ) { e . printStackTrace ( ) ; } finally { try { if ( statement != null ) { statement . close ( ) ; } } catch ( Exception e ) { } } }
Set the value for a custom request