courseframe.java~13~

用java 写的学生信息管理系统

package prjStudent;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JButton;
import prjsystementer.DBManager;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.sql.SQLException;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;

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

//////////////////////
    private void fillTable() {
        DBManager db = new DBManager();
        String sql = "select * from T_COURSE ";
        ResultSet rs = db.ExecuteQuery(sql);
        ArrayList al = new ArrayList();
        try {
            while (rs.next()) {
                String ID = rs.getString("courseID");
                String Name = rs.getString("courseName");
                String Memo = rs.getString("Memo");
                Course c = new Course();

                c.setCourseID(ID);
                c.setCourseName(Name);
                c.setMemo(Memo);

                al.add(c);
            }
            CourseModel cm = new CourseModel();
            cm.al = al;
            this.tblCourse.setModel(cm);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }


    ///////////////////////

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel1.setText("课程信息列表");
        jLabel1.setBounds(new Rectangle(154, 15, 117, 31));
        btnCancel.setBounds(new Rectangle(290, 323, 83, 25));
        btnCancel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnCancel.setText("退出");
        btnCancel.addActionListener(new CourseFrame_btnCancel_actionAdapter(this));
        btnDel.setBounds(new Rectangle(154, 324, 83, 25));
        btnDel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnDel.setText("删除");
        btnDel.addActionListener(new CourseFrame_btnDel_actionAdapter(this));
        btnAdd.setBounds(new Rectangle(24, 324, 83, 25));
        btnAdd.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnAdd.setText("添加");
        btnAdd.addActionListener(new CourseFrame_btnAdd_actionAdapter(this));
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(btnCancel);
        this.getContentPane().add(btnDel);
        this.getContentPane().add(btnAdd);
        jScrollPane1.getViewport().add(tblCourse);
        jScrollPane1.setBounds(new Rectangle(18, 65, 360, 212));
        fillTable();
    }

    JLabel jLabel1 = new JLabel();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable tblCourse = new JTable();
    JButton btnAdd = new JButton();
    JButton btnDel = new JButton();
    JButton btnCancel = new JButton();
    public void btnDel_actionPerformed(ActionEvent e) {
        int x = this.tblCourse.getSelectedRow();
        if (x < 0) {
            JOptionPane.showMessageDialog(this, "您未选中行");
            return;
        }
        int question = JOptionPane.showConfirmDialog(this, "是否删除", "确认",
                JOptionPane.YES_NO_OPTION,
                JOptionPane.WARNING_MESSAGE);
        if (question == JOptionPane.NO_OPTION) {
            return;
        }
        CourseModel cm = new CourseModel();
        String courseid = (String) cm.getValueAt(x, 0);
        String sql = "delete from T_COURSE where courseID='" + courseid + "'";
        DBManager db = new DBManager();
        db.ExecuteUpdate(sql);
        fillTable();
    }

    public void btnAdd_actionPerformed(ActionEvent e) {
        AddCourseFrame a = new AddCourseFrame();
    }

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


class CourseFrame_btnCancel_actionAdapter implements ActionListener {
    private CourseFrame adaptee;
    CourseFrame_btnCancel_actionAdapter(CourseFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class CourseFrame_btnAdd_actionAdapter implements ActionListener {
    private CourseFrame adaptee;
    CourseFrame_btnAdd_actionAdapter(CourseFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class CourseFrame_btnDel_actionAdapter implements ActionListener {
    private CourseFrame adaptee;
    CourseFrame_btnDel_actionAdapter(CourseFrame adaptee) {
        this.adaptee = adaptee;
    }

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