Mybatis传多个参数（推荐）

 Dao层的函数方法

    int deleteMsgById(@Param("name") String name,@Param("id") String id);

　　对应Mapper

    <delete id="deleteMsgById" parameterType="String">
        DELETE FROM msg WHERE id=#{id} and (userId in(select id from [user] where userName=#{name}) or #{name}='sky')
    </delete>