【正文】 pos, 255 )) exec iReturn = sp_OAMethod iStreamObjectId, 39。 and name not like 39。, vchDatabaseName, NULL if error 0 GOTO E_General_Error mit tran SetProperties declare cursorProcNames cursor for select convert(varchar(255), name) from sysobjects where type = 39。, SERVERNAME, NULL exec iPropertyObjectId, 39。 , vchSourceSafeINI , NULL exec iPropertyObjectId, 39。 , vchProjectName , NULL exec iPropertyObjectId, 39。, vchParentId , NULL exec iPropertyObjectId, 39。 select vchParentId = CONVERT(varchar(255),iPropertyObjectId) exec iPropertyObjectId, 39。, iStreamObjectId OUT if iReturn 0 GOTO E_OAError /* Set Database Properties */ begin tran SetProperties /* add high level object */ exec iPropertyObjectId = 39。, NULL, vchSourceSafeINI, vchProjectName output, SERVERNAME, vchDatabaseName, vchLoginName, vchPassword, vchComment if iReturn 0 GOTO E_OAError exec iReturn = sp_OAGetProperty iObjectId, 39。declare vchDatabaseName varchar(255)select vchDatabaseName = db_name()declare iReturnValue intselect iReturnValue = 0declare iPropertyObjectId intdeclare vchParentId varchar(255)declare iObjectCount intselect iObjectCount = 0 exec iReturn = sp_OACreate VSSGUID, iObjectId OUT if iReturn 0 GOTO E_OAError /* Create Project in SS */ exec iReturn = sp_OAMethod iObjectId, 39。asset nocount ondeclare iReturn intdeclare iObjectId intselect iObjectId = 0declare iStreamObjectId intselect iStreamObjectId = 0declare VSSGUID varchar(100)select VSSGUID = 39。, vchPassword varchar(255) =39。, vchLoginName varchar(255) =39。, vchComment varchar(255) =39。, vchProjectName varchar(255) =39。參考文獻(xiàn)[1] 張建章．淺談JSP開發(fā)WEB數(shù)據(jù)庫應(yīng)用技術(shù), 計(jì)算機(jī)應(yīng)用系統(tǒng)[J]．1998,9．[2] 龔玉清．網(wǎng)頁設(shè)計(jì)的色彩運(yùn)用, 現(xiàn)代教育技術(shù)[J]．2003,5．[3] 段永紅、李春海．基于JSP的網(wǎng)站建設(shè), 電腦開發(fā)與應(yīng)用[J]．2000,8．[4] 裴樹軍、張仁偉．基于JSP的動態(tài)WEB技術(shù)設(shè)計(jì), 哈爾濱理工大學(xué)學(xué)報(bào)[J]．1999,4．[5] 楊青．JSP的主要技術(shù)特點(diǎn)分析, 電腦與信息技術(shù)[J]．1999,4． [6] 曹淑琴．JSP技術(shù)的網(wǎng)站建設(shè), 華北科技學(xué)院學(xué)報(bào)[J]．2003,1．[7] 吳玉新．網(wǎng)站JSP后臺解決方案[M]．北京：人民郵電出版社，2003年 [8] 黃明、粱旭．JSP信息系統(tǒng)設(shè)計(jì)與開發(fā)實(shí)例[M]．北京：機(jī)械工業(yè)出版社，2003年 [9] 劉禾、蔡鋒．精通JSP架站技巧[M]．北京：中國青年出版社，2002年 [10] 張海藩．軟件工程[M]． 北京：人民郵電出版社．2002年 [11] Alberto Manuel Ricart．Active server pages 3 exploitation enchiridion[M]．北京：電子工業(yè)出版社,2003年 [12] Eric ．Active server pages[M]．北京：電子工業(yè)出版社，2003年 [13] Dave Mercer．JSP programme[M]．北京：人民郵電出版社，2003年 附錄數(shù)據(jù)庫源代碼SQL SERVER 類：系統(tǒng)管理員建表USE [db_cangchu]GO/****** Object: Table [dbo].[t_admin] Script Date: 05/06/2015 15:56:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_admin]( [userId] [int] IDENTITY(1,1) NOT NULL, [userName] [varchar](50) NULL, [userPw] [varchar](50) NULL, CONSTRAINT [PK_t_admin] PRIMARY KEY CLUSTERED ( [userId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO報(bào)損建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_baosun]( [id] [int] IDENTITY(1,1) NOT NULL, [goodsId] [int] NULL, [shuliang] [int] NULL, [shijian] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_t_baosun] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO出庫建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_chuku]( [id] [int] IDENTITY(1,1) NOT NULL, [goodsId] [int] NULL, [shijian] [varchar](50) NULL, [shuliang] [int] NULL, [zongjiage] [int] NULL, [jingshouren] [varchar](50) NULL, [beizhu] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_t_chuku] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO員工工資建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_gongzi]( [id] [int] IDENTITY(1,1) NOT NULL, [yuangong_id] [int] NULL, [yuefen] [varchar](50) NULL, [jibengongzi] [int] NULL, [jiabanfei] [int] NULL, [gonglingfei] [int] NULL, [kaoqinfei] [int] NULL, [baoxianfei] [int] NULL, [jiangjin] [int] NULL, [shifagongzi] [int] NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_t_gongzi] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO貨物建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_goods]( [id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NULL, [chandi] [varchar](50) NULL, [danwei] [varchar](50) NULL, [guige] [varchar](50) NULL, [beizhu] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_t_cailiao] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIM