最近做了个Java的小项目（第一次写Java的项目哦）， 到网上搜索了半天，找到了一个比较好点的调用存储过程的例子，而且网上普遍采用的都是setXXX((int parameterIndex, XXX x)的形式。这种形式感觉不是很直观，下面就发布一个完整的采用setXXX(String parameterName, XXX x)的编写方法。创建数据表，存储过程的代码都完整发布。 {)?a+C@&
aj< 'P<To<
创建表： ah_Qc$
#e #0J+
CREATE TABLE [BookUser] ( |F%{Z "
[UserID] [int] IDENTITY (1, 1) NOT NULL , H `_p)=2
[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , s2H ~2$h3
[Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , !].rWjw
[Guid] [uniqueidentifier] NOT NULL CONSTRAINT [DF_BookUser_Guid] DEFAULT (newid()), kDANfyASt
[BirthDate] [datetime] NOT NULL , >ex0kxOs8
[Description] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL , 0)+'FY#
[Photo] [image] NULL , VA)NZ0{J
[Other] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT G_#691uL
[DF_BookUser_Other] DEFAULT ('默认值'), ))\V&N2m
CONSTRAINT [PK_BookUser] PRIMARY KEY CLUSTERED &~ W': M
( R ;?vn6
[UserID] gs>q CDp
) ON [PRIMARY] %6ia\b4
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] <kVq}txH
GO Z[\ xQu
8pyd3@
z<%2 (%}&
创建存储过程： By^m,^njf
*-=>[rZRfq
CREATE PROCEDURE InsertUser hv*qEJ[k-
@UserName varchar(50), 0`4dYNG[L
@Title varchar(255), S1(;Jxdk
@Guid uniqueidentifier, (\q5NOG
@BirthDate DateTime, a=ItJ
@Description ntext, JZ#{ 6v
@Photo image, eT+j_F)
@Other nvarchar(50), #(!3.4"
@UserID int output [L 4I_d
As =iH^@9O
c))o@q
Set NOCOUNT ON " tL;"EI\
If Exists (select UserID from BookUser Where UserName = @UserName) s6Ajm
RETURN 0 WiNx
ELSE kluPI
Begin e6>Jx9,sZ
INSERT INTO BookUser (UserName,Title,Guid,BirthDate,Description,Photo,Other) VALUES(@UserName,@Title,@Guid,@BirthDate,@Description,@Photo,@Other) !oc" mmCc
SET @UserID = @@IDENTITY ur62:HuG
RETURN 1 -lBB}g
End dSAhZXW
GO 'gv.n
>3R_ZN\
NoniQG>x
JSP代码： lHU 0"xwL
+.5
＜%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%＞ v wbNAKc
＜%@ page import = "java.sql.*"%＞ s*Y(UQ-K
＜!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"＞ C*8 I1j @N
aj< 'P<To<
创建表： ah_Qc$
#e #0J+
CREATE TABLE [BookUser] ( |F%{Z "
[UserID] [int] IDENTITY (1, 1) NOT NULL , H `_p)=2
[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , s2H ~2$h3
[Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , !].rWjw
[Guid] [uniqueidentifier] NOT NULL CONSTRAINT [DF_BookUser_Guid] DEFAULT (newid()), kDANfyASt
[BirthDate] [datetime] NOT NULL , >ex0kxOs8
[Description] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL , 0)+'FY#
[Photo] [image] NULL , VA)NZ0{J
[Other] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT G_#691uL
[DF_BookUser_Other] DEFAULT ('默认值'), ))\V&N2m
CONSTRAINT [PK_BookUser] PRIMARY KEY CLUSTERED &~ W': M
( R ;?vn6
[UserID] gs>q CDp
) ON [PRIMARY] %6ia\b4
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] <kVq}txH
GO Z[\ xQu
8pyd3@
z<%2 (%}&
创建存储过程： By^m,^njf
*-=>[rZRfq
CREATE PROCEDURE InsertUser hv*qEJ[k-
@UserName varchar(50), 0`4dYNG[L
@Title varchar(255), S1(;Jxdk
@Guid uniqueidentifier, (\q5NOG
@BirthDate DateTime, a=ItJ
@Description ntext, JZ#{ 6v
@Photo image, eT+j_F)
@Other nvarchar(50), #(!3.4"
@UserID int output [L 4I_d
As =iH^@9O
c))o@q
Set NOCOUNT ON " tL;"EI\
If Exists (select UserID from BookUser Where UserName = @UserName) s6Ajm
RETURN 0 WiNx
ELSE kluPI
Begin e6>Jx9,sZ
INSERT INTO BookUser (UserName,Title,Guid,BirthDate,Description,Photo,Other) VALUES(@UserName,@Title,@Guid,@BirthDate,@Description,@Photo,@Other) !oc" mmCc
SET @UserID = @@IDENTITY ur62:HuG
RETURN 1 -lBB}g
End dSAhZXW
GO 'gv.n
>3R_ZN\
NoniQG>x
JSP代码： lHU 0"xwL
+.5
＜%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%＞ v wbNAKc
＜%@ page import = "java.sql.*"%＞ s*Y(UQ-K
＜!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"＞ C*8 I1j @N
0
