mainframe.java

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

package boco.shabank.dbmanager;

import java.util.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.tree.*;
import javax.swing.table.*;
import javax.swing.border.*;
import java.sql.*;
import javax.swing.UIManager;
import javax.swing.border.Border;
import javax.swing.border.EmptyBorder;
import javax.swing.event.ChangeEvent;
import javax.swing.event.ChangeListener;
//import javax.swing.plaf.ComponentUI;
import javax.swing.plaf.metal.MetalToolBarUI;
import javax.swing.table.TableModel;
import javax.swing.event.TableModelEvent;
import javax.swing.JTable;
import javax.swing.table.JTableHeader;
import javax.swing.table.TableColumn;
import javax.swing.table.TableColumnModel;
import javax.swing.table.AbstractTableModel;
import javax.swing.JViewport;
import javax.swing.JOptionPane;
import javax.swing.JDialog;


public class mainFrame extends JFrame {
  final Frame thisframe=this;
  getDBTKey getKey = new getDBTKey();
  String Key;
  int KeyAt;
  //treepath数组
  Object[] objArr;
  String errMsg;
    //保存执行的SQL语句
  String sql="";
  String KeyType;
  //保存当前数据源名的全局变量
  String DBSourceName;
  //保存当前数据表名的全局变量
  String DBTableName;
    //当前行
  int curRow=0;
  //当前列
  int curCol=0;
  //当前总行数
  int rowTotal=0;
  //jcombobox的位置
  int atBox=0;
  //保存当前列名称的向量
  Vector columnNames=new Vector();
  //保存当前所有列类型的向量
  Vector columnTypeName=new Vector();
  //保存当前行的所有值向量
  Vector columnValue=new Vector();
  //当前Table的高度值
  int tableHigh=0;
  //当前Table的高度值
  //TableSorter sorter=new TableSorter();
  JToolBar navToolBar = new JToolBar();
  //create the UI container
  JPanel contentPane;
  JScrollPane JScroll;
  //create the table and tablevalues
   JTable jTableMode;
   TableValue tv;

   String nodetmp="";
  //create the tree
  DefaultMutableTreeNode top =  new DefaultMutableTreeNode("数据管理");
  JTree jTree1 = new JTree(top);
  JScrollPane treeView = new JScrollPane(jTree1);
  DefaultTreeCellRenderer treeRenderer = new DefaultTreeCellRenderer();

  //create the items in the tree
  DefaultMutableTreeNode node1 = null;
  DefaultMutableTreeNode child1 = null;
  DefaultMutableTreeNode child1_level1 = null;
  //DefaultMutableTreeNode child1_level2 = null;
  //DefaultMutableTreeNode child2 = null;
  //DefaultMutableTreeNode child2_level1 = null;

  //define the control button and init their character
  private JButton firstButton;
  private JButton priorButton;
  private JButton nextButton;
  private JButton lastButton;
  private JButton insertButton;
  private JButton deleteButton;
  //private JButton postButton;
  //private JButton cancelButton;
  private JButton dittoButton;
  private JButton saveButton;
  private JButton refreshButton;
  public static final int AUTO_ENABLED = 0;
  public static final int AUTO_HIDDEN = 1;
  public static final int ENABLED = 2;
  public static final int DISABLED = 3;
  public static final int HIDDEN = 4;
  private boolean showRollover=true;
  private boolean showTooltips=true;
  private int buttonStateFirst=0;
  private int buttonStatePrior=0;
  private int buttonStateNext=0;
  private int buttonStateLast=0;
  private int buttonStateInsert=0;
  private int buttonStateDelete=0;
  private int buttonStatePost=0;
  private int buttonStateCancel=0;
  private int buttonStateDitto=0;
  private int buttonStateSave=0;
  private int buttonStateRefresh=0;
  private Border emptyButtonBorder;
  private Border normalButtonBorder;
  private int orientation=0;
  //private ComponentUI ui;
    static Frame getFrame(Component c) {
        while((c = c.getParent()) != null) {
            if(c instanceof Frame)
                return (Frame)c;
        }
        return null;
    }
  //Construct the frame
  public mainFrame() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }

  //init control button
  private void initButtons(JToolBar toolbar)
     {
         firstButton = initButton("first.gif");
         emptyButtonBorder = new EmptyBorder(firstButton.getBorder().getBorderInsets(firstButton));
         normalButtonBorder=UIManager.getBorder("Button.border");
         toolbar.add(firstButton);
         priorButton = initButton("prior.gif");
         toolbar.add(priorButton);
         nextButton = initButton("next.gif");
         toolbar.add(nextButton);
         lastButton = initButton("last.gif");
         toolbar.add(lastButton);
         insertButton = initButton("insert.gif");
         toolbar.add(insertButton);
         deleteButton = initButton("delete.gif");
         toolbar.add(deleteButton);
         //postButton = initButton("post.gif");
         //toolbar.add(postButton);
         //cancelButton = initButton("cancel.gif");
         //toolbar.add(cancelButton);
         dittoButton = initButton("ditto.gif");
         toolbar.add(dittoButton);
         saveButton = initButton("save.gif");
         toolbar.add(saveButton);
         refreshButton = initButton("refresh.gif");
         toolbar.add(refreshButton);
     }
     /*class ButtonMouseListener extends MouseAdapter {
     public void mouseEntered (MouseEvent e) { }
     public void mouseExited  (MouseEvent e) { }
     public void mousePressed (MouseEvent e) { }
     public void mouseReleased(MouseEvent e) { }
     public void mouseClicked (MouseEvent e) {
          this.mouseClicked(e);
     }
 }*/
     class MouseListener extends MouseAdapter{
       public void mouseClicked(MouseEvent e){
             //sorter.insertrow(table);
           }

       public void mousePressed(MouseEvent e)
       {
       }

       public void mouseReleased(MouseEvent e)
       {
           JButton button = (JButton)e.getSource();
           if(showRollover)
               if(button.isEnabled())
               {
                   //if(!(ui instanceof MetalToolBarUI))
                      // button.setBorder(normalButtonBorder);
               } else
               {
                   button.setBorder(emptyButtonBorder);
               }
       }

       public void mouseEntered(MouseEvent e)
       {
           JButton button = (JButton)e.getSource();
           if(showRollover && button.isEnabled())
               button.setBorder(normalButtonBorder);
       }

     public void mouseExited(MouseEvent e)
       {
           JButton button = (JButton)e.getSource();
           if(showRollover)
               button.setBorder(emptyButtonBorder);
     }
     }
     private JButton initButton(String imageName)
     {
         JButton jButton = new JButton(new ImageIcon(getClass().getResource("/image/".concat(String.valueOf(String.valueOf(imageName))))));
         jButton.addMouseListener(new MouseListener());
         jButton.setMargin(new Insets(0, 0, 0, 0));
         //add(jButton);
         return jButton;
     }
      public void setShowRollover(boolean showRollover)
     {
        if("Mac".equals(UIManager.getLookAndFeel().getID()))
           showRollover=false;
        this.showRollover = showRollover;
        if(showRollover)
        {
          //移到第一行键点击响应
          firstButton.addMouseListener(new java.awt.event.MouseAdapter(){
              public void mouseClicked(MouseEvent efirst){
                firstButton_mouseClicked(efirst);
            }
            });
          //移到前一行键点击响应
          priorButton.addMouseListener(new java.awt.event.MouseAdapter(){
              public void mouseClicked(MouseEvent eprior){
                priorButton_mouseClicked(eprior);
            }
            });
          //移到下一行键点击响应
          nextButton.addMouseListener(new java.awt.event.MouseAdapter(){
              public void mouseClicked(MouseEvent enext){
                nextButton_mouseClicked(enext);
            }
            });
          //移到最后一行键点击响应
          lastButton.addMouseListener(new java.awt.event.MouseAdapter(){
              public void mouseClicked(MouseEvent elast){
                lastButton_mouseClicked(elast);
            }
            });
          //增加一行键点击响应
          insertButton.addMouseListener(new java.awt.event.MouseAdapter(){
               public void mouseClicked(MouseEvent einsert){
                 insertButton_mouseClicked(einsert);
             }
             });
          //删除键点击响应
          deleteButton.addMouseListener(new java.awt.event.MouseAdapter(){
               public void mouseClicked(MouseEvent edelete){
                 deleteButton_mouseClicked(edelete);
             }
             });
	  //拷贝当前行：
	  dittoButton.addMouseListener(new java.awt.event.MouseAdapter(){
               public void mouseClicked(MouseEvent editto){
                 dittoButton_mouseClicked(editto);
             }
             });
          //保存键点击响应
          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(erefresh);
             }
             });
        } 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)