mainframe.java

资金源码管理系统,用java开发的,有用的人可以试试看

    this.JtextZGbz.setText("");
    this.JtextZGname.setText("");
    this.JtextZGnum.setText("");
    this.JtextZGwork.setText("");
    this.MainLBid.setText("");
    this.MainLBname.setText("");
    this.SonLBid.setText("");
    this.SonLBname.setText("");
  }

  //关于---关于本系统子菜单
  public void AboutsystemMnu_actionPerformed(ActionEvent e) {
    //实例化一个关于窗口对像
    AboutDialog about = new AboutDialog(this, "资产管理系统 - http://bbs.lr20.com", true);
    about.setSize(new Dimension(550, 300));
    //居中显示开始
    AssetManager am = new AssetManager();
    am.dialogCenterDisplay(about);
    //居中显示结束
    about.setVisible(true); //设置关于窗口为可见
  }

  // ---------------------------------------------------------------------------
  //资产管理--按钮
  public void JbtnZC_actionPerformed(ActionEvent e) {
    btnchangecss(JbtnZC, "btnzc");
    ChangeComponent.Panelchange(contentPane, WelcomePanel, JspanelFortable,
                                ZGEditPanel,
                                LBEditPanel,
                                JYGHEditPanel,
                                ZCEditPanel, jPanelBrowse, "General");

    ChangeComponent.btnchange(JbtnZCinsert, JbtnZCdel, JbtnZCchange,
                              JbtnZCselect, //设置本行按钮不可见
                              CboxforZCselect, "forBtn");

    flag = 1;
    this.cleanText();
    // 录入日期
    String lrdate = "" + objCalendar.get(Calendar.YEAR)
        + "-" + (objCalendar.get(Calendar.MONTH) + 1)
        + "-" + objCalendar.get(Calendar.DATE);

    this.JtextZCdate.setText(lrdate);
    this.JtextZCdate.setEnabled(false);

    //初始化jTable1表
    AssetManager am = new AssetManager();
    String sql = "select * from asset where deleteflag = 1";
    am.displayAsset(jTable1, sql);

  }

//资产管理菜单--增加子菜单
  public void ZCinsertMnu_actionPerformed(ActionEvent e) {
    //调用资产管理按钮事件
    JbtnZC_actionPerformed(e);
    JbtnZCchange.setVisible(false); //关闭修改按钮
    JbtnZCdel.setVisible(false); //关闭删除按钮
  }

  //资产管理菜单--修改子菜单
  public void ZCchangeMnu_actionPerformed(ActionEvent e) {
    //调用资产管理按钮事件
    JbtnZC_actionPerformed(e);
    JbtnZCinsert.setVisible(false); //关闭增加按钮
    JbtnZCdel.setVisible(false); //关闭删除按钮

    JtextZCdate.setEnabled(true); //设置录入日期可编辑
  }

  //资产管理菜单--修改子菜单
  public void ZCdelMnu_actionPerformed(ActionEvent e) {
    //调用资产管理按钮事件
    JbtnZC_actionPerformed(e);
    JbtnZCinsert.setVisible(false); //关闭增加按钮
    JbtnZCchange.setVisible(false); //关闭修改按钮

  }
  // ---------------------------------------------------------------------------
  //职工管理--按钮
  public void JbtnZG_actionPerformed(ActionEvent e) {
    btnchangecss(JbtnZG, "btnzg");
    ChangeComponent.Panelchange(contentPane, WelcomePanel, JspanelFortable,
                                ZCEditPanel,
                                LBEditPanel,
                                JYGHEditPanel,
                                ZGEditPanel, jPanelBrowse, "General");
    ChangeComponent.btnchange(JbtnZGinsert, JbtnZGdel, JbtnZGchange,
                              JbtnZGselect, //设置本行按钮不可见
                              CboxforZGselect, "forBtn");
    flag = 2;
    this.cleanText();

    //读入职工表
    EmpManager empM = new EmpManager();
    String sql = "select * from employee where deleteflag = 1";
    empM.displayEmp(jTable1, sql);
  }

  //职工管理菜单 --增加菜单
  public void ZGinsertMnu_actionPerformed(ActionEvent e) {
    //调用职工管理按钮事件
    JbtnZG_actionPerformed(e);
    JbtnZGdel.setVisible(false); //关闭删除按钮
    JbtnZGchange.setVisible(false); //关闭修改按钮
  }

//职工管理菜单  --修改菜单
  public void ZGchangeMnu_actionPerformed(ActionEvent e) {
    //调用职工管理按钮事件
    JbtnZG_actionPerformed(e);
    JbtnZGdel.setVisible(false); //关闭删除按钮
    JbtnZGinsert.setVisible(false); //关闭增加按钮

  }

//职工管理菜单 --删除菜单
  public void ZGdelMnu_actionPerformed(ActionEvent e) {
    //调用职工管理按钮事件
    JbtnZG_actionPerformed(e);
    JbtnZGchange.setVisible(false); //关闭修改按钮
    JbtnZGinsert.setVisible(false); //关闭增加按钮

  }
  // ---------------------------------------------------------------------------
  // 资产类别管理 --按钮
  public void JbtnLB_actionPerformed(ActionEvent e) {
    //改变当前按纽
    btnchangecss(JbtnLB, "btnlb");
    //隐藏查询条件下拉
    CboxforLBselect.setVisible(false);
    //改变当前界面
    ChangeComponent.Panelchange(contentPane, WelcomePanel, JspanelFortable,
                                ZGEditPanel,
                                ZCEditPanel,
                                JYGHEditPanel,
                                LBEditPanel, jPanelBrowse, "General");

    ChangeComponent.btnchange(JbtnLBinsert, JbtnLBdel, JbtnLBchange,
                              JbtnLBselect, //设置本行按钮不可见
                              CboxforZCselect, "forBtn");

    flag = 3;
    this.cleanText();

    //读入资产类别表
    AssetTypeManager assetType = new AssetTypeManager();
    String sql = "select * from category where deleteflag = 1";
    assetType.displayAssetType(jTable1, sql);
  }

  //类别管理菜单 --增加菜单
  public void LBinsertMnu_actionPerformed(ActionEvent e) {
    //调用资产类别管理按钮事件
    JbtnLB_actionPerformed(e);
    JbtnLBchange.setVisible(false); //关闭修改按钮
    JbtnLBdel.setVisible(false); //关闭删除按钮
  }

  //类别管理菜单 --修改菜单
  public void LBchangeMnu_actionPerformed(ActionEvent e) {
    //调用资产类别管理按钮事件
    JbtnLB_actionPerformed(e);
    JbtnLBinsert.setVisible(false); //关闭增加按钮
    JbtnLBdel.setVisible(false); //关闭删除按钮

  }

  //类别管理菜单 --删除菜单
  public void LBdelMnu_actionPerformed(ActionEvent e) {
    //调用资产类别管理按钮事件
    JbtnLB_actionPerformed(e);
    JbtnLBinsert.setVisible(false); //关闭增加按钮
    JbtnLBchange.setVisible(false); //关闭修改按钮

  }
  // ---------------------------------------------------------------------------
  //资产借用管理 --按钮
  public void JbtnJY_actionPerformed(ActionEvent e) {

    btnchangecss(JbtnJY, "btnjy");
    ChangeComponent.Panelchange(contentPane, WelcomePanel, JspanelFortable,
                                ZCEditPanel,
                                LBEditPanel,
                                ZGEditPanel,
                                JYGHEditPanel, jPanelBrowse, "General");
    ChangeComponent.btnchange(btnJY, btnJYGH, JbtnLBinsert,
                              btnJHselect, //设置本行按钮不可见
                              jCboxforJYGHselect, "forBtn");
    // 读入可借资产编号,状态标志为"正常"
    if (count == 1) {
      try {
        stmt = con.createStatement();
        rs = stmt.executeQuery(
            "select assetid from asset where status = '正常' and asset.deleteflag = 1");

        jCboxZCnum.addItem("---请选择---");
        while (rs.next()) {
          jCboxZCnum.addItem(rs.getObject(1));
        }
        ConnectionManager.closeResultSet(rs);
        ConnectionManager.closeStatement(stmt);
      }
      catch (SQLException ex1) {
      }

      // 读入可借用人的编号
      try {
        stmt = con.createStatement();
        rs = stmt.executeQuery(
            "select ename from employee where deleteflag = 1");
        jCboxJYname.addItem("---请选择---");
        while (rs.next()) {
          jCboxJYname.addItem(rs.getObject(1));
        }
        ConnectionManager.closeResultSet(rs);
        ConnectionManager.closeStatement(stmt);
      }
      catch (SQLException ex2) {
      }
      count++;
    }

    flag = 4;
    this.cleanText();

    // 借用,归还日期
    String lrdate = "" + objCalendar.get(Calendar.YEAR)
        + "-" + (objCalendar.get(Calendar.MONTH) + 1)
        + "-" + objCalendar.get(Calendar.DATE);

    this.JtextJYdate.setText(lrdate);
    this.JtextGHdate.setText(lrdate);
    this.JtextJYdate.setEnabled(false);
    this.JtextGHdate.setEnabled(false);
    this.JtextEditname.setEditable(false);

    // 读入借用归还表
    LendManager lmTable = new LendManager();
    String sql = "select * from lend where deleteflag = 1";
    lmTable.displayLendMag(jTable1, sql);

  }

  //借还管理菜单  --借用菜单
  public void JYMnu_actionPerformed(ActionEvent e) {
    //调用资产借用管理按钮事件
    JbtnJY_actionPerformed(e);
    btnJYGH.setVisible(false); //关闭归还按钮
  }

  //借用管理菜单  --归还菜单
  public void GHMnu_actionPerformed(ActionEvent e) {
    //调用资产借用管理按钮事件
    JbtnJY_actionPerformed(e);
    btnJY.setVisible(false); //关闭借用按钮

  }
  // ---------------------------------------------------------------------------
  // 鼠标点击表格监听
  public void jTable1_mouseClicked(MouseEvent e) {
    //BUTTON1常量  指示鼠标按键 #1；由 getButton() 使用。
    if (e.getButton() == e.BUTTON1) {
      int row = jTable1.getSelectedRow(); //getSelectedRow()   返回首个选定行的索引，如果没有选定的行，则返回 -1。
      DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
      switch (flag) {
        case 1: //当flag设为1 表示将jTable1固定资产信息选中行的值设到相应的编辑框中
          this.JtextZCNNum.setText(model.getValueAt(row, 0).toString());
          this.JtextZCName.setText(model.getValueAt(row, 1).toString());
          String bignum = model.getValueAt(row, 2).toString();
          String smallnum = model.getValueAt(row, 3).toString();
          String bigname;
          String smallname;
          try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(
                "select catename from category where deleteflag = 1 and cateid = " +
                Integer.parseInt(bignum));
            if (rs.next()) {
              bigname = rs.getString(1);
              this.Jcboxmanclass.setSelectedItem(bigname);
              // System.out.println(bigname);

            }
            rs = stmt.executeQuery(
                "select subcatename from category where deleteflag = 1 and subcateid = " +
                Integer.parseInt(smallnum));
            if (rs.next()) {
              smallname = rs.getString(1);
              this.Jcboxsonclass.setSelectedItem(smallname);
            }
          }
          catch (SQLException ex) {
          }

          //样式有可能为空，会产生空对像异常，故需作异常处理
          try {
            this.JtextZCcss.setText(model.getValueAt(row, 4).toString());
          }
          catch (NullPointerException ex) {
            this.JtextZCcss.setText("");
          }

          this.JtextZCprice.setText(model.getValueAt(row, 5).toString());