Myibatis Mapper配置文件写错导致的错误

最新推荐文章于 2022-04-01 00:03:52 发布

大米饭66

最新推荐文章于 2022-04-01 00:03:52 发布

阅读量479

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/oschina_40730821/article/details/80464612

本文介绍了一种在MyBatis中进行查询优化的方法，通过调整SQL语句结构，特别是将LIMIT子句放置于WHERE条件之外，以提高查询效率。文章详细展示了如何修正SQL语句以避免潜在的语法错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

### SQL: select * from customer WHERE limit ?,? ### Cause: com.mysql.jdbc.ex

改正前、

<select id="querycustomerinfo" parameterType="QueryVo" resultType="Customer">
      select * from customer
      <where>
          <if test="custName!=null and custName!=''">
          and cust_name link "%" #{custName} "%"
          </if>
          <if test="custSource!=null and custSource!=''">
          and cust_source=#{custSource}
          </if>
          <if test="custIndustry!=null and custIndustry!=''">
          and cust_industry=#{custIndustry}
          </if>
          <if test="custLevel!=null and custLevel!=''">
          and cust_level=#{custLevel}
          </if>
             limit #{start},#{rows}
       </where>

   </select>

改正后

<select id="querycustomerinfo" parameterType="QueryVo" resultType="Customer">
      select * from customer
      <where>
          <if test="custName!=null and custName!=''">
          and cust_name link "%" #{custName} "%"
          </if>
          <if test="custSource!=null and custSource!=''">
          and cust_source=#{custSource}
          </if>
          <if test="custIndustry!=null and custIndustry!=''">
          and cust_industry=#{custIndustry}
          </if>
          <if test="custLevel!=null and custLevel!=''">
          and cust_level=#{custLevel}
          </if>

       </where>
       limit #{start},#{rows}
   </select>