membermanagepanel.java

自己做的超市管理系统

package shopingmanager;

import java.awt.BorderLayout;

import javax.swing.JPanel;
import java.awt.Dimension;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Rectangle;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JLabel;
import java.awt.Font;
import javax.swing.JTextField;
import java.awt.Color;
import javax.swing.JRadioButton;
import javax.swing.JComboBox;
import java.sql.*;
import javax.swing.table.AbstractTableModel;
import javax.swing.JTable;
import java.util.Vector;
import java.text.SimpleDateFormat;
import javax.swing.JOptionPane;
import java.awt.FlowLayout;
import java.awt.SystemColor;
import javax.swing.UIManager;
import javax.swing.BorderFactory;
import javax.swing.border.TitledBorder;
import java.awt.image.*;
import javax.swing.ImageIcon;
import javax.swing.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class MemberManagePanel extends JPanel {
    ConnectSQL ctsql = new ConnectSQL("SuperMarketMIB");
    ResultSet rs;
    SimpleDateFormat sdf = null;
    AbstractTableModel tm;
    JTable jg_table;
    String title[] = {"会员卡号", "姓名", "性别", "年龄", "家庭地址", "工作地址", "联系方式", "会员积分",
                     "备注", "开始时间"};
    Vector vc;
    JButton btnQuery = new JButton();
    JButton btnAdd = new JButton();
    JButton btnPerfect = new JButton();
    JButton btnDelete = new JButton();
    JPanel pnlAdd = new JPanel();
    JPanel pnlQuery = new JPanel();
    JScrollPane jspQuery = new JScrollPane();
    JLabel lblWorkplace = new JLabel();
    JLabel lblAge = new JLabel();
    JLabel lblSex = new JLabel();
    JLabel lblTelphone = new JLabel();
    JLabel lblAddress = new JLabel();
    JLabel lblRemark = new JLabel();
    JLabel lblStartTime = new JLabel();
    JLabel lblName = new JLabel();
    JTextField txtTelphone = new JTextField();
    JTextField txtWorkplace = new JTextField();
    JTextField txtAddress = new JTextField();
    JTextField txtStartTime = new JTextField();
    JTextField txtName = new JTextField();
    JTextArea txtRemark = new JTextArea();
    JTextField txtAge = new JTextField();
    JButton btnYes = new JButton();
    JButton btnCancel = new JButton();
    JComboBox cmbSex = new JComboBox();
    JPanel pnlPerfect = new JPanel();
    JLabel lbllName = new JLabel();
    JLabel lbllAge = new JLabel();
    JLabel lbllTelphone = new JLabel();
    JLabel lbllWorkplace = new JLabel();
    JTextField textName = new JTextField();
    JTextField textAge = new JTextField();
    JTextField textTelphone = new JTextField();
    JTextField textWorkplace = new JTextField();
    JButton bttnYes = new JButton();
    JButton bttnCancel = new JButton();
    JLabel lblQueryOnly = new JLabel();
    JTextField txtQuery = new JTextField();
    JButton btnQueryOnly = new JButton();
    JLabel lblStarTel = new JLabel();
    JLabel lblStarAge = new JLabel();
    JLabel lblStarName = new JLabel();
    JLabel lblStarSex = new JLabel();
    JComboBox combScore = new JComboBox();
    JComboBox combSex = new JComboBox();
    JLabel textSex = new JLabel();
    JLabel lbllAddress = new JLabel();
    JTextField textAddress = new JTextField();
    JLabel lbllRemark = new JLabel();
    JTextArea txaRemark = new JTextArea();
    JLabel lbldQuery = new JLabel();
    JComboBox combAge = new JComboBox();
    JComboBox combxSex = new JComboBox();
    JLabel lblCheckSex = new JLabel();
    JLabel lblCheckAge = new JLabel();
    JLabel lblCheckScore = new JLabel();
    JButton btndQuery = new JButton();
    JButton btnRefurbish = new JButton();
    JLabel lblScore = new JLabel();
    JTextField txtScore = new JTextField();
    TitledBorder titledBorder1 = new TitledBorder("");
    JButton btnBack = new JButton();
    JPanel pnlBtn = new JPanel();
    JLabel lblId = new JLabel();
    JTextField txtId = new JTextField();
    public MemberManagePanel() {
        try {
            vc = new Vector();
            tm = new AbstractTableModel() {
                public int getColumnCount() {
                    return title.length;
                }

                public int getRowCount() {
                    return vc.size();
                }

                public Object getValueAt(int row, int colum) {
                    if (!vc.isEmpty()) {
                        return ((Vector) vc.elementAt(row)).elementAt(colum);
                    } else {
                        return null;
                    }
                }

                public String getColumnName(int column) {
                    return title[column];
                }

                public void setValueAt
                        (Object value, int row, int column) {}

                public Class getColumnClass(int c) {
                    return getValueAt(0, c).getClass();
                }

                public boolean isCellEditable(int row, int column) {
                    return false;
                }
            };
            jg_table = new JTable(tm);
            //设置帮助提示
            jg_table.setToolTipText("显示全部查询结果");
            //设置表格调整尺寸模式
            jg_table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
            //设置单元格选择方式
            jg_table.setCellSelectionEnabled(false);
            //设置是否显示单元格间的分割线
            jg_table.setShowVerticalLines(true);

            jg_table.setShowHorizontalLines(true);

            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        setSize(new Dimension(600, 450));
        btnQuery.setBounds(new Rectangle(126, 3, 104, 30));
        btnQuery.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnQuery.setForeground(SystemColor.desktop);
        btnQuery.setBorder(null);
        btnQuery.setOpaque(false);
        btnQuery.setPreferredSize(new Dimension(40, 35));
        btnQuery.setContentAreaFilled(false);
        btnQuery.setText("浏览会员");
        //  this.btnQuery.setIcon(new ImageIcon("Image\\btnQuery.gif"));
        this.btnQuery.setToolTipText("浏览所有会员资料");
        btnQuery.addActionListener(new
                                   MemberManagePanel_jbtQuery_actionAdapter(this));
        btnAdd.setBounds(new Rectangle(9, 3, 104, 30));
        btnAdd.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnAdd.setForeground(SystemColor.desktop);
        btnAdd.setBorder(null);
        btnAdd.setMaximumSize(new Dimension(83, 25));
        btnAdd.setMinimumSize(new Dimension(83, 25));
        btnAdd.setOpaque(false);
        btnAdd.setPreferredSize(new Dimension(110, 35));
        btnAdd.setContentAreaFilled(false);
        btnAdd.setText("会员注册");
        // this.btnAdd.setIcon(new ImageIcon("Image\\btnAdd.gif"));
        this.btnAdd.setToolTipText("注册新会员");
        btnAdd.addActionListener(new MemberManagePanel_jbtAdd_actionAdapter(this));
        btnPerfect.setBounds(new Rectangle(254, 5, 90, 28));
        btnPerfect.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnPerfect.setForeground(SystemColor.desktop);
        btnPerfect.setBorder(null);
        btnPerfect.setOpaque(false);
        btnPerfect.setPreferredSize(new Dimension(110, 35));
        btnPerfect.setContentAreaFilled(false);
        btnPerfect.setText("修改资料");
        // this.btnPerfect.setIcon(new ImageIcon("Image\\btnPerfect.gif"));
        this.btnPerfect.setToolTipText("修改会员资料");
        btnPerfect.addActionListener(new
                                     MemberManagePanel_jButton3_actionAdapter(this));
        btnDelete.setBounds(new Rectangle(363, 3, 104, 30));
        btnDelete.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnDelete.setForeground(SystemColor.desktop);
        btnDelete.setBorder(null);
        btnDelete.setOpaque(false);
        btnDelete.setPreferredSize(new Dimension(110, 35));
        btnDelete.setContentAreaFilled(false);
        btnDelete.setText("删除会员");
        // this.btnDelete.setIcon(new ImageIcon("Image\\btnDelete.gif"));
        this.btnDelete.setToolTipText("删除会员");
        btnDelete.addActionListener(new
                                    MemberManagePanel_jbtDelete_actionAdapter(this));
        this.setOpaque(false);
        this.setPreferredSize(new Dimension(40, 40));
        pnlAdd.setOpaque(false);
        pnlAdd.setBounds(new Rectangle(0, 0, 600, 450));
        pnlAdd.setLayout(null);
        pnlQuery.setOpaque(false);
        pnlQuery.setBounds(new Rectangle(0, 0, 600, 450));
        pnlQuery.setLayout(null);
        jspQuery.getViewport().setBackground(SystemColor.controlHighlight);
        jspQuery.setBounds(new Rectangle(9, 50, 407, 230));
        lblWorkplace.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lblWorkplace.setText("工作地址：");
        lblWorkplace.setBounds(new Rectangle(40, 162, 89, 27));
        lblAge.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lblAge.setText("年    龄：");
        lblAge.setBounds(new Rectangle(40, 113, 89, 34));
        lblSex.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lblSex.setText("性    别：");
        lblSex.setBounds(new Rectangle(39, 62, 88, 34));
        lblTelphone.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));