Java仓库管理系统

package View; import java.awt.Color; import java.awt.Font; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.ItemEvent; import java.awt.event.ItemListener; import java.awt.event.KeyEvent; import java.awt.event.KeyListener; import java.sql.ResultSet; import java.sql.SQLException; import javax.swing.BorderFactory; import javax.swing.JButton; import javax.swing.JComboBox; import javax.swing.JFrame; import javax.swing.JInternalFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JPasswordField; import javax.swing.JScrollPane; import javax.swing.JTabbedPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.border.EmptyBorder; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableModel; import Systems.DataOper; public class SecondView { public static JInternalFrame productManagement() { JPanel contentPane; JTextField textField; JTextField textField_1; JTextField textField_2; JTextField textField_3; JTextField textField_4; JTextField textField_5; JTextField textField_6; JTextField textField_7; JTextField textField_8; JInternalFrame frame = new JInternalFrame("商品信息管理"); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.setBounds(0, 80, 804, 506); contentPane = new JPanel(); contentPane.setBorder(new EmptyBorder(5, 5, 5, 5)); frame.setContentPane(contentPane); contentPane.setLayout(null); JTabbedPane tabbedPane = new JTabbedPane(JTabbedPane.TOP); tabbedPane.setBounds(0, 0, 772, 418); contentPane.add(tabbedPane); JPanel panel = new JPanel(); panel.setLayout(null); panel.setBackground(Color.LIGHT_GRAY); tabbedPane.addTab("删除商品", null, panel, null); JLabel label = new JLabel("商品ID:"); label.setFont(new Font("宋体", Font.PLAIN, 20)); label.setBounds(65, 26, 79, 20); panel.add(label); JLabel label_1 = new JLabel("名称:"); label_1.setFont(new Font("宋体", Font.PLAIN, 20)); label_1.setBounds(60, 72, 66, 20); panel.add(label_1); JLabel label_2 = new JLabel("价格:"); label_2.setFont(new Font("宋体", Font.PLAIN, 20)); label_2.setBounds(65, 117, 79, 20); panel.add(label_2); JLabel label_3 = new JLabel("种类:"); label_3.setFont(new Font("宋体", Font.PLAIN, 20)); label_3.setBounds(65, 163, 61, 20); panel.add(label_3); JLabel label_4 = new JLabel("数量:"); label_4.setFont(new Font("宋体", Font.PLAIN, 20)); label_4.setBounds(65, 209, 61, 20); panel.add(label_4); JLabel label_5 = new JLabel("供应商:"); label_5.setFont(new Font("宋体", Font.PLAIN, 20)); label_5.setBounds(65, 258, 79, 20); panel.add(label_5); JComboBox comboBox = new JComboBox();//商品ID下拉框 comboBox.setBounds(154, 16, 581, 41); //加入商品ID comboBox.addItem(""); try { for(String a : DataOper.getProductID()) comboBox.addItem(a); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } panel.add(comboBox); comboBox.getSelectedItem(); textField = new JTextField();//名称栏 textField.setColumns(10); textField.setBounds(154, 61, 581, 41); panel.add(textField); textField_1 = new JTextField();//价格栏 textField_1.setColumns(10); textField_1.setBounds(154, 107, 581, 41); textField_1.addKeyListener(new JudgeOfisNumdouble()); panel.add(textField_1); textField_2 = new JTextField();//种类栏 textField_2.setColumns(10); textField_2.setBounds(154, 153, 581, 41); panel.add(textField_2); textField_3 = new JTextField();//数量栏 textField_3.setColumns(10); textField_3.setBounds(154, 202, 581, 41); textField_3.addKeyListener(new JudgeOfisNumINT()); panel.add(textField_3); JTextField T = new JTextField();//供应商 T.setBounds(154, 248, 581, 41); panel.add(T); JButton button = new JButton("核实"); button.setFont(new Font("宋体", Font.PLAIN, 32)); button.setBackground(Color.LIGHT_GRAY); button.setBounds(36, 315, 118, 43); button.addActionListener(new ActionListener() {//核实按钮监听器 @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stu if(Judge.JudgeOfproducts(comboBox.getSelectedItem().toString(), textField.getText(), textField_1.getText(), textField_2.getText(), T.getText(), textField_3.getText())) JOptionPane.showConfirmDialog(null, "信息核实无误", "提示", JOptionPane.CLOSED_OPTION); else JOptionPane.showConfirmDialog(null, "信息核实有误", "提示", JOptionPane.CLOSED_OPTION); } }); panel.add(button); JButton button_1 = new JButton("重置"); button_1.setFont(new Font("宋体", Font.PLAIN, 32)); button_1.setBackground(Color.LIGHT_GRAY); button_1.setBounds(180, 315, 118, 43); button_1.addActionListener(new ActionListener() {//重置按钮监听器 @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub ResultSet rs = null; try { rs = DataOper.getProductIFM(comboBox.getSelectedItem().toString()); if(rs==null) { textField.setText(""); textField_1.setText(""); textField_2.setText(""); textField_3.setText(""); T.setText(""); return; } while(rs.next()) { textField.setText(rs.getString(2)); textField_1.setText(""+rs.getDouble(3)); textField_2.setText(""+rs.getString(4)); textField_3.setText(""+rs.getInt(6)); T.setText(DataOper.getSuplierName(""+rs.getInt(5))); } } catch (Exception e1) { // TODO Auto-generated catch block e1.printStackTrace(); } } }); panel.add(button_1); JButton button_2 = new JButton("修改"); button_2.setFont(new Font("宋体", Font.PLAIN, 32)); button_2.setBackground(Color.LIGHT_GRAY); button_2.setBounds(324, 315, 118, 43); panel.add(button_2); button_2.addActionListener(new ActionListener() {//修改按钮监听器 @Override public void actionPerformed(ActionEvent arg0) { // TODO Auto-generated method stub try { DataOper.updataPro(comboBox.getSelectedItem().toString(), textField.getText(), textField_1.getText(), textField_2.getText(),DataOper.UseSupNameFindSup_ID(T.getText()),textField_3.getText()); JOptionPane.showConfirmDialog(null, "修改成功", "提示", JOptionPane.CLOSED_OPTION); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } }); JButton button_3 = new JButton("删除"); button_3.setFont(new Font("宋体", Font.PLAIN, 32)); button_3.setBackground(Color.LIGHT_GRAY); button_3.setBounds(466, 315, 118, 43); panel.add(button_3); button_3.addActionListener(new ActionListener() {//删除按钮监听器 @Override public void actionPerformed(ActionEvent arg0) { // TODO Auto-generated method stub if(Judge.JudgeOfproducts(comboBox.getSelectedItem().toString(), textField.getText(), textField_1.getText(), textField_2.getText(), T.getText(), textField_3.getText())) { DataOper.DelprodUSEID(comboBox.getSelectedItem().toString()); JOptionPane.showConfirmDialog(null, "删除成功", "提示", JOptionPane.CLOSED_OPTION); comboBox.removeItem(comboBox.getSelectedItem().toString()); } else JOptionPane.showConfirmDialog(null, "信息核实有误", "提示", JOptionPane.CLOSED_OPTION); } }); JPanel panel_1 = new JPanel(); panel_1.setLayout(null); panel_1.setBackground(Color.LIGHT_GRAY); tabbedPane.addTab("添加商品", null, panel_1, null); JLabel label_6 = new JLabel("商品ID:"); label_6.setFont(new Font("宋体", Font.PLAIN, 20)); label_6.setBounds(65, 26, 79, 20); panel_1.add(label_6); JLabel label_7 = new JLabel("名称:"); l