如何在JdbcTemplate中创建mySQL存储过程

CREATE PROCEDURE GetOrderCount(IN userId INT, OUT orderCount INT)
BEGIN
    SELECT COUNT(*) INTO orderCount FROM orders WHERE user_id = userId;
END

DataSource dataSource = ...; // 设置数据源
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

String createProcedureSql = "CREATE PROCEDURE GetOrderCount(IN userId INT, OUT orderCount INT)\n" +
        "BEGIN\n" +
        "    SELECT COUNT(*) INTO orderCount FROM orders WHERE user_id = userId;\n" +
        "END";
jdbcTemplate.execute(createProcedureSql);

SimpleJdbcCall jdbcCall = new SimpleJdbcCall(jdbcTemplate)
        .withProcedureName("GetOrderCount")
        .declareParameters(
                new SqlParameter("userId", Types.INTEGER),
                new SqlOutParameter("orderCount", Types.INTEGER)
        );

Map<String, Object> inParams = new HashMap<>();
inParams.put("userId", 123);

Map<String, Object> result = jdbcCall.execute(inParams);
int orderCount = (int) result.get("orderCount");