springboot + mybatis @MapKey使用
表信息:
entity:
public class ParentMessage implements Serializable {
private Integer id;
private String value;
get set ......
}
mapper:
@Repository
public interface ParentMessageMapper {
@MapKey("id")
Map<Integer,ParentMessage> idKey();
}
mapper.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.demo.mapper.ParentMessageMapper">
<select id="idKey" resultType="Map">
select * from mk_parentmessage;
</select>
</mapper>
service:
@Service
public class ParentMessageService {
@Autowired
ParentMessageMapper parentMessageMapper;
public Map<Integer,ParentMessage> idkEy(){
return parentMessageMapper.idKey();
}
}
controller:
@RestController
@RequestMapping("message")
public class MessageController {
@Autowired
ParentMessageService parentMessageService;
@GetMapping("idkey")
public Map idKey(){
return parentMessageService.idkEy();
}
}
测试结果: