Hint

This article is generated by AI translation.

Scripts

Use JdbcTemplate's execute method to run arbitrary SQL statements.

warning

These methods do not support argument binding.

Usage

• Execute inline SQL

  jdbc.execute("insert into users (id, name) values(2, 'Alice')");

• Load SQL resources

  jdbc.loadSQL("scripts/mysql-script.sql");

  jdbc.loadSQL(StandardCharsets.UTF_8, "scripts/mysql-script.sql");

  jdbc.loadSQL(new FileReader("/home/users/my/scripts/mysql-script.sql"));

• Load SQL resources and split by splitChars

  jdbc.loadSplitSQL(";", "scripts/mysql-script.sql");

  jdbc.loadSplitSQL(";", StandardCharsets.UTF_8, "scripts/mysql-script.sql");

  jdbc.loadSplitSQL(";", new FileReader("/home/users/my/scripts/mysql-script.sql"));