ERP连接器配置与使用指南

  • 系统对接顾问

所需参数

连接器参数:

  1. 服务器地址:****
  2. 端口号:***
  3. 数据库名称:**
  4. 用户名:****
  5. 密码:****

适配器:

写入适配器:

路径:\Adapter\Jushuitan\JushuitanQMQueryAdapter

确认写入数据表字段 upl-image-previewurl=//pic.qeasy.cloud/2024-02-21/1708501370-525250-image.png

编写插入语句

INSERT INTO shops (shop_id, shop_name, co_id, shop_site, shop_url, created, nick, session_expired, session_uid, short_name, group_id, group_name)
VALUES (:shop_id, :shop_name, :co_id, :shop_site, :shop_url, :created, :nick, :session_expired, :session_uid,:short_name,:group_id,:group_name);

配置写入字段,注意顺序要一致 upl-image-previewurl=//pic.qeasy.cloud/2024-02-21/1708501571-23103-image.png

配置实例

插入语句放置位置 upl-image-previewurl=//pic.qeasy.cloud/2024-02-21/1708501686-495063-image.png

字段配置位置 upl-image-previewurl=//pic.qeasy.cloud/2024-02-21/1708501735-282493-image.png

更多系统对接方案