Neo4j
一、创建节点
create (Kungfu：Move {title:'Kungfo', released:2008, tagline:'made in china'})
二、创建人物节点
create (Zhouxingchi:Person {name:'zhouixingchi', born:1980})
三、创建演员导演关系
create (Zhouxingchi)-[:acted_in {role:'self'}]->(Kungfo),
create (Zhouxingchi)-[:directed]->(Kungfo)
四、查找节点
1.按名字查找：
match (xingye {name:'zhouxingchi'}) return xingye
2.查找电影
match (kf {title:'Kungfo'}) return kf
3.随机查找多个人物
match (people:Person) return people.name limit 10
4.查找多个电影
match (mv:Movie) where mv.released >1970 and mv.released < 2000 return mv.title
五、查找关系
1.查找演员参演过的电影
match (xingye:Person {name:'zhouxingchi'})-[:acted_in]->(xingMovie) return xingye, xingMovie
2.查看谁导演了电影
match (dianying {title:'Kungfo'})<-[:directed]-(daoyan) return daoyan.name
3.查看与zhouxingchi同出演过电影的人
match (xingye:Person {name:'zhouxingchi'})-[:acted_in]->[m]<-[:acted_in]-(yanyuan) return yanyuan.name
4.查找与kungfo相关的所有人(人名、电影关系类型、电影的关系)
match (people:Person)-[relatedTo]-(:Movie {title:'kungfo'}) return people.name, Type(relatedTo), relatedTo
六、查询关系路径
1.查找与演员zhouxingchi存在4条及以内的任何演员及电影
match (bacon:Person {name:'zhouxingchi'})-[*1..4]-(movies) return distinct movies
2.查找演员之间最短路线
match p=shortestPath( (bacon:Person {name:'zhouxingchi'})-[*]-(meg:Person {name:'zhuyin'}) ) return p
3.查找没有与zhouxingchi合作过的演员
match (xingye:Person {name:'zhouxingchi'})-[:acted_in]->(m)<-[:acted_in]-(yanyuan), (yanyuan)-[:acted_in]->(m2)<-[acted_in]-(yanyuan2) where not xingye-[:acted_in]->(m2) return yanyuan2.name as unxingstar, count (*) as strength order by strength.desc
4.找人将zhouxingchi介绍给zhuyin
match (xingye:Person {name:'zhouxingchi'})-[:acted_in]->(m)<-[:acted_in]-(yanyuan), (yanyuan)-[:acted_in]->(m2)<-[acted_in]-(zixia:Person {name:'zhuyin'}) return xingye, m, yanyuan, zixia
七、清空数据库
1.清空所有Person、Movie节点
match (a:Person), (m:Movie) optional match (a)-[r1]-(), (m)-[r2]-() delete a, r1, m, r2
2.检查任意数据
match (n) return n
