在groovy中调用mysql存储过程

import groovy.sql.Sql

def url = 'jdbc:mysql://localhost:3306/mydatabase'
def username = 'root'
def password = 'password'

def sql = Sql.newInstance(url, username, password, 'com.mysql.jdbc.Driver')

sql.call('{call my_stored_procedure(?, ?)}', ['param1', 'param2']) { result ->
    // 处理存储过程的结果
    while (result.next()) {
        // 获取结果集中的数据
        def column1 = result.getString('column1')
        def column2 = result.getString('column2')
        
        // 进行相应的处理
        println "column1: $column1, column2: $column2"
    }
}

sql.close()