如何从Jasper Report调用存储过程？ [英] How do I call a stored procedure from Jasper Report?

问题描述

如何从Jasper Report调用存储过程？

How do I call a stored procedure from Jasper Report?

推荐答案

JasperReports Ultimate Guide 包含有关使用商店程序的信息：

The JasperReports Ultimate Guide contains this information about using store procedure:

将存储过程调用放入报表模板的SQL查询字符串中必须满足某些条件：

通过JDBC调用时，存储过程必须返回java.sql.ResultSet。

存储过程不能有OUT参数。

Certain conditions must be met to put stored procedure calls in the SQL query string of a report template:

The stored procedure must return a java.sql.ResultSet when called through JDBC.

The stored procedure cannot have OUT parameters.

这篇关于如何从Jasper Report调用存储过程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！