mainframe.java

农业银行ATM对帐查询系统后台类包的源代码,实现了FTP,数据库管理等等功能

          if(judgeType.equals("非静态表")||actPower==1){
            navToolBar.setVisible(false);
          }
          //静态表或其它
          else{
            navToolBar.setVisible(true);
          }
          //取得所有DBFID
          Vector DBFID = new Vector();
          DBFID = DBField.getAllDBFID();
          pubDBFID = DBFID;
          //取得所有DBTID
          Vector DBTID = new Vector();
          DBTID = DBField.getAllDBTID();
          pubDBTID = DBTID;
          //取得所有DBFNAME
          Vector DBFName = new Vector();
          DBFName = DBField.getAllDBFName();
          pubDBFName = DBFName;
          //取得所有DBFNAMECN
          Vector DBFNameCN = new Vector();
          DBFNameCN = DBField.getAllDBFNameCN();
          pubDBFNameCN = DBFNameCN;
          //取得所有DBFOperator
          Vector DBFOperator = new Vector();
          DBFOperator = DBField.getAllDBFOperator();
          pubDBFOperator = DBFOperator;
          //取得所有DBFType
          Vector DBFType = new Vector();
          DBFType = DBField.getAllDBFType();
          pubDBFType = DBFType;

          Flen = DBFID.size();
          //:test:System.out.println("Flen:"+Flen);
          if(Flen>0){
            for(ti=1;ti<=Flen;ti++){
              String Field = DBFNameCN.elementAt(ti-1).toString().trim();
              if(DBSourceName.equalsIgnoreCase("dbmng")){
                Field = A2C.AsciiToChineseString(Field);
              }
              if(ti==1) {jLabelField1.setText(Field+":");jTextCon1.setEnabled(true);}
              if(ti==2) {jLabelField2.setText(Field+":");jTextCon2.setEnabled(true);}
              if(ti==3) {jLabelField3.setText(Field+":");jTextCon3.setEnabled(true);}
              if(ti==4) {jLabelField4.setText(Field+":");jTextCon4.setEnabled(true);}
              if(ti==5) {jLabelField5.setText(Field+":");jTextCon5.setEnabled(true);}
              if(ti==6) {jLabelField6.setText(Field+":");jTextCon2.setEnabled(true);}
              if(ti==7) {jLabelField7.setText(Field+":");jTextCon2.setEnabled(true);}
              if(ti==8) {jLabelField8.setText(Field+":");jTextCon2.setEnabled(true);}
            }
          }
          //取得当前表关键字,唯一
          getKey.getKey(DBTableName);
          Key=getKey.getKey();
          //:test:System.out.println("Key="+Key);
          pubView(pathnode,node,Key,false,"");
        }
        else{
          jButtonConExec.setEnabled(false);
          jButtonInpExec.setEnabled(false);
          navToolBar.setVisible(false);
          if(jTableMode!=null)
            JScroll.setVisible(false);
        }
      }
    }
  }
//:响应树点击结束
//******************************************************************************

//******************************************************************************
//处理各BUTTONS响应事件开始:

//选择每一行
  public void firstButton_mouseClicked(){
    int rowNum;
    JViewport jvp=JScroll.getViewport();
    if(jTableMode!=null)
    {
      if(jTableMode.getRowCount()==1){
        //无数据,不进行响应
      }
      else
      {
        //有数据,响应并将视点置于行首
        rowNum=jTableMode.getSelectedRow();
        jTableMode.setRowSelectionInterval(0,0);
        jvp.setViewPosition(new Point(0,0));
        jvp.setView(jTableMode);
      }
    }
  }

//选择前一行
  public void priorButton_mouseClicked(){
    int rowNum;
    int colNum;
    int viewHigh;
    int rowCount;
    JViewport jvp=JScroll.getViewport();
    if(jTableMode!=null)
    {
      if(jTableMode.getRowCount()==1){
        //无数据,不响应
      }
      else
      {
        //有数据,响应
        rowCount=jTableMode.getRowCount();
        rowNum=jTableMode.getSelectedRow();
        colNum=jTableMode.getSelectedColumn();
        if(rowNum==-1){
          //当前表未被选中,选中第一行
          jTableMode.setRowSelectionInterval(0,0);
          jvp.setViewPosition(new Point(0,0));
          jvp.setView(jTableMode);
        }
        else{
          viewHigh=(rowNum-1)*jTableMode.getHeight()/rowCount;
          if(rowNum==0){
            //已在首行,置视点
            jvp.setViewPosition(new Point(0,0));
            jvp.setView(jTableMode);
          }
          else{
            //不在首行,响应并设视点
            jTableMode.setRowSelectionInterval(rowNum-1,rowNum-1);
            jvp.setViewPosition(new Point(0,viewHigh));
            jvp.setView(jTableMode);
          }
        }
      }
    }
  }

//选择下一行
  public void nextButton_mouseClicked(){
    int rowNum;
    int colNum;
    int viewHigh;
    int rowCount;
    JViewport jvp=JScroll.getViewport();
    if(jTableMode!=null)
    {
      if(jTableMode.getRowCount()==1){
        //无数据,不响应
      }
      else
      {
        //有数据,响应
        rowNum=jTableMode.getSelectedRow();
        colNum=jTableMode.getSelectedColumn();
        rowCount=jTableMode.getRowCount();
        viewHigh=(rowNum+1)*jTableMode.getHeight()/rowCount;
        if(rowNum+1==jTableMode.getRowCount()){
          //已在尾行,不响应
        }
        else{
          //不在尾行,响应并设置视点
          jTableMode.setRowSelectionInterval(rowNum+1,rowNum+1);
          jvp.setViewPosition(new Point(0,viewHigh));
          jvp.setView(jTableMode);
        }
      }
    }
  }

//选择最后一行
  public void lastButton_mouseClicked(){
    int rowNum;
    int colNum;
    int rowCount;
    int viewHigh;
    JViewport jvp=JScroll.getViewport();
    if(jTableMode!=null)
    {
      if(jTableMode.getRowCount()==1){
        //无数据,不响应
      }
      else
      {
        //有数据,响应
        viewHigh=jTableMode.getHeight();
        rowCount=jTableMode.getRowCount();
        rowNum=jTableMode.getSelectedRow();
        if(rowNum==jTableMode.getRowCount()){
          //已在尾行,不动作
        }
        else{
          //不在尾行,响应并设视点
          jTableMode.setRowSelectionInterval(rowCount-2,rowCount-2);
          jvp.setViewPosition(new Point(0,viewHigh));
          jvp.setView(jTableMode);
        }
      }
    }
  }

//增加一行
  public void insertButton_mouseClicked(){
    int rowNum;
    int colNum;
    int rowCount;
    JViewport jvp=JScroll.getViewport();
    if(jTableMode!=null)
    {
      if(jTableMode.getRowCount()==1){
        //无数据,选中首行
        jTableMode.setRowSelectionInterval(0,0);
      }
      else
      {
        //已有数据,选中最后一行并设视点
        rowCount=jTableMode.getRowCount();
        colNum=jTableMode.getSelectedColumn();
        jTableMode.setRowSelectionInterval(rowCount-1,rowCount-1);
        jvp.setViewPosition(new Point(0,jTableMode.getHeight()));
        jvp.setView(jTableMode);
      }
    }
  }

//删除当前行
  public void deleteButton_mouseClicked(){
    int rowNum;
    int colNum;
    int rowCount;
    Vector KeyValue=new Vector();
    rowCount=jTableMode.getRowCount();
    JViewport jvp=JScroll.getViewport();
    if(jTableMode!=null)
    {
      if(rowCount==1){
        //无数据,不响应
      }
      else
      {
        //有数据,响应
        rowNum=jTableMode.getSelectedRow();
        colNum=jTableMode.getSelectedColumn();
        if(rowNum==-1){
          //示选中作何行,无动作
        }
        else{
          if(rowNum==jTableMode.getRowCount()-1){
            //选中最后空白行,无动作
          }
          else{
            //选中非最后空白行,响应并设视点
            //取关键列对应值
            for(int i=0;i<KeyAt.size();i++)
              KeyValue.addElement(jTableMode.getValueAt(rowNum,Integer.parseInt(KeyAt.elementAt(i).toString())).toString());
            //:test:System.out.println("Keyvalue="+KeyValue);
            //确定删除当前行的弹出框提示
            int n = JOptionPane.showConfirmDialog(
                this ,"确定删除当前行?",
                "确认提示",
                JOptionPane.YES_NO_OPTION);
            if (n == JOptionPane.YES_OPTION) {
              //确定删除
              doDelCurRow del=new doDelCurRow();
              //:test:System.out.println("DBSourceName:"+DBSourceName);
              //:test:System.out.println("DBTableName:"+DBTableName);
              //:test:System.out.println("Key:"+Key);
              //:test:System.out.println("KeyValue:"+KeyValue);
              //:test:System.out.println("KeyType:" + KeyType);
              del.doDelCurRow(DBSourceName,DBTableName,Key,KeyValue,KeyType);
              //显示返回信息
              errMsg=del.getErrMsg();
              if(errMsg.equals("success")){
                //删除成功:
                tv.removeTableRows(rowNum);
                JOptionPane.showMessageDialog(this,"已成功删除当前行!",
                    "成功信息",
                    JOptionPane.INFORMATION_MESSAGE);

              }
              else{
                //删除失败:
                errMsg=getErrMsg(errMsg);
                JOptionPane.showMessageDialog(this,"删除失败:\n"+errMsg,
                    "错误提示",
                    JOptionPane.ERROR_MESSAGE);

              }
            }
          }
        }
      }
    }
  }
//拷贝当前行
  public void dittoButton_mouseClicked(){
    int rowCount=jTableMode.getRowCount();
    int colCount=jTableMode.getColumnCount();
    int rowNum=jTableMode.getSelectedRow();
    int colNum=jTableMode.getSelectedColumn();
    //columnValue.removeAll(columnValue);
    if(jTableMode!=null){
      if(rowNum==-1 || rowNum == rowCount-1){
        //未选中任何行
      }
      else{
        for(int i=0;i<colCount;i++){
          tv.setValueAt(jTableMode.getValueAt(rowNum,i),rowCount-1,i) ;
        }
        jTableMode.setRowSelectionInterval(rowCount-1,rowCount-1);
      }
    }
  }
//保存修改或增加当前行
  public void saveButton_mouseClicked(){
    int count;
    int rowNum;
    int colNum;
    int rowCount;
    int colCount;
    Vector colValues;
    JViewport jvp=JScroll.getViewport();
    tableHigh = jTableMode.getHeight();
    //:test:System.out.println("tableHigh:"+tableHigh);
    if(jTableMode!=null)
    {
      //有数据,响应并设视点
      //处于编辑状态
      rowCount=jTableMode.getRowCount();
      colCount=jTableMode.getColumnCount();
      rowNum=jTableMode.getSelectedRow();
      colNum=jTableMode.getSelectedColumn();
      //:test:System.out.println("rowCount:"+rowCount);
      //:test:System.out.println("colCount:"+colCount);
      if(rowNum==-1){
        //未选中任何行
      }
      else{
        if(rowNum==jTableMode.getRowCount()-1){
          if(jTableMode.isEditing()){
            jTableMode.getCellEditor().stopCellEditing();
            jTableMode.setRowSelectionInterval(rowNum,rowNum);
          }
          //增加当前行
          int m = JOptionPane.showConfirmDialog(
              this ,"确定增加当前行?",
              "确认提示",
              JOptionPane.YES_NO_OPTION);
          if (m == JOptionPane.YES_OPTION) {
            //确定增加
            //取当前行的值
            columnValue.removeAll(columnValue);
            for(count=1;count<=colCount;count++){
              columnValue.addElement(jTableMode.getValueAt(rowNum,count-1));
              //:test:System.out.println(columnValue.elementAt(count-1));
            }
            //取SQL语句
            //:输入:tablename,vector columntype,vector columnvalue
            //:输出:string sql
            getSQLstring sq = new getSQLstring();