selectorpanel.java~1~

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

             }
             });
          //删除键点击响应
          deleteButton.addMouseListener(new java.awt.event.MouseAdapter(){
               public void mouseClicked(MouseEvent edelete){
                  deleteButton_mouseClicked(edelete);
             }
             });
          //保存键点击响应
          saveButton.addMouseListener(new java.awt.event.MouseAdapter(){
               public void mouseClicked(MouseEvent esave){
                 saveButton_mouseClicked(esave);
                 //refreshButton_mouseClicked(esave);
              }
             });
          //刷新回滚键点击响应
          refreshButton.addMouseListener(new java.awt.event.MouseAdapter(){
               public void mouseClicked(MouseEvent erefresh){
                 refreshButton_mouseClicked();
             }
             });
        } else
        {
            firstButton.removeMouseListener(new MouseListener());
            priorButton.removeMouseListener(new MouseListener());
            nextButton.removeMouseListener(new MouseListener());
            lastButton.removeMouseListener(new MouseListener());
            insertButton.removeMouseListener(new MouseListener());
            deleteButton.removeMouseListener(new MouseListener());
            saveButton.removeMouseListener(new MouseListener());
            refreshButton.removeMouseListener(new MouseListener());
        }

     }

     public boolean isShowRollover(){
         return showRollover;
     }

     public void setShowTooltips(boolean showTooltips){
         this.showTooltips = showTooltips;
         if(showTooltips){
             firstButton.setToolTipText("移到首行");
             priorButton.setToolTipText("移到前一行");
             nextButton.setToolTipText("移到下一行");
             lastButton.setToolTipText("移到最后一行");
             insertButton.setToolTipText("增加一行");
             deleteButton.setToolTipText("删除当前行");
             //postButton.setToolTipText("确认修改当前行");
             //cancelButton.setToolTipText("取消修改");
             //dittoButton.setToolTipText("拷贝当前行");
             saveButton.setToolTipText("保存当前行");
             refreshButton.setToolTipText("恢复");
         } 
	 else{
             firstButton.setToolTipText(null);
             priorButton.setToolTipText(null);
             nextButton.setToolTipText(null);
             lastButton.setToolTipText(null);
             insertButton.setToolTipText(null);
             deleteButton.setToolTipText(null);
             //postButton.setToolTipText(null);
             //cancelButton.setToolTipText(null);
             //dittoButton.setToolTipText(null);
             saveButton.setToolTipText(null);
             refreshButton.setToolTipText(null);
         }
     }

     public boolean isShowTooltips(){
         return showTooltips;
     }

     public void setAlignment(int alignment){
         LayoutManager layout = getLayout();
         if(layout instanceof FlowLayout)
             ((FlowLayout)layout).setAlignment(alignment);
     }

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

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

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

    //选择最后一行
    public void lastButton_mouseClicked(MouseEvent elast){
        int rowNum;
        int colNum;
        int rowCount;
        int viewHigh;
        JViewport jvp=jsp_mod.getViewport();
        if(modTable.isVisible()){
            if(modTable.getRowCount()==1){
                //无数据,不响应
            }
            else{
                //有数据,响应
                viewHigh=modTable.getHeight();
                rowCount=modTable.getRowCount();
                rowNum=modTable.getSelectedRow();
                if(rowNum==modTable.getRowCount()){
                    //已在尾行,不动作
                }
                else{
                    //不在尾行,响应并设视点
                    modTable.setRowSelectionInterval(rowCount-2,rowCount-2);
                    jvp.setViewPosition(new Point(0,viewHigh));
                    jvp.setView(modTable);
                }
            }
        }
        else{}
    }
    //删除当前行
    public void deleteButton_mouseClicked(MouseEvent edelete){
        int rowNum;
        int colNum;
        int rowCount;
        String KeyValue;
        rowCount=modTable.getRowCount();
        JViewport jvp=jsp_mod.getViewport();
        if(rowCount==1){
                //无数据,不响应
        }
        else{
	    //有数据,响应
            rowNum=modTable.getSelectedRow();
            colNum=modTable.getSelectedColumn();
            if(rowNum==-1 || rowNum==modTable.getRowCount()-1){
		//没有选中作何行,或选中空白行，无动作
            }
            else{
		 //选中非最后空白行,响应并设视点
                 //取关键列对应值
                 KeyValue=modTable.getValueAt(rowNum,0).toString();
		 errMsg=pm.delPowerMod(KeyValue) ;
                 //:test:System.out.println("Keyvalue="+KeyValue);
                 //确定删除当前行的弹出框提示
                 int n = JOptionPane.showConfirmDialog(
                            this ,"确定删除当前行?",
                            "确认提示",
                            JOptionPane.YES_NO_OPTION);
                 if (n == JOptionPane.YES_OPTION) {
		       //确定删除    
		       //显示返回信息
		       if(errMsg.equals("success")){
			    //删除成功:
                            JOptionPane.showMessageDialog(this,"已成功删除当前行!",
                                     "成功信息",
				     JOptionPane.QUESTION_MESSAGE);
                            tvm.removeTableRows(rowNum);
                       }
                       else{
			    //删除失败:
                            errMsg=getErrMsg(errMsg);
                            JOptionPane.showMessageDialog(this,"删除失败:\n"+errMsg,
                                     "错误提示",
                                     JOptionPane.QUESTION_MESSAGE);

		       }
		 }
            }
        }
    } 
    //增加一行
    public void insertButton_mouseClicked(MouseEvent einsert){
        JViewport jvp=jsp_mod.getViewport();
        if(modTable.getRowCount()==1){
	    //无数据,选中首行
            modTable.setRowSelectionInterval(0,0);
	    tvm.setValueAt("0",0,0) ;
        }
        else{
	    //已有数据,选中最后一行并设视点
            rowCount=modTable.getRowCount();
            colNum=modTable.getSelectedColumn();
	    tvm.setValueAt(Integer.toString(Integer.parseInt(modTable.getValueAt(rowCount-2,0).toString())+1),rowCount-1,0) ;
            modTable.setRowSelectionInterval(rowCount-1,rowCount-1);
            jvp.setViewPosition(new Point(0,modTable.getHeight()));
            jvp.setView(modTable);
        }
    }
    //保存修改或增加当前行
    public void saveButton_mouseClicked(MouseEvent esave){
        Vector colValues;
        rowCount=modTable.getRowCount();
        colCount=modTable.getColumnCount();
        rowNum=modTable.getSelectedRow();
        colNum=modTable.getSelectedColumn();
        //:test:System.out.println("rowCount:"+rowCount);
        //:test:System.out.println("colCount:"+colCount);
        //未选中任何行
	if(rowNum==-1){}
        else{
	    //增加当前行
            int m = JOptionPane.showConfirmDialog(
                              this ,"确定保存当前行?",
                              "确认提示",
                              JOptionPane.YES_NO_OPTION);
            if(m == JOptionPane.YES_OPTION) {
		 //取当前行的值
		 Vector columnValue = new Vector();
                 for(count=1;count<=colCount;count++){
		    columnValue.addElement(modTable.getValueAt(rowNum,count-1));
                    System.out.println("column1="+columnValue.elementAt(count-1));
		 }
                //增加一条
		errMsg=pm.insertPowerMod(columnValue) ;
		setGroupPower(groupname);
		System.out.println("insertmodsql:"+pm.getSQL());
                 //String errMsg="success";//ins.getErrMsg();
                 if(errMsg.equals("success")){
		    //增加成功:
                    //tv.insertTableRows(columnValue,rowNum);
                    //tv.addTableRows();
                    JOptionPane.showMessageDialog(this,"已成功保存信息!",
                                 "成功信息",