@Data
@TableName(value = "centre_manage_server_info")
public class ServerEntity {
 
    @TableId(value = "id")
    //@Column(name = "id", isKey = true, isNull = false, comment = "id" )
    private String id;
 
    /**
     * 服務(wù)器ip
     */
    @TableField(value = "ip", insertStrategy = FieldStrategy.NOT_EMPTY)
    //@Column(name = "ip", isNull = false, comment = "服務(wù)器ip" )
    private String ip;
    /**
     * 服務(wù)器port
     */
    @TableField(value = "port",  insertStrategy = FieldStrategy.NOT_NULL)
    //@Column(name = "port", isNull = false, comment = "服務(wù)器port" )
    private Integer port;
    /**
     * 服務(wù)器登錄用戶名
     */
    @TableField(value = "authentication_name", typeHandler = AesTypeHandler.class, insertStrategy = FieldStrategy.NOT_EMPTY)
    //@Column(name = "authentication_name", isNull = false, comment = "服務(wù)器登錄用戶名" )
    private String authenticationName;
    /**
     * 服務(wù)器登錄密碼
     */
    @TableField(value = "authentication_pwd", typeHandler = AesTypeHandler.class, insertStrategy = FieldStrategy.NOT_EMPTY)
    //@Column(name = "authentication_pwd", isNull = false, comment = "服務(wù)器登錄密碼" )
    private String authenticationPwd;
 
}

@TableName(value = "centre_manage_server_info", autoResultMap = true)

<resultMap id="ServerEntity" type="com.zhong.core.centremanage.dbservice.server.entity.ServerEntity">
? ? ? ? <id column="id" property="id" />
? ? ? ? <result column="ip" property="ip" />
? ? ? ? <result column="port" property="port" />
? ? ? ? <result column="authentication_name" property="authenticationName" typeHandler="xxxx.AesTypeHandler"/>
? ? ? ? <result column="authentication_pwd" property="authenticationPwd" typeHandler="xxxx.AesTypeHandler"/>
? ? </resultMap>

@MappedTypes({String[].class})
@MappedJdbcTypes({JdbcType.VARCHAR})
public class StringArrayTypeHandler implements TypeHandler<String[]> {
? ? @Override
? ? public void setParameter(PreparedStatement ps, int i, String[] parameter, JdbcType jdbcType) throws SQLException {
? ? ? ? if (parameter == null)
? ? ? ? ? ? ps.setNull(i, Types.VARCHAR);
? ? ? ? else {
? ? ? ? ? ?JSONArray array = ?new JSONArray(Arrays.asList(parameter));
? ? ? ? ? ? ps.setString(i, array.toString());
? ? ? ? }
? ? }
? ? @Override
? ? public String[] getResult(ResultSet rs, String s) throws SQLException {
? ? ? ? String columnValue = rs.getString(s);
? ? ? ? return this.getStringArray(columnValue);
? ? }
? ? @Override
? ? public String[] getResult(ResultSet rs, int columnIndex) throws SQLException {
? ? ? ? String columnValue = rs.getString(columnIndex);
? ? ? ? return this.getStringArray(columnValue);
? ? }
? ? @Override
? ? public String[] getResult(CallableStatement cs, int i) throws SQLException {
? ? ? ? String columnValue = cs.getString(i);
? ? ? ? return this.getStringArray(columnValue);
? ? }
? ? private String[] getStringArray(String columnValue) {
? ? ? ? if (columnValue == null)
? ? ? ? ? ? return null;
? ? ? ? JSONArray jsonArr = JSONArray.parseArray(columnValue);
? ? ? ? return ?jsonArr.toArray(new String[jsonArr.size()]);
? ? }

?/**
? ? ?* 商品貨品的規(guī)格列表
? ? ?*/
? ? @TableField(value = "specifications",el = "specifications,typeHandler=com.seven.wechatshop.shopapi.typehandle.StringArrayTypeHandler")
? ? private String[] specifications;

//注意使用了plus的是添加下面這個(gè)
mybatis-plus.type-handlers-package = com.seven.wechatshop.shopapi.typehandle

mybatis.type-handlers-package=com.seven.wechatshop.shopapi.typehandle