mybatis更新语句(mybatis oracle 批量更新)

    
        insert into user
            
                
                    id,
                
                
                    username,
                
                
                    password,
                
                
                    nickname,
                
                
                    email,
                
                
                    phone,
                
                
                    address
                
            
            
                
                    #{id},
                
                
                    #{username},
                
                
                    #{password},
                
                
                    #{nickname},
                
                
                    #{email},
                
                
                    #{phone},
                
                
                    #{address}
                
            
    

    update user
    
        
            username = #{username}
        
        
            password = #{password}
        
        
            nickname = #{nickname}
        
        
            email = #{email}
        
        
            phone = #{phone}
        
        
            address = #{address}
        
    
    
        id = #{id}