求助 这段存储过程在java怎么调用 万分感激
USE [by_furniture_hypsxt_sxysg]
GO
/****** Object: StoredProcedure [dbo].[Get_Code] Script Date: 10/21/2015 10:11:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* 流水号 */
ALTER procedure [dbo].[Get_Code]
(@instr VarChar(13),@outstr varchar(13) Output)
As
Declare
@v_ParaName char(12),
@v_lb char(2),
@v_deptcode char(2),
@v_rq char(6),
@v_number Int,
@v_rqa char(6),
@v_numberstr Varchar(4),
@strMM VarChar(2),
@strDD VarChar(3),
@IntCount Int
Select @v_ParaName = Rtrim(ParaName)
From Dict_Parameter
where Paratypecode='08' and ParaCode=RTRIM(@Instr)
Select @IntCount=@@RowCount
Select @v_lb =SubString(@v_ParaName,1,2)
Select @v_rq = SubString(@v_ParaName,3,6)
Select @v_number =Convert(Int,substring(@v_ParaName,9,4))
Select @strMM = DATEPART(MM, GetDate())
if Convert(Int,@strMM) < 10
Select @strMM = '0' + @strMM
Select @strDD = DATEPART(DD, GetDate())
If Convert(Int,@strDD) < 10
Select @strDD = '0' + @strDD
Select @v_rqa =SubString(Convert(Char(4),DATEPART(YY, GetDate())),3,2) + @strMM + @strDD
if @v_rq=@v_rqa
begin
select @v_number = @v_number+1
select @v_numberstr = Convert(VarChar(4),@v_number)
While len(rTrim(@v_numberstr)) < 4
select @v_numberstr = '0' + @v_numberstr
Select @v_ParaName = @v_lb + @v_rq + @v_numberstr
Select @outstr = ltrim(rTrim(@v_ParaName))
end
else
Select @v_ParaName = @v_lb + @v_rqa + '0001'
if @IntCount=0
Select @v_ParaName = SubString(@InStr,1,2) + @v_rqa + '0001'
Select @outstr = ltrim(rTrim(@v_ParaName))
If @IntCount=0
Insert Into Dict_Parameter (ParaCode,ParaName,ParaTypeCode,ParaTypeName )
Values (@InStr,@v_ParaName,'08','单据')
Else
update Dict_Parameter set ParaName=@v_ParaName Where Paratypecode='08' and ParaCode=rtrim(@instr)
GO
/****** Object: StoredProcedure [dbo].[Get_Code] Script Date: 10/21/2015 10:11:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* 流水号 */
ALTER procedure [dbo].[Get_Code]
(@instr VarChar(13),@outstr varchar(13) Output)
As
Declare
@v_ParaName char(12),
@v_lb char(2),
@v_deptcode char(2),
@v_rq char(6),
@v_number Int,
@v_rqa char(6),
@v_numberstr Varchar(4),
@strMM VarChar(2),
@strDD VarChar(3),
@IntCount Int
Select @v_ParaName = Rtrim(ParaName)
From Dict_Parameter
where Paratypecode='08' and ParaCode=RTRIM(@Instr)
Select @IntCount=@@RowCount
Select @v_lb =SubString(@v_ParaName,1,2)
Select @v_rq = SubString(@v_ParaName,3,6)
Select @v_number =Convert(Int,substring(@v_ParaName,9,4))
Select @strMM = DATEPART(MM, GetDate())
if Convert(Int,@strMM) < 10
Select @strMM = '0' + @strMM
Select @strDD = DATEPART(DD, GetDate())
If Convert(Int,@strDD) < 10
Select @strDD = '0' + @strDD
Select @v_rqa =SubString(Convert(Char(4),DATEPART(YY, GetDate())),3,2) + @strMM + @strDD
if @v_rq=@v_rqa
begin
select @v_number = @v_number+1
select @v_numberstr = Convert(VarChar(4),@v_number)
While len(rTrim(@v_numberstr)) < 4
select @v_numberstr = '0' + @v_numberstr
Select @v_ParaName = @v_lb + @v_rq + @v_numberstr
Select @outstr = ltrim(rTrim(@v_ParaName))
end
else
Select @v_ParaName = @v_lb + @v_rqa + '0001'
if @IntCount=0
Select @v_ParaName = SubString(@InStr,1,2) + @v_rqa + '0001'
Select @outstr = ltrim(rTrim(@v_ParaName))
If @IntCount=0
Insert Into Dict_Parameter (ParaCode,ParaName,ParaTypeCode,ParaTypeName )
Values (@InStr,@v_ParaName,'08','单据')
Else
update Dict_Parameter set ParaName=@v_ParaName Where Paratypecode='08' and ParaCode=rtrim(@instr)
...全文
相关推荐
Java调用存储过程的2种方法
### Java调用存储过程的两种方法在Java中调用数据库中的存储过程是常见的操作之一,这不仅可以提高程序性能和代码可维护性,还可以更好地利用数据库的功能。
java 调用存储过程
下面将详细阐述如何在Java中调用存储过程。首先,要调用存储过程,你需要确保已正确地在Java应用程序中建立了与数据库的连接。
Java实现调用MySQL存储过程详解
在Java应用程序中,可以通过Java Database Connectivity (JDBC) API来调用MySQL的存储过程。
Java中调用SQL Server存储过程详解
本篇文章详细介绍了如何通过Java调用SQL Server存储过程,涵盖了几种不同类型的存储过程调用方式。1.
Java调用Oracle存储过程
本文主要探讨如何在Java中调用Oracle存储过程,以及如何通过Java创建Oracle存储过程。首先,我们来看如何在Java中调用不带输出参数的Oracle存储过程。


