如何在Spring bean中执行PL/pgSQL脚本？

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
   <property name="driverClassName" value="org.postgresql.Driver" />
   <property name="url" value="jdbc:postgresql://localhost:5432/mydb" />
   <property name="username" value="postgres" />
   <property name="password" value="password" />
</bean>

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
   <property name="dataSource" ref="dataSource" />
</bean>

@Autowired
private JdbcTemplate jdbcTemplate;

public void executeScript() {
   String sql = "DO $$ BEGIN " +
                "   -- your PL/pgSQL script here" +
                "END $$";
   jdbcTemplate.execute(sql);
}