editstuinfo.java

针对数据库操作制作的一个学生管理系统

package Cstudent;

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

/**
 * 学生信息管理模块
 * 修改学生信息的类
 */
public class EditStuInfo extends StuInfo {
	String sNum_str = "";
	public EditStuInfo() {
		this.setTitle("修改学生信息");
		this.setResizable(false);

		Sno.setEditable(false);
		Sno.setText("请查询学号");
		Sname.setEditable(false);
		Ssex.setEditable(false);
		Sage.setEditable(false);
		Sdept.setEditable(false);
		//sYear.setEditable(false);
		//sMajor.setEditable(false);
		//sCollege.setEditable(false);
		//sHome.setEditable(false);

		//设置运行时窗口的位置
		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
		this.setLocation((screenSize.width - 400) / 2, 
			(screenSize.height - 300) / 2 + 45);
	}

	public void downInit(){
		searchInfo.setText("学号查询");
		searchInfo.setFont(new Font("Dialog",0,12));
		downPanel.add(searchInfo);
		modifyInfo.setText("修改");
		modifyInfo.setFont(new Font("Dialog",0,12));
		downPanel.add(modifyInfo);
		clearInfo.setText("清空");
		clearInfo.setFont(new Font("Dialog",0,12));
		downPanel.add(clearInfo);
		eixtInfo.setText("退出");
		eixtInfo.setFont(new Font("Dialog",0,12));
		downPanel.add(eixtInfo);

		searchInfo.setEnabled(true);
		modifyInfo.setEnabled(false);
		clearInfo.setEnabled(true);
		eixtInfo.setEnabled(true);

		//添加事件侦听
		searchInfo.addActionListener(this);
		modifyInfo.addActionListener(this);
		clearInfo.addActionListener(this);
		eixtInfo.addActionListener(this);

		this.contentPane.add(downPanel,BorderLayout.SOUTH);
	}

	/**
	 * 事件处理
	 */
	public void actionPerformed(ActionEvent e) {
		Object obj = e.getSource();
		String[] s = new String[8];

		if (obj == eixtInfo) { //退出
			this.dispose();
		}
		else if (obj == modifyInfo) { //修改
			StuBean modifyStu = new StuBean();
			modifyStu.stuModify(Sno.getText(), Sname.getText(), Ssex.getText(), Sage.getText(), Sdept.getText()/*, sSethnic.getText()/*, sYear.getText(), sMajor.getText(), sCollege.getText()*/);
			modifyStu.stuSearch(Sno.getText());
			s = modifyStu.stuSearch(sNum_str);

			Sname.setText(s[0]);
			Ssex.setText(s[1]);
			Sage.setText(s[2]);
			Sdept.setText(s[3]);
			//sYear.setText(s[4]);
			//sMajor.setText(s[5]);
			//sCollege.setText(s[6]);
			//sBirth.setText(s[7]);
		}
		else if (obj == clearInfo) { //清空
			setNull();
			Sno.setText("请查询学号");
		}
		else if (obj == searchInfo) { //学号查询
			
			StuInfoSearchSno siss = new StuInfoSearchSno(this);
			siss.pack();
			siss.setVisible(true);
			try{
				sNum_str = siss.getSno();
			}catch(Exception ex){
				JOptionPane.showMessageDialog(null, "没有查找到该学号！"); 
			}
	
			StuBean searchStu = new StuBean();
			s = searchStu.stuSearch(sNum_str);
			if(s == null){
				JOptionPane.showMessageDialog(null, "记录不存在！");
				Sno.setText("请查询学号");
				Sname.setText("");
				Ssex.setText("");
				Sage.setText("");
				Sdept.setText("");
				//sYear.setText("");
				//sMajor.setText("");
				//sCollege.setText("");
				//sBirth.setText("");
				
				Sname.setEditable(false);
				Ssex.setEditable(false);
				Sage.setEditable(false);
				Sdept.setEditable(false);
				//sYear.setEditable(false);
				//sMajor.setEditable(false);
				//sCollege.setEditable(false);
				//sHome.setEditable(false);
				modifyInfo.setEnabled(false);
				return;
			}
			else{
				Sno.setText(sNum_str);
				Sname.setText(s[0]);
				Ssex.setText(s[1]);
				Sage.setText(s[2]);
				Sdept.setText(s[3]);
				//sYear.setText(s[4]);
				//sMajor.setText(s[5]);
				//sCollege.setText(s[6]);
				//setText(s[7]);

				Sname.setEditable(true);
				Ssex.setEditable(true);
				Sage.setEditable(true);
				Sdept.setEditable(true);
				//sYear.setEditable(true);
				//sMajor.setEditable(true);
				//sCollege.setEditable(true);
				//sHome.setEditable(true);
				modifyInfo.setEnabled(true);
			}
		}
	}
}