mainframe.java~220~

JAVA+SQL2000 网吧上下机管理

package netbar;

import java.awt.*;
import java.awt.event.*;

import javax.swing.*;
import javax.swing.JTable;
import java.awt.Dimension;
import java.awt.Font;
import javax.swing.BorderFactory;
import javax.swing.border.TitledBorder;
import java.awt.Color;
import java.util.Vector;
import java.io.IOException;
import java.lang.*;
import java.util.Date;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class mainFrame extends JFrame {
    JPanel contentPane;
    JMenuBar jMenuBar1 = new JMenuBar();
    JMenu jMenuFile = new JMenu();
    JMenuItem jMenuFileExit = new JMenuItem();
    JToolBar jToolBar = new JToolBar();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    JButton jButton6 = new JButton();
    JButton jButton7 = new JButton();
    JButton jButton8 = new JButton();
    JButton jButton9 = new JButton();
    JButton jButton10 = new JButton();
    JButton jButton11 = new JButton();
    ImageIcon image1 = new ImageIcon(netbar.mainFrame.class.getResource(
            "member.png"));
    ImageIcon image2 = new ImageIcon(netbar.mainFrame.class.getResource(
            "common.png"));
    ImageIcon image3 = new ImageIcon(netbar.mainFrame.class.getResource(
            "act.png"));
    ImageIcon image4 = new ImageIcon(netbar.mainFrame.class.getResource(
            "online.png"));
    ImageIcon image5 = new ImageIcon(netbar.mainFrame.class.getResource(
            "outline.png"));
    ImageIcon image6 = new ImageIcon(netbar.mainFrame.class.getResource(
            "add.png"));
    ImageIcon image7 = new ImageIcon(netbar.mainFrame.class.getResource(
            "sell.png"));
    ImageIcon image8 = new ImageIcon(netbar.mainFrame.class.getResource(
            "set.png"));
    ImageIcon image9 = new ImageIcon(netbar.mainFrame.class.getResource(
            "admin.png"));
    ImageIcon image10 = new ImageIcon(netbar.mainFrame.class.getResource(
            "change.png"));
    ImageIcon image11 = new ImageIcon(netbar.mainFrame.class.getResource(
            "exit.png"));
    JMenuItem jMenuItem1 = new JMenuItem();
    JMenuItem jMenuItem2 = new JMenuItem();
    JMenuItem jMenuItem3 = new JMenuItem();
    JMenuItem jMenuItem4 = new JMenuItem();
    JMenuItem jMenuItem5 = new JMenuItem();
    JMenu jMenu1 = new JMenu();
    JMenuItem jMenuItem6 = new JMenuItem();
    JMenuItem jMenuItem7 = new JMenuItem();
    JMenu jMenu2 = new JMenu();
    JMenuItem jMenuItem8 = new JMenuItem();
    JMenuItem jMenuItem9 = new JMenuItem();
    JMenu jMenu3 = new JMenu();
    JMenuItem jMenuItem10 = new JMenuItem();
    JMenuItem jMenuItem11 = new JMenuItem();
    JMenu jMenu4 = new JMenu();
    JMenuItem jMenuItem12 = new JMenuItem();
    JMenuItem jMenuItem13 = new JMenuItem();
    JMenuItem jMenuItem14 = new JMenuItem();
    JMenuItem jMenuItem15 = new JMenuItem();
    JMenuItem jMenuItem16 = new JMenuItem();
    JMenuItem jMenuItem17 = new JMenuItem();
    JMenu jMenu5 = new JMenu();
    JMenuItem jMenuItem18 = new JMenuItem();
    JMenuItem jMenuItem19 = new JMenuItem();
    JMenuItem jMenuItem20 = new JMenuItem();
    JMenuItem jMenuItem21 = new JMenuItem();
    JLabel jLabelDate = new JLabel();
    JLabel jLabelinfo = new JLabel();
    JLabel jLabelstat1 = new JLabel();
    TitledBorder titledBorder1 = new TitledBorder("");
    JLabel jLabelstat2 = new JLabel();
    JLabel jLabelstat3 = new JLabel();
    TitledBorder titledBorder2 = new TitledBorder("");
    JScrollPane jScrollPane1 = new JScrollPane(JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
    JTable jTable1 = new JTable();
    GridBagLayout gridBagLayout1 = new GridBagLayout();
    JLabel jLabel1 = new JLabel();
    public mainFrame() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(gridBagLayout1);
        setSize(new Dimension(846, 609));
        setTitle("SunnyNetbar System");
        setIconImage(Toolkit.getDefaultToolkit().createImage(netbar.mainFrame.class.getResource("logo.png")));
        jMenuFile.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuFile.setMnemonic('S');
        jMenuFile.setText("系统设置S");
        jMenuFileExit.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuFileExit.setText("退出系统");
        jMenuFileExit.addActionListener(new
                                        mainFrame_jMenuFileExit_ActionAdapter(this));
        jToolBar.setBackground(UIManager.getColor("Button.background"));
        jToolBar.setFont(new java.awt.Font("Tahoma", Font.PLAIN, 18));
        jToolBar.setBorder(null);
        jToolBar.setFloatable(false);
        jMenuItem1.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem1.setText("管理员设置");
        jMenuItem2.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem2.setText("数据库备份");
        jMenuItem3.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem3.setText("设置客户端");
        jMenuItem4.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem4.setText("修改密码");
        jMenuItem4.addActionListener(new mainFrame_jMenuItem4_actionAdapter(this));
        jMenuItem5.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem5.setText("系统设置");
        jMenu1.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenu1.setMnemonic('K');
        jMenu1.setText("卡类管理K");
        jMenuItem6.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem6.setText("会员用户卡管理");
        jMenuItem6.addActionListener(new mainFrame_jMenuItem6_actionAdapter(this));
        jMenuItem7.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem7.setText("普通用户卡管理");
        jMenuItem7.addActionListener(new mainFrame_jMenuItem7_actionAdapter(this));
        jMenu2.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenu2.setMnemonic('C');
        jMenu2.setText("商品管理C");
        jMenuItem8.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem8.setText("商品销售");
        jMenuItem9.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem9.setText("商品管理");
        jMenu3.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenu3.setMnemonic('A');
        jMenu3.setText("资产管理A");
        jMenuItem10.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem10.setText("资产领用人员管理");
        jMenuItem11.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem11.setText("资产领用信息管理");
        jMenu4.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenu4.setMnemonic('I');
        jMenu4.setText("信息查询I");
        jMenuItem12.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem12.setText("系统日志");
        jMenuItem13.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem13.setText("结账记录");
        jMenuItem14.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem14.setText("充值记录");
        jMenuItem15.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem15.setText("商品销售记录");
        jMenuItem16.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem16.setText("营业记录");
        jMenuItem17.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem17.setText("统计分析");
        jMenu5.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenu5.setMnemonic('H');
        jMenu5.setText("帮助H");
        jMenuItem18.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem18.setText("系统帮助");
        jMenuItem18.addActionListener(new mainFrame_jMenuItem18_actionAdapter(this));
        jMenuItem19.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem19.setText("问题反馈");
        jMenuItem20.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem20.setText("软件注册");
        jMenuItem21.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jMenuItem21.setText("关于");
        jMenuItem21.addActionListener(new mainFrame_jMenuItem21_actionAdapter(this));
        jLabelDate.setBackground(Color.black);
        jLabelDate.setFont(new java.awt.Font("宋体", Font.PLAIN, 28));
        jLabelDate.setForeground(Color.green);
        jLabelDate.setBorder(BorderFactory.createLoweredBevelBorder());
        jLabelDate.setOpaque(true);
        jLabelDate.setHorizontalAlignment(SwingConstants.CENTER);
        jLabelDate.setHorizontalTextPosition(SwingConstants.LEFT);
        jLabelDate.setText("01:32:45");
        jLabelinfo.setBorder(BorderFactory.createEtchedBorder());
        jLabelinfo.setHorizontalAlignment(SwingConstants.LEFT);
        jLabelinfo.setHorizontalTextPosition(SwingConstants.LEFT);
        jLabelinfo.setVerticalAlignment(SwingConstants.TOP);
        jLabelinfo.setVerticalTextPosition(SwingConstants.TOP);
        jLabelstat1.setForeground(Color.red);
        jLabelstat1.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabelstat1.setToolTipText("");
        jLabelstat1.setHorizontalAlignment(SwingConstants.CENTER);
        jLabelstat1.setHorizontalTextPosition(SwingConstants.CENTER);
        jLabelstat1.setText("SunnyNetbar System");
        contentPane.setBorder(null);
        jLabelstat2.setBorder(BorderFactory.createLoweredBevelBorder());
        jLabelstat2.setText("当前操作员：");
        jLabelstat3.setBorder(BorderFactory.createEtchedBorder());
        jLabelstat3.setHorizontalAlignment(SwingConstants.CENTER);
        jLabelstat3.setHorizontalTextPosition(SwingConstants.CENTER);
        jLabelstat3.setText(
                "北大青鸟昆明五华培训中心ST0602 http://www.sunnynetbar.com");
        jButton11.addMouseListener(new mainFrame_jButton11_mouseAdapter(this));
        jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
        connectSQL con=new connectSQL();
        Vector vecAll=con.getComputer();
        Vector vecHeader=new Vector();
        jButton1.addMouseListener(new mainFrame_jButton1_mouseAdapter(this));
        jButton2.addMouseListener(new mainFrame_jButton2_mouseAdapter(this));
        jButton3.addMouseListener(new mainFrame_jButton3_mouseAdapter(this));
        jButton10.addMouseListener(new mainFrame_jButton10_mouseAdapter(this));
        jLabel1.setBorder(null);
        jLabel1.setHorizontalAlignment(SwingConstants.LEFT);
        jLabel1.setText("共有电脑30台,使用 台,剩余 台");
        vecHeader.add("计算机名");
        vecHeader.add("卡号");
        vecHeader.add("计费类型");
        vecHeader.add("卡类型");
        vecHeader.add("开始时间");
        vecHeader.add("下机时间");
        vecHeader.add("用时");
        vecHeader.add("费用");
        vecHeader.add("押金");
        vecHeader.add("余额");
        vecHeader.add("状态");
        vecHeader.add("备注");
        jTable1=new JTable(vecAll,vecHeader);
        jTable1.setBackground(Color.white);
        jMenuBar1.add(jMenuFile);
        jMenuBar1.add(jMenu1);
        jMenuBar1.add(jMenu2);
        jMenuBar1.add(jMenu3);
        jMenuBar1.add(jMenu4);
        jMenuBar1.add(jMenu5);
        jMenuFile.add(jMenuItem5);
        jMenuFile.add(jMenuItem1);
        jMenuFile.add(jMenuItem2);
        jMenuFile.add(jMenuItem3);
        jMenuFile.addSeparator();
        jMenuFile.add(jMenuItem4);
        jMenuFile.addSeparator();
        jMenuFile.add(jMenuFileExit);
        setJMenuBar(jMenuBar1);
        jButton1.setIcon(image1);
        jButton1.setToolTipText("会员卡管理");
        jButton2.setIcon(image2);
        jButton2.setToolTipText("普通卡管理");
        jButton3.setIcon(image3);
        jButton3.setToolTipText("激活普通卡");
        jButton4.setIcon(image4);
        jButton4.setToolTipText("上机");
        jButton5.setIcon(image5);
        jButton5.setToolTipText("结账");
        jButton6.setIcon(image6);
        jButton6.setToolTipText("充值");
        jButton7.setIcon(image7);
        jButton7.setToolTipText("资产管理");
        jButton8.setIcon(image8);
        jButton8.setToolTipText("系统设置");
        jButton9.setIcon(image9);
        jButton9.setToolTipText("权限设置");
        jButton10.setIcon(image10);
        jButton10.setToolTipText("操作员换班");
        jButton11.setIcon(image11);
        jButton11.setToolTipText("退出系统");