How to replace table name in sql query with regex in Java?

I want to replace table name in a sql query string. I only want to change table name. How can I do that in java with regex?

I do not want to use any dependencies.

For example,

Input:

select ... from table1 where/etc ....

expected output:

select ... from UPDATED_TABLE_NAME where/etc ....

If you mutate the query explicitly you open yourself to SQL injection. What you could do is use a PreparedStatement with a parameterized query to provide the table name safely.

try (PreparedStatement statement = connection.prepareStatement("SELECT * FROM ?")) {
    statement.setString(1, "my_table");
    
    try (ResultSet results = statement.executeQuery()) {
        
    }
}

If you're insistent on using regex you can just use the query above and replace ? with the table name. I would not do this in a production environment.

String query = "SELECT * FROM ?";
String queryWithTable = query.replaceAll("?", "my_table");