SpringBoot+mysql+Mybatis返回值对象中含有对象集合
1.对象personalHistoryInfo
public class PersonalHistoryInfo {/** 员工id */private String staffId;/** 员工姓名 */private String staffName;/** 事务id */private String affairId;/** 事务名称 */private String affairName;/** 评价人id */private String evaluatorId;/** 系列 */private String series;/** du */private String du;/** 总分 */private Double sumScore;/** 修改时间 */private Date ChangeTime;/** 事务维度 */private List<PersonalAffairdimension> PersonalAffairdimensionList;}
2.集合内对象
public class PersonalAffairdimension {/** 员工id */private String employeeId;/** 事务维度ID */private Integer transactionDimensionId;/** 维度ID */private int dimensionId;/** 事务名称 */private String dimensionName;/** 维度分数 */private Double score;/** 评价 */private String evaluation;/** 考核点说明 */private String explanation;/** 最高分数 */private Double mark;}
3.映射文件
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapperPUBLIC "-////DTD Mapper 3.0//EN""/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.jjdd.PersonalCenterMapper"><resultMap id="personalHistoryAffairMapper" type="com.jjdd.PersonalHistoryInfo"><id column="staffId" property="staffId"></id><id column="affairId" property="affairId"></id><result column="staffName" property="staffName"></result><result column="affairName" property="affairName"></result><result column="evaluatorId" property="evaluatorId"></result><result column="affairId" property="affairId"></result><result column="affairName" property="affairName"></result><result column="series" property="series"></result><result column="du" property="du"></result><result column="changeTime" property="changeTime"></result><result column="sumScore" property="sumScore"></result><collection property="PersonalAffairdimensionList" ofType="com.jjdd.PersonalAffairdimension"><id column="transactionDimensionId" property="transactionDimensionId"></id><result column="dimensionId" property="dimensionId"></result><result column="dimensionName" property="dimensionName"></result><result column="score" property="score"></result><result column="evaluation" property="evaluation"></result><result column="explanation" property="explanation"></result><result column="mark" property="mark"></result></collection></resultMap><select id="queryHistorySolved" parameterType="java.util.Map" resultMap="personalHistoryAffairMapper">SELECTtemp.*, med.explanation,med.markFROM(SELECTa.staffId,a.staffName,a.evaluatorId,a.affairId,a.affairName,a.series,a.du,b.sumScore,b.changeTime,b.transactionDimensionId,b.dimensionId,b.dimensionName,b.score,b.evaluationFROM..............</select></mapper>
4.json结果
…
