xgxjxx.java

学习成绩管理系统,包括学生管理,成绩管理,科目管理,考试管理等,根据不同权限分为高级用户和普通用户

package studentsystem;

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

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @download by http://www.codefans.net
 * @author not attributable
 * @version 1.0
 */

public class xgxjxx
    extends JFrame {
  Statement ps, up,sc;
  ResultSet rs;
  Connection con;
  String url;

  JLabel jLabel1 = new JLabel();
  JTextField xh = new JTextField();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel9 = new JLabel();
  JTextField xm = new JTextField();
  JTextField rxrq = new JTextField();
  JTextField rq = new JTextField();
  JTextField tel = new JTextField();
  JScrollPane jScrollPane1 = new JScrollPane();
  JTextPane address = new JTextPane();
  JScrollPane jScrollPane2 = new JScrollPane();
  JTextPane comment = new JTextPane();
  JLabel jLabel10 = new JLabel();
  JButton previous = new JButton();
  JButton next = new JButton();
  JButton last = new JButton();
  JButton first = new JButton();
  JButton xgxl = new JButton();
  JButton gxjl = new JButton();
  JButton cancel = new JButton();
  JButton delete = new JButton();
  JLabel jLabel11 = new JLabel();
  JTextField sex = new JTextField();
  JComboBox jComboBox1 = new JComboBox();
  JComboBox jComboBox2 = new JComboBox();
  JComboBox bh = new JComboBox();

  public xgxjxx() {
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }

    try {

      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con = DriverManager.getConnection(
          "jdbc:odbc:lee",
          "sa", "123");
      ps = con.createStatement(ResultSet.
                               TYPE_SCROLL_INSENSITIVE,
                               ResultSet.CONCUR_READ_ONLY);
     sc=con.createStatement(ResultSet.
                              TYPE_SCROLL_INSENSITIVE,
                              ResultSet.CONCUR_READ_ONLY);

    }
    catch (Exception err) {
      err.getMessage();
      String error = err.getMessage();
      JOptionPane.showMessageDialog(null, error);
    }
    try {
      rs = ps.executeQuery("select * from student"); //读取数据库
      if (rs.next()) {
        xh.setText(rs.getString("student_ID"));
        xm.setText(rs.getString("student_Name"));
        sex.setText(rs.getString("student_Sex"));
        rq.setText(rs.getString("born_Date").substring(0, 10));
        bh.addItem(rs.getString("class_NO"));
        tel.setText(rs.getString("tele_Number"));
        rxrq.setText(rs.getString("ru_Date").substring(0, 10));
        address.setText(rs.getString("address"));
        comment.setText(rs.getString("comment"));

      }
    }

    catch (SQLException sqle) {
      String error = sqle.getMessage();
      JOptionPane.showMessageDialog(null, error);
      sqle.printStackTrace();

    }
  }

  public static void main(String[] args) {
    xgxjxx xgxjxx = new xgxjxx();
  }

  private void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel1.setText("学    号");
    jLabel1.setBounds(new Rectangle(26, 34, 58, 44));
    this.setForeground(Color.black);
    this.setResizable(false);
    this.setState(Frame.NORMAL);
    this.setTitle("修改学籍信息");
    this.getContentPane().setLayout(null);
    xh.setBackground(Color.white);
    xh.setFont(new java.awt.Font("Dialog", 0, 15));
    xh.setEditable(false);
    xh.setText("");
    xh.setBounds(new Rectangle(90, 39, 143, 30));
    jLabel2.setBounds(new Rectangle(26, 78, 58, 44));
    jLabel2.setText("性   别");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel3.setText("班   号");
    jLabel3.setBounds(new Rectangle(26, 125, 58, 44));
    jLabel4.setBounds(new Rectangle(16, 164, 65, 44));
    jLabel4.setText("入校日期");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel5.setBounds(new Rectangle(31, 215, 58, 44));
    jLabel5.setText("备  注");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel6.setBounds(new Rectangle(264, 33, 58, 44));
    jLabel6.setText("姓    名");
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel7.setText("出生日期");
    jLabel7.setBounds(new Rectangle(256, 78, 65, 44));
    jLabel8.setBounds(new Rectangle(262, 125, 65, 44));
    jLabel8.setText("联系电话");
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel9.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel9.setText("家庭住址");
    jLabel9.setBounds(new Rectangle(256, 165, 65, 44));
    //sex.addItem("男");
    // sex.addItem("女");
    xm.setBounds(new Rectangle(347, 38, 126, 30));
    xm.setText("");
    xm.setFont(new java.awt.Font("Dialog", 0, 15));
    rxrq.setBounds(new Rectangle(89, 173, 153, 30));
    rxrq.setText("");
    rxrq.setFont(new java.awt.Font("Dialog", 0, 15));
    rq.setBounds(new Rectangle(348, 86, 126, 30));
    rq.setText("");
    rq.setFont(new java.awt.Font("Dialog", 0, 15));
    tel.setBounds(new Rectangle(351, 130, 126, 30));

    tel.setText("");
    tel.setFont(new java.awt.Font("Dialog", 0, 15));
    jScrollPane1.setBounds(new Rectangle(329, 185, 152, 131));
    address.setFont(new java.awt.Font("Dialog", 0, 15));
    address.setText("");
    jScrollPane2.setBounds(new Rectangle(85, 217, 161, 118));
    comment.setFont(new java.awt.Font("Dialog", 0, 15));
    comment.setText("");
    jLabel10.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel10.setText("查看学籍信息");
    jLabel10.setBounds(new Rectangle(22, 343, 97, 33));
    previous.setText("上一条记录");
    previous.addActionListener(new xgxjxx_previous_actionAdapter(this));
    previous.setBounds(new Rectangle(147, 378, 111, 33));
    previous.setFont(new java.awt.Font("Dialog", 0, 15));
    next.setFont(new java.awt.Font("Dialog", 0, 15));
    next.setBounds(new Rectangle(264, 378, 111, 33));
    next.setText("下一条记录");
    next.addActionListener(new xgxjxx_next_actionAdapter(this));
    last.setFont(new java.awt.Font("Dialog", 0, 15));
    last.setBounds(new Rectangle(384, 378, 131, 33));
    last.setText("最后一条记录");
    last.addActionListener(new xgxjxx_last_actionAdapter(this));
    first.setFont(new java.awt.Font("Dialog", 0, 15));
    first.setBounds(new Rectangle(26, 378, 111, 33));
    first.setText("第一条记录");
    first.addActionListener(new xgxjxx_first_actionAdapter(this));
    xgxl.setBounds(new Rectangle(34, 452, 96, 37));
    xgxl.setFont(new java.awt.Font("Dialog", 0, 15));
    xgxl.setText("修改记录");
    xgxl.addActionListener(new xgxjxx_xgxl_actionAdapter(this));
    gxjl.setText("更新记录");
    gxjl.addActionListener(new xgxjxx_gxjl_actionAdapter(this));
    gxjl.setFont(new java.awt.Font("Dialog", 0, 15));
    gxjl.setBounds(new Rectangle(143, 452, 96, 37));
    cancel.setBounds(new Rectangle(377, 453, 96, 38));
    cancel.setFont(new java.awt.Font("Dialog", 0, 15));
    cancel.setText("退   出");
    cancel.addActionListener(new xgxjxx_cancel_actionAdapter(this));
    delete.setText("删除记录");
    delete.addActionListener(new xgxjxx_delete_actionAdapter(this));
    delete.setFont(new java.awt.Font("Dialog", 0, 15));
    delete.setBounds(new Rectangle(263, 452, 96, 38));
    jLabel11.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel11.setText("修改学籍信息");
    jLabel11.setBounds(new Rectangle(26, 416, 101, 37));
    sex.setBounds(new Rectangle(90, 84, 143, 30));
    sex.setText("");
    sex.setFont(new java.awt.Font("Dialog", 0, 15));

    bh.setFont(new java.awt.Font("Dialog", 0, 15));
    bh.setBounds(new Rectangle(89, 125, 150, 35));
    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(xh, null);
    this.getContentPane().add(jLabel3, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(jLabel5, null);
    this.getContentPane().add(jLabel4, null);
    this.getContentPane().add(rxrq, null);
    this.getContentPane().add(jScrollPane1, null);
    jScrollPane1.getViewport().add(address, null);
    this.getContentPane().add(jScrollPane2, null);
    jScrollPane2.getViewport().add(comment, null);
    this.getContentPane().add(tel, null);
    this.getContentPane().add(rq, null);
    this.getContentPane().add(xm, null);
    this.getContentPane().add(jLabel7, null);
    this.getContentPane().add(jLabel6, null);
    this.getContentPane().add(jLabel8, null);
    this.getContentPane().add(jLabel9, null);
    this.getContentPane().add(jLabel10, null);
    this.getContentPane().add(previous, null);
    this.getContentPane().add(next, null);
    this.getContentPane().add(last, null);
    this.getContentPane().add(first, null);
    this.getContentPane().add(xgxl, null);
    this.getContentPane().add(gxjl, null);
    this.getContentPane().add(jLabel11, null);
    this.getContentPane().add(sex, null);
    this.getContentPane().add(delete, null);
    this.getContentPane().add(cancel, null);
    this.getContentPane().add(bh, null);
    this.getContentPane().add(bh, null);
    this.getContentPane().add(bh, null);
    this.setBounds(200, 150, 550, 550);
    this.setVisible(true);
  }

  void first_actionPerformed(ActionEvent e) {
    try {
      if (rs.first()) {
        xh.setText(rs.getString("student_ID"));
        xm.setText(rs.getString("student_Name"));
        sex.setText(rs.getString("student_Sex"));
        rq.setText(rs.getString("born_Date").substring(0, 10));
        bh.addItem(rs.getString("class_NO"));
        tel.setText(rs.getString("tele_Number"));
        rxrq.setText(rs.getString("ru_Date").substring(0, 10));
        address.setText(rs.getString("address"));
        comment.setText(rs.getString("comment"));

      }
      else
        JOptionPane.showMessageDialog(null, "这是第一条记录");
    }

    catch (SQLException sqle) {
      String error = sqle.getMessage();
      JOptionPane.showMessageDialog(null, error);
      sqle.printStackTrace();

    }

  }

  void next_actionPerformed(ActionEvent e) {
    try {
      if (rs.next()) {
        xh.setText(rs.getString("student_ID"));
        xm.setText(rs.getString("student_Name"));
        sex.setText(rs.getString("student_Sex"));
        rq.setText(rs.getString("born_Date").substring(0, 10));
        bh.addItem(rs.getString("class_NO"));
        tel.setText(rs.getString("tele_Number"));
        rxrq.setText(rs.getString("ru_Date").substring(0, 10));
        address.setText(rs.getString("address"));
        comment.setText(rs.getString("comment"));

      }
      else
        JOptionPane.showMessageDialog(null, "这是最后一条记录");
    }

    catch (SQLException sqle) {
      String error = sqle.getMessage();
      JOptionPane.showMessageDialog(null, error);
      sqle.printStackTrace();

    }