billinframe.java

Jbuilder编写的纱线制衣厂的仓库管理系统（学习java时做的一个系统）源码

package yarn;

import java.awt.BorderLayout;
import javax.swing.JInternalFrame;
import javax.swing.JFrame;
import javax.swing.JPanel;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.JButton;
import java.awt.Dimension;
import javax.swing.JToolBar;
import javax.swing.JTextField;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JSpinner;
import javax.swing.BorderFactory;
import java.awt.Color;
import javax.swing.border.TitledBorder;
import javax.swing.JLabel;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Font;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.awt.SystemColor;
import javax.swing.UIManager;
import javax.swing.border.Border;
import javax.swing.border.EtchedBorder;
import javax.swing.SpinnerDateModel;
import javax.swing.DefaultCellEditor;
import java.sql.ResultSet;
import java.util.Vector;
import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.Connection;


import javax.swing.*;
import com.borland.jbcl.layout.XYConstraints;
import java.awt.event.ActionEvent;
import javax.swing.table.TableModel;
import java.sql.ResultSet;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import javax.swing.border.TitledBorder;
import com.borland.jbcl.layout.XYLayout;
import javax.swing.border.Border;
import java.awt.Color;
import java.sql.Statement;
import java.awt.BorderLayout;
import javax.swing.event.DocumentEvent;
import javax.swing.event.DocumentListener;
import java.util.*;
import javax.swing.table.*;
import java.awt.event.MouseListener;
import java.awt.event.MouseEvent;
import java.awt.event.FocusListener;
import java.awt.event.FocusEvent;
import java.beans.PropertyChangeListener;
import java.beans.PropertyChangeEvent;
import javax.swing.event.CellEditorListener;
import javax.swing.event.ChangeEvent;
import java.sql.DriverManager;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class BillInFrame extends JInternalFrame {
    JDBCFile jf = null;
    Statement st = null;
    XYLayout xYLayout1 = new XYLayout();
    JToolBar jToolBar1 = new JToolBar();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JCheckBox jCheckBox1 = new JCheckBox();
    JComboBox jComboBox1 = new JComboBox();
    JComboBox jComboBox3 = new JComboBox();
    JSpinner jSpinner1 = new JSpinner();
    JTextField jTextField4 = new JTextField();
    TitledBorder titledBorder1 = new TitledBorder("");
    TitledBorder titledBorder2 = new TitledBorder("");
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JPanel jPanel1 = new JPanel();
    JScrollPane jScrollPane1 = new JScrollPane();
    XYLayout xYLayout2 = new XYLayout();
    JTable jTable1 = new JTable();
    JTextField jTextField5 = new JTextField();
    JLabel jLabel10 = new JLabel();
    Border border3 = BorderFactory.createEtchedBorder(Color.white,
            new Color(165, 169, 174));
    Border border4 = new TitledBorder(border3, "纱线查询");
    JButton jButton3 = new JButton();
    JPanel jPanel2 = new JPanel();
    Border border5 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.white, new Color(165, 169, 174));
    Border border6 = new TitledBorder(border5, "入库明细");
    XYLayout xYLayout3 = new XYLayout();
    JScrollPane jScrollPane2 = new JScrollPane();
    JTable jTable2 = new JTable();
    JToolBar jToolBar2 = new JToolBar();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    JPanel jPanel3 = new JPanel();
    JLabel jLabel9 = new JLabel();
    XYLayout xYLayout4 = new XYLayout();
    JTextField jTextField6 = new JTextField();
    JComboBox yarnIDJComboBox = new JComboBox();
    JTextField jTextField7 = new JTextField();
    JTextField jTextField8 = new JTextField();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JButton jButton6 = new JButton();
    public BillInFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    public BillInFrame(JDBCFile jf) {
        this.jf = jf;
        st = jf.getStatement();
        try {
            jbInit();
            newBuild();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        border6 = new TitledBorder(BorderFactory.createEtchedBorder(
                EtchedBorder.RAISED, Color.white, new Color(165, 169, 174)),
                                   "入库明细");
        border4 = new TitledBorder(BorderFactory.createEtchedBorder(
                EtchedBorder.RAISED, Color.white, new Color(165, 169, 174)),
                                   "纱线查询");
        this.setVisible(true);
        this.setSize(new Dimension(800,600));
        getContentPane().setLayout(xYLayout1);
        this.setClosable(true);
        this.setMaximizable(true);
        this.setResizable(true);
        xYLayout1.setWidth(800);
        xYLayout1.setHeight(600);
        jButton1.setText("保存");
        jButton1.addActionListener(new BillInFrame_jButton1_actionAdapter(this));
        jButton2.setText("打印");
        jCheckBox1.setText(" 红单标记");
        jToolBar1.setBorder(BorderFactory.createEtchedBorder());
        jLabel1.setText("入库单号");
        jLabel2.setText("入库仓库");
        jLabel3.setText("仓库余量");
        jLabel4.setText("原始单号");
        jLabel5.setText("客户");
        jLabel6.setText("入库日期");
        jLabel7.setText("制单人ID");
        jLabel8.setFont(new java.awt.Font("方正舒体", Font.PLAIN, 40));
        jLabel8.setForeground(SystemColor.desktop);
        jLabel8.setText("入库单");
        jPanel1.setBorder(border4);
        jPanel1.setLayout(xYLayout2);
        jLabel10.setText("请输入纱线ID");
        jButton3.setSelectedIcon(null);
        jButton3.setText("录新纱");
        jPanel2.setBorder(border6);
        jPanel2.setLayout(xYLayout3);
        jButton4.setText("新增明细");

        jButton5.setText("删除明细");

        jToolBar2.setBorder(BorderFactory.createEtchedBorder());
        jPanel3.setBorder(BorderFactory.createEtchedBorder());
        jPanel3.setLayout(xYLayout4);
        jLabel9.setText("备注");
        jTextField1.setEditable(false);
        jTextField2.setEditable(false);
        jComboBox3.setEditable(true);
        jTextField4.setEditable(false);
        jLabel11.setText("总重量");
        jLabel12.setText("总金额");
        jTextField7.setEditable(false);
        jTextField8.setEditable(false);
        jButton6.setText("刷新");
        jButton6.addActionListener(new BillInFrame_jButton6_actionAdapter(this));
        jToolBar1.add(jButton1);
        jToolBar1.add(jButton2);
        jPanel1.add(jLabel10, new XYConstraints(9, 61, -1, -1));
        jScrollPane1.getViewport().add(jTable1);

        this.getContentPane().add(jTextField2,
                                  new XYConstraints(87, 92, 107, -1));
        this.getContentPane().add(jLabel6, new XYConstraints(588, 68, -1, -1));
        this.getContentPane().add(jLabel1, new XYConstraints(33, 43, -1, -1));
        this.getContentPane().add(jTextField1,
                                  new XYConstraints(87, 41, 107, -1));
        this.getContentPane().add(jComboBox1, new XYConstraints(87, 66, 107, 20));
        this.getContentPane().add(jLabel2, new XYConstraints(33, 68, -1, -1));
        this.getContentPane().add(jLabel4, new XYConstraints(219, 96, -1, -1));
        this.getContentPane().add(jTextField3,
                                  new XYConstraints(273, 92, 109, -1));
        this.getContentPane().add(jLabel3, new XYConstraints(33, 95, -1, -1));
        this.getContentPane().add(jTextField4,
                                  new XYConstraints(641, 92, 109, -1));
        this.getContentPane().add(jComboBox3,
                                  new XYConstraints(457, 92, 107, 20));
        this.getContentPane().add(jLabel5, new XYConstraints(424, 94, -1, -1));
        this.getContentPane().add(jSpinner1, new XYConstraints(641, 66, 109, -1));
        this.getContentPane().add(jCheckBox1, new XYConstraints(638, 41, 92, 20));
        this.getContentPane().add(jLabel7, new XYConstraints(588, 94, -1, -1));
        this.getContentPane().add(jLabel8, new XYConstraints(354, 32, 127, 46));
        this.getContentPane().add(jPanel1, new XYConstraints(24, 117, 726, 135));
        jToolBar2.add(jButton4);
        jToolBar2.add(jButton5);
        this.getContentPane().add(jPanel3, new XYConstraints(27, 530, 723, 34));
        jPanel3.add(jLabel9, new XYConstraints(6, 6, -1, -1));
        jPanel3.add(jTextField6, new XYConstraints(37, 5, 672, -1));
        this.getContentPane().add(jToolBar1, new XYConstraints(10, 10, 777, -1));

        jScrollPane2.getViewport().add(jTable2);

        this.getContentPane().add(jPanel2, new XYConstraints(24, 253, 726, 270));
        jPanel2.add(jToolBar2, new XYConstraints(6, 0, -1, 26));
        jPanel2.add(jScrollPane2, new XYConstraints(6, 30, 704, 210));
        jPanel2.add(jLabel12, new XYConstraints(572, 4, -1, -1));
        jPanel2.add(jTextField7, new XYConstraints(479, 2, 79, -1));
        jPanel2.add(jLabel11, new XYConstraints(440, 4, -1, -1));
        jPanel1.add(jScrollPane1, new XYConstraints(93, 0, 617, 103));
        jPanel1.add(jTextField5, new XYConstraints(6, 83, 80, -1));
        jPanel1.add(jButton3, new XYConstraints(6, 26, 80, -1));
        jPanel2.add(jTextField8, new XYConstraints(612, 2, 83, -1));
        this.getContentPane().add(jButton6, new XYConstraints(198, 41, 56, 20));

    }
    public void newBuild()
        {
            //设置各项的默认数据(仓库和客户的)
            try
            {
                ResultSet rs = jf.executeQuery("select DefaultValue from DefaultValue where Types = 'Storage'");
                while(rs.next())
                    jComboBox1.addItem(rs.getString("DefaultValue"));
                rs.close();
                rs = jf.executeQuery("select DefaultValue from DefaultValue where Types = 'Client'");
               while(rs.next())
                   jComboBox3.addItem(rs.getString("DefaultValue"));
               rs.close();
            }
            catch(Exception ex)
            {
                ex.printStackTrace();
            }
            jSpinner1.setModel(new SpinnerDateModel());
            //为增加明细按钮添加活动监听
            jButton4.addActionListener(new BillInFrame_jButton4_actionAdapter(this));
            jButton5.addActionListener(new BillInFrame_jButton5_actionAdapter(this));
            //为仓库选择文本框添加物品监听
            jComboBox1.addItemListener(new BillInFrame_jComboBox1_itemAdapter(this));
            //为文本查询栏添加文档监听
            jTextField5.getDocument().addDocumentListener(new BillInFrame_jTextField5_DocumentAdapter(this));
            //为查询纱线列表添加鼠标双击监听
            jTable1.addMouseListener(new BillInFrame_tableDoubleClick_MouseListener(this));
            //为明细表设置表格模式
            String[] itemColumnName = {"明细项","纱线ID","色名","品种规格","缸号","尾纱","重量","单价"};
            YarnTableModel billInItemModel = new YarnTableModel(new Vector(),itemColumnName,2);
            jTable2.setModel(billInItemModel);
            //增加明细栏的明细数
            ((YarnTableModel)jTable2.getModel()).addTableItem();
            //查找最大单号加1并且填进单号的填写栏，即新建单据令单号加1
            refurbish();
            //将在登陆时的用户填进制表人栏