select        id,        use_name userName,        user_password userPassword,        user_email userEmail,        user_info userInfo,        head_img headImg,        create_time createTime      from sys_user      where        user_name like concat('%',#{userName},'%') and        uer_email=#{userEmail}        
               select        id,        use_name userName,        user_password userPassword,        user_email userEmail,        user_info userInfo,        head_img headImg,        create_time createTime      from sys_user      where        1=1                        and user_name like concat('%',#{userName},'%')                                and user_email = #{userEmail}                
         
         
     
              update sys_user        set          
      
                         user_name=#{userName},          
                
      
                         user_email=#{userEmail},          
                
      
                         user_info=#{userInfo},          
                
      
                         head_img=#{headImg},          
                
      
                         create_time=#{createTime},          
                id=#{id}        where id=#{id}    
         
         
     
              INSERT INTO sys_user          (id,user_name,user_password,          
      
                     user_email,          
                user_info,head_img,create_time)        VALUES          (#{id},#{userName},#{userPassword},          
      
                     #{userEmail},          
                #{userInfo},#{headImg,jdbcType=BLOB},#{createTime,jdbcType=TIMESTAMP})    
     

 

 

From《MyBatis从入门到精通》