被折磨了一个小时
搜了一大堆资料,什么空格多余等等等等,最后发现是没写全限定名
<mapper namespace="com.how2java.pojo">
<insert id="addCategory" parameterType="Category" >
insert into category_ ( name ) values (#{name})
</insert>
<delete id="deleteCategory" parameterType="Category" >
delete from category_ where id= #{id}
</delete>
<select id="getCategory" parameterType="_int" resultType="">
select * from category_ where id= #{id}
</select>
<update id="updateCategory" parameterType="Category" >
update category_ set name=#{name} where id=#{id}
</update>
<select id="listCategory" resultType="Category">
select * from category_
</select>
</mapper>
要写成
<mapper namespace="com.how2java.pojo">
<insert id="addCategory" parameterType="com.bruce.pojo.Category" >
insert into category_ ( name ) values (#{name})
</insert>
<delete id="deleteCategory" parameterType="com.bruce.pojo.Category" >
delete from category_ where id= #{id}
</delete>
<select id="getCategory" parameterType="_int" resultType="com.bruce.pojo.Category">
select * from category_ where id= #{id}
</select>
<update id="updateCategory" parameterType="com.bruce.pojo.Category" >
update category_ set name=#{name} where id=#{id}
</update>
<select id="listCategory" resultType="com.bruce.pojo.Category">
select * from category_
</select>
</mapper>
或者 在mybatis的核心配置文件中配置别名
<typeAliases>
<package name="com.bruce.pojo"/>
</typeAliases>