mybatis全局配置文件

 


 
		
	
  
	
  
    insert into tb_allorders (buy_personid,receive_person,receive_phone,receive_address,state,ispay) values (#{buyPersonid},#{receivePerson},#{receivePhone},#{receiveAddress},#{state},#{ispay}) 
  
	
	
  
	
   select * from tb_allorders where orders_id=#{ordersId} 
	
	
  
	
   select count(orders_id) from tb_allorders 
	
	
  
	
  
    update tb_allorders set state = #{state} where orders_id = #{ordersId} 
  
	
	
  
	
   select * from (select tb_allorders.* , rownum rn from tb_allorders where rownum <= #{endIndex})temp where temp.rn >#{startIndex} order by orders_id desc 
	
	
  
	
   select * from tb_allorders   orders_id = #{ordersId}   and buy_personid = #{buyPersonid}   
	
	
  
	
   
    
    
    
    
    
    
    
    
    
    
     
     
     
     
     
     
     
     
    
  
	
	
   select tall.*,t.* from tb_allorders tall left join tb_order t on tall.orders_id = t.orders_id