querywrapper
修正querywrapper
<?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="vip.xiaonuo.modular.govplatform.mapper.GovPlatformInfoMapper">
<!-- 查询json里面的guid -->
<select id="getGuidsByParams" resultType="java.lang.String">
SELECT JSON_VALUE(CAST(detail_json AS JSONB), '$.guid') AS guid
FROM integrated_gov_platform_info
WHERE status = 0 AND apply_idcard = #{applyIdcard} AND itemid = #{itemid}
</select>
</mapper>
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
多条json 数据
SELECT JSON_VALUE(CAST(json_element AS JSONB), '$.guid') AS guid
FROM (
SELECT CAST(detail_json AS JSONB),
JSONB_ARRAY_ELEMENTS(CAST(detail_json AS JSONB)) AS json_element
FROM integrated_gov_platform_info
WHERE status = 0
AND apply_idcard = #{applyIdcard}
AND itemid = #{itemid}
)
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.