mainframe.java

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

        TableCellRenderer headerRenderer = powerColumn.getHeaderRenderer();
        if (headerRenderer instanceof DefaultTableCellRenderer) {
            ((DefaultTableCellRenderer)headerRenderer).setToolTipText(
                     "点击选择类型");
        }
    }

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

    //选择前一行
    public void priorButton_mouseClicked(MouseEvent eprior){
        int rowNum;
        int colNum;
        int viewHigh;
        int rowCount;
        JViewport jvp=JScroll.getViewport();
        if(jTableMode.isVisible()){
            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);
                    }
                }
            }
        }
        else{}
    }

    //选择下一行
    public void nextButton_mouseClicked(MouseEvent enext){
        int rowNum;
        int colNum;
        int viewHigh;
        int rowCount;
        JViewport jvp=JScroll.getViewport();
        if(jTableMode.isVisible()){
            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);
                }
            }
        }
        else{}
    }

    //选择最后一行
    public void lastButton_mouseClicked(MouseEvent elast){
        int rowNum;
        int colNum;
        int rowCount;
        int viewHigh;
        JViewport jvp=JScroll.getViewport();
        if(jTableMode.isVisible()){
            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);
                }
            }
        }
        else{}
    }
    //增加一行
    public void insertButton_mouseClicked(MouseEvent einsert){
        int rowNum;
        int colNum;
        int rowCount;
        JViewport jvp=JScroll.getViewport();
        if(jTableMode.isVisible()){
            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);
            }
        }
        else{}
    }

    //删除当前行
    public void deleteButton_mouseClicked(MouseEvent edelete){
        int rowNum;
        int colNum;
        int rowCount;
        String KeyValue;
        rowCount=jTableMode.getRowCount();
        JViewport jvp=JScroll.getViewport();
        if(jTableMode.isVisible()){
            if(rowCount==1){
                //无数据,不响应
            }
            else{
                //有数据,响应
                rowNum=jTableMode.getSelectedRow();
                colNum=jTableMode.getSelectedColumn();
                if(rowNum==-1){
                    //示选中作何行,无动作
                }
                else{
                    if(rowNum==jTableMode.getRowCount()-1){
                        //选中最后空白行,无动作
                    }
                    else{
                        //选中非最后空白行,响应并设视点
                        //取关键列对应值
			DefaultMutableTreeNode node = (DefaultMutableTreeNode)jTree1.getLastSelectedPathComponent();
			if(node.getLastChild().isLeaf()){
                            KeyValue=jTableMode.getValueAt(rowNum,KeyAt).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")){
				    //删除成功:
                                    JOptionPane.showMessageDialog(this,"已成功删除当前行!",
                                        "成功信息",
                                        JOptionPane.QUESTION_MESSAGE);
                                    //int row=jTableMode.getSelectedRow();
                                    //System.out.println("row="+row);
                                    //System.out.println("valuesAt="+jTableMode.getValueAt(rowNum,1).toString());
                                    this.delNode(jTableMode.getValueAt(rowNum,1).toString()) ;
                                    tv.removeTableRows(rowNum);
                                }
                                else{
                                    //删除失败:
                                    errMsg=getErrMsg(errMsg);
                                    JOptionPane.showMessageDialog(this,"删除失败:\n"+errMsg,
                                        "错误提示",
                                        JOptionPane.QUESTION_MESSAGE);

                                }
                            }
                            else{}
			}
			else{
			    JOptionPane.showMessageDialog(this,"删除失败，请先删除子项！",
                                     "错误提示",
                                     JOptionPane.QUESTION_MESSAGE);
			}

                    }
                }
            }
        }
        else{}
    }
    public void dittoButton_mouseClicked(MouseEvent editto){
        int rowCount=jTableMode.getRowCount();
        int colCount=jTableMode.getColumnCount();
        int rowNum=jTableMode.getSelectedRow();
        int colNum=jTableMode.getSelectedColumn();
	//columnValue.removeAll(columnValue);
        if(jTableMode.isVisible()){
	    if(rowNum==-1 || rowNum == rowCount-1){
                    //未选中任何行
            }
	    else{
	        for(int i=0;i<colCount;i++){
		    //System.out.println("jtabalemodevale:"+jTableMode.getValueAt(rowNum,i));
	            tv.setValueAt(jTableMode.getValueAt(rowNum,i),rowCount-1,i) ;
                }
		 jTableMode.setRowSelectionInterval(rowCount-1,rowCount-1);
	    }
        }
	else{}
    }
    //保存修改或增加当前行
    public void saveButton_mouseClicked(MouseEvent esave){
        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.isVisible()){
                //有数据,响应并设视点
                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(jTableMode.isEditing()){
			jTableMode.getCellEditor().stopCellEditing();
			jTableMode.setRowSelectionInterval(rowNum,rowNum) ;
		    }
                    if(rowNum==jTableMode.getRowCount()-1){
                        //增加当前行
                        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));
                                //System.out.println("column1="+columnValue.elementAt(count-1));
                            }
                            //取SQL语句
                            CreateSql cq = new CreateSql();
                            sql=cq.getInsertString(objArr,DBSourceName,DBTableName,columnTypeName,columnNames,columnValue) ;
                            //System.out.println("createSql =="+sql) ;
                            //:test:System.out.println("DBTableName:"+DBTableName+" + "+DBSourceName);
                            //*sql = sq.getInsertString(DBSourceName,DBTableName,columnTypeName,columnValue);
                            //增加一条
                            doRunSQL ins = new doRunSQL();
                            ins.doRunSQL(DBSourceName,sql);
                            //取返回信息
                            errMsg=ins.getErrMsg();