deletestuinfo.java

用java2核心类库写的一个学生课程管理系统

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
public class DeleteStuInfo extends JFrame
{
	private JPanel content;
	private JLabel stuIDLabel;
	private JTextField stuIDText;
	private JButton okButton;
	private JButton cancleButton;

    private static final DeleteStuInfo DeleteStu = new DeleteStuInfo();

    public static DeleteStuInfo singleDeleteStuInfo()
	{
		return DeleteStu;
	}

    private DeleteStuInfo()
    {
    	initDeleteStuInfo();
  
    	ClickActionListener  cal = new ClickActionListener();
    	okButton.addActionListener(cal);
    	cancleButton.addActionListener(cal);
    }

	private void initDeleteStuInfo()
    {
    	this.setTitle("删除学生信息");
    	content = new JPanel();
    	stuIDLabel = new JLabel("请输入删除学生的学号:   ");
    	stuIDText= new JTextField(10);
    	okButton = new JButton("删除");
    	cancleButton=new  JButton("取消");
        content.add(stuIDLabel);
    	content.add(stuIDText);
        content.add(okButton );
    	content.add(cancleButton );
    
    	content.setLayout(new FlowLayout());
    	this.add(content);
    	this.setSize(300,300);		
   }
   
   class ClickActionListener implements ActionListener  
   {    
	    public void actionPerformed(ActionEvent e)
	    {
	    	String stuID = null;
	    	if (e.getActionCommand() == "删除")
	    	{
	    	    System.out.println("delete  StuInfo" );
	    	    int option = JOptionPane.showConfirmDialog(DeleteStu, "确实要删除吗", "询问？", JOptionPane.YES_NO_OPTION);
	    	    System.out.println("option = " + option );
	    	    if (option == 0)  //click "yes", means 确实删除
	    	    {
	    	    	stuID = stuIDText.getText();
	    	    	if (stuID!=null)
	    	    	{
	    		        String sqldeleteStu = null;
	    		        sqldeleteStu = "delete from 学生信息 where 学号 = " + "\'" + stuID +"\'";	        	
	    		        System.out.println("sqldeleteStu  = "  + sqldeleteStu);
	    		        SMISDB deleteStuInfoDB = new SMISDB();
	    	            deleteStuInfoDB.getTable(sqldeleteStu,new JFrame(),true);
	    		        System.out.println("delete stu  success " );
	    		        stuIDText.setText(""); 
	    	    	}
	    	    	
	    	    }
	    	    else
	    	    {
	    	    	// click "no"
	    	    }
	    		
	    	}

	    	else if (e.getActionCommand() == "清除")
	    	{
	    		System.out.println(" button is 清除");
	    		stuIDText.setText("");
	    	}
	    }
    }    
}