资源描述:
《java调用sqlserver存储过程》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、------------------------------------------------------创建表CREATETABLE[BookUser]([UserID][int]IDENTITY(1,1)NOTNULL,[UserName][varchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,[Title][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,[Guid][uniqueidentifier]NOTNULLCONSTRAINT[DF_BookUs
2、er_Guid]DEFAULT(newid()),[BirthDate][datetime]NOTNULL,[Description][ntext]COLLATEChinese_PRC_CI_ASNOTNULL,[Photo][image]NULL,[Other][varchar](50)COLLATEChinese_PRC_CI_ASNULLCONSTRAINT[DF_BookUser_Other]DEFAULT('默认值'),CONSTRAINT[PK_BookUser]PRIMARYKEYCLUSTERED([UserID])ON[
3、PRIMARY])ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]GO----------------------------------------------------------------创建存储过程CREATEPROCEDUREInsertUser@UserNamevarchar(50),@Titlevarchar(255),@Guiduniqueidentifier,@BirthDateDateTime,@Descriptionntext,@Photoimage,@Othernvarchar(50),@Use
4、rIDintoutputAsSetNOCOUNTONIfExists(selectUserIDfromBookUserWhereTitle=@Title)--这一句判断数据库某一个字段的唯一性RETURN0ELSEBeginINSERTINTOBookUser(UserName,Title,Guid,BirthDate,Description,Photo,Other)VALUES(@UserName,@Title,@Guid,@BirthDate,@Description,@Photo,@Other)SET@UserID=@@IDENTI
5、TYRETURN1EndGO------------------------------------查询分析器中测试execInsertUser@UserName='111',@Title='测试1',@Guid='69807bfa-45a1-4f27-a21e-8b90025bff05',@BirthDate='2009-04-01',@Description='4455',@Photo=null,@Other=null,@UserID='123'--------------------------------------------页
6、面调用<%@pagelanguage="java"import="java.util.*"pageEncoding="gbk"%><%@pageimport="java.sql.*"%><%@pageimport="java.sql.Date;"%><%Stringpath=request.getContextPath();StringbasePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>
7、TYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
">MyJSP'MyJsp.jsp'startingpage8、-equiv="keywords"content="keyword1,keyword2,keyword3">