Question

mybatis 动态sql语句怎么写if else

Answer 1

and c.id=#{id}

and b.id=#{oid}

and a.pay_time BETWEEN #{startDate} AND #{endDate}

service层参数nullmybatis执行sql语句候拼接指定if标签sql语句