String sql = "";
    Link lk = new Link();
    lk.connection();
    sql = "select * from jinhuo where times like '" + yr + "-" + mn + "%'";
    ResultSet rs = lk.Select(sql);
    tblinto.updateUI();
    try {
      if (rs.next()) {

        do {
          Vector v = new Vector();
          v.removeAllElements();
          v.add(rs.getString(1).trim()); //進貨類別
          v.add(rs.getString(2).trim()); //貨物名
          v.add(rs.getString(3).trim()); //進貨量
          v.add(rs.getString(4).trim()); //進貨時間
          vc.add(v);
        }
        while (rs.next());
        tblinto.updateUI();
      }
      else {
        JOptionPane.showMessageDialog(null, "沒有記錄");
      }
    }
    catch (SQLException ex) {
    }
    lk.close();
  }

  public void btncls_actionPerformed(ActionEvent e) {
    if (vc.size() == 0) {
      return;
    }
    if (JOptionPane.showConfirmDialog(null, "確認清空？", "提示",
                                      JOptionPane.YES_NO_OPTION) == 0) {
      vc.removeAllElements(); //清空表中數據
      tblinto.updateUI();
    }
  }

  public void btnall_actionPerformed(ActionEvent e) { //顯示全部
    vc.removeAllElements();

    String sql = "";
    Link lk = new Link();
    lk.connection();
    sql = "select * from jinhuo";
    ResultSet rs = lk.Select(sql);
    tblinto.updateUI();
    try {
      if (rs.next()) {

        do {
          Vector v = new Vector();
          v.removeAllElements();
          v.add(rs.getString(1).trim()); //進貨類別
          v.add(rs.getString(2).trim()); //貨物名
          v.add(rs.getString(3).trim()); //進貨量
          v.add(rs.getString(4).trim()); //進貨時間
          vc.add(v);
        }
        while (rs.next());
        tblinto.updateUI();
      }
      else {
        JOptionPane.showMessageDialog(null, "沒有記錄");
      }
    }
    catch (SQLException ex) {
    }
    lk.close();
  }

  public void btnyingye_actionPerformed(ActionEvent e) { //彈出統計框
    Taking tk = new Taking();
    tk.setSize(300, 250);
    tk.setLocation(300, 250);
    tk.show();
  }

  public void jMenuItem6_actionPerformed(ActionEvent e) {
Deluser dr=new Deluser();
    dr.setLocation(300,250);
    dr.setSize(360,290);
    dr.show();
  }
}

class MainFrm_jMenuItem6_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_jMenuItem6_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem6_actionPerformed(e);
  }
}

class MainFrm_btnyingye_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btnyingye_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnyingye_actionPerformed(e);
  }
}

class MainFrm_btnall_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btnall_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnall_actionPerformed(e);
  }
}

class MainFrm_btncls_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btncls_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

    adaptee.btncls_actionPerformed(e);
  }
}

class MainFrm_btninto_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btninto_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

    adaptee.btninto_actionPerformed(e);
  }
}

class MainFrm_btncl_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btncl_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btncl_actionPerformed(e);
  }
}

class MainFrm_btnjinhuo_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btnjinhuo_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnjinhuo_actionPerformed(e);
  }
}

class MainFrm_btnquan_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btnquan_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnquan_actionPerformed(e);
  }
}

class MainFrm_treeIn_treeSelectionAdapter
    implements TreeSelectionListener {
  private MainFrm adaptee;
  MainFrm_treeIn_treeSelectionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void valueChanged(TreeSelectionEvent e) {

    adaptee.treeIn_valueChanged(e);
  }
}

class MainFrm_btndate_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btndate_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

    adaptee.btndate_actionPerformed(e);
  }
}

class MainFrm_jMenuItem11_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_jMenuItem11_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem11_actionPerformed(e);
  }
}

class MainFrm_jMenuItem9_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_jMenuItem9_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem9_actionPerformed(e);
  }
}

class MainFrm_jMenuItem4_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_jMenuItem4_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem4_actionPerformed(e);
  }
}

class MainFrm_chbvip_mouseAdapter
    extends MouseAdapter {
  private MainFrm adaptee;
  MainFrm_chbvip_mouseAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseClicked(MouseEvent e) {

    adaptee.chbvip_mouseClicked(e);
  }
}

class MainFrm_jMenuItem2_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_jMenuItem2_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem2_actionPerformed(e);
  }
}

class MainFrm_jMenuItem1_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_jMenuItem1_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

    adaptee.jMenuItem1_actionPerformed(e);
  }
}

class MainFrm_jMenuItem3_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_jMenuItem3_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem3_actionPerformed(e);
  }
}

class MainFrm_txtnumber_keyAdapter
    extends KeyAdapter {
  private MainFrm adaptee;
  MainFrm_txtnumber_keyAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtnumber_keyPressed(e);
  }
}

class MainFrm_btnsell_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btnsell_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

    adaptee.btnsell_actionPerformed(e);
  }
}

class MainFrm_btncan_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btncan_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

    adaptee.btncan_actionPerformed(e);
  }
}

class MainFrm_jButton1_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_jButton1_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class MainFrm_txtspname_keyAdapter
    extends KeyAdapter {
  private MainFrm adaptee;
  MainFrm_txtspname_keyAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtspname_keyPressed(e);
  }
}

class MainFrm_btntianjia_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btntianjia_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

    adaptee.btntianjia_actionPerformed(e);
  }
}

class MainFrm_txtname_keyAdapter
    extends KeyAdapter {
  private MainFrm adaptee;
  MainFrm_txtname_keyAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtname_keyPressed(e);
  }
}

class MainFrm_jButton2_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_jButton2_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class MainFrm_btnkong_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btnkong_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnkong_actionPerformed(e);
  }
}

class MainFrm_btnhuiyuan_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btnhuiyuan_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnhuiyuan_actionPerformed(e);
  }
}

class MainFrm_btnguanyu_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btnguanyu_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnguanyu_actionPerformed(e);
  }
}

class MainFrm_btnshangpin_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btnshangpin_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnshangpin_actionPerformed(e);
  }
}

class MainFrm_btnexit_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_btnexit_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnexit_actionPerformed(e);
  }
}