select.java~204~

基于java+sql2000超市货品进销存管理

package supermarket;
import DB.*;
import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.*;
import javax.swing.JToolBar;
import javax.swing.JButton;
import javax.swing.JTable;
import javax.swing.JTextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import javax.swing.JComboBox;
import javax.swing.JOptionPane;
import java.util.Vector;
import javax.swing.JScrollPane;
import java.sql.ResultSet;
import java.sql.*;
import javax.swing.JDialog;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;
import javax.swing.JPanel;
import javax.swing.*;

public class Select
    extends JDialog {
 // MainFrm mf;//用于跟新树
  JLabel lblguangli = new JLabel();
  Vector vt = new Vector();
  String head[] = {
      "商品编号", "类别", "商品名", "商品价格/元", "库存量", "单位", "折扣率", "备注"};
  TableModle dm = new TableModle(head, vt);
  JTable tbljieguo = new JTable(dm);
  JLabel lblshangpin = new JLabel();
  JTextField txtshangpin = new JTextField();
  JButton btnchaxun = new JButton();
  JButton btngenxin = new JButton();
  JButton btntianjia = new JButton();
  JButton btnshanchu = new JButton();
  JComboBox cmbleibie = new JComboBox();
  JButton btntianjlb = new JButton();
  JButton btnfanhui = new JButton();
  JScrollPane jScrollPane1 = new JScrollPane();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  JPanel jPanel4 = new JPanel();
  MainFrm frm;
  public Select(MainFrm frm) {
    this.frm = frm;
   // this.mf=mf;//存MainFrm 对象MainFrm mf
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    lblguangli.setBackground(Color.white);
    lblguangli.setFont(new java.awt.Font("华文中宋", Font.PLAIN, 20));
    lblguangli.setText("商品管理");
    lblguangli.setBounds(new Rectangle(262, 0, 120, 29));
    this.getContentPane().setLayout(null);
    this.setSize(650, 500);
    this.setLocation(200, 100);
    this.getContentPane().setBackground(new Color(212, 208, 200));
    this.setForeground(Color.black);
    lblshangpin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblshangpin.setText("商品名");
    lblshangpin.setBounds(new Rectangle(34, 35, 77, 26));
    txtshangpin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtshangpin.setText("");
    txtshangpin.setBounds(new Rectangle(110, 33, 125, 30));
    txtshangpin.addKeyListener(new Select_txtshangpin_keyAdapter(this));
    btnchaxun.setBounds(new Rectangle(403, 33, 81, 30));
    btnchaxun.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnchaxun.setText("查询");
    btnchaxun.addActionListener(new Select_btnchaxun_actionAdapter(this));
    btngenxin.setBounds(new Rectangle(141, 388, 81, 30));
    btngenxin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btngenxin.setText("更改");
    btngenxin.addActionListener(new Select_btngenxin_actionAdapter(this));
    btntianjia.setBounds(new Rectangle(25, 388, 79, 30));
    btntianjia.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btntianjia.setText("添加");
    btntianjia.addActionListener(new Select_btntianjia_actionAdapter(this));
    btnshanchu.setBounds(new Rectangle(264, 388, 81, 30));
    btnshanchu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnshanchu.setText("删除");
    btnshanchu.addActionListener(new Select_btnshanchu_actionAdapter(this));
    cmbleibie.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    cmbleibie.setBounds(new Rectangle(258, 32, 112, 32));
    cmbleibie.addKeyListener(new Select_cmbleibie_keyAdapter(this));
    cmbleibie.addActionListener(new Select_cmbleibie_actionAdapter(this));
    btntianjlb.setBounds(new Rectangle(509, 33, 114, 30));
    btntianjlb.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btntianjlb.setText("添加类别");
    btntianjlb.addActionListener(new Select_btntianjlb_actionAdapter(this));
    btnfanhui.setBounds(new Rectangle(377, 388, 81, 30));
    btnfanhui.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnfanhui.setText("返回");
    this.setModal(true);
    this.setTitle("商品管理");
    btnfanhui.addActionListener(new Select_btnfanhui_actionAdapter(this));
    jScrollPane1.setBounds(new Rectangle(28, 136, 575, 230));
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(2, 1, 641, 472));
    jPanel1.setLayout(null);
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle(0, 24, 627, 47));
    jPanel2.setLayout(null);
    jPanel3.setBorder(BorderFactory.createEtchedBorder());
    jPanel3.setBounds(new Rectangle(0, 70, 627, 307));
    jPanel3.setLayout(null);
    jPanel4.setBorder(BorderFactory.createEtchedBorder());
    jPanel4.setBounds(new Rectangle(0, 375, 627, 55));
    jPanel4.setLayout(null);
  //  btngenxin.addActionListener(new Select_btngenxin_actionAdapter(this));
    this.getContentPane().add(txtshangpin);
    this.getContentPane().add(btngenxin);
    this.getContentPane().add(btntianjia);
    this.getContentPane().add(btnshanchu);
    this.getContentPane().add(cmbleibie);
    this.getContentPane().add(btntianjlb);
    this.getContentPane().add(btnchaxun);
    this.getContentPane().add(btnfanhui);
    this.getContentPane().add(jScrollPane1);
    this.getContentPane().add(lblguangli, null);
    this.getContentPane().add(lblshangpin);
    this.getContentPane().add(jPanel1);
    jPanel1.add(jPanel2);
    jPanel1.add(jPanel3);
    jPanel1.add(jPanel4);
    jScrollPane1.getViewport().add(tbljieguo);
    cmbleibie.addItem("商品类别");
    disleibei();
  }

  public void btngenxin_actionPerformed(ActionEvent e) { //修改
    int count = tbljieguo.getSelectedRow();
    Update obj = new Update();
    if (count >= 0) { //判断是否有列被选中,选中时,当点修改时则显示列中的值,便于修改
      obj.Update(vt, count);
      obj.setSize(400, 370); //弹出窗口大小
      obj.setLocation(300, 200); //弹出窗口位置
      obj.show();
      gengxin();
    //  gengxin();
    tbljieguo.updateUI();
   // this.dispose();
    }
    else {
      JOptionPane.showMessageDialog(null, "请先选择一件商品", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
    }
  }

  public void btnshanchu_actionPerformed(ActionEvent e) { //删除
    int count = tbljieguo.getSelectedRow();
    if (count < 0) {
      JOptionPane.showMessageDialog(null, "请选择一件商品", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    if (JOptionPane.showConfirmDialog(null, "确认删除?", "确认",
                                      JOptionPane.YES_NO_OPTION) == 0) {
      Vector tmpe = (Vector) vt.get(count);
      Link lk = new Link();
      lk.connection();
      String sql = "Delete from shopping where name='" + tmpe.get(2) + "'";
      int i = lk.Update(sql);
      if (i > 0) {
        tbljieguo.updateUI();
        JOptionPane.showMessageDialog(null, "删除成功!", "成功",
                                      JOptionPane.INFORMATION_MESSAGE);
        lk.close();
      }
      else{
        lk.close();
        return;
      }
      vt.remove(count);//删除表中的数据
    }
    tbljieguo.updateUI();
  }

  public void btntianjia_actionPerformed(ActionEvent e) { //添加商品
    goodsAdd obj = new goodsAdd(frm);
    obj.setSize(400, 360); //弹出窗口大小
    obj.setLocation(300, 200); //弹出窗口位置
    obj.show();
  }

  public void btnfanhui_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  public void btntianjlb_actionPerformed(ActionEvent e) { //添加商品类别
    kindsAdd obj = new kindsAdd(this);
    obj.setSize(400, 350); //弹出窗口大小
    obj.setLocation(300, 200); //弹出窗口位置
    obj.show();
   // mf.treeIn = new JTree(mf.tree());//重新、加载数
   // mf.treeIn.updateUI();//更新数
  }

public void gengxin(){
    //查询商品
  String name = txtshangpin.getText().trim();
  /*  if (name.equals("")) {
      JOptionPane.showMessageDialog(null, "请输入商品名！", "错误",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }*/
  Link lk = new Link();
  lk.connection();
  String sql = "";
  if (name.equals("") && cmbleibie.getSelectedItem().equals("商品类别")) { //模糊查询,返回所有行
    sql = "select * from shopping order by kindname";
  }
  else if (name.equals("") && !cmbleibie.getSelectedItem().equals("商品类别")) { //根据商品类别进行查询
    sql = "select * from shopping where kindname ='" +
        cmbleibie.getSelectedItem() + "'";
  }
  else if (!name.equals("") && cmbleibie.getSelectedItem().equals("商品类别")) { //根据商品名进行模糊查询
    sql = "select * from shopping where name like '%" + name + "%'";
  }
  else {
    sql = "select * from shopping where name like '%" + name +
        "%' and kindname='" + //根据商品名和商品类别进行查询
        cmbleibie.getSelectedItem() + "'";
  }
  ResultSet rs = lk.Select(sql);
  vt.removeAllElements(); //清理表里原有的数据

  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());  //单价
        v.add(rs.getString(5).trim()); //库存量
        v.add(rs.getString(6).trim()); //单位
        v.add(rs.getString(7).trim());//折扣率
        v.add(rs.getString(8).trim()); //备注
        vt.add(v); //添加数据
      }
      while (rs.next());
      tbljieguo.updateUI(); //更新表
    }
    else {
      JOptionPane.showMessageDialog(null, "没有该商品", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
    }
    rs.close();
    lk.close();
  }
  catch (SQLException ex) {
    }
}
  public void btnchaxun_actionPerformed(ActionEvent e) {

gengxin();
    //失败
    // JOptionPane.showMessageDialog(null,"查询失败，请核实后再查!","错误",JOptionPane.ERROR_MESSAGE);
  }

  public void disleibei() { //显示
    Link obj = new Link();
    obj.connection();
    String sql = "select kindsname from kinds";
    ResultSet rs = obj.Select(sql);
//    vt.removeAllElements();//清理表里原有的数据
//    Vector v=new Vector();
    cmbleibie.removeAllItems();
    cmbleibie.addItem("商品类别");
    try {
      while (rs.next()) {
        cmbleibie.addItem(rs.getString(1));
      }
      rs.close();
      obj.close();
    }
    catch (SQLException ex) {
//      JOptionPane.showMessageDialog(null,"Game Over");
    }
//  vt.add(v);//添加数据
//  tbljieguo.updateUI();//更新表
  }

  public void txtshangpin_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btnchaxun_actionPerformed(null);
    }
  }

  public void cmbleibie_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btnchaxun_actionPerformed(null);
    }
  }

}

class Select_cmbleibie_actionAdapter
    implements ActionListener {
  private Select adaptee;
  Select_cmbleibie_actionAdapter(Select adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

  }
}

class Select_cmbleibie_keyAdapter
    extends KeyAdapter {
  private Select adaptee;
  Select_cmbleibie_keyAdapter(Select adaptee) {
    this.adaptee = adaptee;
  }

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

class Select_btntianjlb_actionAdapter
    implements ActionListener {
  private Select adaptee;
  Select_btntianjlb_actionAdapter(Select adaptee) {
    this.adaptee = adaptee;
  }

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

class Select_btnfanhui_actionAdapter
    implements ActionListener {
  private Select adaptee;
  Select_btnfanhui_actionAdapter(Select adaptee) {
    this.adaptee = adaptee;
  }

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

class Select_btngenxin_actionAdapter
    implements ActionListener {
  private Select adaptee;
  Select_btngenxin_actionAdapter(Select adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

    adaptee.btngenxin_actionPerformed(e);
  }
}

class Select_btnshanchu_actionAdapter
    implements ActionListener {
  private Select adaptee;
  Select_btnshanchu_actionAdapter(Select adaptee) {
    this.adaptee = adaptee;
  }

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

class Select_btntianjia_actionAdapter
    implements ActionListener {
  private Select adaptee;
  Select_btntianjia_actionAdapter(Select adaptee) {
    this.adaptee = adaptee;
  }

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

class Select_btnchaxun_actionAdapter
    implements ActionListener {
  private Select adaptee;
  Select_btnchaxun_actionAdapter(Select adaptee) {
    this.adaptee = adaptee;
  }

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

class Select_txtshangpin_keyAdapter
    extends KeyAdapter {
  private Select adaptee;
  Select_txtshangpin_keyAdapter(Select adaptee) {
    this.adaptee = adaptee;
  }

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