pojo部分: @Data @TableName(value = "sys_user",autoResultMap = true) public class SysUserVo { @TableField(typeHandler = JacksonTypeHandler.class) private String[] professionalField;
}
xml部分:
<resultMap type="com.process.ark.domain.vo.SysUserVo" id="SysUserResult"> <result column="professional_field" jdbcType="VARCHAR" property="professionalField" typeHandler="com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler" /> </resultMap>
------collection部分----
<resultMap type="SysUser" id="SysUserResult">
<result column="professional_field" jdbcType="VARCHAR" property="professionalField" typeHandler="com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler" />
<association property="dept" column="dept_id" javaType="SysDept" resultMap="deptResult"/>
<collection property="roles" javaType="java.util.List" resultMap="RoleResult"/>
</resultMap>
<resultMap id="deptResult" type="SysDept">
<id property="deptId" column="dept_id"/>
<result property="parentId" column="parent_id"/>
<result property="deptName" column="dept_name"/>
<result property="ancestors" column="ancestors"/>
<result property="orderNum" column="order_num"/>
<result property="leader" column="leader"/>
<result property="status" column="dept_status"/>
</resultMap>
核心注解:@TableField