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}