Mybatis菜鸟BUG集

Debug1：

### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance.  Cause: org.xml.sax.SAXParseException; lineNumber: 30; columnNumber: 58; 元素内容必须由格式正确的字符数据或标记组成。

Question1：

select * from demo_user where sex=#{sex} and age<#{age}

Solve1：<![CDATA[  select * from demo_user where sex=#{sex} and age<#{age}]]>

Debug2：

Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%精% desc' at line 1

Question2：

<select id="findCover" resultType="com.jt.pojo.DemoUser">
    select * from demo_user where name like "%"#{name}"%" order by ${name} desc
</select>

Solve2：

select * from demo_user where name like "%"#{name}"%" order by #{age} desc

Debug3：

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'null (

            '大乔'

         ,

            '小乔'

     ...' at line 1

Question3：

<update id="findUpdata" >
update demo_user set age = #{age}, sex = #{sex} where name in #{name} (
    <foreach collection="names" item="name" separator=",">
        #{name}
    </foreach>
    )
</update>

Solve3：

<update id="findUpdata" >
update demo_user set age = #{age}, sex = #{sex} where name in (
    <foreach collection="names" item="name" separator=",">
        #{name}
    </foreach>
    )
</update>

Debug4：

Preparing: select * from demo_user where name like '%'?'%' order by age desc

DEBUG com.jt.mapper.DemoUserMapper.findCover - ==> Parameters: %精%(String)

 DEBUG com.jt.mapper.DemoUserMapper.findCover - <==      Total: 0

[]

Question4：

<select id="findCover" resultType="com.jt.pojo.DemoUser">
    select * from demo_user where name like '%'#{name}'%' order by ${age} desc
</select>

Solve4：

<select id="findCover" resultType="com.jt.pojo.DemoUser">
    select * from demo_user where name like "%"#{name}"%" order by ${age} desc
</select>

Debug5：

Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'mybatis/mappers/demoUserMapper.xml'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.pojo.DemoUser'.  Cause: java.lang.ClassNotFoundException: Cannot find class: com.pojo.DemoUser

Question5：

<select id="selectUser" resultType="com.pojo.DemoUser">
    <![CDATA[  select * from demo_user where sex=#{sex} and age<#{age}]]>
</select>

Solve5：

<select id="selectUser" resultType="com.jt.pojo.DemoUser">
    <![CDATA[  select * from demo_user where sex=#{sex} and age<#{age}]]>
</select>

Debug6：

Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance.  Cause: org.xml.sax.SAXParseException; lineNumber: 12; columnNumber: 50; 元素内容必须由格式正确的字符数据或标记组成。

Question6：

select * from demo_user where sex=#{sex} and age<#{age}

Solve6：

<![CDATA[  select * from demo_user where sex=#{sex} and age<#{age}]]>