mainframe.java

一个用Java写的简单学生成绩管理系统

import javax.swing.*;
import java.awt.*;
import java.sql.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */

import java.awt.*;
import javax.swing.border.Border;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

public class MainFrame
    extends JFrame {
  String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
  String source = "Jdbc:Odbc:srs";
  private String id;
  JPanel jPanel1 = new JPanel();
  JPanel jPleft = new JPanel();
  JPanel jPright = new JPanel();
  Border border1 = BorderFactory.createLineBorder(Color.lightGray, 1);
  JLabel jLleft = new JLabel();
  JLabel jLright = new JLabel();
  JLabel jLid = new JLabel();
  JLabel jLname = new JLabel();
  JLabel jLemail = new JLabel();
  JLabel jLclass = new JLabel();
  JLabel jLdep = new JLabel();
  JButton jBeditstu = new JButton();
  JTextField jTid = new JTextField();
  JTextField jTname = new JTextField();
  JTextField jTemail = new JTextField();
  JTextField jTclass = new JTextField();
  JTextField jTdep = new JTextField();
  JButton jBchoosed = new JButton();
  JButton jBchoosecourse = new JButton();
  JButton jBupdate = new JButton();
  JButton jBallcourse = new JButton();
  public MainFrame() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    this.setTitle("Student Register Systm");
    this.setSize(440, 360); //
    this.setResizable(false);
    this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    jPanel1.setLayout(null);
    jPleft.setBorder(border1);
    jPleft.setBounds(new Rectangle(8, 48, 197, 252));
    jPleft.setLayout(null);
    jPright.setBorder(border1);
    jPright.setBounds(new Rectangle(223, 48, 203, 252));
    jPright.setLayout(null);
    jLleft.setFont(new java.awt.Font("楷体_GB2312", Font.PLAIN, 20));
    jLleft.setText("学生信息");
    jLleft.setBounds(new Rectangle(52, 20, 81, 16));
    jLright.setFont(new java.awt.Font("楷体_GB2312", Font.PLAIN, 20));
    jLright.setToolTipText("");
    jLright.setText("选课信息");
    jLright.setBounds(new Rectangle(261, 21, 84, 16));
    jLid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    jLid.setText("学号");
    jLid.setBounds(new Rectangle(13, 30, 34, 16));
    jLname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    jLname.setText("姓名");
    jLname.setBounds(new Rectangle(13, 65, 34, 16));
    jLemail.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    jLemail.setText("E-mail");
    jLemail.setBounds(new Rectangle(13, 100, 50, 16));
    jLclass.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    jLclass.setText("班级");
    jLclass.setBounds(new Rectangle(13, 135, 34, 16));
    jLdep.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    jLdep.setText("院系");
    jLdep.setBounds(new Rectangle(13, 170, 34, 16));
    jBeditstu.setBounds(new Rectangle(10, 213, 106, 26));
    jBeditstu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
    jBeditstu.setText("修改个人信息");
    jBeditstu.addActionListener(new MainFrame_jBeditstu_actionAdapter(this));
    jTid.setText("");
    jTid.setEditable(false);
    jTid.setBounds(new Rectangle(74, 27, 102, 22));
    jTname.setText("");
    jTname.setEditable(false);
    jTname.setBounds(new Rectangle(73, 62, 101, 22));
    jTemail.setText("");
    jTemail.setEditable(false);
    jTemail.setBounds(new Rectangle(74, 97, 101, 22));
    jTclass.setText("");
    jTclass.setEditable(false);
    jTclass.setBounds(new Rectangle(74, 131, 101, 22));
    jTdep.setText("");
    jTdep.setEditable(false);
    jTdep.setBounds(new Rectangle(73, 168, 102, 22));
    jBchoosed.setBounds(new Rectangle(30, 105, 150, 26));
    jBchoosed.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    jBchoosed.setText("查看您已选课程");
    jBchoosed.addActionListener(new MainFrame_jBchoosed_actionAdapter(this));
    jBchoosecourse.setBounds(new Rectangle(29, 169, 151, 26));
    jBchoosecourse.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    jBchoosecourse.setText("选课");
    jBchoosecourse.addActionListener(new MainFrame_jBchoosecourse_actionAdapter(this));
    jBupdate.setBounds(new Rectangle(129, 214, 62, 26));
    jBupdate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
    jBupdate.setText("更新");
    jBupdate.addActionListener(new MainFrame_jBupdate_actionAdapter(this));
    jBallcourse.setBounds(new Rectangle(30, 38, 150, 26));
    jBallcourse.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    jBallcourse.setText("查看所有课程");
    jBallcourse.addActionListener(new MainFrame_jBallcourse_actionAdapter(this));
    jPanel1.add(jPleft);
    jPleft.add(jLdep);
    jPleft.add(jLid);
    jPleft.add(jLclass);
    jPleft.add(jLemail);
    jPleft.add(jLname);
    jPleft.add(jTid);
    jPleft.add(jTname);
    jPleft.add(jTemail);
    jPleft.add(jTdep);
    jPleft.add(jTclass);
    jPleft.add(jBeditstu);
    jPleft.add(jBupdate);
    jPanel1.add(jLright);
    jPanel1.add(jLleft);
    jPanel1.add(jPright);
    jPright.add(jBchoosed);
    jPright.add(jBchoosecourse);
    jPright.add(jBallcourse);
    this.getContentPane().add(jPanel1, java.awt.BorderLayout.CENTER);

    try {
      Class.forName(driver);
      Connection con = DriverManager.getConnection(source);
      Statement stm = con.createStatement();
      id = LoginDialog.getID();
      System.out.println(id);
      String sql = "Select * from Student where id='" + id + "'";
      ResultSet rs = stm.executeQuery(sql);
      String id, name, email, stuclass, department;
      while (rs.next()) {
        id = rs.getString("id");
        name = rs.getString("name");
        email = rs.getString("email");
        stuclass = rs.getString("class");
        department = Integer.toString(rs.getInt("dep")) + "系";
        jTid.setText(id);
        jTname.setText(name);
        jTemail.setText(email);
        jTclass.setText(stuclass);
        jTdep.setText(department);
      }
    }
    catch (Exception ex) {
      JOptionPane.showConfirmDialog(null, "连接数据库出现问题!请您重新登录!", "ERROR",
                                    JOptionPane.CLOSED_OPTION);
      ex.printStackTrace();
      System.exit(1);
    }
  }

  public void jBeditstu_actionPerformed(ActionEvent e) {
    Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
    EditStudent frame2 = new EditStudent();
    frame2.setLocation( (screenSize.width - frame2.getSize().width) / 2,
                       (screenSize.height - frame2.getSize().height) / 2);
    frame2.setVisible(true);
    //this.dispose();
  }

  public void jBallcourse_actionPerformed(ActionEvent e) {
    Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
    ViewAllCourse viewallcourse = new ViewAllCourse();
    viewallcourse.setLocation( (screenSize.width -
                                viewallcourse.getSize().width) / 2,
                              (screenSize.height -
                               viewallcourse.getSize().height) / 2);
    viewallcourse.setVisible(true);
    //this.dispose();

  }

  public void jBchoosed_actionPerformed(ActionEvent e) {
    Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
    ViewChoosed frame = new ViewChoosed();
    frame.setLocation( (screenSize.width - frame.getSize().width) / 2,
                      (screenSize.height - frame.getSize().height) / 2);
    frame.setVisible(true);
  }

  public void jBupdate_actionPerformed(ActionEvent e) {
    try {
      Class.forName(driver);
      Connection con = DriverManager.getConnection(source);
      Statement stm = con.createStatement();
      id = LoginDialog.getID();
      System.out.println(id);
      String sql = "Select * from Student where id='" + id + "'";
      ResultSet rs = stm.executeQuery(sql);
      //String  name,id, email, stuclass, department;
      while(rs.next())
      {
       String stuid = rs.getString("id");
        String name = rs.getString("name");
        String email = rs.getString("email");
        String stuclass = rs.getString("class");
        String department = rs.getString("dep")+"系";

        System.out.println(name);

        jTid.setText(stuid);
        jTname.setText(name);
        jTemail.setText(email);
        jTclass.setText(stuclass);
        jTdep.setText(department);
      }
    }
    catch (Exception ex) {
      JOptionPane.showConfirmDialog(null, "连接数据库出现问题!请您重新登录!", "ERROR",
                                    JOptionPane.CLOSED_OPTION);
      ex.printStackTrace();
      System.exit(1);
    }

  }

  public void jBchoosecourse_actionPerformed(ActionEvent e) {
    Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
    ChooseCourse newframe = new ChooseCourse();
    newframe.setLocation((screenSize.width - newframe.getSize().width)/2,
                         (screenSize.height - newframe.getSize().height)/2);
    newframe.setVisible(true);
  }
}

class MainFrame_jBchoosecourse_actionAdapter
    implements ActionListener {
  private MainFrame adaptee;
  MainFrame_jBchoosecourse_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class MainFrame_jBupdate_actionAdapter
    implements ActionListener {
  private MainFrame adaptee;
  MainFrame_jBupdate_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class MainFrame_jBallcourse_actionAdapter
    implements ActionListener {
  private MainFrame adaptee;
  MainFrame_jBallcourse_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class MainFrame_jBchoosed_actionAdapter
    implements ActionListener {
  private MainFrame adaptee;
  MainFrame_jBchoosed_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class MainFrame_jBeditstu_actionAdapter
    implements ActionListener {
  private MainFrame adaptee;
  MainFrame_jBeditstu_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

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