student.java

管理系统实现的源代码,

package 学生成绩管理系统;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.beans.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class student
        extends JButton
        implements MouseListener {

    private ResultSet rs;
    String s0, s1;
    int s2;
    int sum, avg;

    public student(String picName, String text, String toolTip, String cla, int id) {
        buildButton(picName, text, toolTip, cla, id, false);
    }

    public student(String picName, String text, String toolTip, String cla, int id, boolean flag) {
        buildButton(picName, text, toolTip, cla, id, flag);
    }

    private void buildButton(String picName, String text, String toolTip, String cla, int id, boolean flag) {
        s0 = cla;
        s1 = text;
        s2 = id;
        this.setIcon(new ImageIcon(picName));
        this.setText(text);
        this.setToolTipText(toolTip);
        this.setBorderPainted(true);
        if (flag) {
            this.setContentAreaFilled(false);		//设置背景色透明

            this.setHorizontalTextPosition(SwingConstants.CENTER);
            this.setVerticalTextPosition(SwingConstants.BOTTOM);
        }
        this.addMouseListener(this);
    }

    public void mouseClicked(MouseEvent me) {
    }

    public void mousePressed(MouseEvent me) {
        MainFrame.jt1.setText(s0);
        MainFrame.jt2.setText(s1);
        MainFrame.jt3.setText("" + s2);
        MainFrame.jt1.setHorizontalAlignment(JTextField.CENTER);
        MainFrame.jt2.setHorizontalAlignment(JTextField.CENTER);
        MainFrame.jt3.setHorizontalAlignment(JTextField.CENTER);
        DBM db = new DBM();
        String sql = "select * from course where id=" + s2;
        rs = db.getResult(sql);
        try {
            if (!rs.next()) {
                JOptionPane.showMessageDialog(null, "无此学号记录", "警告",
                        JOptionPane.WARNING_MESSAGE);
            }
            int a1 = Integer.parseInt(rs.getString(3));
            int a2 = Integer.parseInt(rs.getString(4));
            int a3 = Integer.parseInt(rs.getString(5));
            int sum = (a1 + a2 + a3);
            int avg = sum / 3;
            MainFrame.jt4.setText("" + a1);
            MainFrame.jt5.setText("" + a2);
            MainFrame.jt6.setText("" + a3);
            MainFrame.jt7.setText("" + sum);
            MainFrame.jt8.setText("" + avg);
            MainFrame.jt4.setHorizontalAlignment(JTextField.CENTER);
            MainFrame.jt5.setHorizontalAlignment(JTextField.CENTER);
            MainFrame.jt6.setHorizontalAlignment(JTextField.CENTER);
            MainFrame.jt7.setHorizontalAlignment(JTextField.CENTER);
            MainFrame.jt8.setHorizontalAlignment(JTextField.CENTER);
            db.close();
        }//end try
        catch (SQLException exc) {
            exc.printStackTrace();
            System.exit(1);
        }




    }

    public void mouseReleased(MouseEvent me) {
    }

    public void mouseEntered(MouseEvent me) {
        this.setForeground(new Color(156, 126, 66));
        this.setBackground(new Color(234, 223, 203));
    }

    public void mouseExited(MouseEvent me) {
        this.setForeground(new Color(87, 87, 47));
        this.setBackground(new Color(231, 215, 183));
    }
}