mainframe.java

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

     {
         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;
     }

  //Component initialization
  public void jbInit() throws Exception  {

    //UI container
    contentPane = (JPanel) this.getContentPane();
    contentPane.setLayout(null);
    this.setSize(new Dimension(800, 600));
    this.setTitle("DB Control Center");
    //this.setResizable(false);
    //initialize the control buttons and show them
    navToolBar.setFloatable(false);
    navToolBar.setLayout(new FlowLayout());
    navToolBar.setBounds(new Rectangle(247, 17, 540, 40));
    initButtons(navToolBar);
    setShowRollover(!"Mac".equals(UIManager.getLookAndFeel().getID()));
    //ComponentUI ui = navToolBar.getUI();
    setShowTooltips(true);
    //emptyButtonBorder = new EmptyBorder(firstButton.getBorder().getBorderInsets(firstButton));
    //normalButtonBorder = UIManager.getBorder("Button.border");
    //ui = getUI();
    if(showRollover )
    {
      firstButton.setBorder(emptyButtonBorder);
      priorButton.setBorder(emptyButtonBorder);
      nextButton.setBorder(emptyButtonBorder);
      lastButton.setBorder(emptyButtonBorder);
      insertButton.setBorder(emptyButtonBorder);
      deleteButton.setBorder(emptyButtonBorder);
      //postButton.setBorder(emptyButtonBorder);
      //cancelButton.setBorder(emptyButtonBorder);
      dittoButton.setBorder(emptyButtonBorder);
      saveButton.setBorder(emptyButtonBorder);
      refreshButton.setBorder(emptyButtonBorder);
    }

    //initializes tree and creates tree selection event listener
    createNodes(top);
    jTree1.setEditable(false);
    jTree1.getSelectionModel().setSelectionMode(TreeSelectionModel.CONTIGUOUS_TREE_SELECTION);
    jTree1.setShowsRootHandles(true);
    jTree1.addMouseListener(new java.awt.event.MouseAdapter() {
                    public void mouseClicked(MouseEvent exp) {
                    jTree1_mouseClicked(exp);
                    }
                });
    treeView.setVerticalScrollBarPolicy(JScrollPane.VERTICAL_SCROLLBAR_ALWAYS);
    treeView.setViewportBorder(BorderFactory.createEtchedBorder());
    treeView.setBounds(new Rectangle(5, 14, 240, 550));
    //show tree object
    contentPane.add(treeView, null);
    //show toolbar and textarea
    contentPane.add(navToolBar, null);
}

  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      System.exit(0);
    }
  }

  //method createNodes to add nodes to the tree
  public void createNodes(DefaultMutableTreeNode top) {
      DBSourceManager DBSource = new DBSourceManager();
      //DBTableManager DBTable = new DBTableManager();
      DBSource.getAllSourceRecode();
      Vector DBSID = new Vector();
      DBSID = DBSource.getAllDBSID();
      Vector DBSName = new Vector();
      DBSName = DBSource.getAllDBSName();
      Vector DBTName1 = new Vector();
      Vector DBTName2 = new Vector();
      //显示树
      for(int i=0 ;i<DBSID.size();i++){
        //显示所有数据源
        //System.out.println("dbsid="+DBSID.size()) ;
        DBTableManager DBTable = new DBTableManager(DBSID.elementAt(i).toString());
        Vector DBTType = new Vector();
        DBTType = DBTable.getAllDBTType() ;
        node1 = new DefaultMutableTreeNode(DBSName.elementAt(i).toString());
        top.add(node1);
        //显示数据表类型
        for(int j = 0;j<DBTType.size() ;j++){
            child1 = new DefaultMutableTreeNode(DBTType.elementAt(j).toString() );
            node1.add(child1);
            //test:System.out.println("i="+DBSID.elementAt(i).toString());
            //test:System.out.println("j="+DBTType.elementAt(j).toString());
            DBTableManager dbtm = new DBTableManager();
            dbtm.getAllTableRecode(DBSID.elementAt(i).toString(),DBTType.elementAt(j).toString());
            Vector vTabename = new Vector();
            vTabename = dbtm.getAllDBTName();
            //test:System.out.println("size="+vTabename.size());
            //显示所有表
            for(int k=0 ;k<vTabename.size();k++){
                //test：System.out.println(vTabename.elementAt(k).toString());
                child1_level1 = new DefaultMutableTreeNode(vTabename.elementAt(k).toString());
                child1.add(child1_level1);
            }
        }
      }
    }
    //显示树结束
    //*****************************************************************

    //响应树地鼠标事件根据节点不同加载不同地表格模板
    void jTree1_mouseClicked(MouseEvent exp){
      DefaultMutableTreeNode node = (DefaultMutableTreeNode)jTree1.getLastSelectedPathComponent();
      if(node!=null && !nodetmp.equals(node.toString())){
        nodetmp=node.toString() ;
        TreePath pathnode = (TreePath)jTree1.getLeadSelectionPath();
        if(((exp.getModifiers()&InputEvent.BUTTON3_MASK)!=0)&&(jTree1.getSelectionCount()>0)&&(!node.isLeaf())&&(!node.isRoot())){
          showMenu(exp.getX(),exp.getY());
        }
        if(node.getLevel()==0){
          tv=new TableValue("dbsource","dbsid");
          DBTableName="dbsource";
          Key = "dbsid";
          DBSourceName="access";
          columnNames=tv.getAllColumnName() ;
          columnTypeName=tv.getAllColumnTypeName() ;
        }
        else if(node.getLevel()==1){
          tv = new TableValue(node,"dbtid");
          Key = "dbtid";
          DBTableName="dbtable";
          DBSourceName="access";
          columnNames=tv.getAllColumnName() ;
          columnTypeName=tv.getAllColumnTypeName() ;
          atBox=2;
        }
        else if(node.getLevel()==2){
          String DBS_Name=pathnode.getPathComponent(1).toString();
          Key = "dbtid";
          DBTableName="dbtable";
          tv = new TableValue(node,"dbtid",DBS_Name);
          DBSourceName="access";
          columnNames=tv.getAllColumnName() ;
          columnTypeName=tv.getAllColumnTypeName() ;
          atBox=2;
        }
        else if(node.getLevel()==3){
          String DBS_Name=pathnode.getPathComponent(1).toString();
          String TableType=pathnode.getPathComponent(2).toString();
          Key = "dbfid";
          DBTableName="dbfield";
          DBSourceName="access";
          tv = new TableValue(node,"dbfid",DBS_Name,TableType);
          columnNames=tv.getAllColumnName() ;
          columnTypeName=tv.getAllColumnTypeName() ;
          atBox=5;
        }
        else{
          tv=new TableValue("dbsource","dbsid");
          DBTableName="dbsource";
          Key = "dbsid";
          DBSourceName="access";
          columnNames=tv.getAllColumnName() ;
          columnTypeName=tv.getAllColumnTypeName() ;
          atBox=0;
        }
        //清空当前所有数据显示,重新载入
        contentPane.removeAll();
        contentPane.add(treeView, null);
        contentPane.add(navToolBar, null);
        //contentPane.add(ta,null);
        objArr = pathnode.getPath();
        //for(int i=0;i<objArr.length ;i++){
        //System.out.println("parhArr="+objArr[i].toString() ) ;
        //}
        //System.out.println("treePath="+pathnode.getPath());

        KeyAt=tv.getKeyAt();
        KeyType=tv.getKeyType();
        //sorter.setModel(tv);
        //定义JTable并设置属性/响应事件
        jTableMode = new JTable(tv);
        if(node.getLevel() == 3){
          setFieldType(jTableMode.getColumnModel().getColumn(5));
        }
        jTableMode.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        jTableMode.setAutoscrolls(true);
        jTableMode.setRowSelectionAllowed(true);   //允许行选择
        jTableMode.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
        jTableMode.addMouseListener(new java.awt.event.MouseAdapter(){
          public void mouseClicked(MouseEvent etm){
            jTableMode_mouseClicked(etm);
          }
        });
        //响应排序
        //sorter.addMouseListenerToHeaderInTable(jTableMode);
        //初始化JScrollPane并设置属性
        JScroll = new JScrollPane(jTableMode);
        JScroll.setAutoscrolls(true);
        JScroll.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
        JScroll.setVerticalScrollBarPolicy(JScrollPane.VERTICAL_SCROLLBAR_ALWAYS);
        JScroll.setViewportBorder(BorderFactory.createEtchedBorder());
        JScroll.setBounds(new Rectangle(250, 60, 540, 500));
        //初始化JViewport并设置属性
        JViewport jvp=new JViewport();
        jvp.setView(new RowNumberHeader(jTableMode));
        JScroll.setRowHeader(jvp);
        //显示与清除
        contentPane.add(JScroll,null);
        JScroll.remove(jTableMode);
        jTableMode.removeAll();
      }
    }

    //********************************************************************
    //添加到权限模块菜单
    //********************************************************************
    void showMenu(int x,int y){
    	//System.out.println("x="+x+"y="+y);
         JPopupMenu popup = new JPopupMenu();
         jTree1.add(popup) ;
         JMenuItem mi1=new JMenuItem("添加权限管理");
         popup.add(mi1);
         //菜单监听事件
	 popup.show(jTree1,x,y);
         mi1.addActionListener(new ActionListener(){
              public void actionPerformed(ActionEvent ae){
                     addPowerMod();
              }
            });

    }
    void addPowerMod(){
	 TreePath path=jTree1.getSelectionPath();
	 CustomDialog customDialog = new CustomDialog(thisframe,path.toString(),"2","3");
	 customDialog.pack();
	 customDialog.setVisible(true);
	 //System.out.println("dialogend");
    }

    //ComboBox
    public void setFieldType(TableColumn powerColumn) {
        //Set up the editor for the sport cells.
        JComboBox comboBox = new JComboBox();
        comboBox.addItem("CHAR");
        comboBox.addItem("INT");
        powerColumn.setCellEditor(new DefaultCellEditor(comboBox));
	//modTable.setRowSelectionInterval(modTable.getSelectedRow(),0);
        //Set up tool tips for the sport cells.
        DefaultTableCellRenderer renderer =
                new DefaultTableCellRenderer();
        renderer.setToolTipText("点击选择类型");
        powerColumn.setCellRenderer(renderer);

        //Set up tool tip for the sport column header.