jf_zcxx_inout.java

资产设备管理系统 第1章 系统登录 1.1 系统登录 （1）双击资产设备管理系统图标

package appgdzc.view;

import javax.swing.*;
import java.awt.*;
import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.Font;
import appgdzc.model.Obj_zcxx;
import appgdzc.model.facade;
import javax.swing.table.DefaultTableModel;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.util.Locale;
import java.text.DateFormat;
import appgdzc.tools.JTkeyAdapter;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;
import appgdzc.model.Obj_inout;
import java.util.Date;
import javax.swing.event.ChangeEvent;
import javax.swing.event.ChangeListener;
import appgdzc.tools.QueryTableEJB;
import appgdzc.tools.GlobaBean;

public class JF_zcxx_inout extends JInternalFrame{
    BorderLayout borderLayout1 = new BorderLayout();
    JTabbedPane jTabbedPane1 = new JTabbedPane();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    BorderLayout borderLayout2 = new BorderLayout();
    BorderLayout borderLayout3 = new BorderLayout();
    JPanel jPanel3 = new JPanel();
    JButton jBsave = new JButton();
    JButton jBexit = new JButton();
    FlowLayout flowLayout1 = new FlowLayout();
    JSplitPane jSplitPane1 = new JSplitPane();
    JPanel jPanel4 = new JPanel();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable();
    GridLayout gridLayout1 = new GridLayout();
    JLabel jLabel1 = new JLabel();
    JTextField jTbh = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField jTsl = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField jTbm = new JTextField();
    JLabel jLabel5 = new JLabel();
    JTextField jTjyr = new JTextField();
    JTextField jTmc = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField jTrq = new JTextField();

    private DefaultTableModel deaultTableModel;
    private DefaultTableModel deaultTableModel_gh;
    private facade facadeObject;

    JSplitPane jSplitPane2 = new JSplitPane();
    JScrollPane jScrollPane2 = new JScrollPane();
    JPanel jPanel5 = new JPanel();
    JTable jTable2 = new JTable();
    GridLayout gridLayout2 = new GridLayout();
    JLabel jLabel7 = new JLabel();
    JTextField jTghbh = new JTextField();
    JLabel jLabel8 = new JLabel();
    JTextField jTghrq = new JTextField();
    JLabel jLabel9 = new JLabel();
    JTextField jTghsl = new JTextField();
    JLabel jLabel10 = new JLabel();
    JTextField jTghmc = new JTextField();
    JLabel jLabel11 = new JLabel();
    JTextField jTghjyr = new JTextField();
    JLabel jLabel12 = new JLabel();
    JTextField jTghwhsl = new JTextField();
    JLabel jLabel13 = new JLabel();
    JTextField jTghghrq = new JTextField();
    JLabel jLabel14 = new JLabel();
    JTextField jTghghsl = new JTextField();
    private int seleTabIndex;
    JButton jBlook = new JButton();

    public JF_zcxx_inout() {
    try {
      jbInit();
      buildTable();
    }

    catch(Exception ex) {
      ex.printStackTrace();
    }
  }
private void buildTable(){
    Obj_zcxx objzcxx = null;
    Obj_inout objinout = null;
    java.util.Vector vname = new java.util.Vector();
    java.util.Vector vnamegh = new java.util.Vector();
    vname.addElement("资产编号");
    vname.addElement("资产名称");
    vname.addElement("资产型号");
    vname.addElement("资产单价");
    vname.addElement("资产数量");
    vname.addElement("资产金额");
    vname.addElement("生产厂家");
    vname.addElement("生产日期");
    vname.addElement("购买日期");
    vname.addElement("购买人");
    vname.addElement("库存数量");
    deaultTableModel = new DefaultTableModel(vname,0);

    vnamegh.addElement("流水号");
    vnamegh.addElement("设备编号");
    vnamegh.addElement("设备名称");
    vnamegh.addElement("借出部门");
    vnamegh.addElement("借出数量");
    vnamegh.addElement("借出日期");
    vnamegh.addElement("借用人");
    deaultTableModel_gh = new DefaultTableModel(vnamegh,0);
    facadeObject = GlobaBean.facadeObject;
    System.out.println("facadeobject = " + facadeObject);
    System.out.println("facadeQueryObject = " + GlobaBean.facadeQueryObject);
    java.util.Collection collection = null;
    java.util.Iterator iterator = null;
    try{
      collection = facadeObject.getAllzcxx();
      //System.out.println("collection = " + collection);
      iterator = collection.iterator();
      //System.out.println("iterator = " + iterator);
      for(;iterator.hasNext();){
        java.util.Vector vdata = new java.util.Vector();
        objzcxx = (Obj_zcxx)iterator.next();
        vdata.addElement(objzcxx.getzcBh().trim());
        vdata.addElement(objzcxx.getZcmc().trim());
        vdata.addElement(objzcxx.getZcxh().trim());
        vdata.addElement(objzcxx.getZcdj());
        vdata.addElement(objzcxx.getZcsl());
        vdata.addElement(objzcxx.getZcje());
        vdata.addElement(objzcxx.getSccj().trim());
        vdata.addElement(objzcxx.getScrq());
        vdata.addElement(objzcxx.getGmrq());
        vdata.addElement(objzcxx.getGmr().trim());
        vdata.addElement(String.valueOf(objzcxx.getKcsl()).trim());
        String sts = null;
        sts = objzcxx.getSts().trim();
        System.out.println(objzcxx.getSts());
        if (sts.equals("T")){ //库存状态为"T"表示存在库存
            deaultTableModel.addRow(vdata);
        }


      }
        jTable1.setModel(deaultTableModel);
        jTable1.setRowHeight(20);
        String tName[] = {"流水号","设备编号","设备名称","借出部门","借出数量","借出日期","借用人"};
        String strSql = "SELECT i.lsh, x.zcbh, x.zcmc, i.jcbm, i.jcsl, i.jcrq, i.jyr FROM t_inout i ,t_zcxx x WHERE (i.zcbh = x.zcbh) and  (i.whsl > 0)";

        QueryTableEJB queryTable = new QueryTableEJB("");

        queryTable.setColumnName(tName);
        deaultTableModel_gh = queryTable.getTableModel(strSql);


        jTable2.setModel(deaultTableModel_gh);
        jTable2.setRowHeight(20);
        this.jTghbh.setText("");
        this.jTghghrq.setText("");
        this.jTghghsl.setText("");
        this.jTghjyr.setText("");
        this.jTghmc.setText("");
        this.jTghrq.setText("");
        this.jTghwhsl.setText("");
        this.jTghsl.setText("");
    }catch(java.rmi.RemoteException remote){
      remote.printStackTrace();
    }



}
  void jbInit() throws Exception {
      this.getContentPane().setLayout(borderLayout1);
      jTabbedPane1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jTabbedPane1.addChangeListener(new
                                     JF_zcxx_inout_jTabbedPane1_changeAdapter(this));
      jPanel1.setLayout(borderLayout2);
      jPanel2.setLayout(borderLayout3);
      jPanel1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jBsave.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jBsave.setText("数据存盘");
      jBsave.addActionListener(new JF_zcxx_inout_jBsave_actionAdapter(this));
      jBexit.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jBexit.setText("退出");
      jBexit.addActionListener(new JF_zcxx_inout_jBexit_actionAdapter(this));
      jPanel3.setLayout(flowLayout1);
      flowLayout1.setAlignment(FlowLayout.RIGHT);
      jSplitPane1.setOrientation(JSplitPane.VERTICAL_SPLIT);
      jPanel4.setLayout(gridLayout1);
      gridLayout1.setColumns(4);
      gridLayout1.setRows(3);
      jLabel1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jLabel1.setHorizontalAlignment(SwingConstants.CENTER);
      jLabel1.setText("设备编号");
      jTbh.setText("");
      jLabel2.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jLabel2.setHorizontalAlignment(SwingConstants.CENTER);
      jLabel2.setText("设备名称");
      jTsl.setText("");
      jTsl.addKeyListener(new JF_zcxx_inout_jTsl_keyAdapter(this));
      jLabel3.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jLabel3.setHorizontalAlignment(SwingConstants.CENTER);
      jLabel3.setText("借出部门");
      jLabel4.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jLabel4.setHorizontalAlignment(SwingConstants.CENTER);
      jLabel4.setText("借出数量");
      jTbm.setText("");
      jLabel5.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jLabel5.setHorizontalAlignment(SwingConstants.CENTER);
      jLabel5.setText("借用人");
      jTjyr.setText("");
      jTmc.setText("");
      jLabel6.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jLabel6.setHorizontalAlignment(SwingConstants.CENTER);
      jLabel6.setText("借用日期");
      jTrq.setText("");
      this.setClosable(true);
      this.setTitle("资产/设备借出归还登记情况");
      jTable1.addMouseListener(new JF_zcxx_inout_jTable1_mouseAdapter(this));
      jSplitPane2.setOrientation(JSplitPane.VERTICAL_SPLIT);
        jSplitPane2.setLastDividerLocation(175);
        jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
                                              VERTICAL_SCROLLBAR_ALWAYS);
      jPanel5.setLayout(gridLayout2);
      gridLayout2.setColumns(4);
      gridLayout2.setRows(4);
      jLabel7.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jLabel7.setHorizontalAlignment(SwingConstants.CENTER);
      jLabel7.setText("设备编号");
      jTghbh.setText("");
      jLabel8.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jLabel8.setHorizontalAlignment(SwingConstants.CENTER);
      jLabel8.setText("设备名称");
      jTghrq.setText("");
      jLabel9.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jLabel9.setHorizontalAlignment(SwingConstants.CENTER);
      jLabel9.setText("借出日期");
      jTghsl.setText("");
      jLabel10.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jLabel10.setHorizontalAlignment(SwingConstants.CENTER);
      jLabel10.setText("借出数量");
      jTghmc.setText("");
      jLabel11.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
      jLabel11.setHorizontalAlignment(SwingConstants.CENTER);
      jLabel11.setText("归还日期");
      jTghjyr.setText("");