Java版超市商品管理系统（更新版）

package com.wg; import java.awt.*; import java.awt.event.*; import java.sql.*; import javax.sql.*; import javax.swing.*; import javax.swing.text.AttributeSet; import javax.swing.text.BadLocationException; import javax.swing.text.PlainDocument; public class Select extends JFrame { final JTextField txtbh = new JTextField(10); final JTextField txtmc = new JTextField(); final JTextField txtdj = new JTextField(); final JTextField txtsy = new JTextField(); final JTextField txtname = new JTextField(); final JTextField txtgm = new JTextField(); final JTextField txtsysl = new JTextField(10); final JTextField txtgj = new JTextField(10); DBTools db; private ResultSet rs = null; private String scr = ""; private String sdj = ""; private String ssy = ""; private String smc = ""; public Select() { super(); setTitle("商品管理"); Toolkit tool = this.getToolkit();// 窗口图标设置 Image myimage = tool.getImage("img\\tp.jpg"); // 图片路径 this.setIconImage(myimage); // 窗口图标设置 this.setResizable(false);// 窗口锁死 getContentPane().setLayout(null); setBounds(100, 100, 439, 312); setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); final JLabel label = new JLabel(); label.setText("商品编号"); label.setBounds(21, 32, 60, 15); getContentPane().add(label); final JLabel label_1 = new JLabel(); label_1.setText("商品名称"); label_1.setBounds(21, 84, 60, 15); getContentPane().add(label_1); final JLabel label_2 = new JLabel(); label_2.setText("单 价"); label_2.setBounds(21, 131, 60, 15); getContentPane().add(label_2); final JLabel label_3 = new JLabel(); label_3.setText("剩余数量"); label_3.setBounds(21, 175, 60, 15); getContentPane().add(label_3); final JLabel label_4 = new JLabel(); label_4.setText("卖出数量"); label_4.setBounds(21, 226, 60, 15); getContentPane().add(label_4); txtbh.setBounds(98, 28, 90, 22); txtbh.setDocument(new NumOnlyDocument()); getContentPane().add(txtbh); txtname.setBounds(98, 80, 90, 22); txtname.setEditable(false); getContentPane().add(txtname); txtdj.setBounds(98, 127, 90, 22); txtdj.setEditable(false); getContentPane().add(txtdj); txtsy.setBounds(98, 171, 90, 22); txtsy.setEditable(false); getContentPane().add(txtsy); txtmc.setBounds(98, 222, 90, 22); txtmc.setEditable(false); getContentPane().add(txtmc); txtgm.setBounds(332, 79, 90, 25); getContentPane().add(txtgm); txtgj.setBounds(332, 126, 90, 25); txtgj.setDocument(new NumOnlyDocument()); getContentPane().add(txtgj); txtsysl.setBounds(332, 170, 90, 25); txtsysl.setDocument(new NumOnlyDocument()); getContentPane().add(txtsysl); final JButton button = new JButton(); button.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String temp = txtbh.getText(); try { DBTools dbs = new DBTools(); String sql = "select * from ware where id=" + temp.trim(); rs = dbs.select(sql); if (rs.next()) { scr = rs.getString("wareName"); txtname.setText("" + scr); sdj = rs.getString("price"); txtdj.setText(sdj); ssy = rs.getString("entries"); txtsy.setText(ssy); smc = rs.getString("residual"); txtmc.setText(smc); } else { JOptionPane.showMessageDialog(null, "没有此商品，请重新查询！"); } } catch (Exception e1) { e1.printStackTrace(); } } }); button.setText("查 询"); button.setBounds(205, 29, 110, 22); getContentPane().add(button); final JButton button_1 = new JButton(); button_1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { txtbh.setText(""); txtname.setText(""); txtdj.setText(""); txtsy.setText(""); txtmc.setText(""); } }); button_1.setText("重新查询"); button_1.setBounds(332, 223, 90, 22); getContentPane().add(button_1); final JButton xgdj = new JButton(); xgdj.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String temp = txtbh.getText(); try { if (!txtgj.getText().equals("") && !txtbh.getText().equals("")) { DBTools db = new DBTools(); String sqql = "select * from ware where id=" + temp.trim(); ResultSet cs = db.select(sqql); if (cs.next()) { db.Close(); DBTools dbsd = new DBTools(); boolean gj = dbsd .gj(txtgj.getText(), txtbh.getText()); if (gj) { JOptionPane.showMessageDialog(null, "单价修改成功！"); db.Close(); try { DBTools dbs = new DBTools(); String sql = "select * from ware where id=" + temp.trim() ; rs = dbs.select(sql); while (rs.next()) { scr = rs.getString("wareName"); txtname.setText("" + scr); sdj = rs.getString("price"); txtdj.setText(sdj); ssy = rs.getString("entries"); txtsy.setText(ssy); smc = rs.getString("residual"); txtmc.setText(smc); txtgj.setText(""); } } catch (Exception e1) { e1.printStackTrace(); } } else { JOptionPane.showMessageDialog(null, "单价修改失败，商品编号无效！"); } } else { JOptionPane.showMessageDialog(null, "单价修改失败，商品编号无效！"); } } else { JOptionPane.showMessageDialog(null, "单价修改失败，不能为空！"); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } // } }); xgdj.setText("修改单价→"); xgdj.setBounds(205, 128, 110, 22); getContentPane().add(xgdj); final JButton button_3 = new JButton(); button_3.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String temp = txtbh.getText(); try { if (!txtsysl.getText().equals("") && !txtbh.getText().equals("")) { DBTools db = new DBTools(); String sqql = "select * from ware where id="+ temp.trim(); ResultSet cs = db.select(sqql); if (cs.next()) { db.Close(); DBTools dbs = new DBTools(); boolean dd = dbs.jh(txtsysl.getText(), txtbh.getText()); if (dd) { db.Close(); JOptionPane.showMessageDialog(null, "进货成功！"); try { DBTools dbst = new DBTools(); String sql = "select * from ware where id="+ temp.trim() ; rs = dbst.select(sql); while (rs.next()) { scr = rs.getString("wareName"); txtname.setText("" + scr); sdj = rs.getString("price"); txtdj.setText(sdj); ssy = rs.getString("entries"); txtsy.setText(ssy); smc = rs.getString("residual"); txtmc.setText(smc); txtsysl.setText(""); } } catch (Exception e1) { e1.printStackTrace(); } } else { JOptionPane.showMessageDialog(null, "进货失败，商品编号无效！"); } } else { JOptionPane.showMessageDialog(null, "进货失败，商品编号无效！"); } } else { JOptionPane.showMessageDialog(null, "进货失败，不能为空！"); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } } }); button_3.setText("进 货→"); button_3.setBounds(205, 172, 110, 22); getContentPane().add(button_3); final JButton button_4 = new JButton(); button_4.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String temp = txtbh.getText(); try { if (!txtgm.getText().equals("")