JAVA通过JDBC调用存储过程

以下是调用方法,测试代码没贴.

public class ProcedureTest
{
    public Connection getConnection() throws Exception
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            Connection connection = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/mas2?autoReconnect=true&useUnicode=true&characterEncoding=utf8",
                    "root", "canada");
            return connection;
        }
        catch (Exception e)
        {
            throw e;
        }
    }

    public ResultSet callProcedure() throws Exception
    {
        Connection connection = getConnection();
        CallableStatement statement = connection.prepareCall("{call proc_masbiz_event(?, ?, ?, ?)}");
        statement.setInt(1, 1);
        statement.setString(2, "2010-04-01");
        statement.setString(3, "2010-04-30");
        statement.setInt(4, 1);
        ResultSet rs = statement.executeQuery();
        return rs;
    }
}