givebackback.java

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

/**
 * @(#)GiveBackBack.java
 *
 *
 * @author 
 * @version 1.00 2008/6/1
 */
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 GiveBackBack extends GiveBackWindow{
   	String DiscString;
  	String UserString;
  	String TimeString;
  	String t="";
  	String p="";
  	String d="";
  	String c="";
    String sqlStr;
   float plusvalue=0;
   float days=0 ;
   float price=0;
   float oldcredit=0;
   float newcredit=0;
    public GiveBackBack() {
    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();
           try{ sqlStr="select renttime from rent where UserID='"+UserString+"' and dname ='"+DiscString+"'";
                LinkBase link=new LinkBase(sqlStr,AppFrame.QUERY);
                ResultSet s=link.GetResult();
                if(s.next())
                {t=s.getString(1);
                     sqlStr="select price from disc where dname ='"+DiscString+"'";
                LinkBase link2=new LinkBase(sqlStr,AppFrame.QUERY);
                ResultSet s2=link2.GetResult();
                while(s2.next())
                { p=s2.getString(1);
                 price=Float.valueOf(p).floatValue();
                }
                sqlStr="select DateDiff(dd, '"+t+"' , getdate()) ";
                LinkBase link3=new LinkBase(sqlStr,AppFrame.QUERY);
              	ResultSet s3=link3.GetResult();
              	while(s3.next())
              	{d=s3.getString(1);
                 days=Float.valueOf(d).floatValue();
                }
                sqlStr="select usercredit from userinfo where userID ='"+UserString+"'";
                LinkBase link4=new LinkBase(sqlStr,AppFrame.QUERY);
                ResultSet s4=link4.GetResult();
                while(s4.next())
                { c=s4.getString(1);
                  oldcredit=Float.valueOf(c).floatValue();
                }
                 if(days>5)plusvalue=10;
                 else 
                 {if(days==0)
                 days=1;
                 plusvalue=days*price;
                 newcredit=oldcredit-plusvalue;
                 plus.setText(String.valueOf(plusvalue));
                 left.setText(String.valueOf(newcredit));
                 }
                ok.setEnabled(true);
                }
               else  JOptionPane.showMessageDialog(null,"该用户未借该片!"); 
             }
       	catch(SQLException se2){}
       
      }
   
    else if(e.getSource()==ok){ 
    
     
         sqlStr="delete from rent where userID='"+UserString+"' and dname='"+DiscString+"'";
      
         LinkBase link=new LinkBase(sqlStr,AppFrame.UPDATE);
         sqlStr="update disc set currentnumber=currentnumber+1 where dname='"+DiscString+"'";
         LinkBase link2=new LinkBase(sqlStr,AppFrame.UPDATE);	
         sqlStr="update userinfo set usercredit ="+newcredit+" where userID='"+UserString+"'";
         LinkBase link3=new LinkBase(sqlStr,AppFrame.UPDATE); 	
         JOptionPane.showMessageDialog(null,"归还成功!");
    	 } 
    		
    else if(e.getSource()==cancel)
    {	
    	StartWindow start=new StartWindow();
    	start.Level=Level;
    	dispose();
    }
    }
    }
       
    
}