Java>在mybatis和PostgreSQLJson字段作为查询条件的解决方案

  #####Mybatis#####
  <select id="selectPushDataList" resultMap="BaseResultMap" parameterType="com.jpc.JpushData" >
    SELECT
      <include refid="Base_Column_List" />
    FROM
        jp_push jpt
    <where>
      delete_flag=1
      and (rule::json->>"sendType")::text = "tag"
      <if test="name != null and name !=""" >
        and name =#{name,jdbcType=VARCHAR}
      if>
      ORDER BY
        create_time ASC
         LIMIT ${pageSize} OFFSET ${(currentPage - 1) * pageSize}
    where>
  select>
  
  
  ####PostgreSQL  SQL####
      SELECT
        uuid,
        create_user,
        create_time,
        update_user,
        update_time,
        delete_flag,
        NAME,
        type,
        push,
        rule,
    STATUS 
    FROM
        jp_push jpt 
    WHERE
        jpt.delete_flag = 1 
        AND ( jpct.rule :: json ->> "sendType" ) :: text = "tag" 
        AND jpt.NAME = "testname" 
    ORDER BY
        jpt.create_time ASC 
    LIMIT 20 OFFSET 0