id, c_name, c_sex, c_addr, c_identity, c_phone, c_company_name, createdate  
          
        
          select         ,        from customer    where id = #{id,jdbcType=INTEGER}      
        
      
           delete from customer    where id = #{id,jdbcType=INTEGER}  
         
        
      
           insert into customer    
             
        
                 id,      
              
        
                 c_name,      
            
           
             
        
                 #{id,jdbcType=INTEGER},      
              
        
                 #{c_name,jdbcType=VARCHAR},      
                  
         
          
        
      
           update customer    
             
        
                 c_name = #{c_name,jdbcType=VARCHAR},      
              
        
                 c_sex = #{c_sex,jdbcType=VARCHAR},      
            
           where id = #{id,jdbcType=INTEGER}