Oracle課程設(shè)計(jì)報(bào)告--倉(cāng)庫(kù)管理系統(tǒng)

1、精品資料推薦Oracle課程設(shè)計(jì)實(shí)驗(yàn)題目：倉(cāng)庫(kù)管理系統(tǒng)專(zhuān) 業(yè)：計(jì)算機(jī)應(yīng)用與技術(shù)班 級(jí)：1440302學(xué) 號(hào)：20110030226姓 名：胡強(qiáng)指導(dǎo)教師：王芳3一、 系統(tǒng)描述 倉(cāng)庫(kù)管理系統(tǒng)的功能：1）、產(chǎn)品入倉(cāng)管理：在貨物送到倉(cāng)庫(kù)時(shí)，對(duì)貨物信息進(jìn)行了解并將 相關(guān)信息輸入到數(shù)據(jù)庫(kù) 中，同時(shí)更新數(shù)據(jù)庫(kù)。2）、產(chǎn)品出倉(cāng)管理：在貨物運(yùn)出倉(cāng)庫(kù)時(shí)，進(jìn)行貨物信息統(tǒng)計(jì)并將數(shù) 據(jù)保存到數(shù)據(jù)庫(kù)中，同 時(shí)更新數(shù)據(jù)庫(kù)。3）倉(cāng)庫(kù)貨物信息提醒：當(dāng)貨物少于某一規(guī)定的值時(shí)，或者貨物保質(zhì) 期將至?xí)r將發(fā)出 提醒。4）、借出管理：憑借條借出，然后能夠還庫(kù)。5）、查詢(xún)修改：管理員可以進(jìn)行一系列查詢(xún)：查詢(xún)貨物類(lèi)別及貨物 的信息、數(shù)量和貨

2、 物流動(dòng)的規(guī)則（對(duì)貨物出倉(cāng)進(jìn)倉(cāng)的要求）；并可 以對(duì)以上查詢(xún)進(jìn)行修改； 可以查詢(xún)某一天貨物流動(dòng)的信息， 以及出倉(cāng) 及入倉(cāng)的詳細(xì)信息。6）、初始化庫(kù)存設(shè)置：設(shè)置庫(kù)存的初始化值，庫(kù)存的上下警戒限制。7）、盤(pán)庫(kù)情況：反映沒(méi)有、年的庫(kù)存情況；二、 系統(tǒng)需求分析 利用用例圖、類(lèi)圖、 E-R 圖對(duì)系統(tǒng)進(jìn)行需求分析。 倉(cāng)庫(kù)管理系統(tǒng)可以實(shí)現(xiàn)對(duì)倉(cāng)庫(kù)貨物信息、 出倉(cāng)貨物管理、 進(jìn)倉(cāng)貨物管 理、貨物數(shù)量管理以及貨物出入倉(cāng)限制規(guī)則，以下為其用例圖、類(lèi)圖 及 E-R 圖。倉(cāng)庫(kù)管理系統(tǒng)用例圖類(lèi)圖表1 :產(chǎn)品信息表 PRO字段名數(shù)據(jù)類(lèi)型長(zhǎng)度約束說(shuō)明PROIDNUMBER11主碼產(chǎn)品編號(hào)PRONAMEVARCHAR220NOT

3、 NULL產(chǎn)品名稱(chēng)PRODRESSVARCHAR250產(chǎn)品地址DREPHONENUMBER20產(chǎn)品地址號(hào)碼BDATENUMBER5NOT NULL保質(zhì)天數(shù)DEMOVARCHAR2100說(shuō)明精品資料推薦表2:產(chǎn)品信息管理 PRO_MAN字段名1數(shù)據(jù)類(lèi)型長(zhǎng)度約束說(shuō)明PROIDNUMBER11主碼，外碼產(chǎn)品編號(hào)BIRDATEDATE主碼產(chǎn)品生產(chǎn)日期ZNUMNUMBER20NOT NULL產(chǎn)品數(shù)量DEMOVARCHAR2100說(shuō)明表3:產(chǎn)品出庫(kù)管理 C PRO字段名數(shù)據(jù)類(lèi)型長(zhǎng)度約束說(shuō)明PROIDNUMBER11主碼，外碼產(chǎn)品編號(hào)CDATEDATE主碼出庫(kù)日期BIRDATEDATENOT NULL生產(chǎn)日

4、期ZNUMNUMBER10NOT NULL出庫(kù)數(shù)量DEMOVARCHAR2100說(shuō)明表4:產(chǎn)品入庫(kù)日期 R PRO字段名數(shù)據(jù)類(lèi)型長(zhǎng)度約束說(shuō)明PROIDNUMBER11主碼，外碼產(chǎn)品編號(hào)RDATEDATE主碼入庫(kù)日期BIRDATEDATENOT NULL生產(chǎn)日期RNUMNUMBER10NOT NULL入庫(kù)數(shù)量DEMOVARCHAR2100說(shuō)明表5:產(chǎn)品倉(cāng)庫(kù)限制規(guī)則字段名數(shù)據(jù)類(lèi)型長(zhǎng)度約束說(shuō)明PROIDNUMBER11主碼，外碼產(chǎn)品編號(hào)BIRDATEDATE主碼產(chǎn)品生產(chǎn)日期ZNUMNUMBER20NOT NULL產(chǎn)品數(shù)量DEMOVARCHAR2100說(shuō)明表6:管理員表ADMIN字段名數(shù)據(jù)類(lèi)型長(zhǎng)度約束

5、說(shuō)明IDNUMBER11主碼管理員編號(hào)USARNAMEVARCHAR210NOT NULL管理員賬號(hào)PASSORDVARCHAR211NOT NULL賬號(hào)密碼E-R圖LUS di 1-m4二亠h 二 m -.1HUI 2呱北zXJM-皿idJL沁Sn,3NwHt ：L9；k»二、數(shù)據(jù)庫(kù)對(duì)象設(shè)計(jì)1、表設(shè)計(jì)通過(guò)對(duì)倉(cāng)庫(kù)管理系統(tǒng)的業(yè)務(wù)分析及查詢(xún)資料了解，設(shè)計(jì)該系統(tǒng)的6個(gè)關(guān)系表，詳情見(jiàn)上邊類(lèi)圖部分。2、序列設(shè)計(jì)為了方便倉(cāng)庫(kù)產(chǎn)品管理， 在數(shù)據(jù)庫(kù)中用以下序列產(chǎn)生相應(yīng)編號(hào) C_R_VIE：產(chǎn)生產(chǎn)品編號(hào)，起始值 100。3、視圖設(shè)計(jì)為了方便倉(cāng)庫(kù)管理員查詢(xún)出入庫(kù)情況、 每個(gè)生產(chǎn)日期的庫(kù) 存信息及產(chǎn)品的總

6、數(shù)量，創(chuàng)建下列視圖。(1) 創(chuàng)建名為“ C_R_PRO_VIEW的視圖，用于查看產(chǎn)品的出入庫(kù) 匯總情況，包 括出庫(kù)的產(chǎn)品編號(hào)，入庫(kù)的產(chǎn)品編號(hào)，產(chǎn)品名稱(chēng)，入 庫(kù)日期，出庫(kù)日期，出庫(kù)產(chǎn)品的生產(chǎn)日期，入庫(kù)產(chǎn)品的生產(chǎn)日期，出庫(kù)數(shù)量，入庫(kù)數(shù)量。(2) 創(chuàng)建名為“ SNUM的視圖，用于查詢(xún)一種產(chǎn)品的總庫(kù)存量，包 括產(chǎn)品編號(hào)，產(chǎn)品總數(shù)量。(3) 創(chuàng)建名為“ZNUM_PRO_V”的視圖，用于查詢(xún)產(chǎn)品的庫(kù)存信息， 包括不同 生產(chǎn)日期的庫(kù)存量4、PL/SQL功能模塊設(shè)計(jì)利 用 PL/SQL 程 序 創(chuàng) 建 下 列 各 種 數(shù) 據(jù) 庫(kù) 對(duì) 象。(1) 創(chuàng)建一個(gè)當(dāng)倉(cāng)庫(kù)產(chǎn)品少于最少數(shù)量或者大于最大數(shù)量時(shí)顯示出 產(chǎn)品數(shù)量

7、、生產(chǎn)日期及保質(zhì)期的函數(shù)。(2) 創(chuàng)建一個(gè)計(jì)算距保質(zhì)期時(shí)間的存儲(chǔ)過(guò)程。3）創(chuàng)建一個(gè)計(jì)算出庫(kù)后數(shù)量的函數(shù)。4）創(chuàng)建一個(gè)計(jì)算入庫(kù)后數(shù)量的函數(shù)。四、 數(shù)據(jù)庫(kù)對(duì)象創(chuàng)建 描述數(shù)據(jù)庫(kù)對(duì)象中表的創(chuàng)建、序列的創(chuàng)建、視圖的創(chuàng)建、存儲(chǔ)過(guò)程的 創(chuàng)建，觸發(fā)器的創(chuàng)建等內(nèi)容，實(shí)現(xiàn)系統(tǒng)的基本功能。1、表的創(chuàng)建(1) 產(chǎn)品信息 PRO:CREATE TABLE "USERS"."PRO" ("PROID" NUMBER(11) NOT NULL ,"PRONAME" VARCHAR2(20) NOT NULL , "PRODRESS&q

8、uot; VARCHAR2(50), "DREPHONE"NUMBER(20), "BDATE" NUMBER(5) NOT NULL , "DEMO" VARCHAR2(100),PRIMARY KEY ("PROID") VALIDATE ) TABLESPACE"USERS"(2) 倉(cāng)庫(kù)產(chǎn)品管理 PRO_MANCREATE TABLE "USERS"."PRO_MAN" ( "PROID" NUMBER(11) NOT NULL

9、, "BIRDATE" DATE NOT NULL , "ZNUM" NUMBER(20) NOT NULL , "DEMO" VARCHAR2(100),PRIMARY KEY ("PROID", "BIRDATE") VALIDATE , FOREIGN KEY ("PROID") REFERENCES"SYS"."PRO" ("P ROID") VALIDATE )TABLESPACE"USERS&q

10、uot;( 3)創(chuàng)建入庫(kù)管理表 R_PROCREATE TABLE "USERS"."R_PRO" ( "PROID" NUMBER(11) NOT NULL , "RDATE" DATE NOT NULL , "BIRDATE" DATE NOT NULL , "RNUM" NUMBER(10) NOT NULL , "DEMO" VARCHAR2(100),PRIMARY KEY ("PROID", "RDATE"

11、;) VALIDATE , FOREIGN KEY ("PROID") REFERENCES"SYS"."PRO" ("PRO ID") VALIDATE )TABLESPACE"USERS"19( 4)出庫(kù)產(chǎn)品管理 C_PROCREATE TABLE "USERS"."C_PRO" ("PROID" NUMBER(11) NOT NULL ,"CDATE" DATE NOT NULL ,"BIRDATE&

12、quot; DATE NOT NULL ,"CNUM" NUMBER(10) NOT NULL ,"DEMO" VARCHAR2(100),PRIMARY KEY ("PROID", "CDATE") VALIDATE("PROFOREIGN KEY ("PROID") REFERENCES"SYS"."PRO" ID") VALIDATE )TABLESPACE"USERS"( 5)管理規(guī)則 PRO_LIMCREA

13、TE TABLE "USERS"."PRO_LIM" ("PROID" NUMBER(11) NOT NULL , "MINUM"NUMBER(10)NOT NULL , "MAXUM" NUMBER(10) NOT NULL , "LBIRDATE" NUMBER(5) NOT NULL , "DEMO" VARCHAR2(100),PRIMARY KEY ("PROID") VALIDATE ,FOREIGN KEY ("

14、PROID") REFERENCES"SYS"."PRO" ("PROID")VALIDATE )TABLESPACE"USERS"( 6)管理員表 ADMINCREATE TABLE "USERS"."ADMIN" ("ID" NUMBER(11) NOT NULL , "USERNAME" VARCHAR2(10) NOT NULL ,"PASSWORD"VARCHAR2(11) NOT NULL ,

15、PRIMARY KEY ("ID") VALIDATE ) TABLESPACE"USERS"2、序列的創(chuàng)建CREATE SEQUENCEC_R_VIEW NOCYCLENOORDERNOCACH NOMAXVALUEMINVALUE 100 INCREMENTBY 1 START WITH 1003、視圖的創(chuàng)建1) 產(chǎn)品的出入庫(kù)情況 C_R_PRO_VIEWCREATE OR REPLACE VIEW C_R_PRO_VIEWASSELECTCPROID,RPROID,PRONAME,RDATE,CDATE,CBIRDATE,RBIRDATE,CNUM

16、,RNUM FROM PRO,(SELECTC_PRO.PROIDAS CPROID,R_PRO.PROID AS RPROID,RDATE,CDATE,C _PRO.BIRDATE AS CBIRDATE,R_PRO.BIRDATE AS RB IRDATE,CNUM,RNUMFROM C_PRO FULL JOIN R_PRO O N C_PRO.PROID=R_PRO.PROtDid CDATE二RDATE3RDER BY RP ROID) R_C WHEREPRO.PROID二CPROItAND PRO.PROID二RPROID:A-丸二-> 靈！B SYSJC L PM UU&

17、#39;Hir R PRn IFWc_R_mo3TTi,方強(qiáng)illfl1 b fPROnr廣gPWXTT'.,T?DiTT"，弋THTI 'T't'TUKTHTT” ,-K WRT>M Af/'ItVI'W瞞 VALID亙睥農(nóng) SELECT CPEOID. FPPOID. TPOflAFE. IMTErCIATT. CBIiEfTE, RHPDATT-CNVH, IWJH FltCH PRO*SELEGTC EP.Q 耶。二口 AJ= C FROZE ?RCa F5CLTI ASf RTIATE, CLA.TE. r C rHd

18、.BXRZUkxZ. Q2) 產(chǎn)品總數(shù)量：SNUMCREATE OR REPLACE VIEW SNUMASSELECT PRO.PROID,SUM(ZNUM$NUM FROM PRO,PRO_MAN WHERE PRO.PROID=PRO_MAN.PROGDROUP BY PRO.PROID3）產(chǎn)品的庫(kù)存信息：ZNUM_PRO_VIEWCREATE OR REPLACE VIEW ZNUM_PRO_VIEWASSELECT PRO_MAN.PROID,PRONAME,BIRDATE,BDATE,ZFROMI PRO,PRO_MAN WHER PRO.PROID二PRO_MAN.PROID-般

19、鋁怠方夷SYS別茗 HPRO.PROU>H, bPROStE - ”"EIRDATE", BIMTI "；bZS 狀態(tài)VALID査;Bl士左 ££L±CTH rnOlD rhOilAKE F CtRCATE DEATE> ZbTJH FStOMPRO, PRC vah /HERE PRO. PROII>FR0 MAfJ. PHOID4、PL/SQL程序設(shè)計(jì)(1)倉(cāng)庫(kù)產(chǎn)品少于最少數(shù)量或者大于最大數(shù)量時(shí)顯示出產(chǎn)品數(shù)量、生產(chǎn)日期保質(zhì)期來(lái)：CREATE OR REPLACE FUNCTION MIN_MAX_NUM_SHQW

20、V_PROID NUMBER,V_BIRDATOUT DATE,V_BDATEOUT NUMBER) RETURN NUMBERASV_SNUM NUMBER;V_MINUINUMBER;V_MAXUNUMBER;BEGINSELECT SUM(ZNUM) INTO V_SNUM FROM PRO_MANWHEREPROID=V_PROID;SELECT MINUM,MAXUMNTO V_MINUM,V_MAXUMROM PRO_LIM WHEREPROID二V_PROID;SELECT BIRDATE INTO V_BIRDATE FROM PRO_MANWHEREPROID二V_PROID

21、;SELECT BDATE INTO V_BDATE FROM PRO WHEREPROID=V_ PROID;IF V_SNUM-V_MINUM<=O R V_SNUM-V_MAXUM>THENRETURN V_SNUM;END IF;END;Ct）更新稍息已佩江邙奮謹(jǐn)iljji SY s PRO F"V_ROID SIUMBERrV_BIREA_TE OCT DATEMTTTTOr mMBERVDAYS NUMEE R;IRDh TE TIMBER fBEGlS5F1XZI zlkZATE IKTC V_32ELul：z fROH PRO_WiN WFFRT PRQI

22、 DV_ERCZD； rELE-7 二 7 二：l 二 r-7FJ：i_ i 1S1JCL I：iZ 2 - Z7.T5 匸；工PRO MAN UHESE PROIlWr PROIDjSELECT LBIUDWE INTO V LBIELDATE FROM PRO_LIMMOM P®OID-V_PRO1D：-IF V_DAVS>-V_£b1RBAIE TH£NKETURH V ma'S SE2TD IF?(2)計(jì)算距保質(zhì)期時(shí)間：CREATE OR REPLACE PROCEDURPRO_B(V_PROID NUMBER)ASV_DA YS NUMBE

23、R;V_LBIRDATE NUMBER;CURSORC_BIRDATE IS SELECT BIRDATE FROMPRO_MANWHEREPROID二V_PROID;BEGINSELECT LBIRDATE INTO V_LBIRDATE FROM PRO_LIMWHEREPROID=V_PROID;FOR V_BIRDATE IN C_BIRDATE LOOPIF V_DA YS:=(S YSDATE-V_BIRDATE)>=V_LBIRDATE THENDBMS_OUTPUT.PUTLINE(V_DA YS);END IF;END LOOP;END. V BJKWrE OTT DU

24、E)NTbDElL；BEGT1B“廠廠-w = IZ - TZ- ZZ-T- Z Z； ' - T -SELECTunc魚(yú)3 廠SriECT FRD MU.PRC KW/BIBC&rE CEIREftIT,OTOK, DP3M FSONJFK,PBC_>O|J-Pni3I>wR?.C.PaCZB JlKD. KMtTE-C_PHQ.SITaiUTElrHClE-V_Fl1iiulEi_C. LEIRmiE- 上丄事匚盟巴；RZTOltH VCZSfiTHFBTf(4) 計(jì)算入庫(kù)后數(shù)量：CREATE OR REPLACE FUNCTION A_R_NUM(V_PROI

25、D NUMBER,V_BIRDATEOUT DATE) RETURN NUMBR ASV_RZNUMNUMBER;BEGINSELECT BIRDATE INTO V_BIRDATE FROM R_PRO WHEREP ROID=V_PROID;SELECT ZNUM+RNUMINTO V_RZNUMFROM (SELECT PRO_MAN.PROID,PRO_MAN.BIRDATERBIRDATE,RNUM,ZNUM FROM R_PRO,PRO_MANWHEREPRO_MAN.PROID=R_PRO.PROAIDND PRO_MAN.BIRDATE=R_PRO .BIRDATE) A_RW

26、HEREPROID=V_PROIDAND A_R.RBIRDATE=V_BIRDATE;RETURN V_RZNUM;END;G更新消息VLHDiD KUffinvjnauE an dktoWTCRJT WJMBERA5V_R2HTH SKMBEJ;tEGXlt5EUCI BIRQUZ IHTD Y BIRKII FEm BFRO WH£RE Pftai>V_PftDID? SELICT ZWM+RBUF INTOP RDTCM FROM C5EL1CT FRO HAS.¥RCIE, PPO K3JT, STR DATE RBTKiArE, KTOMr ZWW FHO

27、KR. PfiO.FKi 與N WHEREPRC_Ma,PRCIOS_FRO.FRCIE MIE PRO_MAN.rBIPJATE瓦曲SB燉DAT& A S winrif f£oid*v_pr6id and a_r .m i rdate-v_bi imiE ； RETCKK VRINUWiIHH; _附Java源代碼：package倉(cāng)庫(kù)管理;import java.awt.BorderLayout;import java.awt.EventQueue;import javax.swing.JFrame;import javax.swing.JPanel;import java

28、x.swing.border.EmptyBorder;import javax.swing.JButton;public class jiemian2 extends JFrame private JPanel contentPane;public JPanel getContentPane() return contentPane;/* Launch the application.*/public static void main(String args) EventQueue.invokeLater(new Runnable() public void run() try jiemian

29、2 frame = new jiemian2(); frame.setVisible(true); catch (Exception e) e.printStackTrace(););* Create the frame.*/public jiemian2() setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setBounds(100, 100, 450, 300);contentPane = new JPanel();contentPane.setBorder(new EmptyBorder(5, 5, 5,5);setContentPane(

30、contentPane);contentPane.setLayout(null);package 倉(cāng)庫(kù)管理 ;import java.awt.BorderLayout;import java.awt.CardLayout;import java.awt.EventQueue;import javax.swing.JFrame;import javax.swing.JMenuItem;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.border.EmptyBorder;import javax

31、.swing.JTextField;import javax.swing.JLabel;import java.awt.Font;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JButton;implementspublic class jiemian1 extends JFrameActionListenerprivate JPanel contentPane;jiemian jm;CardLayout cl;JPanel jp;jiemian2 jm2;JP

32、anel jp2;private static double chushi,up,down;public JPanel getContentPane() return contentPane;public void setContentPane(JPanel contentPane) this.contentPane = contentPane;private JTextField text1;private JLabel label_1;private JLabel label_2;private JTextField text2;private JTextField text3;priva

33、te JButton jb1;private JButton jb2;/* Launch the application.*/*精品資料推薦* Create the frame.*/public jiemian1() jp=jiemian.getJp(); cl=jiemian.getCl();setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setBounds(100, 100, 450, 300);contentPane = new JPanel(); contentPane.setBorder(new EmptyBorder(5, 5, 5,

34、 5);setContentPane(contentPane); contentPane.setLayout(null);text1 = new JTextField(); text1.setBounds(193, 22, 192, 29); contentPane.add(text1);text1.setColumns(10);newJLabel labelJLabel("u5E93u5B58u521Du59CBu5316u503CuFF1A"); label.setFont(new Font("微軟雅黑 ", Font.PLAIN,16); labe

35、l.setBounds(46, 21, 113, 29); contentPane.add(label);label_1 = newJLabel("u4E0Au8B66u6212u7EBFuFF1A");label_1.setFont(new Font(" 微軟雅黑 ", Font.PLAIN, 16);label_1.setBounds(79, 70, 80, 29);contentPane.add(label_1);label_2 = newJLabel("u4E0Bu8B66u6212u7EBFuFF1A");label_2.s

36、etFont(new Font(" 微軟雅黑 ", Font.PLAIN, 16);label_2.setBounds(79, 125, 80, 29);contentPane.add(label_2);text2 = new JTextField();text2.setColumns(10);text2.setBounds(193, 75, 192, 29); contentPane.add(text2);text3 = new JTextField();text3.setColumns(10);text3.setBounds(193, 130, 192, 29);con

37、tentPane.add(text3);jb1 = new JButton("u786Eu5B9A");Font.PLAIN,Font.PLAIN,jb1.setFont(new Font(" 華 文 琥 珀 " 16);jb1.setBounds(76, 194, 122, 39);contentPane.add(jb1);jb2 = new JButton("u8FD4u56DE");jb2.setFont(new Font(" 華 文 琥 珀 " 16);jb2.setBounds(262, 194, 122

38、, 39); contentPane.add(jb2); jb1.addActionListener(this); jb2.addActionListener(this);jm2=new jiemian2();jp2=jm2.getContentPane();jp.add(jp2,"two");Overridepublic void actionPerformed(ActionEvent e) / TODO Auto-generated method stub if(e.getSource()=jb1)int i=0;trychushi=newDouble(text1.ge

39、tText().toString();up=new Double(text2.getText().toString(); down=new Double(text3.getText().toString(); jm.m1_mi1.setEnabled(true); jm.m1_mi2.setEnabled(true); jm.m2_mi1.setEnabled(true);jm.m2_mi2.setEnabled(true);jm.m2_mi3.setEnabled(true);jm.m3_mi1.setEnabled(true);jm.m3_mi2.setEnabled(true);初始化數(shù)

40、據(jù)JOptionPane.showMessageDialog(null, "成功！ ");catch(Exception e1)JOptionPane.showMessageDialog(null, "不能為空！ ");i=1;if(i!=1)cl.show(jp, "two");if(e.getSource()=jb2)cl.show(jp, "main");package 倉(cāng)庫(kù)管理 ;import java.awt.BorderLayout;import java.awt.CardLayout;import j

41、ava.awt.EventQueue;import javax.swing.JFrame;import javax.swing.JMenuItem;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.border.EmptyBorder;import javax.swing.JTextField;import javax.swing.JLabel;import java.awt.Font;import java.awt.event.ActionEvent;import java.awt.even

42、t.ActionListener;import javax.swing.JButton;implementspublic class jiemian1 extends JFrameActionListenerprivate JPanel contentPane; jiemian jm;CardLayout cl;JPanel jp;jiemian2 jm2;JPanel jp2;private static double chushi,up,down;public JPanel getContentPane() return contentPane;public void setContent

43、Pane(JPanel contentPane) this.contentPane = contentPane;private JTextField text1;private JLabel label_1;private JLabel label_2;private JTextField text2;private JTextField text3;private JButton jb1;private JButton jb2;/* * Launch the application.*/* Create the frame.*/public jiemian1() jp=jiemian.get

44、Jp(); cl=jiemian.getCl();setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setBounds(100, 100, 450, 300);contentPane = new JPanel(); contentPane.setBorder(new EmptyBorder(5, 5, 5, 5);setContentPane(contentPane); contentPane.setLayout(null);text1 = new JTextField();text1.setBounds(193, 22, 192, 29);con

45、tentPane.add(text1);text1.setColumns(10);JLabel label = new JLabel("u5E93u5B58u521Du59CBu5316u503CuFF1A" );label.setFont(new Font(" 微軟雅黑 ", Font.PLAIN, 16);label.setBounds(46, 21, 113, 29); contentPane.add(label);label_1 = newJLabel("u4E0Au8B66u6212u7EBFuFF1A");label_1.

46、setFont(new Font(" 微軟雅黑 ", Font.PLAIN, 16);label_1.setBounds(79, 70, 80, 29);contentPane.add(label_1);label_2 = newJLabel("u4E0Bu8B66u6212u7EBFuFF1A");Font.PLAIN,label_2.setFont(new Font(" 微軟雅黑 "16);label_2.setBounds(79, 125, 80, 29);contentPane.add(label_2);text2 = new

47、 JTextField(); text2.setColumns(10); text2.setBounds(193, 75, 192, 29); contentPane.add(text2);text3 = new JTextField(); text3.setColumns(10); text3.setBounds(193, 130, 192, 29); contentPane.add(text3);jb1 = new JButton("u786Eu5B9A");Font.PLAIN,Font.PLAIN,jb1.setFont(new Font(" 華 文 琥

48、珀 " 16);jb1.setBounds(76, 194, 122, 39); contentPane.add(jb1);jb2 = new JButton("u8FD4u56DE");jb2.setFont(new Font(" 華 文 琥 珀 "29精品資料推薦16);jb2.setBounds(262, 194, 122, 39);contentPane.add(jb2);jb1.addActionListener(this);jb2.addActionListener(this);jm2=new jiemian2();jp2=jm2.

49、getContentPane();jp.add(jp2,"two");Overridepublic void actionPerformed(ActionEvent e) / TODO Auto-generated method stub if(e.getSource()=jb1)int i=0;trychushi=newDouble(text1.getText().toString();up=new Double(text2.getText().toString(); down=new Double(text3.getText().toString(); jm.m1_mi

50、1.setEnabled(true); jm.m1_mi2.setEnabled(true); jm.m2_mi1.setEnabled(true); jm.m2_mi2.setEnabled(true);jm.m2_mi3.setEnabled(true);jm.m3_mi1.setEnabled(true);jm.m3_mi2.setEnabled(true);初始化數(shù)據(jù)JOptionPane.showMessageDialog(null, " 成功！ ");catch(Exception e1)JOptionPane.showMessageDialog(null, &

51、quot; 不能為空！ ");i=1;if(i!=1)cl.show(jp, "two");if(e.getSource()=jb2)cl.show(jp, "main");package 倉(cāng)庫(kù)管理 ;import java.awt.BorderLayout;import java.awt.CardLayout;import java.awt.EventQueue;import javax.swing.JFrame;import javax.swing.JOptionPane; import javax.swing.JPanel;import

52、javax.swing.border.EmptyBorder; import javax.swing.JLabel;import java.awt.Font;import javax.swing.JTextField; import javax.swing.JButton;implementsimport java.awt.event.ActionListener; import java.awt.event.ActionEvent;public class jiemian3 extends JFrame ActionListener private JPanel contentPane; p

53、rivate JTextField textField; private JTextField textField_1; private JTextField textField_2; private JTextField textField_3; jiemian jm;CardLayout cl;JPanel jp;private JButton jb1,jb2;/* Launch the application.*/*Create the frame.*/public jiemian3() setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); se

54、tBounds(100, 100, 450, 300);contentPane = new JPanel(); contentPane.setBorder(new EmptyBorder(5, 5, 5, 5);setContentPane(contentPane); contentPane.setLayout(null);JLabel label = new JLabel("u5165u5E93u4EA7u54C1u540Du79F0uFF1A" );label.setFont(new Font("黑體 ", Font.BOLD, 15);label.

55、setBounds(38, 19, 127, 28); contentPane.add(label);JLabel label_1 = new JLabel("u5165u5E93u4EA7u54C1u6570u91CFuFF1A" );label_1.setFont(newFont(" 黑 體 ", Font.BOLD,15);label_1.setBounds(38, 57, 127, 28); contentPane.add(label_1);JLabel label_2 = new JLabel("u5165u5E93u4EA7u54C

56、1u7F16u53F7uFF1A" );label_2.setFont(new Font(" 黑 體 ", Font.BOLD, 15);label_2.setBounds(38, 95, 114, 28); contentPane.add(label_2);JLabel label_3 = new JLabel("u5165u5E93u4EA7u54C1u4EF7u683CuFF1A" );label_3.setFont(new Font(" 黑 體 ", Font.BOLD, 15);label_3.setBounds(

57、38, 133, 114, 28); contentPane.add(label_3);textField = new JTextField(); textField.setFont(new Font(" 黑 體 ", Font.BOLD,35精品資料推薦43Font.BOLD,Font.BOLD,Font.BOLD,15);textField.setBounds(196, 22, 162, 21); contentPane.add(textField);textField.setColumns(10);textField_1 = new JTextField();text

58、Field_1.setFont(new Font(" 黑體 " 15);textField_1.setColumns(10);textField_1.setBounds(196, 60, 162, 21); contentPane.add(textField_1);textField_2 = new JTextField();textField_2.setFont(new Font(" 黑體 " 15);textField_2.setColumns(10);textField_2.setBounds(196, 98, 162, 21); contentPane.add(textField_2);textField_3