discinfochangeback.java

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

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

public class DiscInfoChangeBack extends DiscInfoChangeWindow{
       String NameString;
       String RoleString;
       float NumberString;
       float PriceString;
       String TypeString;
       String AreaString;
       String TimeString;
       String role;
   	   String area;
   	   String time;
   	   String type;
   	   String number;
   	   String price;
       String sqlStr;
       int ch=0;
    public DiscInfoChangeBack() {
    	
 
       TypeBox.addItemListener(
        	new ItemListener(){
        	public void itemStateChanged(ItemEvent e)
        	{
        		if(e.getStateChange()==ItemEvent.SELECTED)
        			SetType(names3[TypeBox.getSelectedIndex()]);
        	}
        		}
        	);
         TimeBox.addItemListener(
        	new ItemListener(){
        	public void itemStateChanged(ItemEvent e)
        	{
        		if(e.getStateChange()==ItemEvent.SELECTED)
        			SetTime(names2[TimeBox.getSelectedIndex()]);
        	}
        		}
        	);
        
         AreaBox.addItemListener(
        	new ItemListener(){
        	public void itemStateChanged(ItemEvent e)
        	{
        		if(e.getStateChange()==ItemEvent.SELECTED)
        		SetArea(names1[AreaBox.getSelectedIndex()]);
        	}
        		}
        	);
       
        ButtonHandler handler=new ButtonHandler();
        ok.addActionListener(handler);
        change.addActionListener(handler);
        cancel.addActionListener(handler);
       
   }
   
   
    public void SetName(String s){
      	NameString=s;
      	}
       public void SetRole(String s){
       	RoleString=s;
       	}
       public void SetNumber(String s){
       	NumberString=Float.valueOf(s).floatValue();
       	}
       public void SetPrice(String s){
       	PriceString=Float.valueOf(s).floatValue();
       	}
       public void SetType(String s){
       	TypeString=s;
       	}
       public void SetArea(String s){
       	AreaString=s;
       	}
       public void SetTime(String s){
       	TimeString=s;
       	}
       
       public String GetName(){
       	return NameString;
       	}
       public String GetRole(){
       	return RoleString;
       	}
       public float GetNumber(){
       	return NumberString;
       	}
       public float GetPrice(){
       	return PriceString;
       	}
       public String GetType(){
       	return TypeString;
       	}
       public String GetArea(){
       	return AreaString;
       	}
       public String GetTime(){
       	return TimeString;
       	}
    
  private class ButtonHandler implements ActionListener{
   
    public void actionPerformed(ActionEvent e){
    if(e.getSource()==ok){ 
    change.setEnabled(true);
    SetName(NameField.getText());


   sqlStr="select * from disc where dname='"+GetName()+"'";     
   LinkBase link=new LinkBase(sqlStr,AppFrame.QUERY);
   ResultSet s=link.GetResult();
   try{
   	while(s.next())
   	{
     role=s.getString(2);
   	 area=s.getString(3);
     time=s.getString(4);
   	 type=s.getString(5);
   	 number=s.getString(7);
   	 price=s.getString(8);
   		}
   	RoleField.setText(role);
   	NumberField.setText(number);
   	PriceField.setText(price); 
   	  
   	for(int i=0;i<5;i++)
   	 if(names1[i].equals(area.trim()))
   		ch=i;
 	AreaBox.setSelectedIndex(ch);
   
   	for(int i=0;i<10;i++)
   	 if(names2[i].equals(time.trim()))
   		ch=i;
  
   	TimeBox.setSelectedIndex(ch);
   	
   	for(int i=0;i<11;i++)
   	 if(names3[i].equals(type.trim()))
   		ch=i;
  
   	TypeBox.setSelectedIndex(ch);
   		
	}
	catch(SQLException se){
		  JOptionPane.showMessageDialog(null,"不存在!");
		}
	catch(NullPointerException ne){
		  JOptionPane.showMessageDialog(null,"不存在!");
		}
   }
    	 
    else if(e.getSource()==change)
    {
   try{ SetRole(RoleField.getText());
    SetNumber(NumberField.getText());
    SetPrice(PriceField.getText());
    sqlStr="update disc set role='"+GetRole()+"',area='"+GetArea()+"',type='"+GetType()
    	+"',time='"+GetTime()+"',totlenumber="+GetNumber()+",price="+GetPrice()+
    		" where dname='"+GetName()+"'";
    LinkBase link=new LinkBase(sqlStr,AppFrame.UPDATE);	
    JOptionPane.showMessageDialog(null,"成功修改 "+GetName()+" 相关信息");		
  	}
  	catch(NumberFormatException nfe){
  	JOptionPane.showMessageDialog(null,"出错!");
  		}
  	}
    	
    else if(e.getSource()==cancel)
    {	
    	StartWindow start=new StartWindow();
    	start.Level=Level;
    	dispose();
    }
    }
    }
    
    
    
    
}