discdelback.java

自己做的影碟碟出租管理系统

/**
 * @(#)DiscDelBack.java
 *
 *
 * @author 
 * @version 1.00 2008/5/27
 */
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.awt.*; 
import java.util.*; 

public class DiscDelBack extends DiscDelWindow{
	String NameString;
    String sqlStr;
    public DiscDelBack() {
   	ButtonHandler handler=new ButtonHandler();
    test.addActionListener(handler);
    ok.addActionListener(handler);
    cancel.addActionListener(handler); 	
    }
 
  private class ButtonHandler implements ActionListener{
   
    public void actionPerformed(ActionEvent e){
    if(e.getSource()==test)
    {
    	
    	NameString=NameField.getText().trim();
        sqlStr="select totlenumber,currentnumber from disc where dname ='"+NameString+"'";
        LinkBase link=new LinkBase(sqlStr,AppFrame.QUERY);
        float totle=0,current=-1;
        ResultSet s=link.GetResult();
       try { while(s.next())
            {
            	totle=Float.valueOf(s.getString(1)).floatValue();
            	current=Float.valueOf(s.getString(2)).floatValue();
            }
         if(totle==current)
          {  ok.setEnabled(true); 
         	 JOptionPane.showMessageDialog(null,"可以删除!");
         	}
        else  JOptionPane.showMessageDialog(null,"不存在或仍有在借的碟片,请回收!"	);
       	}
      catch(SQLException se){
		 
		}

    }
    else if(e.getSource()==ok){ 
      	NameString=NameField.getText().trim();
        sqlStr="delete  from disc where dname ='"+NameString+"'";
        LinkBase link=new LinkBase(sqlStr,AppFrame.UPDATE);	
        JOptionPane.showMessageDialog(null,"删除成功!");
    	  }
    else if(e.getSource()==cancel)
    {	
    	StartWindow start=new StartWindow();
    	start.Level=Level;
    	dispose();
    }
    }
    }
       
    
}