DemoEntity.java
package com.example.demo.entity.DemoEntity
public class DemoEntity {
private Integer id;
private Integer queryId;
private Object result;
// get/set ...
}
DemoMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.demo.mapper.DemoMapper">
<resultMap id="id" type="com.example.demo.entity.DemoEntity" extends="BaseResultMap">
<id column="id" property="id"/>
<result column="query_id" property="queryId"/>
<association property="result" column="{id=id,queryId=query_id}"
javaType="java.lang.Object"
select="com.example.demo.mapper.DemoMapper.query"/>
</resultMap>
<select id="query" resultType="java.lang.Object">
select * from table where id=#{id} and query_id=#{queryId}
</select>
</mapper>
DemoMapper.java
package com.example.demo.mapper.DemoMapper
public interface DemoMapper {
Object query(@Param("id") Integer id, @Param("queryId") Integer queryId);
}