viewcourseframe.java

java(Swing) access做的成绩管理系统

package edu.xscj.business;

import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.table.DefaultTableModel;
import edu.xscj.action.*;
import edu.xscj.conn.*;
import java.sql.*;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.BorderFactory;
import edu.xscj.bean.Course;

public class ViewCourseFrame extends JFrame {
    public ViewCourseFrame() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.courseInfo("select * from course");
        this.getContentPane().setLayout(xYLayout1);
        xYLayout1.setWidth(585);
        xYLayout1.setHeight(553);
        jEditPanel.setLayout(xYLayout2);
        jMenuItem1.setText("刷新");
        jMenuItem1.addActionListener(new
                                     ViewCourseFrame_jMenuItem1_actionAdapter(this));
        jMenuItem2.setText("添加课程");
        jMenuItem2.addActionListener(new
                                     ViewCourseFrame_jMenuItem2_actionAdapter(this));
        jMenuItem3.setText("删除");
        jMenuItem3.addActionListener(new
                                     ViewCourseFrame_jMenuItem3_actionAdapter(this));
        jTable1.addMouseListener(new ViewCourseFrame_jTable1_mouseAdapter(this));
        lbCourseNo.setText("课程编号");
        jEditPanel.setBorder(BorderFactory.createLineBorder(Color.black));
        lbCourseName.setText("课程名");
        jLabel2.setText("学分");
        btnOK.setText("更新");
        btnOK.addActionListener(new ViewCourseFrame_btnOK_actionAdapter(this));
        this.getContentPane().add(jTableScrollPane,
                                  new XYConstraints(3, 7, 575, 264));
        jTableScrollPane.getViewport().add(jTable1);
        jPopupMenu1.add(jMenuItem1);
        jPopupMenu1.add(jMenuItem2);
        jPopupMenu1.add(jMenuItem3);
        this.getContentPane().add(jEditPanel,
                                  new XYConstraints(3, 283, 574, 256));
        jEditPanel.add(txtCourseName, new XYConstraints(263, 76, 124, 27));
        jEditPanel.add(lbCourseName, new XYConstraints(177, 86, -1, -1));
        jEditPanel.add(jLabel2, new XYConstraints(183, 126, -1, -1));
        jEditPanel.add(btnOK, new XYConstraints(251, 185, 61, -1));
        jEditPanel.add(lbCourseNo, new XYConstraints(172, 45, 59, -1));
        jEditPanel.add(txtCourseNo, new XYConstraints(263, 35, 124, 24));
        jEditPanel.add(boxXuefen, new XYConstraints(263, 119, 80, 25));
        this.setSize(600, 550);
        this.setResizable(false);
        this.setTitle("浏览课程信息");
        btnOK.setEnabled(false);
    }

    XYLayout xYLayout1 = new XYLayout();
    JScrollPane jTableScrollPane = new JScrollPane();
    JPanel jEditPanel = new JPanel();
    JTable jTable1 = new JTable();
    XYLayout xYLayout2 = new XYLayout();
    DefaultTableModel tableModel = new DefaultTableModel();
    JPopupMenu jPopupMenu1 = new JPopupMenu();
    JMenuItem jMenuItem1 = new JMenuItem();
    JMenuItem jMenuItem2 = new JMenuItem();
    JMenuItem jMenuItem3 = new JMenuItem();
    int row = 0;
    JLabel lbCourseNo = new JLabel();
    JTextField txtCourseNo = new JTextField();
    JLabel lbCourseName = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField txtCourseName = new JTextField();
    JButton btnOK = new JButton();
    JComboBox boxXuefen = new JComboBox();


    public void courseInfo(String sql) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rst = null;
        tableModel.setColumnCount(0);
        tableModel.setRowCount(0);

        tableModel.addColumn("课程编号");
        tableModel.addColumn("课程名");
        tableModel.addColumn("学分");

        try {
            conn = ConnectDataBase.getConn();
            stmt = conn.createStatement();
            rst = stmt.executeQuery(sql);
            int i = 0;
            while (rst.next()) {
                tableModel.setNumRows(i + 1);

                tableModel.setValueAt(rst.getString("courNo"), i, 0);
                tableModel.setValueAt(rst.getString("courName"), i, 1);
                tableModel.setValueAt(rst.getString("courXuefen"), i, 2);
                i++;
            }
            jTable1.setModel(tableModel);
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            try {
                if (rst != null) {
                    rst.close();
                }
                if (stmt != null) {
                    stmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

    public int getRow() {
        return row;
    }

    public void setRow(int row) {
        this.row = row;
    }

    public void jTable1_mouseClicked(MouseEvent e) {
        int i = e.getButton();
        int y = e.getY();
        int x = e.getX();
        if (i == 3) {
            row = e.getY() / jTable1.getRowHeight();
            jTable1.setRowSelectionInterval(row, row);
            jPopupMenu1.show(e.getComponent(), x, y);
        } else {
            row = jTable1.getSelectedRow();
        }
        jTable1.setSelectionBackground(Color.cyan);
        jTable1.setSelectionForeground(Color.red);

        String courseNo = (String) jTable1.getModel().getValueAt(row, 0);
        String courseName = (String) jTable1.getModel().getValueAt(row, 1);
        String xuefen = (String) jTable1.getModel().getValueAt(row, 2);
        txtCourseNo.setText(courseNo);
        txtCourseName.setText(courseName);
        for (int j = 1; j < 20; j++) {
            boxXuefen.addItem(Integer.toString(j));
            if (j == Integer.parseInt(xuefen)) {
                boxXuefen.setSelectedItem(Integer.toString(j));
            }
        }
        txtCourseNo.setEnabled(false);
        btnOK.setEnabled(true);
    }

    public void jMenuItem3_actionPerformed(ActionEvent e) {
        String courseNo = (String) jTable1.getModel().getValueAt(row, 0);
        DeleteCourseAction delCourse = new DeleteCourseAction();
        delCourse.deleteCourse(courseNo);
        try {
            //this.setVisible(false);
            //this.dispose();
            //new ViewCourseFrame().setVisible(true);
            courseInfo("select * from course");
        } catch (Exception ex) {

        }
    }

    public void jMenuItem2_actionPerformed(ActionEvent e) {
        addCourseFrame addCourse = new addCourseFrame();
        addCourse.setVisible(true);
    }

    public void jMenuItem1_actionPerformed(ActionEvent e) {
        try {
            courseInfo("select * from course");
        } catch (Exception ex) {
        }
    }

    public void btnOK_actionPerformed(ActionEvent e) {
        String courseNo = txtCourseNo.getText();
        String courseName = txtCourseName.getText();
        String xuefen = (String) boxXuefen.getSelectedItem();
        if (courseNo.equals("") || courseName.equals("")) {
            JOptionPane.showMessageDialog(this, "课程编号和课程名不能为空！", "温心提示",
                                          JOptionPane.
                                          INFORMATION_MESSAGE);
            return;
        }
        Course course = new Course();
        course.setCourNo(courseNo);
        course.setCourName(courseName);
        course.setCourXuefen(Integer.parseInt(xuefen));

        UpdateCourseAction updateCourse = new UpdateCourseAction();
        String str = updateCourse.updateStudent(course);
        if (str.equals("sucess")) {
            JOptionPane.showMessageDialog(this, "更新成功！", "温心提示",
                                          JOptionPane.
                                          INFORMATION_MESSAGE);
            try {
                courseInfo("select * from course");
            } catch (Exception ex) {
            }
        } else {
            JOptionPane.showMessageDialog(this, "更新失败！", "温心提示",
                                          JOptionPane.
                                          INFORMATION_MESSAGE);
        }
    }
}


class ViewCourseFrame_btnOK_actionAdapter implements ActionListener {
    private ViewCourseFrame adaptee;
    ViewCourseFrame_btnOK_actionAdapter(ViewCourseFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ViewCourseFrame_jMenuItem1_actionAdapter implements ActionListener {
    private ViewCourseFrame adaptee;
    ViewCourseFrame_jMenuItem1_actionAdapter(ViewCourseFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ViewCourseFrame_jMenuItem3_actionAdapter implements ActionListener {
    private ViewCourseFrame adaptee;
    ViewCourseFrame_jMenuItem3_actionAdapter(ViewCourseFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ViewCourseFrame_jMenuItem2_actionAdapter implements ActionListener {
    private ViewCourseFrame adaptee;
    ViewCourseFrame_jMenuItem2_actionAdapter(ViewCourseFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ViewCourseFrame_jTable1_mouseAdapter extends MouseAdapter {
    private ViewCourseFrame adaptee;
    ViewCourseFrame_jTable1_mouseAdapter(ViewCourseFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jTable1_mouseClicked(e);
    }
}