java调用存储过程返回数字

最新推荐文章于 2023-09-12 16:09:23 发布

努力的Java程序员

最新推荐文章于 2023-09-12 16:09:23 发布

阅读量210

点赞数

文章标签： java 数据库开发语言

本文链接：https://blog.csdn.net/weixin_44605543/article/details/132748474

版权

<select id="jimuReportNumber" resultType="java.lang.Integer">
        exec jimu_report_number #{reportIdPdf}
    </select>

ALTER PROCEDURE [dbo].[jimu_report_number]
  @reportId AS varchar(32) 
AS
BEGIN
		create table #tmp(
		number int
	)

	DECLARE @sqlMain NVARCHAR(4000)

	-- routine body goes here, e.g.
	-- SELECT 'Navicat for SQL Server'
	SELECT @sqlMain = db_dyn_sql FROM jimu_report_db WHERE jimu_report_id = @reportId and db_ch_name = 'ao'
	insert into #tmp execute sp_executesql @sqlMain
	select number from  #tmp
END