mybatis if or 语句
- 作者: 哼着小调啦啦~
- 来源: 51数据库
- 2020-10-03
and c.id=#{id}
and b.id=#{oid}
and a.pay_time BETWEEN #{startDate} AND #{endDate}
service层参数nullmybatis执行sql语句候拼接指定if标签sql语句
在对应的.xml中添加insert标签,换掉中间的insert语句 <insert id="adduser" parametertype="user" usegeneratedkeys="true" keyproperty="id"> insert into user(username,userage,useraddress) values(#{username},#{userage},#{useraddress}) </insert>
and b.id=#{oid}
and a.pay_time BETWEEN #{startDate} AND #{endDate}
service层参数nullmybatis执行sql语句候拼接指定if标签sql语句
在对应的.xml中添加insert标签,换掉中间的insert语句 <insert id="adduser" parametertype="user" usegeneratedkeys="true" keyproperty="id"> insert into user(username,userage,useraddress) values(#{username},#{userage},#{useraddress}) </insert>
推荐阅读