Moderne licensed

Replace SQL string concatenation with a `PreparedStatement`

Recipe IDorg.openrewrite.java.security.FixSqlInjectionConcat

Artifactorg.openrewrite.recipe:rewrite-java-security

Rewrites JDBC Statement.executeQuery/executeUpdate/execute/addBatch calls whose argument is a string concatenation built from a literal SQL prefix plus simple variable operands into a PreparedStatement with ? placeholders and setX(i, ...) bindings. Only fixes the narrow safe subset where the Statement is a local variable from Connection.createStatement() used for a single SQL execution; other cases are left for the FindSqlInjection recipe to surface.

Single recipeCWE-89RSPEC-S2077Proprietary

Usage

This recipe has no required configuration options. You’ll need the Moderne CLI configured before running the command below.

mod run . --recipe org.openrewrite.java.security.FixSqlInjectionConcat

If the recipe isn’t available locally, install it with:

mod config recipes jar install org.openrewrite.recipe:rewrite-java-security:3.36.0

Data tables

Structured output this recipe can produce.

Source files that had resultsSource files that were modified by the recipe run.org.openrewrite.table.SourcesFileResults
Source files that had search resultsSearch results that were found during the recipe run.org.openrewrite.table.SearchResults
Source files that errored on a recipeThe details of all errors produced by a recipe run.org.openrewrite.table.SourcesFileErrors
Recipe performanceStatistics used in analyzing the performance of recipes.org.openrewrite.table.RecipeRunStats