@Service
public class DingRobotMsgServiceImpl extends ServiceImpl<DingRobotMsgMapper, DingRobotMsg> implements IDingRobotMsgService {
 
    @Autowired
    private DingRobotMsgMapper dingRobotMsgMapper;
 
    @Override
    public void insertRobotMsg(DingRobotMsg dingRobotMsg) {
        // 新增
        dingRobotMsg.setState("1");
        if (dingRobotMsg.getMsgtype().equals("text") || dingRobotMsg.getMsgtype().equals("file")) {
            dingRobotMsgMapper.insert(dingRobotMsg);
        } else {
            // TODO: 類型錯(cuò)誤！
        }
    }
}

@Data
@TableName("t_dingtalk_recemsg")
public class DingRobotMsg {
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;
 
    @TableField(value = "msgtype")
    private String msgtype;
 
    private Content content;
 
    private Text text;
 
    // ...
}

/**
 * 對(duì)象字段轉(zhuǎn)存為Json類型
 * @param <T>
 */
@MappedTypes({Text.class, Content.class})
public class JsonTypeHandler<T> extends BaseTypeHandler<T> {
 
    private final Class<T> type;
 
    public JsonTypeHandler(Class<T> type) {
        if (type == null) {
            throw new IllegalArgumentException("Type argument cannot be null");
        }
        this.type = type;
    }
 
    @Override
    public void setNonNullParameter(PreparedStatement ps, int i, T parameter, JdbcType jdbcType) throws SQLException {
        // 將對(duì)象轉(zhuǎn)換為JSON字符串并設(shè)置到PreparedStatement中
        ps.setString(i, JSON.toJSONString(parameter));
    }
 
    @Override
    public T getNullableResult(ResultSet rs, String columnName) throws SQLException {
        // 從ResultSet中獲取JSON字符串并轉(zhuǎn)換為指定類型的對(duì)象
        String jsonString = rs.getString(columnName);
        return JSON.parseObject(jsonString, type);
    }
 
    @Override
    public T getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
        // 從ResultSet中獲取JSON字符串并轉(zhuǎn)換為指定類型的對(duì)象
        String jsonString = rs.getString(columnIndex);
        return JSON.parseObject(jsonString, type);
    }
 
    @Override
    public T getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
        // 從CallableStatement中獲取JSON字符串并轉(zhuǎn)換為指定類型的對(duì)象
        String jsonString = cs.getString(columnIndex);
        return JSON.parseObject(jsonString, type);
    }
}

@TableField(typeHandler = JsonTypeHandler.class)
private Content content;
 
@TableField(typeHandler = JsonTypeHandler.class)
private Text text;