Mybatis 自定义类型处理程序不起作用：java.lang.NoSuchMethodException：org.springframework.security.core.GrantedAutho

Question

**我正在对我的应用程序实现基于角色的访问控制。应用程序中有3个用户(Admin、Teacher、Student(具有相同的属性，因此我创建了一个basedUser实体，让他们继承它。我希望在从数据库中选择时获得用户的权限，所以我创建了类型处理程序，在该过程中将String类型中的权限转换为GrantedAuthority类型，但我不知道为什么会一直出现这个错误：**

嵌套异常为org.mybati.spring.MyBatisSystemException：嵌套异常为org.apache.ibati.reflection.ReflectionException：实例化具有无效类型((或值((的接口org.springframework.security.core.GrantedAuthority时出错。原因：java.lang.NoSuchMethodException：org.springframework.security.coreGrantedAuthority.((]，根本原因为

java.lang.NoSuchMethodException:org.springframework.security.coreGrantedAuthority.((位于java.base/java.lang.Class.getConstructor0(Class.java：3349(~[na:na]位于java.base/java.lang.Class.getDeclaredConstructor(Class.java:2553(~[na:na]网址：org.apache.ibatis.reflection.factory.DefaultObjectFactory.instantiateClass(DefaultObjectFactory.java:60(~[mybatis-3.5.4.jar:3.5.4]网址：org.apache.ibatis.reflection.factory.DefaultObjectFactory.create(DefaultObjectFactory.java:53(~[mybatis-3.5.4.jar:3.5.4]网址：org.apache.ibatis.reflection.factory.DefaultObjectFactory.create(DefaultObjectFactory.java:45(~[mybatis-3.5.4.jar:3.5.4]网址：org.apache.ibati.executor.resultset.DefaultResultSetHandler.createResultObject(DefaultResultSetHandler.java：616(~[mybatis-3.5.4.jar:3.5.4]网址：org.apache.ibati.executor.resultset.DefaultResultSetHandler.createResultObject(DefaultResultSetHandler.java：591(~[mybatis-3.5.4.jar:3.5.4]

我一直在寻找这个问题的答案，但没有找到任何答案，有人知道如何解决这个问题吗？？

实体

@Data
public class BaseUser {
protected Integer id;
protected String username;
protected String password;
protected Date birthday;
protected String email;
protected String phone;
protected String address;
protected Boolean status;
protected String creator;
protected Date createTime;
protected Date updateTime;
protected Set<GrantedAuthority> authorities;

Mybatis xml查询：

<select id="selectByAdminId" resultMap="AdminResultMap">
SELECT a.id, a.password, a.admin_name, a.birthday, a.email, a.phone, a.address, a.status , au.authority as authority
FROM admin a
JOIN user_role ur ON ur.user_id = a.id
JOIN role r ON r.id = ur.role_id
JOIN role_authority ra ON ra.role_id = r.id
JOIN authority au ON au.id = ra.authority_id
WHERE a.id = #{id} and r.status = 1 AND au.status = 1
</select>

Mybatis标测

<resultMap id="BaseUserResultMap" type="com.example.abstractionizer.student.management.system5.db.rmdb.entities.BaseUser">
<id column="id" property="id" jdbcType="INTEGER"/>
<result column="password" property="password" jdbcType="VARCHAR"/>
<result column="admin_name" property="username" jdbcType="VARCHAR"/>
<result column="birthday" property="birthday" jdbcType="DATE"/>
<result column="email" property="email" jdbcType="VARCHAR"/>
<result column="phone" property="phone" jdbcType="VARCHAR"/>
<result column="address" property="address" jdbcType="VARCHAR"/>
<result column="status" property="status" jdbcType="TINYINT"/>
<collection property="authorities" ofType="org.springframework.security.core.GrantedAuthority">
<result column="authority" jdbcType="VARCHAR" typeHandler="com.example.abstractionizer.student.management.system5.handlers.GrantedAuthorityTypeHandler"/>
</collection>
</resultMap>
<resultMap id="AdminResultMap" type="com.example.abstractionizer.student.management.system5.db.rmdb.entities.Admin" extends="BaseUserResultMap">
</resultMap>

类型处理程序

@Slf4j
@MappedJdbcTypes({JdbcType.VARCHAR})
public class GrantedAuthorityTypeHandler extends BaseTypeHandler<GrantedAuthority> {
@Override
public void setNonNullParameter(PreparedStatement preparedStatement, int i, GrantedAuthority grantedAuthority, JdbcType jdbcType) throws SQLException {
preparedStatement.setObject(i, grantedAuthority.toString(), jdbcType.TYPE_CODE);
}
@Override
public GrantedAuthority getNullableResult(ResultSet resultSet, String s) throws SQLException {
return new SimpleGrantedAuthority(resultSet.getString(s));
}
@Override
public GrantedAuthority getNullableResult(ResultSet resultSet, int i) throws SQLException {
return new SimpleGrantedAuthority(resultSet.getString(i));
}
@Override
public GrantedAuthority getNullableResult(CallableStatement callableStatement, int i) throws SQLException {
return new SimpleGrantedAuthority(callableStatement.getNString(i));
}
}

Answer 1

类型处理程序不适合您的使用
您应该使用构造函数映射。

...
<collection property="authorities" 
ofType="org.springframework.security.core.authority.SimpleGrantedAuthority">
<constructor>
<idArg column="authority" javaType="string" />
</constructor>
</collection>
...

由于GrantedAuthority是一个接口，MyBatis不知道如何实例化它，因此需要为ofType指定一个具体类型(即SimpleGrantedAuthority(。