/*  * 創(chuàng)建者：張俊強  * 時間：2016/5/15  * */ package SaleSys;  import java.awt.*; import java.awt.event.*; import java.util.Vector;  import javax.swing.*;  import java.sql.*;  class Goods{  public String[] name;  public Float[] price;  Goods(){   name =new String[100];   price=new Float[100];  } } public class SuperMarket extends JFrame{  public static void main(String[] args) throws SQLException{   MainWinow mainWin=new MainWinow("網(wǎng)上超市購物結(jié)算");     mainWin.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);   mainWin.setBounds(300, 300, 500, 400);   mainWin.setVisible(true);   mainWin.setWin(mainWin);   mainWin.setMinWindowLayout();  } }  class MainWinow extends JFrame{  Goods goods;  private JButton user;  private JButton manager;  private JLabel loginLabel;  private ManageWindow magWin;  private UserWindow userWin;  private Listener lis;  private MainWinow loginWin;  private int goodsNum;  /*  * 設(shè)置界面  * */  private JLabel setNameLabel;  private JLabel setPriceLabel;  private JTextField setNameText;  private JTextField setPriceText;  private JButton inputBut;  private TextArea inputArea;  private JButton returnBut1;  private JButton cancelBut;  /*  * 用戶界面  * */  private Vector<String> buyItem;  private Float[] buyCount;  private int buyNum;  private JComboBox goodsCombox;  private JButton returnBut2;  private JLabel choiceGoodLabel;  private JLabel showPriceLabel;  private JTextField showPrice;  private TextArea showChoice;  private JLabel showBuyNum;  private JTextField showBuyNumText;  private JButton submitBuy;  private JButton deleteBuyBut;  private JList choiceList;  private JButton countBut;  private Float sumMoney;  /**   * 數(shù)據(jù)庫導入   */   Statement stmt;  MainWinow(String winName) throws SQLException{   super(winName);   goodsNum=0;   buyNum=0;   sumMoney=(float)0;   goods=new Goods();   user=new JButton("我是用戶");   manager=new JButton("我是管理員");   loginLabel=new JLabel("請選擇角色!");   magWin=new ManageWindow("設(shè)置商品");   magWin.setBounds(300, 300, 500, 400);   magWin.setDefaultCloseOperation(DO_NOTHING_ON_CLOSE);   userWin=new UserWindow("歡迎選購");   userWin.setBounds(300, 300, 500, 400);   userWin.setDefaultCloseOperation(DO_NOTHING_ON_CLOSE);   lis=new Listener();   /*   * 設(shè)置界面初始化   * */   setNameLabel=new JLabel("商品名:");   setPriceLabel=new JLabel("價格:");   setNameText=new JTextField(5);   setPriceText=new JTextField(5);   inputBut=new JButton("確認添加");   inputArea=new TextArea();   returnBut1=new JButton("返回");   cancelBut=new JButton("撤回添加");   /*   * 用戶界面初始化   * */   goodsCombox=new JComboBox();   returnBut2=new JButton("返回");   choiceGoodLabel=new JLabel("請選擇商品:");   showPriceLabel=new JLabel("價格");   showPrice=new JTextField(5);   showChoice=new TextArea();   showBuyNum=new JLabel("購買數(shù)量:");   showBuyNumText=new JTextField(5);   submitBuy=new JButton("確認購買");   deleteBuyBut=new JButton("刪除訂單");   countBut=new JButton("訂單結(jié)算");   choiceList=new JList();   buyItem=new Vector<String>();   buyCount=new Float[100];   /*    * 數(shù)據(jù)庫的導入    * */   try {    Class.forName("com.mysql.jdbc.Driver");   } catch (ClassNotFoundException e) {    // TODO Auto-generated catch block    e.printStackTrace();   }   String url= "jdbc:mysql://localhost:3306/device";   String user="root";   String password="zjq1314520";   Connection con=DriverManager.getConnection(url,user,password);   stmt = con.createStatement();   /*    * 數(shù)據(jù)庫數(shù)據(jù)的導出    * */   importSql();  }  public void importSql() throws SQLException {   int i=1;   // TODO Auto-generated method stub   ResultSet result=stmt.executeQuery(     "SELECT name,price FROM goods_info"     );   while(result.next()){    goods.name[i-1]=result.getString(1);    goods.price[i-1]=Float.parseFloat(result.getString(2));    i++;   }   goodsNum=i-1;  }  public void setWin(MainWinow w){   loginWin=w;  }  public void setMinWindowLayout(){   Container loginCon=new Container();   loginCon.setLayout(new FlowLayout());   loginCon.add(manager);   loginCon.add(user);      manager.addActionListener(lis);   user.addActionListener(lis);   this.setLayout(new BorderLayout());   this.add(loginLabel,BorderLayout.NORTH);   this.add(loginCon,BorderLayout.CENTER);   this.validate();   /*   * 設(shè)置界面布局   * */   magWin.setLayout(new FlowLayout());   magWin.add(setNameLabel);   magWin.add(setNameText);   magWin.add(setPriceLabel);   magWin.add(setPriceText);   magWin.add(inputBut);   magWin.add(inputArea);   magWin.add(cancelBut);   magWin.add(returnBut1);      inputBut.addActionListener(lis);   returnBut1.addActionListener(lis);   cancelBut.addActionListener(lis);   /*   * 用戶界面布局   * */   userWin.setLayout(new BorderLayout());   Container userCon=new Container();   userCon.setLayout(new FlowLayout());   userCon.add(choiceGoodLabel);   userCon.add(goodsCombox);   userCon.add(showPriceLabel);   userCon.add(showPrice);   userCon.add(showBuyNum);   userCon.add(showBuyNumText);   userCon.add(submitBuy);   userWin.add(userCon,BorderLayout.NORTH);   //choiceList.setListData(goods.name);   userWin.add(choiceList,BorderLayout.CENTER);   userWin.add(new JScrollPane(choiceList));      Container butCon=new Container();   butCon.setLayout(new FlowLayout());   butCon.add(deleteBuyBut);   butCon.add(countBut);   butCon.add(returnBut2);   userWin.add(butCon,BorderLayout.SOUTH);      goodsCombox.addItemListener(    new ItemListener(){    @Override     public void itemStateChanged(ItemEvent e) {     // TODO Auto-generated method stub     int i=goodsCombox.getSelectedIndex();     if(i>=0)showPrice.setText(goods.price[i].toString());    }   }   );   returnBut2.addActionListener(lis);   submitBuy.addActionListener(lis);   deleteBuyBut.addActionListener(lis);   countBut.addActionListener(lis);  }    private void addComboxItem() {   // TODO Auto-generated method stub   for(int i=0;i<goodsNum;i++){    goodsCombox.addItem(goods.name[i]);   }  }    class Listener implements ActionListener{   @Override    public void actionPerformed(ActionEvent e) {    // TODO Auto-generated method stub    if(e.getSource()==manager){     addGoods();     loginWin.setVisible(false);     magWin.setVisible(true);    }    if(e.getSource()==user){     loginWin.setVisible(false);     userWin.setVisible(true);     goodsCombox.removeAllItems();     addComboxItem();    }    if(e.getSource()==inputBut){     //String showOut="";          if(setNameText.getText().equals("")||setPriceText.getText().equals("")){      JOptionPane.showMessageDialog(magWin,"不可以有空余項!", "警告",JOptionPane.PLAIN_MESSAGE);     }     else{      goods.name[goodsNum]=setNameText.getText();      goods.price[goodsNum]=Float.parseFloat(setPriceText.getText());      try {       /*        * 寫進數(shù)據(jù)庫        * */       stmt.executeUpdate("insert into goods_info(name,price)values('"+goods.name[goodsNum]+"','"+(float)goods.price[goodsNum]+"')");      } catch (SQLException e1) {       // TODO Auto-generated catch block       e1.printStackTrace();      }      goodsNum++;      addGoods();      setNameText.setText("");      setPriceText.setText("");      //showOut="商品名:"+setNameText.getText()+"/t"+"價格:"+setPriceText.getText()+"/n";      //inputArea.append(showOut);     }    }    if(e.getSource()==cancelBut){     if(goodsNum>0){      goodsNum--;      String deleteName=goods.name[goodsNum];      String deletePrice=goods.price[goodsNum].toString();      //System.out.println(deleteName);      /*       * 刪除數(shù)據(jù)庫里面的元素       * */      String sql = "delete from goods_info where name = '"+deleteName+"' AND price ='"+deletePrice+"'";      try {       stmt.executeUpdate(sql);      } catch (SQLException e1) {       // TODO Auto-generated catch block       e1.printStackTrace();      }      //Connection con= DBManager .getConnection();;      //PreparedStatement ps = con.prepareStatement(sql);      addGoods();     }    }    if(e.getSource()==returnBut1){     loginWin.setVisible(true);     magWin.setVisible(false);    }    /*    * 用戶界面事件響應(yīng)    * */    if(e.getSource()==returnBut2){     loginWin.setVisible(true);     userWin.setVisible(false);    }    if(e.getSource()==submitBuy){      if(!showBuyNumText.getText().equals("")){       buyCount[goodsCombox.getSelectedIndex()]=Float.parseFloat(showBuyNumText.getText());      String contentItem="";      Float sumMon=Float.parseFloat(showBuyNumText.getText())*(Float)goods.price[goodsCombox.getSelectedIndex()];      contentItem="商品名："+goods.name[goodsCombox.getSelectedIndex()]+" "       +"單價："+goods.price[goodsCombox.getSelectedIndex()].toString()+" "       +"購買數(shù)量："+showBuyNumText.getText()+" "       +"總價："+sumMon.toString();      buyItem.addElement(contentItem);      //buyItem[buyNum]=contentItem;      buyNum++;      choiceList.removeAll();      choiceList.setListData(buyItem);      sumMoney+=sumMon;     }     else{      JOptionPane.showMessageDialog(magWin,"購買數(shù)量不可以為空", "警告",JOptionPane.PLAIN_MESSAGE);     }         }    if(e.getSource()==deleteBuyBut){     if(choiceList.getSelectedValue()==null){      JOptionPane.showMessageDialog(magWin,"未選擇待刪除的物品", "警告",JOptionPane.PLAIN_MESSAGE);         }     else if(buyNum>0){      int i=choiceList.getSelectedIndex();      String selectItem=buyItem.get(i);      //System.out.println(selectItem);      String deletePrice="";      for(int j=0;j<selectItem.length()-3;j++){      // System.out.println(selectItem.substring(j, j+3));       if(selectItem.substring(j, j+3).equals("總價：")){        deletePrice=selectItem.substring(j+3,selectItem.length());        System.out.println(deletePrice);        sumMoney-=Float.parseFloat(deletePrice);        break;       }      }      buyItem.remove(i);      choiceList.removeAll();      choiceList.setListData(buyItem);      choiceList.validate();      buyNum--;     }     else{      JOptionPane.showMessageDialog(magWin,"購物車為空,不可刪除", "警告",JOptionPane.PLAIN_MESSAGE);     }    }    if(e.getSource()==countBut){//sumMoney     for(int i=0;i<buyItem.size();i++){      String str=buyItem.get(i).substring(0, 2);      if(str.equals("總價")){       buyItem.remove(i);      }     }     buyItem.addElement("總價："+sumMoney.toString());     choiceList.removeAll();     choiceList.setListData(buyItem);     choiceList.validate();    }   }      private void addGoods() {    if(!inputArea.getText().equals(""))inputArea.setText("");    // TODO Auto-generated method stub    for(int i=0;i<goodsNum;i++){     String massage="商品名:"+goods.name[i]+"/t"+"價格:"+goods.price[i].toString()+"/n";     inputArea.append(massage);    }   }  } } class ManageWindow extends JFrame {  ManageWindow(String title){   super(title);  } } class UserWindow extends JFrame{  UserWindow(String title){   super(title);  } }