快捷搜索:

JSP中调用SQL Server存储过程实例讲解

下面先容一个JSP调用SQL Server存储历程的实例:

创建表:

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 KEYCLUSTERED

(

[UserID]

)ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

创建存储历程:

CREATE PROCEDURE InsertUser

@UserName varchar(50),

@Title varchar(255),

@Guiduniqueidentifier,

@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

JSP代码:

您可能还会对下面的文章感兴趣: