Mybatis动态SQL

    select * from sys_user
    
        and user_id = #{userId}
        and user_name = #{userName}
        and email = #{email}
    



    select * from sys_user
    
        
            
                user_id = #{userId}
            
            
                user_name = #{userName}
            
            
                email = #{email}
            
            
                1 = 1
            
        
    



    update sys_user
    
        user_name = #{userName},
        email = #{email},
    
    where user_id = #{userId}



    select * from sys_user
    where user_id in
    
        #{item}
    



    insert into sys_user(dept_id,user_name,email)
    values
    
       ( #{user.deptId},#{user.userName},#{user.email} )