mainframe.java

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

          this.JtextZCdate.setText(model.getValueAt(row, 6).toString());
          this.JcboxZCsta.setSelectedItem(model.getValueAt(row, 7).toString());

          //经办人有可能为空，会产生空对像异常，故须作异常处理
          try {
            this.JtextZCuser.setText(model.getValueAt(row, 8).toString());
          }
          catch (NullPointerException ex) {
            this.JtextZCuser.setText("");
          }

          //资产备注有可能为空，会产生空对像异常，故需作异常处理
          try {
            this.JtextZCbz.setText(model.getValueAt(row, 9).toString());
          }
          catch (NullPointerException ex) {
            this.JtextZCbz.setText("");
          }
          break
              ;

        case 2: //当flag设为2 表示将jTable1职员信息选中行的值设到相应的编辑框中
          this.JtextZGnum.setText(model.getValueAt(row, 0).toString());
          this.JtextZGname.setText(model.getValueAt(row, 1).toString());
          this.JtextZGwork.setText(model.getValueAt(row, 2).toString());
          try {
            this.JtextZGbz.setText(model.getValueAt(row, 3).toString());
          }
          catch (NullPointerException ex) {
            this.JtextZGbz.setText("");
          }

          break
              ;
        case 3: //当flag设为3 表示将jTable1固定资产类别信息选中行的值设到相应的编辑框中
          this.MainLBid.setText(model.getValueAt(row, 0).toString());
          this.MainLBname.setText(model.getValueAt(row, 1).toString());
          this.SonLBid.setText(model.getValueAt(row, 2).toString());
          try {
            this.SonLBname.setText(model.getValueAt(row, 3).toString());
          }
          catch (NullPointerException ex) {
          }

          break;
        case 4: //当flag设为4 表示将jTable1归还信息 选中行的值设到相应的编辑框中
          break;
      }
    }
    if (e.getButton() == e.BUTTON3) {
      this.cleanText();
    }

  }

  //用户管理---增加新用户子菜单
  public void NewuserMnu_actionPerformed(ActionEvent e) {
    NewUserDialog newuser = new NewUserDialog(this,
                                              "资产管理系统--增加新用户", true);
    newuser.setSize(new Dimension(380, 250));
    //居中显示开始
    AssetManager am = new AssetManager();
    am.dialogCenterDisplay(newuser);
    //居中显示结束
    newuser.setVisible(true);
  }

// -----------------------------------------------------------------
  // 资产管理-增加按钮
  public void JbtnZCinsert_actionPerformed(ActionEvent e) {
    AssetModel assetModel = new AssetModel();
    AssetManager assetmanager = new AssetManager();

    if (JtextZCNNum.getText().equals("")) {
      JOptionPane.showMessageDialog(this, "请填写资产编号");
      JtextZCNNum.requestFocus();
      return;
    }
    char[] ch = JtextZCNNum.getText().toCharArray();
    if (ch.length != 6) {
      JOptionPane.showMessageDialog(this, "编号长度必须为6位");
      JtextZCNNum.requestFocus();
      return;
    }
    for (int i = 0; i < ch.length; i++) {
      if (! (Character.isDigit(ch[i]))) {
        JOptionPane.showMessageDialog(this, "编号必须为数字");
        JtextZCNNum.requestFocus();
        return;
      }
    }
    if (ch[0] != '1') {
      JOptionPane.showMessageDialog(this, "编号第一位数字必须为1");
      JtextZCNNum.requestFocus();
      return;

    } // 主键约束-资产编号
    try {
      stmt = con.createStatement();
      rs = stmt.executeQuery(
          "select assetid from ASSET where assetid = "
          + Integer.parseInt(JtextZCNNum.getText()));
      if (rs.next()) {
        JOptionPane.showMessageDialog(null, "编号冲突，无法插入!!");
        rs.close();
        stmt.close();
        return;
      }
    }
    catch (SQLException ex1) {

    }

    if (JtextZCName.getText().equals("")) {
      JOptionPane.showMessageDialog(this, "请填写资产名称");
      JtextZCName.requestFocus();
      return;
    }
    else if (Jcboxmanclass.getSelectedIndex() == 0) {
      JOptionPane.showMessageDialog(this, "请选择大类");
      Jcboxmanclass.requestFocus();
      return;
    }
    else if (Jcboxsonclass.getSelectedIndex() == 0) {
      JOptionPane.showMessageDialog(this, "请选择小类");
      Jcboxmanclass.requestFocus();
      return;
    }
    else if (JtextZCprice.getText().equals("")) {
      JOptionPane.showMessageDialog(this, "请填写价格");
      JtextZCprice.requestFocus();
      return;
    }
    else if (JtextZCdate.getText().equals("")) {
      JOptionPane.showMessageDialog(this, "请填写录入日期");
      JtextZCdate.requestFocus();
      return;
    }
    else if (JcboxZCsta.getSelectedIndex() == 0) {
      JOptionPane.showMessageDialog(this, "请选择状态");
      JcboxZCsta.requestFocus();
      return;
    }

    //设置资产
    String bignum = null;
    String smallnum = null;
    assetModel.setassedid(JtextZCNNum.getText());
    assetModel.setasset_name(JtextZCName.getText());
    try {
      rs = stmt.executeQuery(
          "select DISTINCT cateid from category where catename like '"
          + Jcboxmanclass.getSelectedItem().toString() + "'");
      while (rs.next()) {
        bignum = rs.getString(1);
      }

      rs = stmt.executeQuery(
          "select DISTINCT subcateid from category where subcatename like '"
          + Jcboxsonclass.getSelectedItem().toString() + "'");
      while (rs.next()) {
        smallnum = rs.getString(1);
      }

      assetModel.setcateid(bignum);
      assetModel.setsubcateid(smallnum);
      assetModel.setmodel(JtextZCcss.getText());
      assetModel.setprice(JtextZCprice.getText());
      assetModel.setpurchase_date(JtextZCdate.getText());
      assetModel.setstatus(JcboxZCsta.getSelectedItem().toString());
      assetModel.setuseby(JtextZCuser.getText());
      assetModel.setremarks(JtextZCbz.getText());

      assetmanager.addToAsset(assetModel);
      JOptionPane.showMessageDialog(this, "成功添加一条记录");
      DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
      model.addRow(new Object[] {JtextZCNNum.getText(),
                   JtextZCName.getText(),
                   bignum, smallnum, JtextZCcss.getText(),
                   JtextZCprice.getText(),
                   JtextZCdate.getText(),
                   JcboxZCsta.getSelectedItem().toString(), JtextZCuser.getText(),
                   JtextZCbz.getText()});
      jTable1.setModel(model);

      cleanText();

    }
    catch (SQLException ex) {
      System.out.println(ex);
    }
  }

  // 资产管理-修改按钮
  public void JbtnZCchange_actionPerformed(ActionEvent e) {
    AssetModel assetModel = new AssetModel();
    AssetManager assetmanager = new AssetManager();
    char[] ch = JtextZCNNum.getText().toCharArray();
    if (JtextZCNNum.getText().equals("")) {
      JOptionPane.showMessageDialog(this, "请填写要修改的资产编号");
      JtextZCNNum.requestFocus();
      return;
    }
    if (JtextZCName.getText().equals("")) {
      JOptionPane.showMessageDialog(this, "请填写资产名称");
      JtextZCName.requestFocus();
      return;
    }
    else if (Jcboxmanclass.getSelectedIndex() == 0) {
      JOptionPane.showMessageDialog(this, "请选择大类");
      Jcboxmanclass.requestFocus();
      return;
    }
    else if (Jcboxsonclass.getSelectedIndex() == 0) {
      JOptionPane.showMessageDialog(this, "请选择小类");
      Jcboxmanclass.requestFocus();
      return;
    }
    else if (JtextZCprice.getText().equals("")) {
      JOptionPane.showMessageDialog(this, "请填写价格");
      JtextZCprice.requestFocus();
      return;
    }
    else if (JtextZCdate.getText().equals("")) {
      JOptionPane.showMessageDialog(this, "请填写录入日期");
      JtextZCdate.requestFocus();
      return;
    }
    else if (JcboxZCsta.getSelectedIndex() == 0) {
      JOptionPane.showMessageDialog(this, "请选择状态");
      JcboxZCsta.requestFocus();
      return;
    }

    //设置资产
    String bignum = null;
    String smallnum = null;
    assetModel.setassedid(JtextZCNNum.getText());
    assetModel.setasset_name(JtextZCName.getText());
    try {
      rs = stmt.executeQuery(
          "select DISTINCT cateid from category where catename like '"
          + Jcboxmanclass.getSelectedItem().toString() + "'");
      while (rs.next()) {
        bignum = rs.getString(1);
      }
      rs.close();
      rs = stmt.executeQuery(
          "select DISTINCT subcateid from category where subcatename like '"
          + Jcboxsonclass.getSelectedItem().toString() + "'");
      while (rs.next()) {
        smallnum = rs.getString(1);
      }
      rs.close();

      assetModel.setcateid(bignum);
      assetModel.setsubcateid(smallnum);

      assetModel.setmodel(JtextZCcss.getText());
      assetModel.setprice(JtextZCprice.getText());
      assetModel.setpurchase_date(JtextZCdate.getText());
      assetModel.setstatus(JcboxZCsta.getSelectedItem().toString());
      assetModel.setuseby(JtextZCuser.getText());
      assetModel.setremarks(JtextZCbz.getText());

      assetmanager.updateAsset(assetModel);
      JOptionPane.showMessageDialog(this, "成功更新一条记录");
      //------ 更新tableBrowse模板 开始 ------
      AssetManager am = new AssetManager();
      String sql = "select * from Asset where deleteflag = 1";
      am.displayAsset(jTable1, sql);
      //------ 更新tableBrowse模板 结束 ------

    }
    catch (SQLException ex) {
      JOptionPane.showMessageDialog(this, "无此类别");
    }
    this.cleanText();
    Jcboxmanclass.setSelectedIndex(0);
    Jcboxsonclass.setSelectedIndex(0);
    JcboxZCsta.setSelectedIndex(0);
  }

  // 资产管理-删除按钮
  public void JbtnZCdel_actionPerformed(ActionEvent e) {
    AssetModel assetModel = new AssetModel();
    AssetManager assetmanager = new AssetManager();

    assetModel.setassedid(JtextZCNNum.getText());
    if (JtextZCNNum.getText().length() == 0) {
      JOptionPane.showMessageDialog(this, "请输入要删除的资产编号！");
      return;
    }

    try {
      stmt = con.createStatement();
      rs = stmt.executeQuery(
          "select assetid from asset where deleteflag = '1' and assetid=" +
          Integer.parseInt(JtextZCNNum.getText()));
      //System.out.println(rs.getString(1));
      if (! (rs.next())) {
        JOptionPane.showMessageDialog(this, "无