Mybatis connection to PGSQL for json and jsonb

The pgsql database table field is set in jsonb format; using String or object conversion in java entities will always prompt an error:

Caused by: : ERROR: column "xx" is of type jsonb but expression is of type character varying

A conversion method is required:

 
import ;
import ;
import ;
import ;
import ;
import ;
import ;
import ;
import ;
/**
  * PGJsonTypeHandler: handles the conversion between Object object type and JSONB type in postgresql
  * author:lipu
  * created_at:2021/07/29 14:00
  */
@SuppressWarnings("unchecked")
@MappedTypes(value = {})
public class PGJsonbTypeHandler&lt;T extends Object&gt; extends BaseTypeHandler&lt;T&gt; {
    private static final PGobject pgObject = new PGobject();
    @Override
    public void setNonNullParameter(PreparedStatement preparedStatement, int i, T parameter, JdbcType jdbcType) throws SQLException {
        if (preparedStatement != null) {
            ("jsonb");
            ((parameter));
            (i, pgObject);
        }
    }
    @Override
    public T getNullableResult(ResultSet rs, String columnName) throws SQLException {
        return (T) ((columnName));
    }
    @Override
    public T getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
        return (T) ((columnIndex));
    }
    @Override
    public T getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
        return (T) ((columnIndex));
    }
}

When defining entity DO, specify:

@TableField(typeHandler = ) // For PostgreSQL of JSONB type

for example:

    @TableField(typeHandler = ) // JSONB type for PostgreSQL    private ShipToAddr shipToAddr;

This is the article about the processing of json and jsonb in mybatis connection PGSQL. For more related content on mybatis PGSQL json and jsonb, please search for my previous articles or continue browsing the related articles below. I hope everyone will support me in the future!