MyBatisXML去除多余AND|OR前缀或逗号等后缀的操作

select * from user 

 AND user_name=#{userName}
 AND login_name=#{loginName}

select * from user where login_name = 'xx'

update user

 user_name=#{userName} , 
 login_name=#{loginName} , 

update user set login_name='xx'  where user_id='xx'

select

from uc_user


user_name = #{userName}


or email = #{email}


or phOne= #{phone}


or weibo_id = #{weiboId}


or wx_id = #{wxId}
 

or qq_id = #{qqId}


and status = 1