1）利用Cypher语句创建数据
// 清空现有数据库（测试时慎用）
MATCH (n) DETACH DELETE n;

// 1. 创建金融与业务机构节点
MERGE (:Company {name: '智远智造'});
MERGE (:Company {name: '泰康保理'});
MERGE (:Company {name: '绿洲环保'});
MERGE (:Company {name: '光辉光伏'});
MERGE (:Company {name: '云创资本'});
MERGE (:Company {name: '环宇科技'});
MERGE (:Company {name: '极光芯片'});
MERGE (:Company {name: '星河新能源'});
MERGE (:Company {name: '晨曦创投'});
MERGE (:Company {name: '华夏能源集团'});
MERGE (:Company {name: '蓝天数智'});
MERGE (:Company {name: '高晟咨询'});
MERGE (:Company {name: '远东物流'});
MERGE (:Company {name: '银河重工'});
MERGE (:Company {name: '雷霆基建'});
MERGE (:Bank {name: '华夏商业银行'});
MERGE (:FinancialProduct {name: '信托计划（4亿元）'});

// 2. 创建人物节点
MERGE (:Person {name: '王晓燕'});
MERGE (:Person {name: '李建国'});
MERGE (:Person {name: '张强'});
MERGE (:Person {name: '周杰'});
MERGE (:Person {name: '陈明'});
MERGE (:Person {name: '刘伟'});
MERGE (:Person {name: '郑敏'});

// 匹配节点并建立商业关系连线
MATCH (h {name: '星河新能源'}), (t {name: '雷霆基建'}) MERGE (h)-[:对外担保]->(t);
MATCH (h {name: '雷霆基建'}), (t {name: '张强'}) MERGE (h)-[:法定代表人]->(t);
MATCH (h {name: '云创资本'}), (t {name: '星河新能源'}) MERGE (h)-[:举牌_买入股票]->(t);
MATCH (h {name: '云创资本'}), (t {name: '星河新能源'}) MERGE (h)-[:提供担保]->(t);
MATCH (h {name: '王晓燕'}), (t {name: '云创资本'}) MERGE (h)-[:担任法定代表人]->(t);
MATCH (h {name: '王晓燕'}), (t {name: '云创资本'}) MERGE (h)-[:担任股东]->(t);
MATCH (h {name: '王晓燕'}), (t {name: '李建国'}) MERGE (h)-[:配偶]->(t);
MATCH (h {name: '李建国'}), (t {name: '星河新能源'}) MERGE (h)-[:担任董事长]->(t);
MATCH (h {name: '雷霆基建'}), (t {name: '云创资本'}) MERGE (h)-[:提供担保]->(t);
MATCH (h {name: '雷霆基建'}), (t {name: '信托计划（4亿元）'}) MERGE (h)-[:违约_信托]->(t);
MATCH (h {name: '光辉光伏'}), (t {name: '星河新能源'}) MERGE (h)-[:签署供货协议]->(t);
MATCH (h {name: '华夏商业银行'}), (t {name: '光辉光伏'}) MERGE (h)-[:发放贷款]->(t);
MATCH (h {name: '华夏能源集团'}), (t {name: '光辉光伏'}) MERGE (h)-[:提供担保]->(t);
MATCH (h {name: '星河新能源'}), (t {name: '绿洲环保'}) MERGE (h)-[:合资成立]->(t);
MATCH (h {name: '环宇科技'}), (t {name: '绿洲环保'}) MERGE (h)-[:合资成立]->(t);
MATCH (h {name: '环宇科技'}), (t {name: '周杰'}) MERGE (h)-[:法定代表人]->(t);
MATCH (h {name: '智远智造'}), (t {name: '雷霆基建'}) MERGE (h)-[:中标项目]->(t);
MATCH (h {name: '远东物流'}), (t {name: '雷霆基建'}) MERGE (h)-[:签署运输协议]->(t);
MATCH (h {name: '远东物流'}), (t {name: '陈明'}) MERGE (h)-[:法定代表人]->(t);
MATCH (h {name: '晨曦创投'}), (t {name: '极光芯片'}) MERGE (h)-[:领投融资]->(t);
MATCH (h {name: '晨曦创投'}), (t {name: '刘伟'}) MERGE (h)-[:派出董事]->(t);
MATCH (h {name: '泰康保理'}), (t {name: '光辉光伏'}) MERGE (h)-[:提供保理服务]->(t);
MATCH (h {name: '光辉光伏'}), (t {name: '星河新能源'}) MERGE (h)-[:应收账款买方]->(t);
MATCH (h {name: '蓝天数智'}), (t {name: '郑敏'}) MERGE (h)-[:任命]->(t);
MATCH (h {name: '郑敏'}), (t {name: '华夏商业银行'}) MERGE (h)-[:曾任职]->(t);
MATCH (h {name: '高晟咨询'}), (t {name: '云创资本'}) MERGE (h)-[:提供合规顾问服务]->(t);
MATCH (h {name: '银河重工'}), (t {name: '雷霆基建'}) MERGE (h)-[:签署战略合作框架协议]->(t);

2）利用Cypher语句查看数据整体结构
MATCH (n)-[r]->(m)
RETURN n, r, m

3）利用Cypher语句查询两家公司之间是否存在三层以内的隐藏股权或高管关联路径
MATCH path = (a {name: '星河新能源'})-[*1..3]-(b {name: '云创资本'})
RETURN path

4）利用Cypher语句查询企业业务链条
// 查找从“光辉光伏”出发，沿担保、供应链、股权等链路能扩散到的所有企业及路径
MATCH path = (src:Company {name: '光辉光伏'})-[*1..3]-(target)
RETURN path

5）利用Cypher语句查询跨领域风险溯源问题
// 复杂推理：追踪合规信贷资金如何通过“供应链-担保链”跨界传染至违约资产
MATCH path = (bank:Bank {name: '华夏商业银行'})
             -[r1:发放贷款]->(supplier:Company)
             -[r2:应收账款买方]->(core:Company)
             -[r3:对外担保|提供担保*1..3]-(risky:Company)
             -[r4:违约_信托]->(bad_asset:FinancialProduct)
RETURN bank.name AS 资金方, 
       supplier.name AS 授信通道, 
       core.name AS 核心传染源, 
       risky.name AS 违约主体, 
       bad_asset.name AS 最终风险敞口,
       path


课后练习参考
1）
MATCH (p:Person {name: '李建国'})-[r]->(c:Company)
RETURN p.name AS 目标人物, type(r) AS 担任职务或关系, c.name AS 关联企业
2）
MATCH (supplier:Company)-[r:中标项目|签署运输协议|签署战略合作框架协议]->(target:Company {name: '雷霆基建'})
RETURN supplier.name AS 潜在受损供应商, type(r) AS 合作类型
3）
MATCH (c:Company)-[r:对外担保|提供担保]->(other)
RETURN c.name AS 担保企业, count(r) AS 担保次数
ORDER BY 担保次数 DESC
LIMIT 2
4）
MATCH (n)
WHERE NOT (n)-[]-()
RETURN n.name AS 孤立节点标签, labels(n) AS 节点类型
















