●●●●●●●●●●●●●●●●●●MySQL是一款非常適合于中小型應用的數(shù)據(jù)庫軟件，且價格適宜。大大降低了中（9）選擇“銷售查詢”節(jié)點，便可以進入如圖1-10所示界面，在該界面可以對銷售信息進行查詢。表1-1客戶基本信息表（Customer）表1-3供貨商基本信息表（Feeder）表1-7其它庫存變動信息表（OtherStock）{}publicvoidactionPerfo{}4.業(yè)務方法都封裝為特定的類，這些類在第三部的UI類中的事件響應代碼中完成對數(shù)●●●●●}publicvoiddeleteProduct(){}{}publicvoidactionPe}}publicvoidactionPerfu}}}}publicvoidactionPerformed(ActionEvent}publicvoidactionPerformed(ActionEvent}publicvoidactionPerformed(ActionEventpublicclassDataBase{Connectioncon=null;//聲明Connection引用Statementstat;ResultSetrs;intcount;publicDataBase(){try{//加載MySQL的驅動類，并創(chuàng)建數(shù)據(jù)庫連接Class.forName("org.gjt.mm.mysql.Driver");con=DriverManager.getConnection("jdbc:mysql://:3306/test","root","123456");stat=con.createStatement();//創(chuàng)建Statement對象}catch(Exceptione){e.printStackTrace();}}publicclassProductextendsJPanelimplementsActionListener{privateJSplitPanejsp=newJSplitPane(JSplitPane.VERTICAL_SPLIT);//設置本面板為網(wǎng)格布局privateJPaneljpt=newJPanel();String[]str1=newString[8];Stringsql;//聲明sql字符串DataBasedb;privateJLabel[]jlArray={//創(chuàng)建標簽newJLabel("商品ID"),newJLabel("商品名稱"),newJLabel("商品規(guī)格"),newJLabel("計量單位"),newJLabel("參考進價"),newJLabel("參考售價"),newJLabel("庫存下限"),newJLabel("庫存上限"),newJLabel("商品資料"),privateJTextField[]jtxtArray=newJTextField[]{//創(chuàng)建文本框privateutton[]Array={//創(chuàng)建utton按鈕并設置其文本容Vector<String>head=newVector<String>();//創(chuàng)建標題}publicProduct(){jlArray[8].setBounds(5,5,100,20);//設置貨品資料標簽的大小位置for(inti=0;i<8;i++){jpt.add(jlArray[i]);jpt.add(jtxtArray[i]);if(i<4){//設置第一行標簽和文本框的大小位置jlArray[i].setBounds(15+i*200,40,80,20);jtxtArray[i].setBounds(95+i*200,40,120,20);jtxtArray[i].addActionListener(this);//為文本框注冊事件監(jiān)聽器}publicvoidactionPerformed(ActionEvente){}publicvoid}publicvoid}publicvoid}publicvoid}insertProduct(){deleteProduct(){}updateProduct(){searchProduct(){}publicstaticvoidmain(String[]args){newProduct();}}5.3節(jié)進行了商品資料模塊的開發(fā)，這publicclassCustomerextendsJPanelimplementsActionListener{privateJSplitPanejsp=newJSplitPane(JSplitPane.VERTICAL_SPLIT);privateJPaneljpt=newJPanel();String[]str1=newString[6];DataBasedb;Stringsql;privateJLabel[]jlArray={newJLabel("客戶資料"),newJLabel("客戶ID"),newJLabel("客戶名"),newJLabel("客戶地址"),newJLabel("聯(lián)系人"),newJLabel("聯(lián)系"),newJLabel("備注信息")privateutton[]Array={newutton("添加客戶"),newutton("刪除客戶"),newutton("修改客戶"),newutton("查詢客戶")//創(chuàng)建標題javac-java-publicclassFeederextendsJPanelimplementsActionListener//申明和創(chuàng)建累成員變量代碼省去publicvoidactionPerformed(ActionEvente)//實現(xiàn)actionPerformed方法publicvoidinsertFeeder//插入操作代碼省略publicvoiddeleteFeeder()//刪除操作代碼省略publicvoidupdateFeeder()//更新操作代碼省略publicvoidselectFeeder()//查詢操作代碼省略publicstaticvoidmain(String[]args)newFeeder();}javac-java-publicclassStockextendsJPanelimplementsActionListener{privateJSplitPanejsp=newJSplitPane(JSplitPane.VERTICAL_SPLIT);//分割方向為上下privateJPaneljpt=newJPanel();//聲明面板String[]str1=newString[10];DataBasedb;Stringsql;//聲明sql變量privateJLabel[]jlArray={//聲明標簽并創(chuàng)建其文本newJLabel("入庫單號"),newJLabel("供應商名"),newJLabel("貨品規(guī)格"),newJLabel("計量單位"),newJLabel("入庫數(shù)量"),newJLabel("入庫單價"),newJLabel("金額"),newJLabel("入庫日期")privateJLabeljl=newJLabel("入庫信息");//聲明標簽privateJTextField[]jtxtArray=newJTextField[]newJTextField(),newJTextField(),newJTextField(),newJTextField(),newJTextField(),newJTextField(),newJTextField(),newJTextField(),newJTextField(),newJTextField()}publicvoidactionPerformed(ActionEvente){if(e.getSource()==jtxtArray[0]){//事件源為"入庫單號"文本框"供貨商名"文本框將獲得鼠標焦點jtxtArray[1].requestFocus();}if(e.getSource()==Array[0]){//當點擊"添加此商品入庫"按鈕是將執(zhí)行添加功能this.insertStock();}JOptionPane.showMessageDialog(this,"請輸入新貨物信息?。?,"提示",JOptionPane.INFORMATION_MESSAG;//提示輸入新信息return;}}javac-d.Stock.javajava-classpathc:\jdbc\mysql-connector-java-5.1.17-bin.jar;c:\chap06wyf.hxl.publicclassStockStatisticextendsJPanelimplementsActionListener{privateJSplitPanejsp=newJSplitPane(JSplitPane.VERTICAL_SPLIT);//設置分割方向privateJPaneljpt=newJPanel();DataBasedb;privateJLabel[]jlArray={//設置標簽newJLabel("庫存查詢"),newJLabel("查詢結果")privateJTextFieldjtxt=newJTextField();privateutton[]Array={//設置utton按鈕的文本newutton("查詢"),newutton("短線商品"),newutton("超限商品")privateJRadioButton[]jrb={newJRadioButton("商品名",true),newJRadioButton("全部庫存信息")};//設置單選按鈕privateButtonGroupbg=newButtonGroup();Vector<String>head=newVector<String>();head.add("入庫單ID");head.add("供貨商名稱");head.add("商品ID");head.add("商品名稱");head.add("商品規(guī)格");head.add("計量單位");head.add("入庫數(shù)量");head.add("入庫單價");head.add("金額");head.add("入庫日期");}}publicvoidtable(){try{Vector<Vector>v=newVector<Vector>();while(db.rs.next()){//得到結果集Vector<String>vtemp=newVector<String>();for(inti=0;i<10;i++){//對得到的信息進行轉碼Stringstr1=newString(db.rs.getString(i+1).getBytes("ISO-8859-1"),"gb2312");vtemp.add(str1);//將從結果集得到的信息添加到臨時數(shù)組}v.add(vtemp);//將臨時數(shù)組中的信息添加到表格}if(v.size()==0){//結果集為空的提示}//更新table}catch(Exceptionep){ep.printStackTrace();}//捕獲異常}javac-d.SearchStock.javajava-classpathc:\jdbc\mysql-connector-java-5.1.17-bin.jar;c:\chap06wyf.hxl.publicvoidactionPerformed(ActionEvente){//事件源為"銷售單號"文本框//事件源為"客戶名稱"文本框if(e.getSource()==jtxtArray[2]){//事件源為"商品ID"文本框jtxtArray[3].requestFocus();}if(e.getSource()==Array[0]){//當點擊"銷售此商品"按鈕將執(zhí)行添加功能this.insertSell();}if(e.getSource()==Array[1]){for(inti=0;i<10;i++){//清空文本框jtxtArray[i].setText("");}JOptionPane.showMessageDialog(this,"請輸入新貨物信息?。?,"提示",JOptionPane.INFORMATION_MESSAG;//提示輸入新貨物return;}}publicvoidinsertSell(){for(inti=0;i<10;i++){//得到文本框所輸入信息str1[i]=jtxtArray[i].getText().trim();}else{//結果集為空提示JOptionPane.showMessageDialog(this,"該貨物缺貨?。?,"提示",JOptionPane.INFORMATION_MESSAG;return;}}else{//操作錯誤提示JOptionPane.showMessageDialog(this,"該貨物缺貨??！","提示",JOptionPane.INFORMATION_MESSAG;return;}}catch(Exceptione){e.printStackTrace();}//捕獲異常}javac-d.Sell.javajava-classpathc:\jdbc\mysql-connector-java-5.1.17-bin.jar;c:\chap06wyf.hxl.5.8節(jié)實現(xiàn)了銷售信息添加功能的開發(fā)publicvoidactionPerformed(ActionEvente){if(e.getSource()==jrb[0]){//當選擇"銷售單號"單選按鈕，鼠標焦點到達相應文本框jtxtArray[0].requestFocus();}if(e.getSource()==jrb[1]){//當選擇"客戶"單選按鈕，鼠標焦點到達相應文本框jtxtArray[1].requestFocus();}if(e.getSource()==jrb[2]){//當選擇"銷售日期"單選按鈕，鼠標焦點到達相應文本框jtxtArray[2].requestFocus();}…//其余實現(xiàn)代碼略}publicvoidxianshi(){try{if(db.rs.next()){//獲得結果集Vector<String>v=newVector<String>();JOptionPane.showMessageDialog(this,"您已經(jīng)成功查詢該商品銷售信息！！","提示",JOptionPane.INFORMATION_MESSAG;//查詢成功提示for(inti=0;i<4;i++){//清空文本框jtxtArray[i].setText("");}return;}else{//查詢失敗提示JOptionPane.showMessageDialog(this,"您所查詢的商品銷售信息不存在！！","提示",JOptionPane.INFORMATION_MESSAG;return;}}catch(Exceptionep){ep.printStackTrace();}//捕獲異常}javac-d.SearchSell.javajava-classpathc:\jdbc\mysql-connector-java-5.1.17-bin.jar;c:\chap06wyf.hxl.publicclassOtherStorageextendsJPanelimplementsActionListener{DataBasedb;Stringsql;//聲明sql變量privateJLabel[]jlArray={//聲明標簽，并為其指定文本newJLabel("對方名稱"),newJLabel("對方ID"),newJLabel("變動日期"),newJLabel("貨品名稱"),newJLabel("變動名稱"),newJLabel("變動數(shù)量"),newJLabel("庫存變動信息")publicvoidactionPerformed(ActionEvente){if(e.getSource()==jtxtArray[0]){//事件源為"對方名稱"文本框鼠標焦點將跳轉到"對方ID"文本框jtxtArray[1].requestFocus();}if(e.getSource()==jtxtArray[1]){//事件源為"對方ID"文本框鼠標焦點將跳轉到"變動日期"文本框jtxtArray[2].requestFocus();}if(e.getSource()==jtxtArray[2]){//事件源為"變動日期"文本框鼠標焦點將跳轉到"貨品名稱"文本框jtxtArray[3].requestFocus();}…//其余構造代碼省略}}javac-d.OtherStorage.javajava-classpathc:\jdbc\mysql-connector-java-5.1.17-bin.publicvoidactionPerformed(ActionEvente){if(e.getSource()==jrb[0]){//文本框將得到鼠標焦點jtxt.requestFocus();}if(e.getSource()==Array[0]){//當點擊"查詢"按鈕將執(zhí)行查詢功能this.searchProduct();for(inti=0;i<3;i++){str1[i]=jtxtArray[i].getText().trim();}}if(e.getSource()==Array[1]){//當點擊"短線商品"按鈕將執(zhí)行查詢短線商品this.littleProduct();}if(e.getSource()==Array[2]){//當點擊"超限商品"按鈕將執(zhí)行查詢超限商品this.manyProduct();}}…//其余實現(xiàn)代碼省略publicvoidinsertManager(){if((jtxtArray[0]!=null)&&(jtxtArray[1]!=null)&&(jtxtArray[2]!=null)){…//實現(xiàn)代碼省略}data.add(v);//更新tabledtm.setDataVector(data,head);jt.updateUI();jt.repaint();return;}{JOptionPane.showMessageDialog(this,"商品信息不能為空?。?！","消息",JOptionPane.INFORMATION_MESSAG;return;}}javac-d.StockStatistic.javajava-classpathc:\jdbc\mysql-connector-java-5.1.17-bin.jar;c:\chap06wyf.hxl.publicvoidactionPerformed(ActionEvente){sql="selectpermittedfrommanagerwheremgNo='"+mgNo+"'";db=newDataBase();db.selectDb(sql);Stringstring="";{while(db.rs.next()){}string=db.rs.getString(1).trim();…//其余代碼省略if(e.getSource()==jrb[0]){//文本框將得到鼠標焦點jtxt.requestFocus();}if(e.getSource()==Array[0]){//當點擊"查詢"按鈕將執(zhí)行查詢功能this.searchProduct();}catch(Exceptionex){ex.printStackTrace();}//關閉數(shù)據(jù)庫db.dbClose();publicvoidinsertManager(){if((jtxtArray[0]!=null)&&(jtxtArray[1]!=null)&&(jtxtArray[2]!=null)){for(inti=0;i<3;i++){str1[i]=jtxtArray[i].getText().trim();}sql="insertintomanager(mgNo,Permitted,password)values('"+str1[0]+"','"+str1[1]+"','"+str1[2]+"')";db=newDataBase();db.updateDb(sql);Vector<String>v=newVector<String>();…//其余代碼略{JOptionPane.showMessageDialog(this,"商品信息不能為空?。。?,"消息",JOptionPane.INFORMATION_MESSAG;return;}}javac-d.NewMangager.javajava-classpathc:\jdbc\mysql-connector-java-5.1.17-bin.jar;c:\chap06wyf.hxl.publicclassRootextendsJFrame{for(inti=0;i<3;i++){str1[i]=jtxtArray[i].getText().trim();}DefaultMutableTreeNode[]dmtn={//創(chuàng)建節(jié)點數(shù)組newDefaultMutableTreeNode(newNodeValue("勁輝物流商品流通系統(tǒng)")),newDefaultMutableTreeNode(newNodeValue("基本信息")),newDefaultMutableTreeNode(newNodeValue("業(yè)務處理")),newDefaultMutableTreeNode(newNodeValue("業(yè)務統(tǒng)計")),newDefaultMutableTreeNode(newNodeValue("系統(tǒng)維護")),DefaultMutableTreeNode(newNodeValue("入庫查詢")),newDefaultMutableTreeNode(newNodeValu