delstuinfo.java

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

package Cstudent;

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

/**
 * 学生信息管理模块
 * 删除学生信息的类
 */
public class DelStuInfo extends StuInfo{
	String sNum_str = "";

	public DelStuInfo() {
		this.setTitle("删除学生信息");
		this.setResizable(false);

		Sno.setEditable(false);
		Sno.setText("请查询学号");
		Sname.setEditable(false);
		Ssex.setEditable(false);
		Sage.setEditable(false);
		Sdept.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);
		deleteInfo.setText("删除");
		deleteInfo.setFont(new Font("Dialog",0,12));
		downPanel.add(deleteInfo);
		eixtInfo.setText("退出");
		eixtInfo.setFont(new Font("Dialog",0,12));
		downPanel.add(eixtInfo);

		searchInfo.setEnabled(true);
		deleteInfo.setEnabled(false);
		eixtInfo.setEnabled(true);

		//添加事件侦听
		searchInfo.addActionListener(this);
		deleteInfo.addActionListener(this);
		eixtInfo.addActionListener(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 == deleteInfo) { //删除
			int ifdel = JOptionPane.showConfirmDialog(null,"真的要删除该信息？","提示信息",JOptionPane.YES_NO_OPTION,JOptionPane.INFORMATION_MESSAGE );
			if(ifdel == JOptionPane.YES_OPTION){
				StuBean delStu = new StuBean();
				delStu.stuDel(Sno.getText());
				
				this.dispose();

				DelStuInfo dsi = new DelStuInfo();
				dsi.downInit();
				dsi.pack();
				dsi.setVisible(true);
			}
			else{
				return;
			}
		}
		else if (obj == searchInfo) { //学号查询
			StuInfoSearchSno siss = new StuInfoSearchSno(this);
			siss.pack();
			siss.setVisible(true);
			sNum_str = siss.getSno();
			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("");
				
				deleteInfo.setEnabled(false);
				return;
			}
			else{
				Sno.setText(sNum_str);
				Sname.setText(s[0]);
				Ssex.setText(s[1]);
				Sage.setText(s[2]);
				Sdept.setText(s[3]);
				
				deleteInfo.setEnabled(true);
			}
			
		}
	}
}