📄 deletepanel.java~13~

📁 会员管理系统的一个子模块
💻 JAVA~13~
字号:
package memberpane;

import java.sql.*;
import java.text.*;
import java.util.*;
import java.util.Date;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
import javax.swing.table.*;
import javax.swing.JPanel;
import java.awt.Rectangle;

public class DeletePanel extends JPanel{
    public DeletePanel(JTable table) {
        this.table = table;
        try {
            jbInit();
        }
        catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        if(table != null && table.getSelectedRow() != -1){
            String Mname = (String)table.getValueAt(table.getSelectedRow(),1);
            middleLabel.setText("<html>\n" + "<font color=red>" + Mname + "<font>\n");
        }else {
            middleLabel.setText("");
        }
        frontLabel.setText("确定要将会员 ");
        frontLabel.setBounds(new Rectangle(71, 62, 91, 24));
        middleLabel.setBounds(new Rectangle(157, 60, 53, 24));
        backLabel.setText("彻底删除掉吗？");
        backLabel.setBounds(new Rectangle(210, 62, 94, 24));
        okButton.setBounds(new Rectangle(91, 110, 76, 27));
        okButton.setText("确定");
        okButton.addActionListener(new DeletePanel_okButton_actionAdapter(this));
        cancelButton.setBounds(new Rectangle(212, 110, 76, 27));
        cancelButton.setText("取消");
        cancelButton.addActionListener(new
                                       DeletePanel_cancelButton_actionAdapter(this));
        this.add(okButton);
        this.add(cancelButton);
        this.add(frontLabel);
        this.add(middleLabel);
        this.add(backLabel);
    }

    JLabel frontLabel = new JLabel();
    JLabel middleLabel = new JLabel();
    JLabel backLabel = new JLabel();
    JButton okButton = new JButton();
    JButton cancelButton = new JButton();
    private JTable table = null;
    public void okButton_actionPerformed(ActionEvent e) {
        if(table != null && table.getSelectedRow() != -1){
            int selectedRow = table.getSelectedRow();
            String ID = (String)table.getValueAt(selectedRow,0);

            Connection conn = null;
            try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            } catch (ClassNotFoundException ex) {
            }
            String dburl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=db.mdb";
            try {
                conn = DriverManager.getConnection(dburl);
            } catch (SQLException ex1) {
            }

            Statement stmtUpdate = null;
            try {
                stmtUpdate = conn.createStatement();
                //更新数据库
                ////////////=============
                System.out.println(ID);
                stmtUpdate.executeUpdate("delete from VIP where ID = '"+ID+"'");
                //更新表，得到当前选中的表的一行，修改其中每列的值
                DefaultTableModel tm = (DefaultTableModel)table.getModel();
                tm.removeRow(selectedRow);
                table.repaint();
                conn.close();
            }catch (SQLException ex) {
                System.out.println(ex.getStackTrace());
            }
            cancelButton_actionPerformed(e);
        }else {
            cancelButton_actionPerformed(e);
        }

    }

    public void cancelButton_actionPerformed(ActionEvent e) {
        JFrame frame = (JFrame)this.getParent().getParent().getParent().getParent();
        frame.setVisible(false);
        frame.dispose();
    }
}

class DeletePanel_cancelButton_actionAdapter
    implements ActionListener {
    private DeletePanel adaptee;
    DeletePanel_cancelButton_actionAdapter(DeletePanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cancelButton_actionPerformed(e);
    }
}

class DeletePanel_okButton_actionAdapter
    implements ActionListener {
    private DeletePanel adaptee;
    DeletePanel_okButton_actionAdapter(DeletePanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.okButton_actionPerformed(e);
    }
}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -