项目报告书JAVA设计报告.doc

项目实习报告书小组人数2实习名称软件开发实习(A)周数2实习地点钟海楼软件实验室班级软件1073人数31起止时间2008.12.22-2009.1.4形式集中 分散指导教师张健小组成员：马晓槟（200711701319）、凌志强（200711701315）一、软件项目开发选择掌握使用Java语言开发数据库应用程序的基本技能，巩固数据库原理及应用等理论知识。编写一个文本界面的Java应用程序，该应用程序能够与数据库建立连接，并且在数据库上执行数据操纵语言。(1)DepartmentalStore项目Domino是一间大型百货商店，Domino库存管理系统预期目标如下： 数据库将能维护供应商的详细资料（维护：查询、插入、删除、修改）。 数据库将能维护商品的详细资料。 数据库将能维护交易的详细资料。 库存管理软件系统应能打印商品可用库存的报表（屏幕上显示出报表即可）(2)ShareAccounting项目Ericmobil是一间国际商业股份有限公司，该公司计划发行一千万股股票（每股 $10）筹集资金，股份按以下四种类型分配：常驻居民、非常驻居民、国内公司、外国公司。Ericmobil的股份账务系统维护股东的详细资料，系统预期目标如下： 数据库将能维护申请者的详细资料。 该股份账务系统应该可以进行适当的查询。 该股份账务系统应该可以打印基于股东类型的分配列表。 该股份账务系统应该可以打印基于股东类型的最大分配列表（以上四种股民的最大股东）。 该股份账务系统应该可以打印基于日期的分配列表。-我们小组选择了项目1.DepartmentalStore项目。-二、实习进度第1-3天：软件项目分配及概念讨论，项目分析第4-5天：数据库设计及实施，建立连接SQL Server数据库的数据源第6-7天：用户界面设计 第7-9天：用Java语言开发项目第10-11天：测试与验证第12-13天：软件项目文档写作三、实习要求软件项目开发以项目组的形式组织实施，每个项目组由2人组成，单号项目组从以上两个开发项目中选做第一个项目，双号项目组选做第二个项目，每组成员协作完成整个项目。项目开发提交文档：1每个项目组提交软件系统源代码。2每个项目组提交软件系统设计文档。3每个项目组提交数据库SQL脚本。四、实习结果1.系统设计框图数据库架构图2.SQL脚本/*1.新建名为CommodityManage的数据库*/create database CommodityManage/*2.创建各个表*/create table SupplierDetail( cSupplierID char(6) primary key, vSupplierName varchar(50), vSupplierDescription varchar(50), cSupplierTele 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), vCommodityType 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, 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) )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) 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 SupplierDetail (cSupplierID)/*3.在各个表中插入数据*/*3.1 在SupplierDetail表中插入数据*/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)insert 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 commoditiesNanjing Square No.64,3,best)insert into SupplierDetail values(SE0006,Just Buy,not so goodZhongshan Road No.234,4,so-so)/*3.2 在Commodity表中插入数据*/insert into Commodity values(TM0001,Banana,Fruit,A cheap and delicious fruit,1.7,kilo);/*香蕉*/insert into Commodity values(MD0002,Apple,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-Necessities,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,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表中插入数据*/insert into Supply values(TM0001,SE0001)insert into Supply 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,SE0002)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 Supply values(FE0027,SE0003)insert into Supply values(RG0029,SE0006)/*3.4 在CommodityDetail表中插入数据*/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(TK0011,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.需要用到的触发器*/*4.1 在更新CommodityDetail表时自动更改标志位*/create trigger trgUpdateCommodityDetailon 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,cOrderFlag=nwhere cCommodityID=idendendelsebeginupdate CommodityDetailset cNeedFlag=n,cOrderFlag=nwhere cCommodityID=idend/*4.2 在CommodityDetail表中插入新记录时自动填写部分列*/create trigger trgInsertCommodityDetailon CommodityDetailafter insertasupdate CommodityDetailset dCommodityStoreDate=getdate(),cNeedFlag=n,cOrderFlag=nwhere cCommodityID=(select cCommodityID from inserted)/*5.需用到的存储过程*/*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 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.setInt(1,Integer.p