hy-202005.zip

package com.hy.sy; import javax.swing.JPanel; import javax.swing.JLabel; import javax.swing.JOptionPane; import java.awt.Font; import java.awt.Color; import javax.swing.JTextField; import javax.swing.table.DefaultTableModel; import com.hy.login.LoginData; import com.hy.uils.DataBaseManager; import javax.swing.JButton; import java.awt.event.ActionListener; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Vector; import java.awt.event.ActionEvent; import javax.swing.JScrollPane; import javax.swing.JTable; public class Sy extends JPanel implements ActionListener { /** * */ private static final long serialVersionUID = 1L; private JTextField textField; private JTextField textField_1; private JTextField textField_2; private JTextField textField_3; private JTable table; JButton button_tj = null; JButton button_xg = null; JButton button_th = null; JButton button_yejz = null; JButton button_xjjz = null; Vector<Vector<Object>> hangData; Vector<String> lie = null; DefaultTableModel dtm = null; JScrollPane scrollPane = null; JLabel label_6 = null; JLabel label_7 = null; JLabel label_8 = null; JLabel lblNewLabel_1 = null; JLabel label_11 = null; JLabel label_13 = null; String hykh = null; String sptm = null; String meName = null; String meJf = null; String meYe = null; String zongjia = null; String zongshu = null; String sp = null; String name = null; String gg = null; int tm = 0; String dw = null; int sj = 0; public Sy() { setBounds(151, 93, 1039, 573); setLayout(null); JPanel panel = new JPanel(); panel.setBackground(new Color(128, 128, 128)); panel.setBounds(0, 0, 1039, 46); add(panel); panel.setLayout(null); JLabel label = new JLabel("\u6536\u94F61"); label.setFont(new Font("宋体", Font.PLAIN, 24)); label.setBounds(15, 0, 89, 46); panel.add(label); JPanel panel_1 = new JPanel(); panel_1.setBackground(new Color(0, 255, 255)); panel_1.setBounds(0, 48, 1039, 54); add(panel_1); panel_1.setLayout(null); textField = new JTextField(); textField.setBounds(117, 15, 143, 27); panel_1.add(textField); textField.setColumns(10); JLabel label_1 = new JLabel("\u5546\u54C1\u6761\u7801 :"); label_1.setBounds(15, 18, 137, 21); panel_1.add(label_1); button_tj = new JButton("\u6DFB\u52A0\u5546\u54C1"); button_tj.setBounds(275, 14, 143, 29); panel_1.add(button_tj); button_xg = new JButton("\u4FEE\u6539\u8D2D\u4E70\u6570\u91CF"); button_xg.setEnabled(false); button_xg.setBounds(881, 14, 143, 29); panel_1.add(button_xg); button_th = new JButton("\u9000\u56DE"); button_th.setBounds(433, 14, 143, 29); panel_1.add(button_th); button_th.setEnabled(false); JLabel label_14 = new JLabel("\u8BF7\u8F93\u5165\u4FEE\u6539\u6570\u91CF\uFF1A"); label_14.setBounds(591, 18, 149, 21); panel_1.add(label_14); textField_3 = new JTextField(); textField_3.setBounds(736, 15, 130, 27); panel_1.add(textField_3); textField_3.setColumns(10); button_th.addActionListener(this); JPanel panel_2 = new JPanel(); panel_2.setBounds(0, 104, 1039, 317); add(panel_2); panel_2.setLayout(null); scrollPane = new JScrollPane(); scrollPane.setBounds(0, 0, 1039, 317); panel_2.add(scrollPane); JPanel panel_3 = new JPanel(); panel_3.setBackground(new Color(147, 112, 219)); panel_3.setBounds(0, 421, 1039, 46); add(panel_3); panel_3.setLayout(null); JLabel label_2 = new JLabel("\u4F1A\u5458\u5361\u53F7\uFF1A"); label_2.setBounds(15, 15, 101, 21); panel_3.add(label_2); textField_1 = new JTextField(); textField_1.setBounds(105, 12, 166, 27); panel_3.add(textField_1); textField_1.setColumns(10); JLabel label_3 = new JLabel("\u59D3\u540D\uFF1A"); label_3.setBounds(305, 15, 81, 21); panel_3.add(label_3); JLabel label_4 = new JLabel("\u79EF\u5206\uFF1A"); label_4.setBounds(475, 15, 81, 21); panel_3.add(label_4); JLabel label_5 = new JLabel("\u4F59\u989D\uFF1A"); label_5.setBounds(631, 15, 69, 21); panel_3.add(label_5); button_yejz = new JButton("\u4F59\u989D\u7ED3\u8D26"); button_yejz.setEnabled(false); button_yejz.setBounds(814, 11, 180, 29); panel_3.add(button_yejz); label_6 = new JLabel(""); label_6.setBounds(379, 15, 81, 21); panel_3.add(label_6); label_7 = new JLabel(""); label_7.setBounds(535, 15, 81, 21); panel_3.add(label_7); label_8 = new JLabel(""); label_8.setBounds(702, 15, 81, 21); panel_3.add(label_8); JPanel panel_4 = new JPanel(); panel_4.setBackground(new Color(152, 251, 152)); panel_4.setBounds(0, 470, 1039, 103); add(panel_4); panel_4.setLayout(null); JLabel label_9 = new JLabel("\u5171\u8BA1\uFF1A\uFFE5"); label_9.setFont(new Font("宋体", Font.PLAIN, 28)); label_9.setBounds(15, 15, 140, 37); panel_4.add(label_9); JLabel label_10 = new JLabel("\u5171\u8BA1\uFF1A\uFFE5"); label_10.setFont(new Font("宋体", Font.PLAIN, 28)); label_10.setBounds(15, 51, 120, 37); panel_4.add(label_10); JLabel lblNewLabel = new JLabel("\u5B9E \u6536\uFF1A\uFFE5"); lblNewLabel.setFont(new Font("宋体", Font.PLAIN, 28)); lblNewLabel.setBounds(294, 15, 168, 32); panel_4.add(lblNewLabel); lblNewLabel_1 = new JLabel(""); lblNewLabel_1.setFont(new Font("宋体", Font.PLAIN, 28)); lblNewLabel_1.setBounds(129, 20, 140, 32); panel_4.add(lblNewLabel_1); label_11 = new JLabel(""); label_11.setFont(new Font("宋体", Font.PLAIN, 28)); label_11.setBounds(129, 56, 36, 32); panel_4.add(label_11); JLabel label_12 = new JLabel("\u5E94\u627E\u91D1\u989D\uFF1A\uFFE5"); label_12.setFont(new Font("宋体", Font.PLAIN, 28)); label_12.setBounds(294, 51, 168, 37); panel_4.add(label_12); label_13 = new JLabel(""); label_13.setFont(new Font("宋体", Font.PLAIN, 28)); label_13.setBounds(465, 51, 197, 37); panel_4.add(label_13); button_xjjz = new JButton("\u73B0\u91D1\u7ED3\u8D26"); button_xjjz.setEnabled(false); button_xjjz.setFont(new Font("宋体", Font.PLAIN, 34)); button_xjjz.setBounds(786, 0, 212, 103); panel_4.add(button_xjjz); textField_2 = new JTextField(); textField_2.setBounds(477, 15, 185, 35); panel_4.add(textField_2); textField_2.setColumns(10); JLabel lblNewLabel_2 = new JLabel("\u79CD\u5546\u54C1"); lblNewLabel_2.setFont(new Font("宋体", Font.PLAIN, 28)); lblNewLabel_2.setBounds(150, 51, 95, 37); panel_4.add(lblNewLabel_2); button_tj.addActionListener(this); button_xg.addActionListener(this); button_yejz.addActionListener(this); button_xjjz.addActionListener(this); } @Override public void actionPerformed(ActionEvent e) { Object object = e.getSource(); if (button_tj == object) { try { sptm = textField.getText(); hykh = textField_1.getText(); if (sptm.length() <= 0) { JOptionPane.showMessageDialog(null, "请输入商品条码！"); return; } String sql01 = "select sp_tiaoma from shangpin where sp_tiaoma = ?"; PreparedStatement pmt = DataBaseManager.getMyConn().prepareStatement(sql01); pmt.setString(1, sptm); ResultSet rut = pmt.executeQuery(); while (null != rut && rut.next()) { sp = rut.getString(1); } if (sptm != null || !sptm.equals("")) { String sql11 = "select comm_yard from commodity where comm_yard = ?"; PreparedStatement pet11 = DataBaseManager.getMyConn().prepareStatement(sql11); pet11.setString(1, sptm); ResultSet rst11 = pet11.executeQuery(); String tiaom = null; while (null != rst11 && rst11.next()) { tiaom = rst11.getString(1); } if (!sptm.equals(tiaom)) { JOptionPane.showMessageDialog(null, "没有该商品"