Generating Query with StringBuilder

query_with_builder.md

                StringBuilder queryString = "insert into test (id, f1) values ";
                
                // add placeholder for values
                for (int counter = 0; counter <= 100; counter += 1) 
                    queryString.append("(?, ?),");

                // replace the trailing ',' with a ';'
                queryString.replace(queryString.length() - 1, queryString.length(), ";");

                PreparedStatement prepared_statement = connection.prepareStatement(queryString.toString());
                
                // bind the values
                for (int counter = 0; counter <= 100; counter += 1) {
                    prepared_statement.setInt((counter * 2) + 1, counter);
                    prepared_statement.setString((counter * 2) + 2, "A");
                }
                
                prepared_statement.execute();