Skip to main content

Scripts

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

warning

Script-loading methods (loadSQL / loadSplitSQL) do not bind arguments. The execute(sql, args) overload does support binding; see Arguments.

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"));