【正文】 yuanggongidInt6否是員工編號(hào)yuanggongnameVarchar50否否員工姓名YuefenDate否否月份JibengongziInt50是否基本工資JiabanfeiInt50是否加班費(fèi)JiangjinInt50是否獎(jiǎng)金ShifagongziInt50否否實(shí)發(fā)工資 工資表字段名類型長度是否為空是否為主鍵描述kehuidInt6否是客戶編號(hào)MingchengVarchar50否否客戶姓名DizhiVarchar50是否地址DianghuaInt50是否電話YouxiangInt50是否郵箱KaihuhangVarchar50是否開戶行ZhanghaoInt50否否銀行賬號(hào) 客戶信息表字段名類型長度是否為空是否為主鍵描述orderidInt6否是訂單號(hào)riqiDate是否訂單日期JineInt50否否訂單金額KehunameVarchar50是否客戶名字 訂單信息表字段名類型長度是否為空是否為主鍵描述RukuidInt6否是入庫單號(hào)GoodsidInt50否否貨物編號(hào)ShijianDate50是否入庫時(shí)間ShuliangInt50是否入庫數(shù)量ZongjiageInt50是否貨物總價(jià)格JingshourenVarchar50是否經(jīng)手人 入庫表字段名類型長度是否為空是否為主鍵描述WuliuidInt6否是配送單編號(hào)ChufadianVarchar50是否出發(fā)點(diǎn)MudidiVarchar50是否目的地FacheshijianDate是否發(fā)車時(shí)間FanhuishijianDate是否返回時(shí)間ChepaihaoInt50是否車牌號(hào) 配送表字段名類型長度是否為空是否為主鍵描述YuangongidInt6否是員工編號(hào)YuanggongnameVarchar50否否員工姓名YuanggongsexVarchar50是否員工性別YuanggongageInt50是否員工年齡YuanggongtelInt50是否員工電話YuanggongaddressVarchar50是否員工住址YuanggongzhiweiVarchar50是否員工職位 員工表總結(jié)在本次畢業(yè)設(shè)計(jì)過程中，我了解到上課所理解的那些知識(shí)在很大程度上不能滿足實(shí)踐的需求，只有真正動(dòng)手對(duì)書上內(nèi)容進(jìn)行操作才能真正意義上的掌握書上講述的那些技術(shù)。雖然做了很充足的準(zhǔn)備，但是有時(shí)候也會(huì)出現(xiàn)一些之前完全沒有考慮到會(huì)出現(xiàn)的錯(cuò)誤，這就需要我們正確對(duì)待這些錯(cuò)誤并且積極去克服。他們教會(huì)我的不止是課堂上的知識(shí)，更珍貴的是為人處世的那些道理。雖然本次的畢業(yè)設(shè)計(jì)任務(wù)有點(diǎn)繁重，但是也正是這樣一項(xiàng)繁重的任務(wù)讓我體會(huì)到了將所學(xué)知識(shí)應(yīng)用到實(shí)踐中的成就感，我相信：這份畢業(yè)設(shè)計(jì)就是我為我的四年大學(xué)生活交上的一份完美的答卷。參考文獻(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的動(dòng)態(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后臺(tái)解決方案[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 [PRIMARY]GOSET ANSI_PADDING OFFGO客戶建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_kehu]( [id] [int] IDENTITY(1,1) NOT NULL, [mingcheng] [varchar](50) NULL, [dizhi] [varchar](50) NULL, [lianxiren] [varchar](50) NULL, [dianhua] [varchar](50) NULL, [youbian] [varchar](50) NULL, [chuanzhen] [varchar](50) NULL, [youxiang] [varchar](50) NULL, [kahuhang] [varchar](50) NULL, [zha