本文共 2168 字，大约阅读时间需要 7 分钟。

   
     
        
         
         
         
         
         
         
         
         
         
         
         
         
         
       
      
      
        
         
         
         
         
         
       
      
      
        
         
      	
       
      
      	
    	    
     	    
      	 
    		 
    		 	
    		 		select * form district where id=#{district_id}			 	  
     	
    	    
     	    
      	 
     	   
      
      	select * from users where id=#{user_id}    
       
      	select * from street where id=#{street_id}    
      	
      	select * from types where id=#{type_id}    
    
         ID, USER_ID, TYPE_ID, TITLE, DESCRIPTION, PRICE, PUBDATE, FLOORAGE, CONTACT, STREET_ID  
        
      
        select         from house    where ID = #{id,jdbcType=INTEGER}      
      
    
         delete from house    where ID = #{id,jdbcType=INTEGER}  
        
      
    
         insert into house     (	     USER_ID, TYPE_ID, TITLE, 	    DESCRIPTION, PRICE,  PUBDATE, 	    FLOORAGE, CONTACT, STREET_ID    )    values     (	      #{users.id,jdbcType=INTEGER}, 	     #{types.id,jdbcType=INTEGER},  #{title,jdbcType=VARCHAR},	     #{description,jdbcType=VARCHAR}, #{price,jdbcType=REAL}, 	     #{pubdate,jdbcType=DATE}, #{floorage,jdbcType=INTEGER},	     #{contact,jdbcType=VARCHAR}, #{street.id,jdbcType=INTEGER}     )  
        
      
    
     	update house set		USER_ID     = #{users.id,jdbcType=INTEGER},		TYPE_ID     = #{types.id,jdbcType=INTEGER},		TITLE  		= #{title,jdbcType=VARCHAR},		DESCRIPTION = #{description,jdbcType=VARCHAR},		PRICE		= #{price,jdbcType=REAL},		PUBDATE 	= #{pubdate,jdbcType=DATE},		FLOORAGE 	= #{floorage,jdbcType=INTEGER},		CONTACT		= #{contact,jdbcType=VARCHAR},		STREET_ID 	= #{street.id,jdbcType=INTEGER}	where ID 		= #{id,jdbcType=INTEGER}  
        
        
    	select count(0) from house h						 and h.price > #{priceBegin}							and h.price     #{priceEnd}				
     					 and h.street_id = #{street.id}		 		 
     		 		 	 and h.type_id = #{types.id}  		  					 and h.floorage > #{floorageBegin}  							and h.floorage   #{floorageEnd}			      
      
      		select * from house h						 and h.price > #{priceBegin}							and h.price     #{priceEnd}							 and h.street_id = #{street.id}		 				 	 and h.type_id = #{types.id}  		 					 and h.floorage > #{floorageBegin}  							and h.floorage   #{floorageEnd}					    limit #{stratRow},#{endRow}      
      
      		select * from house       
      
      		select * from house limit #{startRow},#{endRow}