項(xiàng)目報(bào)告書 AVA設(shè)計(jì)報(bào)告

1、最新 精品 Word 歡迎下載 可修改項(xiàng)目實(shí)習(xí)報(bào)告書小組人數(shù)2實(shí)習(xí)名稱軟件開發(fā)實(shí)習(xí)(A)周數(shù)2實(shí)習(xí)地點(diǎn)鐘海樓軟件實(shí)驗(yàn)室班級(jí)軟件1073人數(shù)31起止時(shí)間2022.12.22-2022.1.4形式集中 分散指導(dǎo)教師張健小組成員：馬曉檳（202211701319）、凌志強(qiáng)（202211701315）一、軟件項(xiàng)目開發(fā)選擇掌握使用Java語言開發(fā)數(shù)據(jù)庫應(yīng)用程序的基本技能，鞏固數(shù)據(jù)庫原理及應(yīng)用等理論知識(shí)。編寫一個(gè)文本界面的Java應(yīng)用程序，該應(yīng)用程序能夠與數(shù)據(jù)庫建立連接，并且在數(shù)據(jù)庫上執(zhí)行數(shù)據(jù)操縱語言。(1)DepartmentalStore項(xiàng)目Domino是一間大型百貨商店，Domino庫存管理系統(tǒng)預(yù)期

2、目標(biāo)如下： 數(shù)據(jù)庫將能維護(hù)供應(yīng)商的詳細(xì)資料（維護(hù)：查詢、插入、刪除、修改）。 數(shù)據(jù)庫將能維護(hù)商品的詳細(xì)資料。 數(shù)據(jù)庫將能維護(hù)交易的詳細(xì)資料。 庫存管理軟件系統(tǒng)應(yīng)能打印商品可用庫存的報(bào)表（屏幕上顯示出報(bào)表即可）(2)ShareAccounting項(xiàng)目Ericmobil是一間國(guó)際商業(yè)股份有限公司，該公司計(jì)劃發(fā)行一千萬股股票（每股 $10）籌集資金，股份按以下四種類型分配：常駐居民、非常駐居民、國(guó)內(nèi)公司、外國(guó)公司。Ericmobil的股份賬務(wù)系統(tǒng)維護(hù)股東的詳細(xì)資料，系統(tǒng)預(yù)期目標(biāo)如下： 數(shù)據(jù)庫將能維護(hù)申請(qǐng)者的詳細(xì)資料。 該股份賬務(wù)系統(tǒng)應(yīng)該可以進(jìn)行適當(dāng)?shù)牟樵儭?該股份賬務(wù)系統(tǒng)應(yīng)該可以打印基于股東類型的分

3、配列表。 該股份賬務(wù)系統(tǒng)應(yīng)該可以打印基于股東類型的最大分配列表（以上四種股民的最大股東）。 該股份賬務(wù)系統(tǒng)應(yīng)該可以打印基于日期的分配列表。-我們小組選擇了項(xiàng)目1.DepartmentalStore項(xiàng)目。-二、實(shí)習(xí)進(jìn)度第1-3天：軟件項(xiàng)目分配及概念討論，項(xiàng)目分析第4-5天：數(shù)據(jù)庫設(shè)計(jì)及實(shí)施，建立連接SQL Server數(shù)據(jù)庫的數(shù)據(jù)源第6-7天：用戶界面設(shè)計(jì) 第7-9天：用Java語言開發(fā)項(xiàng)目第10-11天：測(cè)試與驗(yàn)證第12-13天：軟件項(xiàng)目文檔寫作三、實(shí)習(xí)要求軟件項(xiàng)目開發(fā)以項(xiàng)目組的形式組織實(shí)施，每個(gè)項(xiàng)目組由2人組成，單號(hào)項(xiàng)目組從以上兩個(gè)開發(fā)項(xiàng)目中選做第一個(gè)項(xiàng)目，雙號(hào)項(xiàng)目組選做第二個(gè)項(xiàng)目，每組成員

4、協(xié)作完成整個(gè)項(xiàng)目。項(xiàng)目開發(fā)提交文檔：1每個(gè)項(xiàng)目組提交軟件系統(tǒng)源代碼。2每個(gè)項(xiàng)目組提交軟件系統(tǒng)設(shè)計(jì)文檔。3每個(gè)項(xiàng)目組提交數(shù)據(jù)庫SQL腳本。四、實(shí)習(xí)結(jié)果1.系統(tǒng)設(shè)計(jì)框圖數(shù)據(jù)庫架構(gòu)圖2.SQL腳本/*1.新建名為CommodityManage的數(shù)據(jù)庫*/create database CommodityManage/*2.創(chuàng)建各個(gè)表*/create table SupplierDetail( cSupplierID char(6) primary key, vSupplierName varchar(50), vSupplierDescription varchar(50), cSupplierTe

5、le char(12) check(cSupplierTele like 0-9 0-9 0-9 0-9- 0-9 0-9 0-9 0-9 0-9 0-9 0-9 ), vSupplierAddress varchar(50), iShipmentDelay int, cCredibilityDeg char(5) check(cCredibilityDeg in(so-so,high,best,medium)create table Commodity( cCommodityID char(6) primary key, vCommodityName varchar(50), vCommod

6、ityType varchar(20), vCommodityDescription varchar(50), mCommodityUnitPrice money, vCommodityUnit char(10),)create table Supply( cCommodityID char(6), cSupplierID char(6), primary key(cCommodityID,cSupplierID) create table CommodityDetail( cCommodityID char(6) not null, cSupplierID char(6) not null,

7、 vCommodityName varchar(50), vCommodityType varchar(20), iCommodityQty int, iCommodityThreshold int, dCommodityStoreDate datetime, cNeedFlag char(1), cOrderFlag char(1), foreign key (cCommodityID) references Commodity (cCommodityID), foreign key (cSupplierID) references SupplierDetail (cSupplierID)

8、)create table OrderDetail( cOrderID char(3) primary key, cCommodityID char(6), cSupplierID char(6), iOrderQty int, dOrderDate datetime, dShipmentDate datetime, vOrderRemark varchar(50), vOrderClerk varchar(50), foreign key (cCommodityID) references Commodity (cCommodityID), foreign key (cSupplierID)

9、 references SupplierDetail (cSupplierID)create table Sold( cJournalNo char(4) primary key, cCommodityID char(6), cSupplierID char(6), vCommodityName varchar(50), iCommodityQty int, dSoldDate datetime foreign key (cCommodityID) references Commodity (cCommodityID), foreign key (cSupplierID) references

10、 SupplierDetail (cSupplierID)/*3.在各個(gè)表中插入數(shù)據(jù)*/*3.1 在SupplierDetail表中插入數(shù)據(jù)*/insert into SupplierDetail values(SE0001,Rdtio Goods,Famous,high qualityLondon Bridge No.114,3,best)insert into SupplierDetail values(SE0002,Tehns Squre,so-so,but cheapTianhe Road No.231,5,so-so)inser

11、t into SupplierDetail values(SE0003,Ocean Store,not badZhongshan Road No.12,4,high)insert into SupplierDetail values(SE0004,Mars Commodities,quite good,and very fastRenmin Road No.35,2,high)insert into SupplierDetail values(SE0005,Simple,good serve and good commodities,04

12、95-8543468,Nanjing Square No.64,3,best)insert into SupplierDetail values(SE0006,Just Buy,not so goodZhongshan Road No.234,4,so-so)/*3.2 在Commodity表中插入數(shù)據(jù)*/insert into Commodity values(TM0001,Banana,Fruit,A cheap and delicious fruit,1.7,kilo);/*香蕉*/insert into Commodity values(MD0002,App

13、le,Fruit,An apple a day keep the doctor away,2.4,kilo);/*蘋果*/insert into Commodity values(ZE0004,Cake,Dessert,A sweet food for you to enjoy,10,box);/*蛋糕*/insert into Commodity values(JJ0007,Chocolate,Dessert,Almost girls enjoy it,15,box);/*巧克力*/insert into Commodity values(SB0009,Toothpaste,Daily-Ne

14、cessities,Necessities for tooth,9.9,box);/*牙膏*/insert into Commodity values(TK0011,Paper,Daily-Necessities,Necessities for clean,4.5,package);/*紙巾*/insert into Commodity values(EF0014,Rice,Daily-Food,Food that people eat everyday,50,kg);/*大米*/insert into Commodity values(GE0020,Peanut oil,Daily-Food

15、,Need for cook,45,can);/*花生油*/insert into Commodity values(FE0027,Badminton Racket,Fun,Need for sport,99,pair);/*羽毛球拍*/insert into Commodity values(RG0029,Genuine-DVD,Fun,Film,Animation,Concert and so on,111,piece);/*正版DVD*/*3.3 在Supply表中插入數(shù)據(jù)*/insert into Supply values(TM0001,SE0001)insert into Supp

16、ly values(TM0001,SE0004)insert into Supply values(MD0002,SE0006)insert into Supply values(EF0014,SE0003)insert into Supply values(TK0011,SE0002)insert into Supply values(JJ0007,SE0005)insert into Supply values(SB0009,SE0005)insert into Supply values(GE0020,SE0001)insert into Supply values(FE0027,SE0

17、002)insert into Supply values(RG0029,SE0003)insert into Supply values(ZE0004,SE0004)insert into Supply values(ZE0004,SE0006)insert into Supply values(TK0011,SE0004)insert into Supply values(GE0020,SE0003)insert into Supply values(JJ0007,SE0001)insert into Supply values(JJ0007,SE0002)insert into Supp

18、ly values(FE0027,SE0003)insert into Supply values(RG0029,SE0006)/*3.4 在CommodityDetail表中插入數(shù)據(jù)*/insert into CommodityDetail values(TM0001,SE0001,Banana,Fruit,56,10,2008-12-29,n,n)insert into CommodityDetail values(ZE0004,SE0004,Cake,Dessert,150,25,2008-11-20,n,n)insert into CommodityDetail values(TK00

19、11,SE0004,Paper,Daily-Necessities,130,50,2008-10-5,n,n)insert into CommodityDetail values(FE0027,SE0003,Badminton Racket,Fun,20,5,2008-9-15,n,n)insert into CommodityDetail values(GE0020,SE0001,Peanut oil,Daily-Food,17,5,2008-11-26,n,n)/*4.需要用到的觸發(fā)器*/*4.1 在更新CommodityDetail表時(shí)自動(dòng)更改標(biāo)志位*/create trigger tr

20、gUpdateCommodityDetailon CommodityDetailafter updateasdeclare qty intdeclare threshold intdeclare id char(6)declare need char(1)select id=cCommodityID,qty=iCommodityQty,threshold=iCommodityThreshold,need=cNeedFlag from insertedif(qtythreshold)beginif(need=n)beginupdate CommodityDetailset cNeedFlag=y

21、,cOrderFlag=nwhere cCommodityID=idendendelsebeginupdate CommodityDetailset cNeedFlag=n,cOrderFlag=nwhere cCommodityID=idend/*4.2 在CommodityDetail表中插入新記錄時(shí)自動(dòng)填寫部分列*/create trigger trgInsertCommodityDetailon CommodityDetailafter insertasupdate CommodityDetailset dCommodityStoreDate=getdate(),cNeedFlag=n

22、,cOrderFlag=nwhere cCommodityID=(select cCommodityID from inserted)/*5.需用到的存儲(chǔ)過程*/*5.1 生成售出商品信息*/create proc prcSold journalno char(4),commodityid char(6),qty intasbegin begin tran declare date datetime select date=getdate() declare supplierid char(6) declare commodityname varchar(50) declare result

23、int select supplierid=cSupplierID,commodityname=vCommodityName from CommodityDetail where cCommodityID=commodityid insert into Sold values(journalno,commodityid,supplierid,commodityname,qty,date) update CommodityDetail set iCommodityQty=iCommodityQty-qty where cCommodityID=commodityid set result=(select iCommodityQty from CommodityDetail where cCommodityID=commodityid) if(result4) stat.set