# 下载ORDS
https://www.oracle.com/tools/downloads/ords-downloads.html

# 解压安装
$ unzip ords-xx.x.x.zip -d /opt/ords
$ cd /opt/ords

# 配置ORDS
$ java -jar ords.war install advanced

# 配置向导
Enter the location to store configuration data: /opt/ords/config
Enter the name of the database server: fgeduhost
Enter the database listen port: 1521
Enter 1 to specify the database service name, or 2 for SID: 1
Enter the database service name: fgedudb
Enter 1 if you want to verify/install Oracle REST Data Services schema, or 2 to skip: 1
Enter the database password for ORDS_PUBLIC_USER: xxxxxx
Enter the database password for SYS: xxxxxx
Enter 1 for HTTP, 2 for HTTPS, or 3 to skip: 2
Enter the HTTPS port: 8443

# 启动ORDS
$ java -jar ords.war standalone

# 验证安装
$ curl -k https://localhost:8443/ords/

# 配置数据库连接池
# 编辑 /opt/ords/config/databases/fgedudb/pool.xml

ORDS_PUBLIC_USER
xxxxxx
fgeduhost
1521
fgedudb
10
5
100

# 启用REST服务
SQL> BEGIN
ORDS.ENABLE_SCHEMA(
p_enabled => TRUE,
p_schema => ‘FGEDU’,
p_url_mapping_type => ‘BASE_PATH’,
p_url_mapping_pattern => ‘fgedu’
);
COMMIT;
END;
/

PL/SQL procedure successfully completed.

# 创建REST模块
SQL> BEGIN
ORDS.DEFINE_MODULE(
p_module_name => ‘orders_api’,
p_base_path => ‘/orders/’,
p_items_per_page => 25
);
COMMIT;
END;
/

PL/SQL procedure successfully completed.

# 创建模板
SQL> BEGIN
ORDS.DEFINE_TEMPLATE(
p_module_name => ‘orders_api’,
p_pattern => ‘/’
);
COMMIT;
END;
/

# 创建GET处理程序
SQL> BEGIN
ORDS.DEFINE_HANDLER(
p_module_name => ‘orders_api’,
p_pattern => ‘/’,
p_method => ‘GET’,
p_source_type => ORDS.source_type_collection_feed,
p_source => ‘SELECT * FROM orders WHERE order_date > :date’
);
COMMIT;
END;
/

# 创建POST处理程序
SQL> BEGIN
ORDS.DEFINE_HANDLER(
p_module_name => ‘orders_api’,
p_pattern => ‘/’,
p_method => ‘POST’,
p_source_type => ORDS.source_type_plsql,
p_source => ‘BEGIN
INSERT INTO orders(order_id, order_date, customer_id, amount)
VALUES(orders_seq.NEXTVAL, SYSDATE, :customer_id, :amount);
COMMIT;
END;’
);
COMMIT;
END;
/

# 启用表自动REST
SQL> BEGIN
ORDS.ENABLE_OBJECT(
p_enabled => TRUE,
p_schema => ‘FGEDU’,
p_object => ‘ORDERS’,
p_object_type => ‘TABLE’,
p_auto_rest_auth => FALSE
);
COMMIT;
END;
/

PL/SQL procedure successfully completed.

# 访问自动REST API
# GET请求
$ curl -k https://localhost:8443/ords/fgedu/orders/

# 响应示例
{
“items”: [
{
“order_id”: 1001,
“order_date”: “2026-04-01T00:00:00Z”,
“customer_id”: “C001”,
“amount”: 1000,
“links”: […]
},
{
“order_id”: 1002,
“order_date”: “2026-04-02T00:00:00Z”,
“customer_id”: “C002”,
“amount”: 2000,
“links”: […]
}
],
“hasMore”: false,
“limit”: 25,
“offset”: 0,
“count”: 2
}

# POST请求
$ curl -k -X POST \
-H “Content-Type: application/json” \
-d ‘{“customer_id”:”C003″,”amount”:1500}’ \
https://localhost:8443/ords/fgedu/orders/

# PUT请求
$ curl -k -X PUT \
-H “Content-Type: application/json” \
-d ‘{“amount”:2000}’ \
https://localhost:8443/ords/fgedu/orders/1003

# DELETE请求
$ curl -k -X DELETE \
https://localhost:8443/ords/fgedu/orders/1003

# 查询所有记录
$ curl -k https://localhost:8443/ords/fgedu/orders/

# 查询特定记录
$ curl -k https://localhost:8443/ords/fgedu/orders/1001

# 分页查询
$ curl -k “https://localhost:8443/ords/fgedu/orders/?limit=10&offset=20”

# 过滤查询
$ curl -k “https://localhost:8443/ords/fgedu/orders/?q={\”customer_id\”:\”C001\”}”

# 排序查询
$ curl -k “https://localhost:8443/ords/fgedu/orders/?orderby=order_date:desc”

# 选择列
$ curl -k “https://localhost:8443/ords/fgedu/orders/?fields=order_id,customer_id,amount”