rentback.java

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

/**
 * @(#)RentBack.java
 *
 *
 * @author 
 * @version 1.00 2008/5/31
 */
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.awt.*; 
import java.util.*;
import java.text.SimpleDateFormat;
import java.text.ParseException;

public class RentBack extends RentWindow{

  	String DiscString;
  	String UserString;
  	String TimeString;
    String sqlStr;
   
    public RentBack() {
   	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)
    {
      	DiscString=DiscField.getText();
    	UserString=UserField.getText();
        sqlStr="select currentnumber from disc where dname ='"+DiscString+"'";
        LinkBase link=new LinkBase(sqlStr,AppFrame.QUERY);
        float current=-1;
        ResultSet s=link.GetResult();
      try { while(s.next())
            {
            	current=Float.valueOf(s.getString(1)).floatValue();
            }
         if(current==-1)JOptionPane.showMessageDialog(null,"没有该片！请检查输入!");
         else if(current==0) JOptionPane.showMessageDialog(null,"Sorry，该碟片全部借出!"	);   
         else 
          {  ok.setEnabled(true); 
         	 
           sqlStr="select * from rent where UserID='"+UserString+"' and dname ='"+DiscString+"'";
           LinkBase link2=new LinkBase(sqlStr,AppFrame.QUERY);
           ResultSet s2=link2.GetResult();
         try{
           if(s2.next())
            {
           JOptionPane.showMessageDialog(null,"该用户已在租赁该片!");	
           ok.setEnabled(false); 
           	}
          else JOptionPane.showMessageDialog(null,"可以租赁!");
          } 
         
       	catch(SQLException se2){}
          }
         
       	}
       	catch(SQLException se){}
    }
   
    else if(e.getSource()==ok){ 
      
        sqlStr="insert into rent values('"+UserString+"','"+DiscString+"',CONVERT(varchar(10), getdate(), 120))";
      
         LinkBase link=new LinkBase(sqlStr,AppFrame.UPDATE);
         sqlStr="update disc set currentnumber=currentnumber-1 where dname='"+DiscString+"'";
         LinkBase link2=new LinkBase(sqlStr,AppFrame.UPDATE);	
         JOptionPane.showMessageDialog(null,"租赁成功!");
    }	 
    else if(e.getSource()==cancel)
    {	
    	StartWindow start=new StartWindow();
    	start.Level=Level;
    	dispose();
    }
    }
    }
       
    
}