mainframe.java

管理系统实现的源代码,

/*
 * MainFrame.java
 *
 * Created on 2008年12月3日, 下午10:35
 */
package 学生成绩管理系统;

import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class MainFrame extends javax.swing.JFrame implements ActionListener {

    PieChart1 ww = new PieChart1();
    zhiFangTu zz = new zhiFangTu();
    public static JTool m1,  m2,  m3;
    Timer timer = new Timer(1000, this);
    public static addStudent h = new addStudent();
    public static SearchStudent s = new SearchStudent();
    ratecount rate1 = new ratecount();
    ratecount rate2 = new ratecount();
    ratecount rate3 = new ratecount();
    ratecount rate4 = new ratecount();
    ratecount rate5 = new ratecount();
    ratecount rate6 = new ratecount();
    int fh1 = 0;
    int fh2 = 0;
    int fh3 = 0;
    int fl1 = 100;
    int fl2 = 100;
    int fl3 = 100;
    int sh1 = 0;
    int sh2 = 0;
    int sh3 = 0;
    int sl1 = 100;
    int sl2 = 100;
    int sl3 = 100;

    public MainFrame() {

        int s3 = 0;
        int e1 = 0;
        int e2 = 0;
        int e3 = 0;
        int r0 = 0;
        int r1 = 0;
        int r2 = 0;
        int r3 = 0;
        int r4 = 0;
        int ra = 0;
        int rb = 0;
        int rc = 0;
        int rd = 0;
        int re = 0;
        int b1 = 0;
        int b2 = 0;
        int b3 = 0;
        int b4 = 0;
        int b5 = 0;

        int y20 = 0;
        int y21 = 0;
        int y22 = 0;
        int y23 = 0;
        int y24 = 0;
        int y25 = 0;

        int s20 = 0;
        int s21 = 0;
        int s22 = 0;
        int s23 = 0;
        int s24 = 0;

        int e20 = 0;
        int e21 = 0;
        int e22 = 0;
        int e23 = 0;
        int e24 = 0;
        DBM db = new DBM();
        String sql = "select * from course;";
        ResultSet rs0 = db.getResult(sql);
        rs0 = db.getResult(sql);
        try {
            while (rs0.next()) {

                if (rs0.getString(2).equals("1")) {

                    int a0 = Integer.parseInt(rs0.getString(3));
                    int a1 = Integer.parseInt(rs0.getString(4));
                    int a2 = Integer.parseInt(rs0.getString(5));
                    if (fh1 < a0) {
                        fh1 = a0;
                    }
                    if (fh2 < a1) {
                        fh2 = a1;
                    }
                    if (fh3 < a2) {
                        fh3 = a2;
                    }
                    if (fl1 > a0) {
                        fl1 = a0;
                    }
                    if (fl2 > a1) {
                        fl2 = a1;
                    }
                    if (fl3 > a2) {
                        fl3 = a2;
                    }
                    if (a0 < 60) {
                        r0++;
                    }
                    if (60 <= a0 && a0 <= 69) {
                        r1++;
                    }
                    if (70 <= a0 && a0 <= 79) {
                        r2++;
                    }
                    if (80 <= a0 && a0 <= 89) {
                        r3++;
                    }
                    if (90 <= a0 && a0 <= 100) {
                        r4++;
                    }
                    if (a1 < 60) {
                        ra++;
                    }
                    if (60 <= a1 && a1 <= 69) {
                        rb++;
                    }
                    if (70 <= a1 && a1 <= 79) {
                        rc++;
                    }
                    if (80 <= a1 && a1 <= 89) {
                        rd++;
                    }
                    if (90 <= a1 && a1 <= 100) {
                        re++;
                    }
                    if (a2 < 60) {
                        b1++;
                    }
                    if (60 <= a2 && a2 <= 69) {
                        b2++;
                    }
                    if (70 <= a2 && a2 <= 79) {
                        b3++;
                    }
                    if (80 <= a2 && a2 <= 89) {
                        b4++;
                    }
                    if (90 <= a2 && a2 <= 100) {
                        b5++;
                    }

                }




            }

            db.close();
        } catch (SQLException exc) {
            exc.printStackTrace();
            System.exit(1);
        }

        rate1.set(r0, r1, r2, r3, r4);
        rate2.set(ra, rb, rc, rd, re);
        rate3.set(b1, b2, b3, b4, b5);
        rate4.set(y20, y21, y22, y23, y24);
        rate5.set(s20, s21, s22, s23, s24);
        rate6.set(e20, e21, e22, e23, e24);
        timer.start();
        initComponents();

        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String strurl = "jdbc:odbc:student";//创建指定数据库的URL

            Connection con = null;
            con = DriverManager.getConnection(strurl);
            Statement sta = con.createStatement();
            ResultSet rs = sta.executeQuery("select * from student;");
            while (rs.next()) {

                {
                    int num = Integer.parseInt(rs.getString(2));
                    String cla = rs.getString(3);
                    String name = rs.getString(4);
                    int id = Integer.parseInt(rs.getString(5));
                    if (cla.equals("1")) {
                        student bt1 = new student("image/m01.gif", name, "学号：" + num, cla, id, true);
                        R1.add(bt1);
                    }
                    if (cla.equals("2")) {
                        student bt1 = new student("image/m01.gif", name, "学号：" + num, cla, id, true);
                        R2.add(bt1);
                    }
                    if (cla.equals("3")) {
                        student bt1 = new student("image/m01.gif", name, "学号：" + num, cla, id, true);
                        R3.add(bt1);

                    }

                }

            }
        } catch (Exception e) {
            e.printStackTrace();
        }


        m1 = new JTool("image/m01.gif", "  学生管理  ", "增加以及查看学生成绩", true);
        m2 = new JTool("image/m02.gif", "  班级管理  ", "有关班级的信息", true);
        m3 = new JTool("image/m10.gif", "  退出系统  ", "退出这个系统", true);
        jToolBar.add(m1);
        jToolBar.add(m2);
        jToolBar.add(m3);
    }

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        jToolBar = new javax.swing.JToolBar();
        L = new javax.swing.JPanel();
        Time = new javax.swing.JTextField();
        jLabel1 = new javax.swing.JLabel();
        jSeparator1 = new javax.swing.JSeparator();
        jLabel2 = new javax.swing.JLabel();
        jt1 = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        jt2 = new javax.swing.JTextField();
        jLabel4 = new javax.swing.JLabel();
        jt3 = new javax.swing.JTextField();
        jSeparator2 = new javax.swing.JSeparator();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        jt4 = new javax.swing.JTextField();
        jLabel7 = new javax.swing.JLabel();
        jt5 = new javax.swing.JTextField();
        jLabel8 = new javax.swing.JLabel();
        jt6 = new javax.swing.JTextField();
        jLabel9 = new javax.swing.JLabel();
        jt7 = new javax.swing.JTextField();
        jLabel10 = new javax.swing.JLabel();
        jt8 = new javax.swing.JTextField();
        jSeparator3 = new javax.swing.JSeparator();
        jLabel11 = new javax.swing.JLabel();
        jComboBox1 = new javax.swing.JComboBox();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jButton3 = new javax.swing.JButton();
        jButton4 = new javax.swing.JButton();
        jButton5 = new javax.swing.JButton();
        count0 = new javax.swing.JLabel();
        count1 = new javax.swing.JLabel();
        count2 = new javax.swing.JLabel();
        count3 = new javax.swing.JLabel();
        count4 = new javax.swing.JLabel();
        jButton6 = new javax.swing.JButton();
        jButton7 = new javax.swing.JButton();
        jTextField1 = new javax.swing.JTextField();
        R = new javax.swing.JTabbedPane();
        R2 = new javax.swing.JPanel();
        R3 = new javax.swing.JPanel();
        R1 = new javax.swing.JPanel();
        Rx = new javax.swing.JPanel();
        show = new javax.swing.JPanel();
        jLabel12 = new javax.swing.JLabel();
        High = new javax.swing.JTextField();
        jLabel13 = new javax.swing.JLabel();
        Low = new javax.swing.JTextField();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setTitle("学生成绩管理");

        jToolBar.setBorder(javax.swing.BorderFactory.createEtchedBorder());
        jToolBar.setRollover(true);

        L.setBorder(javax.swing.BorderFactory.createEtchedBorder());

        Time.setEditable(false);
        Time.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                TimeMouseClicked(evt);
            }
        });

        jLabel1.setForeground(new java.awt.Color(153, 153, 0));
        jLabel1.setText("时间");

        jLabel2.setForeground(new java.awt.Color(255, 153, 153));
        jLabel2.setText("班级：");

        jt1.setEditable(false);

        jLabel3.setForeground(new java.awt.Color(153, 153, 255));
        jLabel3.setText("姓名：");

        jt2.setEditable(false);
        jt2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jt2ActionPerformed(evt);
            }
        });

        jLabel4.setForeground(new java.awt.Color(102, 102, 102));
        jLabel4.setText("学号：");

        jt3.setEditable(false);
        jt3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jt3ActionPerformed(evt);
            }