<select id="getOrderListByPage" resultType="java.util.Map">
select o.order_id as orderId from
<include refid="table_name"></include> as o
<!-- 查询用户订单 -->
<if test="userId != null and userId != ''">
where o.created_by = #{userId}
</if>
order by o.create_time desc
limit #{offset}, #{limit}
</select>
mybatis代码字段如上,但是报错,将select * from tbl where created_by = 111 在mysql中执行也没有报错,
但是created_by 改成 created_user 之后就没问题了,说明mybatis中created_by是有问题,可能是关键词来的
<select id="getOrderListByPage" resultType="java.util.Map">
select o.order_id as orderId from
<include refid="table_name"></include> as o
<!-- 查询用户订单 -->
<if test="userId != null and userId != ''">
where o.created_user = #{userId}
</if>
order by o.create_time desc
limit #{offset}, #{limit}
</select>