requete1_amprunt.sql

来自「a small application in Mysql and Delphi」· SQL 代码 · 共 57 行

CREATE  PROCEDURE requte1_emprunt( code1 VARCHAR(4), code2 VARCHAR(4), code3 VARCHAR(4),code DATE)
BEGIN 

IF code1='*'THEN
    IF code2='*' THEN
               IF code3='*' THEN
			                  IF code4='*'THEN 
							     SELECT * FROM  emprunt ;
							  ELSE SELECT * FROM  emprunt WHERE date_emprunt=code4 ;
			                  END IF;             
			  ELSEIF code4='*'THEN
						SELECT * FROM  emprunt WHERE code_exemplaire=code3;
					     ELSE SELECT * FROM  emprunt WHERE code_exemplaire=code3 AND date_emprunt=code4 ;
				 
			  END IF;
               
	ELSEif code3='*' THEN
			         IF code4='*'THEN
				     SELECT * FROM  emprunt WHERE code_film=code2;
					 ELSE SELECT * FROM  emprunt WHERE code_film=code2 AND date_emprunt=code4 ;
			         END IF;    
	    ELSEIF code4='*' THEN
					    SELECT * FROM  emprunt WHERE date_emprunt=code2 AND code_exemplaire=code3;
					    ELSE SELECT * FROM  emprunt WHERE date_emprunt=code2 AND code_exemplaire=code3 AND date_emprunt=code4 ;
								     
	END IF;		        	
ELSEIF code2='*' THEN
               IF code3='*'THEN
			                  IF code4='*'THEN
							  SELECT * FROM  emprunt WHERE code_personne=code1;
						 	  ELSE SELECT * FROM  emprunt WHERE code_personne=code1 AND date_emprunt=code4 ;
			                  END IF;   
			   ELSEIF code4='*' THEN
			           SELECT * FROM  emprunt WHERE code_personne=code1 AND code_exemplaire=code3;
					   ELSE SELECT * FROM  emprunt WHERE code_personne=code1 AND code_exemplaire=code3 AND date_emprunt=code4 ;														
					  
			  END IF;
    ELSEIF code3='*' THEN
			IF code4='*' THEN
		    	SELECT * FROM  emprunt WHERE code_personne=code1 AND code_film=code2;
		
	    	 ELSE SELECT * FROM  emprunt WHERE code_personne=code1 AND code_film=code2 AND date_emprunt=code4 ;
			END IF;		                 	                
		ELSEIF code4='*' THEN
              SELECT * FROM  emprunt WHERE code_personne=code1 AND date_emprunt=code2 AND code_exemplaire=code3;
							                 
				ELSE SELECT * FROM  emprunt WHERE code_personne=code1 AND date_emprunt=code2 AND code_exemplaire=code3 AND date_emprunt=code4 ;		
			        
END IF;
END/