如何从iReport调用存储过程？

I'm trying to call a stored procedure that receives a parameter from the iReport plugin wizard of Netbeans 6.1, how can I successfully accomplish this task?

我正在尝试调用从Netbeans 6.1的iReport插件向导接收参数的存储过程,如何成功完成此任务?

Other technical details are: using MySQL 5.0.51a-17, and iReport designer 1.0.

其他技术细节是:使用MySQL 5.0.51a-17和iReport设计器1.0。

Thanks!

Update: I'm voting this question to be closed, since it's from 2008.

更新:我投票将这个问题关闭,因为它是从2008年开始的。

1 个解决方案

#1

Edit the myreport.jrmxl file directly:

直接编辑myreport.jrmxl文件:

<jasperReport ...>
    ...
    <parameter name="someParam" class="java.lang.String"/>
    <queryString>
       <![CDATA[call myproc($P{someParam})]]>
    </queryString>
    ...
</jasperReport>