Neo4j-森林图

1.新建节点-标签-关系

CREATE

(pll:TEST1 {name:'森林',mj:"5000亩"}),

(pl2:TEST1 {name:'沙漠',mj:"3000亩"}),

(lb1:TEST2 {name:'大树'}),

(lb2:TEST2 {name:'小树'}),

(lb3:TEST2 {name:'杂草'}),

(zll:TEST3 {name:'灌木'}),

(zl2:TEST3 {name:'乔木'}),

(lb1)-[:zb{bl:"60%",mj:"3000亩"}]->(pll),

(lb2)-[:zb{bl:"30%",mj:"2000亩"}]->(pll),

(lb3)-[:zb{bl:"10%",mj:"1000亩"}]->(pll),

(lb1)-[:zb{bl:"10%",mj:"100亩"}]->(pl2),

(lb2)-[:zb{bl:"20%",mj:"900亩"}]->(pl2),

(lb3)-[:zb{bl:"70%",mj:"2000亩"}]->(pl2),

(lb3)-[:zb{bl:"70%",mj:"2000亩"}]->(pl2)

------------------------------查询篇-----------------------------

–查询整体

MATCH (a:TEST1),(b:TEST2) RETURN a,b

–查询森林的植物

MATCH (a:TEST1),(b:TEST2)

WHERE a.name = "森林"

RETURN a,b

–查询沙漠中面积为100亩的植物

match (a:TEST1)<-[r]-(b:TEST2)

where a.name = "沙漠" and r.mj='100亩'

return a,b;

–查询持有平安银行的股东同时持有其他公司

MATCH (x:TEST1)-[:r]-> (y:TEST2 {code: "000001"})

WITH x

MATCH (x)-[:r]-> (z:gsinfo)

RETURN x,z

------------------------------节点-----------------------------

–新增节点

CREATE (pl3:TEST1 {name:'海洋',mj:"5000亩"})

–删除节点-（与其他节点不存在关系）

MATCH (a:TEST1)

WHERE a.name = "森林"

DELETE a

–删除节点-（与其他节点存在关系）

MATCH (x:TEST1)<-[r]-(y:TEST2)

WHERE x.name = "森林"

DELETE x,y

–删除节点个关系

MATCH (x:movie)-[r]-(y:Person) RETURN r

MATCH (x:movie)-[r]-(y:Person) DELETE x,y,r

–修改节点属性值

MATCH (x:TEST1)

WHERE x.name = "沙漠"

SET x.name = "荒漠"

------------------------------标签-----------------------------

–新增标签

CREATE (pll:TEST3 {name:'灌木'})

–删除标签

MATCH (x:TEST3) DELETE x

------------------------------关系-----------------------------

–新增关系属性

MATCH (x:TEST1),(y:TEST2)

WHERE x.name="海洋" and y.name="杂草"

CREATE (y)-[:zb{bl:"1%",mj:"88亩"}]->(x)

RETURN x,y;

–修改关系属性

match (x:TEST1)<-[r]-(y:TEST2)

where x.name = "沙漠" and y.name='大树'

set r.bl='80%'

return x,y;

–删除关系属性

match (x:TEST1)<-[r]-(y:TEST2)

where x.name = "沙漠" and y.name='大树'

delete r;

------------------------------数据导入-----------------------------

–csv导入

LOAD CSV WITH HEADERS FROM 'file:///1.csv' AS line FIELDTERMINATOR ','  

MERGE (:TEST4 { id:line.id ,name: line.name})