《实例讲解jsp调用sqlserver的存储过程》由会员分享,可在线阅读,更多相关《实例讲解jsp调用sqlserver的存储过程(4页珍藏版)》请在金锄头文库上搜索。
1、实例讲解 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 (ne
2、wid(),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 PRIMARYGO
3、创建存储过程: CREATE PROCEDURE InsertUserUserName varchar(50),Title varchar(255),Guid uniqueidentifier,BirthDate DateTime,Description ntext,Photo image,Other nvarchar(50),UserID int output As Set NOCOUNT ONIf Exists (select UserID from BookUser Where UserName = UserName)RETURN 0ELSEBeginINSERT INTO BookUs
4、er (UserName,Title,Guid,BirthDate,Description,Photo,Other) VALUES(UserName,Title,Guid,BirthDate,Description,Photo,Other)SET UserID = IDENTITYRETURN 1EndGOJSP代码: 添加成功!);out.print(UserID = + UserID);out.print(returnValue = + returnValue);elseout.print(添加失败!);f.close();catch(Exception ex)out.print(ex.getLocalizedMessage();finallytryif(cmd != null)cmd.close();cmd = null;if(cn != null)cn.close();cn = null;catch(Exception e) e.printStackTrace();%