Full sample of SQL Server stored procedures called in java/jsp

"From Mencius E blog" Recently did a small Java project (first write Java project), to search the internet for a long time, found a better example of the call stored procedures, and the Internet is commonly used is setxxx (int parameterindex, XXX x) The form. This form of feeling is not very intuitive, the following release a complete use of setxxx (String parametername, XXX x) Writing method. Create the data table, and the code for the stored procedure is published completely.

Create a table

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 ('默认值'),
CONSTRAINT [PK_BookUser] PRIMARY KEY　CLUSTERED
(
[UserID]
)　ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Creating a Stored Procedure

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