delcourse.java

自己写的学生选课系统,多多关照.以后共同学习

package student;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JComboBox;
import java.awt.Rectangle;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JButton;
import java.sql.ResultSet;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

public class DelCourse extends JFrame {
    public DelCourse() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jComboBox1.setBounds(new Rectangle(194, 40, 129, 24));
        jButton2.setBounds(new Rectangle(193, 77, 70, 24));
        jButton2.setText("取消");
        jButton2.addActionListener(new DelCourse_jButton2_actionAdapter(this));
        jButton1.addActionListener(new DelCourse_jButton1_actionAdapter(this));
        this.getContentPane().add(jLabel1);
        jButton1.setBounds(new Rectangle(90, 78, 73, 23));
        jButton1.setText("确定");
        this.getContentPane().add(jComboBox1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton1);
        jLabel1.setText("请选择你要删除的课程：");
        jLabel1.setBounds(new Rectangle(60, 41, 133, 23));

        String sql = "select Cname from course"; //查询course表里面所包含的课程

        ResultSet rs = DBManager.getResult(sql); //返回结果集
        jComboBox1.addItem("");
        try {
            while (rs.next()) {
                String str = new String();
                str = rs.getString("Cname"); //取结果集中的元素
                jComboBox1.addItem(str); //添加到jComboBoxSearch
            }

        } catch (Exception ex) {

        }

    }

    JComboBox jComboBox1 = new JComboBox();
    JLabel jLabel1 = new JLabel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    public void jButton1_actionPerformed(ActionEvent e) {
        String sql = "delete from Course where Cname = '"
                     + jComboBox1.getSelectedItem().toString().trim() + "'";
        if (DBManager.executeSql(sql)) {
            JOptionPane.showMessageDialog(this, "删除成功！·");
        } else {
            JOptionPane.showMessageDialog(this, "删除失败！");
        }
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        this.dispose();
    }
}


class DelCourse_jButton2_actionAdapter implements ActionListener {
    private DelCourse adaptee;
    DelCourse_jButton2_actionAdapter(DelCourse adaptee) {
        this.adaptee = adaptee;
    }

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


class DelCourse_jButton1_actionAdapter implements ActionListener {
    private DelCourse adaptee;
    DelCourse_jButton1_actionAdapter(DelCourse adaptee) {
        this.adaptee = adaptee;
    }

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