站点信息 访问统计：332897 在线人数：7 本次启动时间：2010-3-11 8:30:36
※ 热门文章 ※
※ 实例讲解JSP调用SQL Server的存储过程 ※
JSP调用SQL Server存储过程的实例：
创建表：
SQL代码
- 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
创建存储过程：
SQL代码
- 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
