求助 这段存储过程在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调用存储过程的2种方法 Java调用存储过程的2种方法 Java调用存储过程的2种方法
java 调用存储过程
java 调用存储过程java 调用存储过程java 调用存储过程java 调用存储过程java 调用存储过程java 调用存储过程java 调用存储过程
Java实现调用MySQL存储过程详解
相信大家都知道存储过程是在大型数据库系统中,一组为了完成特定功能的SQL语句集。存储过程是数据库中的一个重要对象,任何一个设计良好的数据库应用程序都应该用到存储过程。Java调用mysql存储过程,实现如下,有需要的朋友们可以参考借鉴,下面来一起看看吧。
Java中调用SQL Server存储过程详解
主要介绍了Java中调用SQL Server存储过程详解,本文讲解了使用不带参数的存储过程、使用带有输入参数的存储过程、使用带有输出参数的存储过程、使用带有返回状态的存储过程、使用带有更新计数的存储过程等操作实例,需要的朋友可以参考下
Java调用Oracle存储过程
Java是一门面向对象编程语言,不仅吸收了C++语言的各种优点,还摒弃了C++里难以理解的多继承、指针等概念,因此Java语言具有功能强大和简单易用两个特征。Java语言作为静态面向对象编程语言的代表,极好地实现了面向对象理论,允许程序员以优雅的思维方式进行复杂的编程 。


