java进销存系统（含数据库）

[java]代码库
package com.itstar.erp.ui.kucunswing;
 
import javax.swing.SwingUtilities;
 
import javax.swing.DefaultComboBoxModel;
import javax.swing.JPanel;
import javax.swing.JFrame;
import javax.swing.JComboBox;
import java.awt.Rectangle;
import java.awt.event.ItemEvent;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import java.util.Vector;
 
import javax.swing.JLabel;
import javax.swing.JTextField;
 
import com.itstar.erp.dao.kucun.KuCunDaoImpl;
import com.itstar.erp.util.GetResultSet;
 
public class KuCunJFrame extends JFrame {
 
    private static final long serialVersionUID = 1L;
    private JPanel jContentPane = null;
    private JComboBox pronameComboBox = null;
    private JLabel jLabel = null;
    String provalue = ""; 
    static Map<Integer, String> proidnamemap = new HashMap<Integer, String>(); 
    static Map<String, Double> pronamepricemap = new HashMap<String, Double>(); 
    static Map<String, Integer> pronameidmap = new HashMap<String, Integer>(); 
    private JLabel jLabel1 = null;
    private JLabel jLabel2 = null;
    private JLabel jLabel3 = null;
    private JLabel jLabel4 = null;
    private JLabel jLabel5 = null;
    private JTextField proid = null;
    private JTextField proname = null;
    private JTextField proprice = null;
    private JTextField kucunacount = null;
    private JTextField total = null;
     
    static {
        String table = "tb_product_info";
        ResultSet rs = new GetResultSet().getResultSet(table);
        try {
            while (rs.next()) {
                int id = rs.getInt(1);
                String name = rs.getString(3);
                double price = rs.getDouble(4);
                proidnamemap.put(id, name);
                pronamepricemap.put(name, price);
                pronameidmap.put(name, id);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
 
    static Map<String, Integer> kucunidacountmap = new HashMap<String, Integer>(); // @jve:decl-index=0:
    static {
 
        String table = "tb_kucun_info";
        ResultSet rs = new GetResultSet().getResultSet(table);
        try {
            while (rs.next()) {
                int id = rs.getInt(1);
                int count = rs.getInt(2);
                String name = proidnamemap.get(count);
                kucunidacountmap.put(name, count);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
 
    }
 
    /**
     * This method initializes pronameComboBox
     * 
     * @return javax.swing.JComboBox
     */
    private JComboBox getPronameComboBox() {
        if (pronameComboBox == null) {
            Vector v = new Vector();
            v.add("");
            v.add("查询全部");
            String table = "tb_kucun_info";
            ResultSet rs = new GetResultSet().getResultSet(table);
            try {
                while (rs.next()) {
                    int proid = rs.getInt(1);
                    String name = proidnamemap.get(proid);
                    v.add(name);
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
            DefaultComboBoxModel model = new DefaultComboBoxModel(v);
            pronameComboBox = new JComboBox(model);
 
            pronameComboBox.setBounds(new Rectangle(295, 66, 275, 36));
            pronameComboBox.addItemListener(new java.awt.event.ItemListener() {
                public void itemStateChanged(java.awt.event.ItemEvent e) {
                    if (e.getStateChange() == ItemEvent.SELECTED) {
                        provalue = pronameComboBox.getSelectedItem().toString();
                        if (!provalue.equals("") && !provalue.equals("查询全部")) {
                            int id = pronameidmap.get(provalue);
                            String name = provalue;
                            double price = pronamepricemap.get(provalue);
                            int kcount = new KuCunDaoImpl().getkucunAcount(id);
                            double ktotal = price * kcount;
 
                            proid.setText("准字" + (1000 + id));
                            proname.setText(name);
                            proprice.setText("" + price);
                            kucunacount.setText("" + kcount);
                            total.setText("" + ktotal);
 
                        }
                        if (provalue.equals("查询全部")) {
                            proid.setText("");
                            proname.setText("");
                            proprice.setText("");
                            kucunacount.setText("");
                            total.setText("");
 
                            new KuCunJTable().init();
                            pronameComboBox.setSelectedIndex(0);
 
                        }
                        if (provalue.equals("")) {
                            proid.setText("");
                            proname.setText("");
                            proprice.setText("");
                            kucunacount.setText("");
                            total.setText("");
                        }
                    }
                }
            });
        }
        return pronameComboBox;
    }
 
    /**
     * This method initializes proid
     * 
     * @return javax.swing.JTextField
     */
    private JTextField getProid() {
        if (proid == null) {
            proid = new JTextField();
            proid.setEditable(false);
            proid.setBounds(new Rectangle(52, 195, 114, 30));
        }
        return proid;
    }
 
    /**
     * This method initializes proname
     * 
     * @return javax.swing.JTextField
     */
    private JTextField getProname() {
        if (proname == null) {
            proname = new JTextField();
            proname.setEditable(false);
            proname.setBounds(new Rectangle(176, 197, 127, 29));
        }
        return proname;
    }
 
    /**
     * This method initializes proprice
     * 
     * @return javax.swing.JTextField
     */
    private JTextField getProprice() {
        if (proprice == null) {
            proprice = new JTextField();
            proprice.setEditable(false);
            proprice.setBounds(new Rectangle(320, 193, 110, 34));
        }
        return proprice;
    }
 
    /**
     * This method initializes kucunacount
     * 
     * @return javax.swing.JTextField
     */
    private JTextField getKucunacount() {
        if (kucunacount == null) {
            kucunacount = new JTextField();
            kucunacount.setEditable(false);
            kucunacount.setBounds(new Rectangle(447, 195, 95, 32));
        }
        return kucunacount;
    }
 
    /**
     * This method initializes total
     * 
     * @return javax.swing.JTextField
     */
    private JTextField getTotal() {
        if (total == null) {
            total = new JTextField();
            total.setEditable(false);
            total.setBounds(new Rectangle(558, 192, 108, 32));
        }
        return total;
    }
 
    /**
     * @param args
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        SwingUtilities.invokeLater(new Runnable() {
            public void run() {
                KuCunJFrame thisClass = new KuCunJFrame();
                thisClass.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
                thisClass.setVisible(true);
            }
        });
    }
 
    /**
     * This is the default constructor
     */
    public KuCunJFrame() {
        super();
        initialize();
    }
 
    /**
     * This method initializes this
     * 
     * @return void
     */
    private void initialize() {
        this.setSize(700, 500);
        this.setContentPane(getJContentPane());
        this.setTitle("库存管理");
        this.setLocationRelativeTo(null);
    }
 
    /**
     * This method initializes jContentPane
     * 
     * @return javax.swing.JPanel
     */
    private JPanel getJContentPane() {
        if (jContentPane == null) {
            jLabel5 = new JLabel();
            jLabel5.setBounds(new Rectangle(556, 149, 110, 27));
            jLabel5.setText("       库存金额");
            jLabel4 = new JLabel();
            jLabel4.setBounds(new Rectangle(442, 147, 97, 31));
            jLabel4.setText("      库存数量");
            jLabel3 = new JLabel();
            jLabel3.setBounds(new Rectangle(320, 149, 107, 31));
            jLabel3.setText("         进价");
            jLabel2 = new JLabel();
            jLabel2.setBounds(new Rectangle(177, 148, 124, 32));
            jLabel2.setText("    商品名称");
            jLabel1 = new JLabel();
            jLabel1.setBounds(new Rectangle(53, 145, 112, 33));
            jLabel1.setText("     商品编号");
            jLabel = new JLabel();
            jLabel.setBounds(new Rectangle(99, 69, 196, 35));
            jLabel.setText("                请选择商品名称");
            jContentPane = new JPanel();
            jContentPane.setLayout(null);
            jContentPane.add(getPronameComboBox(), null);
            jContentPane.add(jLabel, null);
            jContentPane.add(jLabel1, null);
            jContentPane.add(jLabel2, null);
            jContentPane.add(jLabel3, null);
            jContentPane.add(jLabel4, null);
            jContentPane.add(jLabel5, null);
            jContentPane.add(getProid(), null);
            jContentPane.add(getProname(), null);
            jContentPane.add(getProprice(), null);
            jContentPane.add(getKucunacount(), null);
            jContentPane.add(getTotal(), null);
        }
        return jContentPane;
    }
 
} // @jve:decl-index=0:visual-constraint="215,10"
[代码运行效果截图]
[源代码打包下载]
用户注册

用户登录

发表随想

该用户最新代码

编程随想

[java]代码库

[代码运行效果截图]

[源代码打包下载]

网友评论 (发表评论)

发表评论：

评论须知：

扫码下载

输入口令后可复制整站源码
