neo4j几种导入数据方式:
1、直接创建
--创建公司--创建人
CREATE (c1:company{cid:"1",name:"芜湖三六机械有限公司",注册资本:"800万人民币",成立日期:"2010-08-02"})
CREATE (c2:company{cid:"2",name:"平阳县东兴通讯器材有限公司",注册资本:"50万元人民币",成立日期:"1998-03-20"})
CREATE (c3:company{cid:"3",name:"芜湖哎造文化传媒有限公司",注册资本:"50万元人民币",成立日期:"2017-05-31"})
CREATE (p1:person{pid:"1",name:"潘致远",职位:"法定代表人"})
CREATE (p2:person{pid:"2",name:"潘明志",职位:"法定代表人"})
CREATE (p3:person{pid:"3",name:"王传洋",职位:"法定代表人"})
match(c1:company{cid:"1"}),(p1:person{pid:"1"}),
(c2:company{cid:"2"}),(p2:person{pid:"2"}),
(c3:company{cid:"3"}),(p3:person{pid:"3"})
create (c1)-[:法定代表人]->(p1)
,(c2)-[:法定代表人]->(p2)
,(c3)-[:法定代表人]->(p3)
,(c1)-[:投资]->(c2)
,(c1)-[:投资]->(c3)
,(c2)-[:投资]->(c3)
---创建公司
CREATE (c1:Company{index:"308f451a2d774f46a357c179eec141a",name:"芜湖信达降杠杆投资管理合伙企业(有限合伙)"});
CREATE (c1:Company{index:"e4c234bff2454a896aa504a9ae78e9",name:"长城国丰(芜湖)城镇化并购重组基金(有限合伙)"});
CREATE (c1:Company{index:"a9c4e650b1f46d213a3af137129d349f",name:"芜湖华融资本创瑞投资中心(有限合伙)"});
CREATE (c1:Company{index:"7160abf44dce2ec3212457c5f584c6",name:"长城信保(芜湖)投资中心(有限合伙)"});
---创建关系
match(c1:Company{index:"308f451a2d774f46a357c179eec141a"}),(c2:Company{index:"e4c234bff2454a896aa504a9ae78e9"})
,(c3:Company{index:"a9c4e650b1f46d213a3af137129d349f"})
,(c4:Company{index:"7160abf44dce2ec3212457c5f584c6"})
create (c1)-[:RelationShip{name:"直接投资"}]->(c2),
(c1)-[:RelationShip{name:"间接投资"}]->(c3),
(c3)-[:RelationShip{name:"分支机构"}]->(c1),
(c4)-[:RelationShip{name:"直接投资"}]->(c1);
--删除关系及节点
MATCH (n1:Company)-[r:RelationShip]->(n2:Company) delete n1,r,n2
2、使用load csv
准备好csv文件,以逗号分隔,记事本打开另存为utf8,防止中文乱码
csv文件如下
将csv文件上传都neo4j安装目录/import下,此为默认的文件地址;
执行load命令:
load csv with headers from 'file:///company.csv' as line FIELDTERMINATOR ',' create (c:Company{index:line.credit_code,name:line.company_name})
company.csv文件名,with headers包含了标题,create语句中指明了节点为Company,属性和csv文件的对应关系;
执行成功,导入数据:
参照步骤一,选取部分数据,插入关系
match(c1:Company{index:"91340200MA2NBYDB7K"}),(c2:Company{index:"523402000597305778"})
,(c3:Company{index:"12340200485121977X"})
,(c4:Company{index:"91340222MA2RLLK8XP"})
create (c1)-[:RelationShip{name:"直接投资"}]->(c2),
(c1)-[:RelationShip{name:"间接投资"}]->(c3),
(c3)-[:RelationShip{name:"分支机构"}]->(c1),
(c4)-[:RelationShip{name:"直接投资"}]->(c1);
3、使用kettle将mysql数据导入neo4j中