deletecourseinfo.java

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

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
public class DeleteCourseInfo extends JFrame
{
	private JPanel content;
	private JLabel courseIDLabel;
	private JTextField courseIDText;
	private JButton okButton;
	private JButton cancleButton;

    private static final DeleteCourseInfo DeleteCourse = new DeleteCourseInfo();

    public static DeleteCourseInfo singleDeleteCourseInfo()
	{
		return DeleteCourse;
	}

    private DeleteCourseInfo()
    {
    	initDeleteCourseInfo();
 
    	ClickActionListener  cal = new ClickActionListener();
    	okButton.addActionListener(cal);
    	cancleButton.addActionListener(cal);
    }
 
	private void initDeleteCourseInfo()
    {
    	this.setTitle("删除课程信息");
    	content = new JPanel();
    	courseIDLabel = new JLabel("请输入删除课程的课程号:   ");
    	courseIDText= new JTextField(10);
    	okButton = new JButton("删除");
    	cancleButton=new  JButton("取消");
        content.add(courseIDLabel);
    	content.add(courseIDText);
        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 courseID = null;
	    	if (e.getActionCommand() == "删除")
	    	{
	    		int option = JOptionPane.showConfirmDialog(DeleteCourse, "确实要删除吗", "询问？", JOptionPane.YES_NO_OPTION);
	    	    System.out.println("option = " + option );
	    	    if (option == 0)  //click "yes", means 确实删除
	    	    {
	    	    	courseID = courseIDText.getText();
	    	     	if (courseID!=null)
	    	    	{
	    		        String sqlselectCourse = null;
	    		        sqlselectCourse = "delete from 课程信息 where 课程号 = " + "\'" + courseID +"\'";
   
	    		        System.out.println("sqlselectCourse  = "  + sqlselectCourse);
	    		        SMISDB deleteCourseInfoDB = new SMISDB();
	    	            deleteCourseInfoDB.getTable(sqlselectCourse,new JFrame(),true);
	    		        System.out.println("delete course success " ); 
	    		        courseIDText.setText("");	 
	    	    	}
	    	    	
	    	    }
	    	    else
	    	    {
	    	    	// click "no"
	    	    }
	    		
	    	}
	    	else if (e.getActionCommand() == "清除")
	    	{
	    		System.out.println(" button is 清除");
	    		courseIDText.setText("");
	    	}
	    }	   
    }    
}