Mybaits配置文件之动态SQL配置备忘录

    select ID,COMMAND,DESCRIPTION,CONTENT from MESSAGE where 1=1
    
      and COMMAND=#{command}
    
    
      and DESCRIPTION like '%' #{description} '%'
    
  

    delete from MESSAGE WHERE ID = #{_parameter}

  
    delete from MESSAGE WHERE ID in (
    
      #{item}
    
    )