mybatis一对多 关系映射问题
踩坑2小时,先说结论,错误与代码如下
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.pageheper.dao.UserDao">
<resultMap id="userMap" type="com.example.pageheper.entity.User">
<id property="id" column="id"/>
<result property="username" column="username"/>
<result property="birthday" column="birthday"/>
<result property="sex" column="sex"/>
<result property="address" column="address"/>
<collection property="roles" ofType="com.example.pageheper.entity.Role">
<id property="roleId" column="rid"/>
<result property="roleName" column="ROLE_NAME"/>
<result property="roleDesc" column="ROLE_DESC"/>
</collection>
</resultMap>
<select id="findAll" resultMap="userMap">
SELECT u.*,r.ID as rid,r.ROLE_DESC,r.ROLE_NAME FROM user u
LEFT OUTER JOIN user_role ur on u.id = ur.UID
LEFT OUTER JOIN role r on ur.RID = r.ID
</select>
</mapper>
本来写给demo测分页没想到踩大坑,2小时未解决只能去看mybatis底层,发现底层是根据反射来定义,后发现自己手贱定义返回user和relo类时加了一个有参构造,有参构造!!!java中有参构造后会默认无视无参构造,而反射的Class.forName(“className”).newInstance();需要对应的类提供一个无参构造函数。不然就会报错,看到这里你应该会恍然大悟,所以解决方法给返回类加上无参构造或者去掉你加有参构造使用java默认的无参构造,去掉构造参数后轻松查出!
踩坑不易,给个关注吧~~后续持续更新…