myBatis查询报错 You have an error in your SQL syntax; check the manual that corresponds to your MySQL s...

myBatis查询报错

　　 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

<select id="selectList" parameterType="com.hanilucky.core.vo.Dep"
        resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from dep
        <where>
            <if test="uuid != null">
                AND　UUID = #{uuid,jdbcType=INTEGER}
            </if>    
            <if test="name != null and name != ''">
                AND NAME = #{name,jdbcType=VARCHAR}
            </if>
            <if test="tele != null and tele != ''">
                AND TELE = #{tele,jdbcType=VARCHAR}
            </if>
        </where>
    </select>

标红的NAME是mysql的关键字,解析时报错

修改时加上``引用(数字1左边的键)

<select id="selectList" parameterType="com.hanilucky.core.vo.Dep"
        resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from dep
        <where>
            <if test="uuid != null">
                AND　UUID = #{uuid,jdbcType=INTEGER}
            </if>
            <if test="name != null and name != ''">
                AND `NAME` = #{name,jdbcType=VARCHAR}
            </if>
            <if test="tele != null and tele != ''">
                AND TELE = #{tele,jdbcType=VARCHAR}
            </if>
        </where>
    </select>

 

转载于:https://www.cnblogs.com/covet/p/10149299.html