stuinfo.java

这是一个用JAVA编写的学生管理系统

package studentms;

import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import java.sql.*;
import java.lang.*;
import java.util.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class stuInfo extends JFrame {
  JPanel jPanel1 = new JPanel();
  XYLayout xYLayout1 = new XYLayout();
  XYLayout xYLayout2 = new XYLayout();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JTextField jTNum = new JTextField();
  JTextField jTName = new JTextField();
  JTextField jTSex = new JTextField();
  JTextField jTHome = new JTextField();
  JTextField jTBirth = new JTextField();
  JTextField jTEthnic = new JTextField();
  JTextField jTClass = new JTextField();
  JButton jBAdd = new JButton();
  JButton jBModify = new JButton();
  JButton jBDelete = new JButton();
  JButton jBCancel = new JButton();
  JButton jBSave = new JButton();

  private String exeType=new String();   //标志操作类型
  // public String currentPeopleID;         //标志当前人员
  Database DB =new Database();           //连接数据库
  ResultSet rs ;                         //返回结果
  String sql=new String();               //SQL语句

  JButton jBSee = new JButton();
  JButton jBSearch = new JButton();
  JButton jBExit = new JButton();
  JButton jBSum = new JButton();
  JButton jBGrade = new JButton();

  public stuInfo() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    this.getContentPane().setLayout(xYLayout1);
    jPanel1.setLayout(xYLayout2);
    jLabel4.setText("民族：");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel1.setText("姓名：");
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel3.setText("学号：");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel7.setText("籍贯：");
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel2.setText("性别：");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
    jBSave.setFont(new java.awt.Font("Dialog", 0, 12));
    jBSave.setMargin(new Insets(2, 2, 2, 2));
    jBSave.setText("保存");
    jBSave.addActionListener(new stuInfo_jBSave_actionAdapter(this));
    jBSave.addMouseListener(new stuInfo_jBSave_mouseAdapter(this));

    jLabel6.setText("出生日期：");
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel5.setText("所在班级：");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
    jPanel1.setOpaque(true);
    jBAdd.setFont(new java.awt.Font("Dialog", 0, 12));
    jBAdd.setMargin(new Insets(2, 2, 2, 2));
    jBAdd.setText("新增");
    jBAdd.addActionListener(new stuInfo_jBAdd_actionAdapter(this));
    jBModify.setFont(new java.awt.Font("Dialog", 0, 12));
    jBModify.setMargin(new Insets(2, 2, 2, 2));
    jBModify.setText("修改");
    jBModify.addActionListener(new stuInfo_jBModify_actionAdapter(this));
    jBDelete.setFont(new java.awt.Font("Dialog", 0, 12));
    jBDelete.setActionCommand("");
    jBDelete.setMargin(new Insets(2, 2, 2, 2));
    jBDelete.setText("删除");
    jBDelete.addActionListener(new stuInfo_jBDelete_actionAdapter(this));
    jBCancel.setFont(new java.awt.Font("Dialog", 0, 12));
    jBCancel.setMargin(new Insets(2, 2, 2, 2));
    jBCancel.setText("取消");
    jBCancel.addActionListener(new stuInfo_jBCancel_actionAdapter(this));
    xYLayout1.setWidth(384);
    xYLayout1.setHeight(279);
    this.setTitle("个人信息管理");
    jTHome.setFont(new java.awt.Font("Dialog", 0, 12));
    jTSex.setFont(new java.awt.Font("Dialog", 0, 12));
    jTName.setFont(new java.awt.Font("Dialog", 0, 12));
    jTNum.setFont(new java.awt.Font("Dialog", 0, 12));
    jTEthnic.setFont(new java.awt.Font("Dialog", 0, 12));
    jTClass.setFont(new java.awt.Font("Dialog", 0, 12));
    jTBirth.setFont(new java.awt.Font("Dialog", 0, 12));
    jBSee.setFont(new java.awt.Font("Dialog", 0, 12));
    jBSee.setMargin(new Insets(2, 2, 2, 2));
    jBSee.setText("查看成绩");
    jBSee.addActionListener(new stuInfo_jBSee_actionAdapter(this));
    jBSearch.setFont(new java.awt.Font("Dialog", 0, 12));
    jBSearch.setActionCommand("搜  索");
    jBSearch.setIcon(null);
    jBSearch.setText("查  询");
    jBSearch.addActionListener(new stuInfo_jBSearch_actionAdapter(this));
    jBExit.setFont(new java.awt.Font("Dialog", 0, 12));
    jBExit.setMargin(new Insets(2, 2, 2, 2));
    jBExit.setText("退出");
    jBExit.addActionListener(new stuInfo_jBExit_actionAdapter(this));
    jBSum.setFont(new java.awt.Font("Dialog", 0, 12));
    jBSum.setMargin(new Insets(2, 2, 2, 2));
    jBSum.setText("人员统计");
    jBSum.addActionListener(new stuInfo_jBSum_actionAdapter(this));
    jBGrade.setFont(new java.awt.Font("Dialog", 0, 12));
    jBGrade.setMargin(new Insets(2, 2, 2, 2));
    jBGrade.setText("成绩管理");
    jBGrade.addActionListener(new stuInfo_jBGrade_actionAdapter(this));
    jPanel1.add(jTNum, new XYConstraints(83, 57, 72, 20));
    jPanel1.add(jLabel3, new XYConstraints(39, 57, 38, 19));
    jPanel1.add(jTName, new XYConstraints(83, 96, 72, 20));
    jPanel1.add(jLabel7, new XYConstraints(41, 174, 44, 19));
    jPanel1.add(jTClass, new XYConstraints(268, 96, 72, 20));
    jPanel1.add(jLabel4, new XYConstraints(218, 57, 39, 19));
    jPanel1.add(jTEthnic, new XYConstraints(267, 55, 72, 20));
    jPanel1.add(jBAdd, new XYConstraints(37, 218, 43, 23));
    jPanel1.add(jBModify,  new XYConstraints(88, 218, 43, 23));
    jPanel1.add(jBExit, new XYConstraints(294, 218, 43, 23));
    jPanel1.add(jBDelete, new XYConstraints(141, 218, 43, 23));
    jPanel1.add(jBSave, new XYConstraints(193, 218, 43, 23));
    jPanel1.add(jBCancel, new XYConstraints(244, 218, 43, 23));
    jPanel1.add(jBSearch,  new XYConstraints(41, 10, 65, 23));
    jPanel1.add(jBSee,  new XYConstraints(118, 10, 65, 23));
    jPanel1.add(jBGrade, new XYConstraints(273, 10, 65, 23));
    jPanel1.add(jBSum, new XYConstraints(195, 10, 65, 23));
    jPanel1.add(jTSex,  new XYConstraints(83, 135, 72, 20));
    jPanel1.add(jLabel2,  new XYConstraints(40, 135, 45, 17));
    jPanel1.add(jLabel6,   new XYConstraints(203, 135, 69, 20));
    jPanel1.add(jTBirth,  new XYConstraints(268, 135, 72, 20));
    jPanel1.add(jTHome, new XYConstraints(83, 173, 257, 20));
    jPanel1.add(jLabel5,   new XYConstraints(202, 96, 61, 17));
    jPanel1.add(jLabel1,  new XYConstraints(40, 95, -1, -1));
    this.getContentPane().add(jPanel1,  new XYConstraints(3, 11, 363, 251));


    //设置初始化时文本框和按钮的状态
    setAbled(false);
    setButton(true,false,false,false,false);
    nullSet();
  }

  //设置文本框是否可编辑
  void setAbled(boolean logic){
    jTNum.setEnabled(logic);
    jTEthnic.setEnabled(logic);
    jTName.setEnabled(logic);
    jTClass.setEnabled(logic);
    jTSex.setEnabled(logic);
    jTBirth.setEnabled(logic);
    jTHome.setEnabled(logic);
  }
  //设置按钮的状态
  void setButton(boolean add,boolean xiugai,boolean del,boolean save,boolean cancel){
    jBAdd.setEnabled(add);
    jBModify.setEnabled(xiugai);
    jBDelete.setEnabled(del);
    jBSave.setEnabled(save);
    jBCancel.setEnabled(cancel);
  }

  //将文本框清空
  void setNull(){
    jTNum.setText(null);
    jTEthnic.setText(null);
    jTName.setText(null);
    jTClass.setText(null);
    jTSex.setText(null);
    jTBirth.setText(null);
    jTHome.setText(null);
  }

//设置操作类型，以使数据库根据不同类型进行不同的操作
  void setExeType(String type){
    exeType=type;
  }

  //新添
  void jBAdd_actionPerformed(ActionEvent e) {
    setExeType("addnew");
    setNull();
    this.setAbled(true);
    this.setButton(false,false,false,true,true);
  }
 //取消
  void jBCancel_actionPerformed(ActionEvent e) {
    this.setAbled(false);
    //如果是新建信息，将所有文本框清空
    if(exeType=="addnew"){
      this.setNull() ;
    }
    this.setButton(true,true,true,false,false);
    nullSet();
  }

  //查看成绩，点击查看成绩按钮时调用此函数
  void seeGrade(){
      //调用searchGrade类中查看信息的方法，避免了代码的重复
      searchGrade seegrade=new searchGrade();
      seegrade.showResult(rs);
  }

  void jBSave_mouseClicked(MouseEvent e) {
  }

//如果当前人员为空，设置各按钮属性
 void nullSet(){
   if(jTNum.getText().equals("")){
        jBModify.setEnabled(false);
        jBDelete.setEnabled(false);
        jBSee.setEnabled(false);
   }
   else{
        jBModify.setEnabled(true);
        jBDelete.setEnabled(true);
        jBSee.setEnabled(true);
   }
 }

 //保存信息
 void jBSave_actionPerformed(ActionEvent e) {

    if (exeType=="addnew"){
          if(jTNum.getText().equals("")){
            JOptionPane.showMessageDialog(null, "学号不能为空！");
          }
          else{
            sql = "select Num from stuTable where Num=" +
                Integer.parseInt(jTNum.getText()) + "";
            rs = DB.getResult(sql);