employeemanagepanel.java

自己做的超市管理系统

package shopingmanager;

import java.awt.BorderLayout;
import java.util.*;

import javax.swing.JPanel;
import javax.swing.JButton;
import java.awt.Rectangle;
import javax.swing.JLabel;
import java.awt.Font;
import javax.swing.JTextField;
import java.awt.Dimension;
import javax.swing.JComboBox;
import javax.swing.JTextArea;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JOptionPane;
import javax.swing.table.AbstractTableModel;
import javax.swing.UIManager;
import java.awt.SystemColor;
import java.awt.Color;
import javax.swing.JTextPane;
import javax.swing.BorderFactory;

public class EmployeeManagePanel extends JPanel {
   ConnectSQL ds=new ConnectSQL("SuperMarketMIB");
   ResultSet rs;
   AbstractTableModel tm;
   JTable jg_table;
   String title[]={"编号","姓名","性别","年龄","职务","工资","联系方式","地址","备注"};
   Vector vc;//=new Vector();

JScrollPane queryFile = new JScrollPane();

    public EmployeeManagePanel() {
        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 column) {
                    if (!vc.isEmpty()) {
                        return ((Vector) vc.elementAt(row)).elementAt(column);

                    } 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);
        this.setOpaque(false);
        setSize(new Dimension(607, 450));
        btnQuery.setBounds(new Rectangle(124, 0, 102, 33));
        btnQuery.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnQuery.setForeground(SystemColor.desktop);
        btnQuery.setBorder(null);
        btnQuery.setMaximumSize(new Dimension(83, 25));
        btnQuery.setContentAreaFilled(false);
        btnQuery.setText("查询员工");
        btnQuery.addActionListener(new
                                   EmployeeManagePanel_btnQuery_actionAdapter(this));
        btnRejigger.setBounds(new Rectangle(366, 0, 102, 33));
        btnRejigger.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnRejigger.setForeground(SystemColor.desktop);
        btnRejigger.setBorder(null);
        btnRejigger.setToolTipText("");
        btnRejigger.setContentAreaFilled(false);
        btnRejigger.setText("更改信息");
        btnRejigger.addActionListener(new
                                      EmployeeManagePanel_btnRejigger_actionAdapter(this));
        btnAppend.setBounds(new Rectangle(244, 0, 102, 33));
        btnAppend.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnAppend.setForeground(SystemColor.desktop);
        btnAppend.setBorder(null);
        btnAppend.setMaximumSize(new Dimension(83, 25));
        btnAppend.setMinimumSize(new Dimension(83, 25));
        btnAppend.setPreferredSize(new Dimension(83, 25));
        btnAppend.setContentAreaFilled(false);
        btnAppend.setText("添加员工");
        btnAppend.addActionListener(new
                                    EmployeeManagePanel_btnAppend_actionAdapter(this));
        btnDelete.setBounds(new Rectangle(488, 0, 102, 33));
        btnDelete.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnDelete.setForeground(SystemColor.desktop);
        btnDelete.setBorder(null);
        btnDelete.setToolTipText("");
        btnDelete.setContentAreaFilled(false);
        btnDelete.setText("删除员工");
        btnDelete.addActionListener(new
                                    EmployeeManagePanel_btnDelete_actionAdapter(this));
        btnInfo.setBounds(new Rectangle(8, 0, 100, 33));
        btnInfo.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnInfo.setForeground(SystemColor.desktop);
        btnInfo.setBorder(null);
        btnInfo.setContentAreaFilled(false);
        btnInfo.setText("所有信息");
        btnInfo.addActionListener(new EmployeeManagePanel_btnExit_actionAdapter(this));
        pnlQuery.setOpaque(false);
        pnlQuery.setBounds(new Rectangle(0, 32, 599, 416));
        pnlQuery.setLayout(null);
        lblQName.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lblQName.setText("请输入要查询员工的编号:");
        lblQName.setBounds(new Rectangle(56, 154, 191, 30));
        txtQId.setBounds(new Rectangle(261, 152, 114, 32));
        btnQConfirm.setBounds(new Rectangle(167, 288, 72, 30));
        btnQConfirm.setBorder(BorderFactory.createRaisedBevelBorder());
        btnQConfirm.setToolTipText("");
        btnQConfirm.setContentAreaFilled(false);
        btnQConfirm.setText("确定");
        btnQConfirm.addActionListener(new
                                      EmployeeManagePanel_btnQConfirm_actionAdapter(this));
        btnQAgain.setBounds(new Rectangle(295, 288, 71, 30));
        btnQAgain.setBorder(BorderFactory.createRaisedBevelBorder());
        btnQAgain.setToolTipText("");
        btnQAgain.setContentAreaFilled(false);
        btnQAgain.setText("重置");
        btnQAgain.addActionListener(new
                                    EmployeeManagePanel_btnQAgain_actionAdapter(this));
        pnlAppend.setOpaque(false);
        pnlAppend.setBounds(new Rectangle(0, 34, 599, 415));
        pnlAppend.setLayout(null);
        lalAInfo.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        lalAInfo.setText("请输入要添加员工的详细信息：");
        lalAInfo.setBounds(new Rectangle(25, 8, 258, 28));
        lalAName.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalAName.setText("姓名");
        lalAName.setBounds(new Rectangle(24, 95, 40, 25));
        lalAage.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalAage.setText("年龄");
        lalAage.setBounds(new Rectangle(24, 184, 40, 25));
        lalASex.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalASex.setText("性别");
        lalASex.setBounds(new Rectangle(24, 139, 40, 25));
        lalADuty.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalADuty.setText("职务");
        lalADuty.setBounds(new Rectangle(23, 224, 40, 25));
        lalAWage.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalAWage.setText("工    资");
        lalAWage.setBounds(new Rectangle(313, 53, 67, 25));
        lalATouch.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalATouch.setText("联系方式");
        lalATouch.setBounds(new Rectangle(312, 98, 68, 25));
        lalAaddress.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalAaddress.setText("地    址");
        lalAaddress.setBounds(new Rectangle(310, 139, 69, 25));
        txtAName.setBounds(new Rectangle(81, 95, 123, 25));
        txtAage.setBounds(new Rectangle(81, 184, 125, 25));
        cboASex.setBounds(new Rectangle(81, 139, 124, 25));
        txtADuty.setBounds(new Rectangle(81, 224, 124, 25));
        txtAWage.setBounds(new Rectangle(410, 52, 153, 25));
        txtATouch.setBounds(new Rectangle(410, 95, 153, 25));
        txtAaddress.setBounds(new Rectangle(410, 139, 153, 25));
        lalARemark.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalARemark.setText("备    注");
        lalARemark.setBounds(new Rectangle(310, 184, 68, 25));
        txtARemark.setBorder(BorderFactory.createEtchedBorder());
        txtARemark.setSelectionColor(Color.white);
        txtARemark.setBounds(new Rectangle(410, 184, 153, 66));
        btnAConfirm.setBounds(new Rectangle(158, 324, 80, 28));
        btnAConfirm.setBorder(BorderFactory.createRaisedBevelBorder());
        btnAConfirm.setContentAreaFilled(false);
        btnAConfirm.setText("确定");
        btnAConfirm.addActionListener(new
                                      EmployeeManagePanel_btnAConfirm_actionAdapter(this));
        btnAagain.setBounds(new Rectangle(304, 324, 80, 28));
        btnAagain.setBorder(BorderFactory.createRaisedBevelBorder());
        btnAagain.setContentAreaFilled(false);
        btnAagain.setText("重置");
        btnAagain.addActionListener(new
                                    EmployeeManagePanel_btnAagain_actionAdapter(this));
        pnlRejigger.setOpaque(false);
        pnlRejigger.setBounds(new Rectangle( -1, 36, 600, 414));
        pnlRejigger.setLayout(null);
        lalRInfo.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        lalRInfo.setText("请输入要更改员工的信息：");
        lalRInfo.setBounds(new Rectangle(15, 9, 218, 29));
        lalRId.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalRId.setText("编号");
        lalRId.setBounds(new Rectangle(33, 53, 35, 27));
        txtRId.setBounds(new Rectangle(87, 54, 113, 26));
        lalRDuty.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalRDuty.setText("职务");
        lalRDuty.setBounds(new Rectangle(33, 105, 35, 27));
        lalRWage.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalRWage.setText("工资");
        lalRWage.setBounds(new Rectangle(33, 163, 35, 27));
        txtRDuty.setBounds(new Rectangle(85, 106, 113, 26));
        txtRWage.setBounds(new Rectangle(85, 163, 113, 26));
        btnRConfirm.setBounds(new Rectangle(160, 283, 75, 32));
        btnRConfirm.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnRConfirm.setBorder(BorderFactory.createRaisedBevelBorder());
        btnRConfirm.setContentAreaFilled(false);
        btnRConfirm.setText("确定");
        btnRConfirm.addActionListener(new
                                      EmployeeManagePanel_btnRConfirm_actionAdapter(this));
        btnRAgian.setBounds(new Rectangle(312, 283, 75, 32));
        btnRAgian.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnRAgian.setBorder(BorderFactory.createRaisedBevelBorder());
        btnRAgian.setContentAreaFilled(false);
        btnRAgian.setText("重置");
        btnRAgian.addActionListener(new
                                    EmployeeManagePanel_btnRAgian_actionAdapter(this));
        pnlDelete.setOpaque(false);
        pnlDelete.setBounds(new Rectangle(0, 32, 566, 415));
        pnlDelete.setLayout(null);
        lalDInfo.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        lalDInfo.setText("请输入要删除员工的信息：");
        lalDInfo.setBounds(new Rectangle(24, 11, 217, 32));
        lalDId.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalDId.setText("请输入要删除员工的编号：");
        lalDId.setBounds(new Rectangle(58, 149, 192, 31));
        txtDId.setBounds(new Rectangle(260, 146, 113, 29));
        btnDConfirm.setBounds(new Rectangle(162, 307, 78, 31));
        btnDConfirm.setBorder(BorderFactory.createRaisedBevelBorder());
        btnDConfirm.setContentAreaFilled(false);
        btnDConfirm.setText("确定");
        btnDConfirm.addActionListener(new
                                      EmployeeManagePanel_btnDConfirm_actionAdapter(this));
        btnDAgian.setBounds(new Rectangle(311, 307, 78, 31));
        btnDAgian.setBorder(BorderFactory.createRaisedBevelBorder());
        btnDAgian.setContentAreaFilled(false);
        btnDAgian.setText("重置");
        btnDAgian.addActionListener(new
                                    EmployeeManagePanel_btnDAgian_actionAdapter(this));
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel1.setText("请输入要查询员工的信息:");
        jLabel1.setBounds(new Rectangle(26, 11, 213, 36));
        lalAId.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalAId.setText("编号");
        lalAId.setBounds(new Rectangle(24, 52, 40, 25));
        txtAId.setBounds(new Rectangle(81, 52, 123, 25));
        queryFile.setBounds(new Rectangle(17, 63, 589, 324));
        lalRAddress.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalRAddress.setText("地   址");
        lalRAddress.setBounds(new Rectangle(278, 51, 57, 27));
        lalRTouch.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalRTouch.setText("联系方式");
        lalRTouch.setBounds(new Rectangle(278, 105, 72, 27));
        txtRAddress.setBounds(new Rectangle(354, 52, 183, 26));
        txtRTouch.setBounds(new Rectangle(354, 106, 183, 26));
        lalRremark.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        lalRremark.setText("备   注");
        lalRremark.setBounds(new Rectangle(278, 163, 63, 27));
        txtRremark.setBorder(BorderFactory.createEtchedBorder());
        txtRremark.setBounds(new Rectangle(354, 163, 183, 74));
        pnlTitle.setBackground(new Color(224, 223, 255));
        pnlTitle.setBorder(BorderFactory.createEtchedBorder());
        pnlTitle.setOpaque(false);
        pnlTitle.setBounds(new Rectangle(11, 6, 596, 37));
        pnlTitle.setLayout(null);
        pnlQuery.add(btnQConfirm);
        pnlQuery.add(btnQAgain);
        pnlQuery.add(txtQId);
        pnlQuery.add(lblQName);
        pnlQuery.add(jLabel1);
        this.add(pnlTitle);
        this.add(queryFile);
        queryFile.getViewport().add(jg_table);
        this.add(pnlDelete);
        pnlDelete.add(btnDAgian);
        pnlDelete.add(btnDConfirm);
        pnlDelete.add(lalDId);
        pnlDelete.add(lalDInfo);
        pnlDelete.add(txtDId);
        this.add(pnlRejigger);
        pnlRejigger.add(btnRConfirm);
        pnlRejigger.add(btnRAgian);
        pnlRejigger.add(txtRId);
        pnlRejigger.add(lalRInfo);
        pnlRejigger.add(lalRId);
        pnlRejigger.add(txtRTouch);