addstudentinfoframe.java~88~

用java 写的学生信息管理系统

package prjStudent;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import java.awt.Font;
import javax.swing.JTextArea;
import javax.swing.JRadioButton;
import javax.swing.ButtonGroup;
import javax.swing.JSpinner;
import javax.swing.JComboBox;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.*;
import prjsystementer.DBManager;
import java.awt.Color;
import java.sql.ResultSet;

public class AddStudentInfoFrame extends JDialog {
    public AddStudentInfoFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    Student s;
    public AddStudentInfoFrame(Student st) {
        //stuID, stuName, stuSex, stuBirthday, classID, stuPhone, stuInDate, stuAddress,
        this();
        this.s = st;
        this.txtId.setText(s.getID());
        this.txtName.setText(s.getName());

        //取要修改的性别，怎么 取？

        if (s.getSex().equals("男")) {
            this.radMan.setSelected(true);

        } else {
            this.radWomen.setSelected(true);

        }
        this.txtBirthday.setText(s.getBirthday());
        this.cboClass.setSelectedItem(s.getClassId());
        this.txtPhone.setText(s.getPhone());
        this.txtDate.setText(s.getIndate());
        this.txtAddress.setText(s.getAddress());
        this.txtMemo.setText(s.getMemo());
        this.txtId.setEnabled(false);
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel1.setText("编号：");
        jLabel1.setBounds(new Rectangle(26, 25, 42, 15));
        jLabel9.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel9.setText("住址：");
        jLabel9.setBounds(new Rectangle(208, 101, 42, 15));
        jLabel8.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel8.setText("班级：");
        jLabel8.setBounds(new Rectangle(209, 131, 42, 15));
        jLabel7.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel7.setText("备注：");
        jLabel7.setBounds(new Rectangle(26, 181, 42, 15));
        jLabel6.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel6.setText("入校时间：");
        jLabel6.setBounds(new Rectangle(26, 128, 80, 22));
        lblName.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblName.setText("名称：");
        lblName.setBounds(new Rectangle(204, 27, 42, 15));
        jLabel4.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel4.setText("生日：");
        jLabel4.setBounds(new Rectangle(207, 66, 42, 15));
        jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel3.setText("电话：");
        jLabel3.setBounds(new Rectangle(26, 99, 42, 15));
        jLabel2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        radWomen.setBackground(Color.orange);
        radWomen.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        radWomen.setText("女");
        radWomen.setBounds(new Rectangle(132, 59, 44, 23));
        radMan.setBackground(Color.orange);
        radMan.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        radMan.setSelected(true);
        radMan.setText("男");
        radMan.setBounds(new Rectangle(89, 59, 44, 23));
        txtId.setBounds(new Rectangle(89, 23, 74, 21));
        txtDate.setBounds(new Rectangle(90, 130, 75, 21));
        txtPhone.setBounds(new Rectangle(89, 94, 74, 21));
        txtName.setBounds(new Rectangle(259, 23, 91, 21));
        txtBirthday.setBounds(new Rectangle(260, 58, 90, 21));
        txtAddress.setBounds(new Rectangle(260, 95, 90, 21));
        cboClass.setBounds(new Rectangle(260, 125, 96, 23));
        btnRWirt.setBackground(Color.white);
        btnRWirt.setBounds(new Rectangle(32, 305, 83, 25));
        btnRWirt.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnRWirt.setText("重置");
        btnRWirt.addActionListener(new
                                   AddStudentInfoFrame_btnRWirt_actionAdapter(this));
        btnOk.setBackground(Color.white);
        btnOk.setBounds(new Rectangle(145, 305, 83, 25));
        btnOk.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnOk.setText("确定");
        btnOk.addActionListener(new AddStudentInfoFrame_btnOk_actionAdapter(this));
        btnCancel.setBackground(Color.white);
        btnCancel.setBounds(new Rectangle(269, 305, 83, 25));
        btnCancel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnCancel.setText("取消");
        btnCancel.addActionListener(new
                                    AddStudentInfoFrame_btnCancel_actionAdapter(this));
        this.getContentPane().setBackground(Color.orange);
        this.setTitle("修改学生信息");
        jScrollPane1.setBounds(new Rectangle(90, 185, 262, 91));
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel7);
        this.getContentPane().add(txtId);
        this.getContentPane().add(txtPhone);
        this.getContentPane().add(txtDate);
        this.getContentPane().add(radMan);
        this.getContentPane().add(radWomen);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(txtName);
        this.getContentPane().add(txtBirthday);
        this.getContentPane().add(txtAddress);
        this.getContentPane().add(cboClass);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(lblName);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel9);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(btnRWirt);
        this.getContentPane().add(btnCancel);
        this.getContentPane().add(btnOk);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(txtMemo);
        jLabel2.setText("性别：");
        jLabel2.setBounds(new Rectangle(26, 64, 42, 15));
        buttonGroup1.add(radWomen);
        buttonGroup1.add(radMan);
        fillCbo();
    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel lblName = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JTextField txtBirthday = new JTextField();
    JTextField txtName = new JTextField();
    JTextField txtPhone = new JTextField();
    JTextField txtDate = new JTextField();
    JTextField txtId = new JTextField();
    JTextArea txtMemo = new JTextArea();
    JRadioButton radWomen = new JRadioButton();
    JRadioButton radMan = new JRadioButton();
    ButtonGroup buttonGroup1 = new ButtonGroup();
    JTextField txtAddress = new JTextField();
    JComboBox cboClass = new JComboBox();
    JButton btnRWirt = new JButton();
    JButton btnOk = new JButton();
    JButton btnCancel = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();


    private void fillCbo() {
        this.cboClass.removeAllItems();
        String[] conditions = {"AT1Q7084", "AT1Q7085", "AT1Q7086", "AT1Q7091"};
        for (int i = 0; i < conditions.length; i++) {
            this.cboClass.addItem(conditions[i]);
        }
    }


    private void addStudent() {
        String sql = "";
        String id = this.txtId.getText();
        if (id.equals("")) {
            JOptionPane.showMessageDialog(this, "编号不能为空。");
            return;
        }
        if (id.substring(0, 1).equals("S") == false) {
            JOptionPane.showMessageDialog(this, "编号首位应该是S");
            return;
        }
        if (id.length() > 6 || id.length() < 6) {
            JOptionPane.showMessageDialog(this, "学生编号应该为六位");
            return;
        }
        String querySql = "select * from T_STUDENT where stuID='" + id + "'";
        DBManager db = new DBManager();
        ResultSet qs = db.ExecuteQuery(querySql);
        if (qs.next()) {
            JOptionPane.showMessageDialog(this, "编号不可用");
        }
        String sex = "";
        if (radMan.isSelected() == true) {
            sex = "男";
        } else {
            sex = "女";
        }
        // JOptionPane.showMessageDialog(this, "您还没有选择您要注册的性别");

        String name = this.txtName.getText();
        if (name.equals("")) {
            JOptionPane.showMessageDialog(this, "姓名不能为空。");
            return;
        }
        String phone = this.txtPhone.getText();
        if (phone.equals("")) {
            JOptionPane.showMessageDialog(this, "电话不能为空。");
            return;
        }
        String date = this.txtDate.getText();
        String memo = this.txtMemo.getText();

        if (name.equals("")) {
            JOptionPane.showMessageDialog(this, "姓名不能为空。");
            return;
        }
        String birthday = this.txtBirthday.getText();
        String address = this.txtAddress.getText();
        String classId = (String)this.cboClass.getSelectedItem();
//        if (classId.equals("")) {
//            JOptionPane.showMessageDialog(this, "班级编号不能为空。");
//            return;
//        }
        DBManager db = new DBManager();

        if (this.s == null) {
            sql = "insert T_STUDENT (stuID,stuName,stuSex,stuBirthday,classID,stuPhone,stuInDate,stuAddress,Memo) values('" +
                  id + "','" + name + "','" + sex + "','" + birthday + "','" +
                  classId + "','" + phone + "','" + date + "','" + address +
                  "','" + memo + "')";
            db.ExecuteUpdate(sql);
            JOptionPane.showMessageDialog(this, "注册成功。");
        } else {
            sql = "update T_STUDENT  set stuID='" +
                  id + "',stuName='" + name + "',stuSex='" + sex +
                  "',stuBirthday='" + birthday + "',classID='" +
                  classId + "',stuPhone='" + phone + "',stuInDate='" + date +
                  "',stuAddress='" + address +
                  "',Memo='" + memo + "' where stuID='" + id + "'";

            db.ExecuteUpdate(sql);
            JOptionPane.showMessageDialog(this, "修改成功。");
        }

    }


    public void btnCancel_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void btnOk_actionPerformed(ActionEvent e) {
        addStudent();

    }

    public void btnRWirt_actionPerformed(ActionEvent e) {
        this.txtAddress.setText("");
        this.txtBirthday.setText("");
        this.txtDate.setText("");
        this.txtId.setText("");
        this.txtMemo.setText("");
        this.txtName.setText("");
        this.txtPhone.setText("");
        this.radMan.setSelected(true);
        this.cboClass.setSelectedItem("AT1Q7084");
        //this.cboClass.setSelectedIndex(1);
    }
}


class AddStudentInfoFrame_btnRWirt_actionAdapter implements ActionListener {
    private AddStudentInfoFrame adaptee;
    AddStudentInfoFrame_btnRWirt_actionAdapter(AddStudentInfoFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class AddStudentInfoFrame_btnOk_actionAdapter implements ActionListener {
    private AddStudentInfoFrame adaptee;
    AddStudentInfoFrame_btnOk_actionAdapter(AddStudentInfoFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class AddStudentInfoFrame_btnCancel_actionAdapter implements ActionListener {
    private AddStudentInfoFrame adaptee;
    AddStudentInfoFrame_btnCancel_actionAdapter(AddStudentInfoFrame adaptee) {
        this.adaptee = adaptee;
    }

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

    public static void main(String[] args) {
        AddStudentInfoFrame s = new AddStudentInfoFrame();
        s.setSize(401, 330);
        //显示弹出窗口的位置，现在在显示屏的中间
        s.setLocation(300, 180);
        s.setDefaultCloseOperation(s.DISPOSE_ON_CLOSE);
        s.setVisible(true);
        s.dispose();
    }

}