userqueryback.java

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

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

public class UserQueryBack extends UserQueryWindow{
       String NameString;
       String RoleString;
       String TypeString;
       String AreaString;
       String TimeString;
       String sqlStr;
       String[] result=new String[7];
       int find;
       
       
    public UserQueryBack() {
     
      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);
     cancel.addActionListener(handler);
        
    }
    
       public void SetName(String s){
      	NameString=s;
      	}
       public void SetRole(String s){
       	RoleString=s;
       	}
       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 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){  
    	SetName(NameField.getText());
    	SetRole(RoleField.getText());
      if(TypeString!=null&&TypeString.length()==0)TypeString=null;
      if(AreaString!=null&&AreaString.length()==0)AreaString=null;
      if(TimeString!=null&&TimeString.length()==0)TimeString=null;
      
    int ch=0;
    if(GetName().length()!=0)
    	ch=1;
    else{
    if(GetRole().length()!=0&&TypeString==null&&TimeString==null&&AreaString==null)
    	ch=2;
    if(GetRole().length()!=0&&TypeString!=null&&TimeString==null&&AreaString==null)
    	ch=3;
    if(GetRole().length()!=0&&TypeString==null&&TimeString!=null&&AreaString==null)
    	ch=4;
    if(GetRole().length()!=0&&TypeString==null&&TimeString==null&&AreaString!=null)
    	ch=5;
    if(GetRole().length()!=0&&TypeString!=null&&TimeString!=null&&AreaString==null)
    	ch=6;
    if(GetRole().length()!=0&&TypeString!=null&&TimeString==null&&AreaString!=null)
    	ch=7;
    if(GetRole().length()!=0&&TypeString==null&&TimeString!=null&&AreaString!=null)
    	ch=8;
    if(GetRole().length()!=0&&TypeString!=null&&TimeString!=null&&AreaString!=null)
    	ch=9;
    if(GetRole().length()==0&&TypeString!=null&&TimeString==null&&AreaString==null)
    	ch=10;
    if(GetRole().length()==0&&TypeString==null&&TimeString!=null&&AreaString==null)
    	ch=11;
    if(GetRole().length()==0&&TypeString==null&&TimeString==null&&AreaString!=null)
    	ch=12;
    if(GetRole().length()==0&&TypeString!=null&&TimeString!=null&&AreaString==null)
    	ch=13;
    if(GetRole().length()==0&&TypeString!=null&&TimeString==null&&AreaString!=null)
    	ch=14;
    if(GetRole().length()==0&&TypeString==null&&TimeString!=null&&AreaString!=null)
    	ch=15;
    if(GetRole().length()==0&&TypeString!=null&&TimeString!=null&&AreaString!=null)
    	ch=16;
    
   }
 
	switch(ch)
    	{
    	 case 0:    sqlStr="select * from disc ";break;
    	 case 1: 	sqlStr="select * from disc where dname like '%"+GetName()+"%'";break;
    	 case 2: 	sqlStr="select * from disc where role like '%"+GetRole()+"%'";break;
         case 3: 	sqlStr="select * from disc where role like '%"+GetRole()+"%' and type='"+GetType()+"'";break;
    	 case 4: 	sqlStr="select * from disc where role like '%"+GetRole()+"%' and time='"+GetTime()+"'";break;
    	 case 5: 	sqlStr="select * from disc where role like '%"+GetRole()+"%' and area='"+GetArea()+"'";break;
    	 case 6: 	sqlStr="select * from disc where role like '%"+GetRole()+"%' and type='"+GetType()
    	 	                +"' and time='"+GetTime()+"'";break;
    	 case 7: 	sqlStr="select * from disc where role like '%"+GetRole()+"%' and type='"+GetType()
    	 	                +"' and area='"+GetArea()+"'";break;
    	 case 8: 	sqlStr="select * from disc where role like '%"+GetRole()+"%' and area='"+GetArea()
    	 	                +"' and time='"+GetTime()+"'";break;
    	 case 9: 	sqlStr="select * from disc where role like '%"+GetRole()+"%' and type='"+GetType()
    	 	                +"' and time='"+GetTime()+"' and area='"+GetArea()+"'";break;
    	 case 10:	sqlStr="select * from disc where type='"+GetType()+"'";break;
    	 case 11:	sqlStr="select * from disc where role like '%"+GetRole()+"%'";break;
    	 case 12: 	sqlStr="select * from disc where area='"+GetArea()+"'";break;
    	 case 13: 	sqlStr="select * from disc where type='"+GetType()+"' and time='"+GetTime()+"'";break;
    	 case 14: 	sqlStr="select * from disc where type='"+GetType()+"' and area='"+GetArea()+"'";break;	
    	 case 15: 	sqlStr="select * from disc where time='"+GetTime()+"' and area='"+GetArea()+"'";break;
    	 case 16: 	sqlStr="select * from disc where type='"+GetType()+"' and time='"+GetTime()
    	 	+"' and area='"+GetArea()+"'";break;
    	
   	}
   	    LinkBase link=new LinkBase(sqlStr,AppFrame.QUERY);
        ResultSet s=link.GetResult();
        
   try {
    	find=0;
    	rowdata.removeAllElements();
     	while(s.next())
    	{
       	find++;
       	Vector currentRow = new Vector(); 
            result[0]=s.getString(1);
        	result[1]=s.getString(2);
            result[2]=s.getString(3);
        	result[3]=s.getString(4);
            result[4]=s.getString(5);
        	result[5]=s.getString(6);
        	result[6]=s.getString(8);
        	
        	for(int i=0;i<7;i++)
        	currentRow.addElement(result[i]);
            rowdata.addElement(currentRow); 
    	}
        
           table.repaint();
           setExtendedState(JFrame.MAXIMIZED_BOTH);
        	NumberField.setText(String.valueOf(find));
        }
        catch(SQLException se){
        se.printStackTrace();

        	}
       catch(NullPointerException ne)
        {
      	ne.printStackTrace();
        }
    	
    	}
    
    else if(e.getSource()==cancel)
    {	
    	StartWindow start=new StartWindow();
    	start.Level=Level;
    	dispose();
    }
  }
   		
}



}