Java中調(diào)用SQLServer存儲(chǔ)過程示例

下面就發(fā)布一個(gè)完整的采用setXXX(String parameterName, XXX x)的編寫方法。創(chuàng)建數(shù)據(jù)表，存儲(chǔ)過程的代碼都完整發(fā)布。
    創(chuàng)建表：
    CREATE TABLE [BookUser] (
     [UserID] [int] IDENTITY (1, 1) NOT NULL ,
     [UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
     [Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
     [Guid] [uniqueidentifier] NOT NULL CONSTRAINT [DF_BookUser_Guid] DEFAULT (newid()),
     [BirthDate] [datetime] NOT NULL ,
     [Description] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
     [Photo] [image] NULL ,
     [Other] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT
     [DF_BookUser_Other] DEFAULT ('默認(rèn)值'),
     CONSTRAINT [PK_BookUser] PRIMARY KEY CLUSTERED
     (
     [UserID]
     ) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    GO
    創(chuàng)建存儲(chǔ)過程：
    CREATE PROCEDURE InsertUser
    @UserName varchar(50),
    @Title varchar(255),
    @Guid uniqueidentifier,
    @BirthDate DateTime,
    @Description ntext,
    @Photo image,
    @Other nvarchar(50),
    @UserID int output
    As
    Set NOCOUNT ON
    If Exists (select UserID from BookUser Where UserName = @UserName)
    RETURN 0
    ELSE
    Begin
    INSERT INTO BookUser (UserName,Title,Guid,BirthDate,Description,Photo,Other) VALUES(@UserName,@Title,@Guid,@BirthDate,@Description,@Photo,@Other)
    SET @UserID = @@IDENTITY
    RETURN 1
    End
    GO