qidao123.com技术社区-IT企服评测·应用市场

标题: neo4j官方示例 [打印本页]
作者: 曹旭辉    时间: 2025-5-9 07:39
标题: neo4j官方示例
目录
一、预备数据
1.执行检察效果
二、操作
1.find 单个节点
2.同上，已某个属性去查询
3. 指定查询个数
4.条件查询
5.查询某个人出演的电影汇总
6.查询tom出演的电影中，尚有其他演员的信息。
7.查询跟电影(Cloud Atlas)有关的演员，并显示是什么关系。
8.多级关系
2跳关系
4跳关系
9.查找 Kevin Bacon 和 Meg Ryan 之间的最短路径，并返回了这条路径上的节点和关系

 
一、预备数据

  1. CREATE (TheMatrix:Movie {title:'The Matrix', released:1999, tagline:'Welcome to the Real World'})
  2. CREATE (Keanu:Person {name:'Keanu Reeves', born:1964})
  3. CREATE (Carrie:Person {name:'Carrie-Anne Moss', born:1967})
  4. CREATE (Laurence:Person {name:'Laurence Fishburne', born:1961})
  5. CREATE (Hugo:Person {name:'Hugo Weaving', born:1960})
  6. CREATE (LillyW:Person {name:'Lilly Wachowski', born:1967})
  7. CREATE (LanaW:Person {name:'Lana Wachowski', born:1965})
  8. CREATE (JoelS:Person {name:'Joel Silver', born:1952})
  9. CREATE
  10.   (Keanu)-[:ACTED_IN {roles:['Neo']}]->(TheMatrix),
  11.   (Carrie)-[:ACTED_IN {roles:['Trinity']}]->(TheMatrix),
  12.   (Laurence)-[:ACTED_IN {roles:['Morpheus']}]->(TheMatrix),
  13.   (Hugo)-[:ACTED_IN {roles:['Agent Smith']}]->(TheMatrix),
  14.   (LillyW)-[:DIRECTED]->(TheMatrix),
  15.   (LanaW)-[:DIRECTED]->(TheMatrix),
  16.   (JoelS)-[:PRODUCED]->(TheMatrix)
  18. CREATE (Emil:Person {name:"Emil Eifrem", born:1978})
  19. CREATE (Emil)-[:ACTED_IN {roles:["Emil"]}]->(TheMatrix)
  21. CREATE (TheMatrixReloaded:Movie {title:'The Matrix Reloaded', released:2003, tagline:'Free your mind'})
  22. CREATE
  23.   (Keanu)-[:ACTED_IN {roles:['Neo']}]->(TheMatrixReloaded),
  24.   (Carrie)-[:ACTED_IN {roles:['Trinity']}]->(TheMatrixReloaded),
  25.   (Laurence)-[:ACTED_IN {roles:['Morpheus']}]->(TheMatrixReloaded),
  26.   (Hugo)-[:ACTED_IN {roles:['Agent Smith']}]->(TheMatrixReloaded),
  27.   (LillyW)-[:DIRECTED]->(TheMatrixReloaded),
  28.   (LanaW)-[:DIRECTED]->(TheMatrixReloaded),
  29.   (JoelS)-[:PRODUCED]->(TheMatrixReloaded)
  31. CREATE (TheMatrixRevolutions:Movie {title:'The Matrix Revolutions', released:2003, tagline:'Everything that has a beginning has an end'})
  32. CREATE
  33.   (Keanu)-[:ACTED_IN {roles:['Neo']}]->(TheMatrixRevolutions),
  34.   (Carrie)-[:ACTED_IN {roles:['Trinity']}]->(TheMatrixRevolutions),
  35.   (Laurence)-[:ACTED_IN {roles:['Morpheus']}]->(TheMatrixRevolutions),
  36.   (Hugo)-[:ACTED_IN {roles:['Agent Smith']}]->(TheMatrixRevolutions),
  37.   (LillyW)-[:DIRECTED]->(TheMatrixRevolutions),
  38.   (LanaW)-[:DIRECTED]->(TheMatrixRevolutions),
  39.   (JoelS)-[:PRODUCED]->(TheMatrixRevolutions)
  41. CREATE (TheDevilsAdvocate:Movie {title:"The Devil's Advocate", released:1997, tagline:'Evil has its winning ways'})
  42. CREATE (Charlize:Person {name:'Charlize Theron', born:1975})
  43. CREATE (Al:Person {name:'Al Pacino', born:1940})
  44. CREATE (Taylor:Person {name:'Taylor Hackford', born:1944})
  45. CREATE
  46.   (Keanu)-[:ACTED_IN {roles:['Kevin Lomax']}]->(TheDevilsAdvocate),
  47.   (Charlize)-[:ACTED_IN {roles:['Mary Ann Lomax']}]->(TheDevilsAdvocate),
  48.   (Al)-[:ACTED_IN {roles:['John Milton']}]->(TheDevilsAdvocate),
  49.   (Taylor)-[:DIRECTED]->(TheDevilsAdvocate)
  51. CREATE (AFewGoodMen:Movie {title:"A Few Good Men", released:1992, tagline:"In the heart of the nation's capital, in a courthouse of the U.S. government, one man will stop at nothing to keep his honor, and one will stop at nothing to find the truth."})
  52. CREATE (TomC:Person {name:'Tom Cruise', born:1962})
  53. CREATE (JackN:Person {name:'Jack Nicholson', born:1937})
  54. CREATE (DemiM:Person {name:'Demi Moore', born:1962})
  55. CREATE (KevinB:Person {name:'Kevin Bacon', born:1958})
  56. CREATE (KieferS:Person {name:'Kiefer Sutherland', born:1966})
  57. CREATE (NoahW:Person {name:'Noah Wyle', born:1971})
  58. CREATE (CubaG:Person {name:'Cuba Gooding Jr.', born:1968})
  59. CREATE (KevinP:Person {name:'Kevin Pollak', born:1957})
  60. CREATE (JTW:Person {name:'J.T. Walsh', born:1943})
  61. CREATE (JamesM:Person {name:'James Marshall', born:1967})
  62. CREATE (ChristopherG:Person {name:'Christopher Guest', born:1948})
  63. CREATE (RobR:Person {name:'Rob Reiner', born:1947})
  64. CREATE (AaronS:Person {name:'Aaron Sorkin', born:1961})
  65. CREATE
  66.   (TomC)-[:ACTED_IN {roles:['Lt. Daniel Kaffee']}]->(AFewGoodMen),
  67.   (JackN)-[:ACTED_IN {roles:['Col. Nathan R. Jessup']}]->(AFewGoodMen),
  68.   (DemiM)-[:ACTED_IN {roles:['Lt. Cdr. JoAnne Galloway']}]->(AFewGoodMen),
  69.   (KevinB)-[:ACTED_IN {roles:['Capt. Jack Ross']}]->(AFewGoodMen),
  70.   (KieferS)-[:ACTED_IN {roles:['Lt. Jonathan Kendrick']}]->(AFewGoodMen),
  71.   (NoahW)-[:ACTED_IN {roles:['Cpl. Jeffrey Barnes']}]->(AFewGoodMen),
  72.   (CubaG)-[:ACTED_IN {roles:['Cpl. Carl Hammaker']}]->(AFewGoodMen),
  73.   (KevinP)-[:ACTED_IN {roles:['Lt. Sam Weinberg']}]->(AFewGoodMen),
  74.   (JTW)-[:ACTED_IN {roles:['Lt. Col. Matthew Andrew Markinson']}]->(AFewGoodMen),
  75.   (JamesM)-[:ACTED_IN {roles:['Pfc. Louden Downey']}]->(AFewGoodMen),
  76.   (ChristopherG)-[:ACTED_IN {roles:['Dr. Stone']}]->(AFewGoodMen),
  77.   (AaronS)-[:ACTED_IN {roles:['Man in Bar']}]->(AFewGoodMen),
  78.   (RobR)-[:DIRECTED]->(AFewGoodMen),
  79.   (AaronS)-[:WROTE]->(AFewGoodMen)
  81. CREATE (TopGun:Movie {title:"Top Gun", released:1986, tagline:'I feel the need, the need for speed.'})
  82. CREATE (KellyM:Person {name:'Kelly McGillis', born:1957})
  83. CREATE (ValK:Person {name:'Val Kilmer', born:1959})
  84. CREATE (AnthonyE:Person {name:'Anthony Edwards', born:1962})
  85. CREATE (TomS:Person {name:'Tom Skerritt', born:1933})
  86. CREATE (MegR:Person {name:'Meg Ryan', born:1961})
  87. CREATE (TonyS:Person {name:'Tony Scott', born:1944})
  88. CREATE (JimC:Person {name:'Jim Cash', born:1941})
  89. CREATE
  90.   (TomC)-[:ACTED_IN {roles:['Maverick']}]->(TopGun),
  91.   (KellyM)-[:ACTED_IN {roles:['Charlie']}]->(TopGun),
  92.   (ValK)-[:ACTED_IN {roles:['Iceman']}]->(TopGun),
  93.   (AnthonyE)-[:ACTED_IN {roles:['Goose']}]->(TopGun),
  94.   (TomS)-[:ACTED_IN {roles:['Viper']}]->(TopGun),
  95.   (MegR)-[:ACTED_IN {roles:['Carole']}]->(TopGun),
  96.   (TonyS)-[:DIRECTED]->(TopGun),
  97.   (JimC)-[:WROTE]->(TopGun)
  99. CREATE (JerryMaguire:Movie {title:'Jerry Maguire', released:2000, tagline:'The rest of his life begins now.'})
  100. CREATE (ReneeZ:Person {name:'Renee Zellweger', born:1969})
  101. CREATE (KellyP:Person {name:'Kelly Preston', born:1962})
  102. CREATE (JerryO:Person {name:"Jerry O'Connell", born:1974})
  103. CREATE (JayM:Person {name:'Jay Mohr', born:1970})
  104. CREATE (BonnieH:Person {name:'Bonnie Hunt', born:1961})
  105. CREATE (ReginaK:Person {name:'Regina King', born:1971})
  106. CREATE (JonathanL:Person {name:'Jonathan Lipnicki', born:1996})
  107. CREATE (CameronC:Person {name:'Cameron Crowe', born:1957})
  108. CREATE
  109.   (TomC)-[:ACTED_IN {roles:['Jerry Maguire']}]->(JerryMaguire),
  110.   (CubaG)-[:ACTED_IN {roles:['Rod Tidwell']}]->(JerryMaguire),
  111.   (ReneeZ)-[:ACTED_IN {roles:['Dorothy Boyd']}]->(JerryMaguire),
  112.   (KellyP)-[:ACTED_IN {roles:['Avery Bishop']}]->(JerryMaguire),
  113.   (JerryO)-[:ACTED_IN {roles:['Frank Cushman']}]->(JerryMaguire),
  114.   (JayM)-[:ACTED_IN {roles:['Bob Sugar']}]->(JerryMaguire),
  115.   (BonnieH)-[:ACTED_IN {roles:['Laurel Boyd']}]->(JerryMaguire),
  116.   (ReginaK)-[:ACTED_IN {roles:['Marcee Tidwell']}]->(JerryMaguire),
  117.   (JonathanL)-[:ACTED_IN {roles:['Ray Boyd']}]->(JerryMaguire),
  118.   (CameronC)-[:DIRECTED]->(JerryMaguire),
  119.   (CameronC)-[:PRODUCED]->(JerryMaguire),
  120.   (CameronC)-[:WROTE]->(JerryMaguire)
  122. CREATE (StandByMe:Movie {title:"Stand By Me", released:1986, tagline:"For some, it's the last real taste of innocence, and the first real taste of life. But for everyone, it's the time that memories are made of."})
  123. CREATE (RiverP:Person {name:'River Phoenix', born:1970})
  124. CREATE (CoreyF:Person {name:'Corey Feldman', born:1971})
  125. CREATE (WilW:Person {name:'Wil Wheaton', born:1972})
  126. CREATE (JohnC:Person {name:'John Cusack', born:1966})
  127. CREATE (MarshallB:Person {name:'Marshall Bell', born:1942})
  128. CREATE
  129.   (WilW)-[:ACTED_IN {roles:['Gordie Lachance']}]->(StandByMe),
  130.   (RiverP)-[:ACTED_IN {roles:['Chris Chambers']}]->(StandByMe),
  131.   (JerryO)-[:ACTED_IN {roles:['Vern Tessio']}]->(StandByMe),
  132.   (CoreyF)-[:ACTED_IN {roles:['Teddy Duchamp']}]->(StandByMe),
  133.   (JohnC)-[:ACTED_IN {roles:['Denny Lachance']}]->(StandByMe),
  134.   (KieferS)-[:ACTED_IN {roles:['Ace Merrill']}]->(StandByMe),
  135.   (MarshallB)-[:ACTED_IN {roles:['Mr. Lachance']}]->(StandByMe),
  136.   (RobR)-[:DIRECTED]->(StandByMe)
  138. CREATE (AsGoodAsItGets:Movie {title:'As Good as It Gets', released:1997, tagline:'A comedy from the heart that goes for the throat.'})
  139. CREATE (HelenH:Person {name:'Helen Hunt', born:1963})
  140. CREATE (GregK:Person {name:'Greg Kinnear', born:1963})
  141. CREATE (JamesB:Person {name:'James L. Brooks', born:1940})
  142. CREATE
  143.   (JackN)-[:ACTED_IN {roles:['Melvin Udall']}]->(AsGoodAsItGets),
  144.   (HelenH)-[:ACTED_IN {roles:['Carol Connelly']}]->(AsGoodAsItGets),
  145.   (GregK)-[:ACTED_IN {roles:['Simon Bishop']}]->(AsGoodAsItGets),
  146.   (CubaG)-[:ACTED_IN {roles:['Frank Sachs']}]->(AsGoodAsItGets),
  147.   (JamesB)-[:DIRECTED]->(AsGoodAsItGets)
  149. CREATE (WhatDreamsMayCome:Movie {title:'What Dreams May Come', released:1998, tagline:'After life there is more. The end is just the beginning.'})
  150. CREATE (AnnabellaS:Person {name:'Annabella Sciorra', born:1960})
  151. CREATE (MaxS:Person {name:'Max von Sydow', born:1929})
  152. CREATE (WernerH:Person {name:'Werner Herzog', born:1942})
  153. CREATE (Robin:Person {name:'Robin Williams', born:1951})
  154. CREATE (VincentW:Person {name:'Vincent Ward', born:1956})
  155. CREATE
  156.   (Robin)-[:ACTED_IN {roles:['Chris Nielsen']}]->(WhatDreamsMayCome),
  157.   (CubaG)-[:ACTED_IN {roles:['Albert Lewis']}]->(WhatDreamsMayCome),
  158.   (AnnabellaS)-[:ACTED_IN {roles:['Annie Collins-Nielsen']}]->(WhatDreamsMayCome),
  159.   (MaxS)-[:ACTED_IN {roles:['The Tracker']}]->(WhatDreamsMayCome),
  160.   (WernerH)-[:ACTED_IN {roles:['The Face']}]->(WhatDreamsMayCome),
  161.   (VincentW)-[:DIRECTED]->(WhatDreamsMayCome)
  163. CREATE (SnowFallingonCedars:Movie {title:'Snow Falling on Cedars', released:1999, tagline:'First loves last. Forever.'})
  164. CREATE (EthanH:Person {name:'Ethan Hawke', born:1970})
  165. CREATE (RickY:Person {name:'Rick Yune', born:1971})
  166. CREATE (JamesC:Person {name:'James Cromwell', born:1940})
  167. CREATE (ScottH:Person {name:'Scott Hicks', born:1953})
  168. CREATE
  169.   (EthanH)-[:ACTED_IN {roles:['Ishmael Chambers']}]->(SnowFallingonCedars),
  170.   (RickY)-[:ACTED_IN {roles:['Kazuo Miyamoto']}]->(SnowFallingonCedars),
  171.   (MaxS)-[:ACTED_IN {roles:['Nels Gudmundsson']}]->(SnowFallingonCedars),
  172.   (JamesC)-[:ACTED_IN {roles:['Judge Fielding']}]->(SnowFallingonCedars),
  173.   (ScottH)-[:DIRECTED]->(SnowFallingonCedars)
  175. CREATE (YouveGotMail:Movie {title:"You've Got Mail", released:1998, tagline:'At odds in life... in love on-line.'})
  176. CREATE (ParkerP:Person {name:'Parker Posey', born:1968})
  177. CREATE (DaveC:Person {name:'Dave Chappelle', born:1973})
  178. CREATE (SteveZ:Person {name:'Steve Zahn', born:1967})
  179. CREATE (TomH:Person {name:'Tom Hanks', born:1956})
  180. CREATE (NoraE:Person {name:'Nora Ephron', born:1941})
  181. CREATE
  182.   (TomH)-[:ACTED_IN {roles:['Joe Fox']}]->(YouveGotMail),
  183.   (MegR)-[:ACTED_IN {roles:['Kathleen Kelly']}]->(YouveGotMail),
  184.   (GregK)-[:ACTED_IN {roles:['Frank Navasky']}]->(YouveGotMail),
  185.   (ParkerP)-[:ACTED_IN {roles:['Patricia Eden']}]->(YouveGotMail),
  186.   (DaveC)-[:ACTED_IN {roles:['Kevin Jackson']}]->(YouveGotMail),
  187.   (SteveZ)-[:ACTED_IN {roles:['George Pappas']}]->(YouveGotMail),
  188.   (NoraE)-[:DIRECTED]->(YouveGotMail)
  190. CREATE (SleeplessInSeattle:Movie {title:'Sleepless in Seattle', released:1993, tagline:'What if someone you never met, someone you never saw, someone you never knew was the only someone for you?'})
  191. CREATE (RitaW:Person {name:'Rita Wilson', born:1956})
  192. CREATE (BillPull:Person {name:'Bill Pullman', born:1953})
  193. CREATE (VictorG:Person {name:'Victor Garber', born:1949})
  194. CREATE (RosieO:Person {name:"Rosie O'Donnell", born:1962})
  195. CREATE
  196.   (TomH)-[:ACTED_IN {roles:['Sam Baldwin']}]->(SleeplessInSeattle),
  197.   (MegR)-[:ACTED_IN {roles:['Annie Reed']}]->(SleeplessInSeattle),
  198.   (RitaW)-[:ACTED_IN {roles:['Suzy']}]->(SleeplessInSeattle),
  199.   (BillPull)-[:ACTED_IN {roles:['Walter']}]->(SleeplessInSeattle),
  200.   (VictorG)-[:ACTED_IN {roles:['Greg']}]->(SleeplessInSeattle),
  201.   (RosieO)-[:ACTED_IN {roles:['Becky']}]->(SleeplessInSeattle),
  202.   (NoraE)-[:DIRECTED]->(SleeplessInSeattle)
  204. CREATE (JoeVersustheVolcano:Movie {title:'Joe Versus the Volcano', released:1990, tagline:'A story of love, lava and burning desire.'})
  205. CREATE (JohnS:Person {name:'John Patrick Stanley', born:1950})
  206. CREATE (Nathan:Person {name:'Nathan Lane', born:1956})
  207. CREATE
  208.   (TomH)-[:ACTED_IN {roles:['Joe Banks']}]->(JoeVersustheVolcano),
  209.   (MegR)-[:ACTED_IN {roles:['DeDe', 'Angelica Graynamore', 'Patricia Graynamore']}]->(JoeVersustheVolcano),
  210.   (Nathan)-[:ACTED_IN {roles:['Baw']}]->(JoeVersustheVolcano),
  211.   (JohnS)-[:DIRECTED]->(JoeVersustheVolcano)
  213. CREATE (WhenHarryMetSally:Movie {title:'When Harry Met Sally', released:1998, tagline:'At odds in life... in love on-line.'})
  214. CREATE (BillyC:Person {name:'Billy Crystal', born:1948})
  215. CREATE (CarrieF:Person {name:'Carrie Fisher', born:1956})
  216. CREATE (BrunoK:Person {name:'Bruno Kirby', born:1949})
  217. CREATE
  218.   (BillyC)-[:ACTED_IN {roles:['Harry Burns']}]->(WhenHarryMetSally),
  219.   (MegR)-[:ACTED_IN {roles:['Sally Albright']}]->(WhenHarryMetSally),
  220.   (CarrieF)-[:ACTED_IN {roles:['Marie']}]->(WhenHarryMetSally),
  221.   (BrunoK)-[:ACTED_IN {roles:['Jess']}]->(WhenHarryMetSally),
  222.   (RobR)-[:DIRECTED]->(WhenHarryMetSally),
  223.   (RobR)-[:PRODUCED]->(WhenHarryMetSally),
  224.   (NoraE)-[:PRODUCED]->(WhenHarryMetSally),
  225.   (NoraE)-[:WROTE]->(WhenHarryMetSally)
  227. CREATE (ThatThingYouDo:Movie {title:'That Thing You Do', released:1996, tagline:'In every life there comes a time when that thing you dream becomes that thing you do'})
  228. CREATE (LivT:Person {name:'Liv Tyler', born:1977})
  229. CREATE
  230.   (TomH)-[:ACTED_IN {roles:['Mr. White']}]->(ThatThingYouDo),
  231.   (LivT)-[:ACTED_IN {roles:['Faye Dolan']}]->(ThatThingYouDo),
  232.   (Charlize)-[:ACTED_IN {roles:['Tina']}]->(ThatThingYouDo),
  233.   (TomH)-[:DIRECTED]->(ThatThingYouDo)
  235. CREATE (TheReplacements:Movie {title:'The Replacements', released:2000, tagline:'Pain heals, Chicks dig scars... Glory lasts forever'})
  236. CREATE (Brooke:Person {name:'Brooke Langton', born:1970})
  237. CREATE (Gene:Person {name:'Gene Hackman', born:1930})
  238. CREATE (Orlando:Person {name:'Orlando Jones', born:1968})
  239. CREATE (Howard:Person {name:'Howard Deutch', born:1950})
  240. CREATE
  241.   (Keanu)-[:ACTED_IN {roles:['Shane Falco']}]->(TheReplacements),
  242.   (Brooke)-[:ACTED_IN {roles:['Annabelle Farrell']}]->(TheReplacements),
  243.   (Gene)-[:ACTED_IN {roles:['Jimmy McGinty']}]->(TheReplacements),
  244.   (Orlando)-[:ACTED_IN {roles:['Clifford Franklin']}]->(TheReplacements),
  245.   (Howard)-[:DIRECTED]->(TheReplacements)
  247. CREATE (RescueDawn:Movie {title:'RescueDawn', released:2006, tagline:"Based on the extraordinary true story of one man's fight for freedom"})
  248. CREATE (ChristianB:Person {name:'Christian Bale', born:1974})
  249. CREATE (ZachG:Person {name:'Zach Grenier', born:1954})
  250. CREATE
  251.   (MarshallB)-[:ACTED_IN {roles:['Admiral']}]->(RescueDawn),
  252.   (ChristianB)-[:ACTED_IN {roles:['Dieter Dengler']}]->(RescueDawn),
  253.   (ZachG)-[:ACTED_IN {roles:['Squad Leader']}]->(RescueDawn),
  254.   (SteveZ)-[:ACTED_IN {roles:['Duane']}]->(RescueDawn),
  255.   (WernerH)-[:DIRECTED]->(RescueDawn)
  257. CREATE (TheBirdcage:Movie {title:'The Birdcage', released:1996, tagline:'Come as you are'})
  258. CREATE (MikeN:Person {name:'Mike Nichols', born:1931})
  259. CREATE
  260.   (Robin)-[:ACTED_IN {roles:['Armand Goldman']}]->(TheBirdcage),
  261.   (Nathan)-[:ACTED_IN {roles:['Albert Goldman']}]->(TheBirdcage),
  262.   (Gene)-[:ACTED_IN {roles:['Sen. Kevin Keeley']}]->(TheBirdcage),
  263.   (MikeN)-[:DIRECTED]->(TheBirdcage)
  265. CREATE (Unforgiven:Movie {title:'Unforgiven', released:1992, tagline:"It's a hell of a thing, killing a man"})
  266. CREATE (RichardH:Person {name:'Richard Harris', born:1930})
  267. CREATE (ClintE:Person {name:'Clint Eastwood', born:1930})
  268. CREATE
  269.   (RichardH)-[:ACTED_IN {roles:['English Bob']}]->(Unforgiven),
  270.   (ClintE)-[:ACTED_IN {roles:['Bill Munny']}]->(Unforgiven),
  271.   (Gene)-[:ACTED_IN {roles:['Little Bill Daggett']}]->(Unforgiven),
  272.   (ClintE)-[:DIRECTED]->(Unforgiven)
  274. CREATE (JohnnyMnemonic:Movie {title:'Johnny Mnemonic', released:1995, tagline:'The hottest data on earth. In the coolest head in town'})
  275. CREATE (Takeshi:Person {name:'Takeshi Kitano', born:1947})
  276. CREATE (Dina:Person {name:'Dina Meyer', born:1968})
  277. CREATE (IceT:Person {name:'Ice-T', born:1958})
  278. CREATE (RobertL:Person {name:'Robert Longo', born:1953})
  279. CREATE
  280.   (Keanu)-[:ACTED_IN {roles:['Johnny Mnemonic']}]->(JohnnyMnemonic),
  281.   (Takeshi)-[:ACTED_IN {roles:['Takahashi']}]->(JohnnyMnemonic),
  282.   (Dina)-[:ACTED_IN {roles:['Jane']}]->(JohnnyMnemonic),
  283.   (IceT)-[:ACTED_IN {roles:['J-Bone']}]->(JohnnyMnemonic),
  284.   (RobertL)-[:DIRECTED]->(JohnnyMnemonic)
  286. CREATE (CloudAtlas:Movie {title:'Cloud Atlas', released:2012, tagline:'Everything is connected'})
  287. CREATE (HalleB:Person {name:'Halle Berry', born:1966})
  288. CREATE (JimB:Person {name:'Jim Broadbent', born:1949})
  289. CREATE (TomT:Person {name:'Tom Tykwer', born:1965})
  290. CREATE (DavidMitchell:Person {name:'David Mitchell', born:1969})
  291. CREATE (StefanArndt:Person {name:'Stefan Arndt', born:1961})
  292. CREATE
  293.   (TomH)-[:ACTED_IN {roles:['Zachry', 'Dr. Henry Goose', 'Isaac Sachs', 'Dermot Hoggins']}]->(CloudAtlas),
  294.   (Hugo)-[:ACTED_IN {roles:['Bill Smoke', 'Haskell Moore', 'Tadeusz Kesselring', 'Nurse Noakes', 'Boardman Mephi', 'Old Georgie']}]->(CloudAtlas),
  295.   (HalleB)-[:ACTED_IN {roles:['Luisa Rey', 'Jocasta Ayrs', 'Ovid', 'Meronym']}]->(CloudAtlas),
  296.   (JimB)-[:ACTED_IN {roles:['Vyvyan Ayrs', 'Captain Molyneux', 'Timothy Cavendish']}]->(CloudAtlas),
  297.   (TomT)-[:DIRECTED]->(CloudAtlas),
  298.   (LillyW)-[:DIRECTED]->(CloudAtlas),
  299.   (LanaW)-[:DIRECTED]->(CloudAtlas),
  300.   (DavidMitchell)-[:WROTE]->(CloudAtlas),
  301.   (StefanArndt)-[:PRODUCED]->(CloudAtlas)
  303. CREATE (TheDaVinciCode:Movie {title:'The Da Vinci Code', released:2006, tagline:'Break The Codes'})
  304. CREATE (IanM:Person {name:'Ian McKellen', born:1939})
  305. CREATE (AudreyT:Person {name:'Audrey Tautou', born:1976})
  306. CREATE (PaulB:Person {name:'Paul Bettany', born:1971})
  307. CREATE (RonH:Person {name:'Ron Howard', born:1954})
  308. CREATE
  309.   (TomH)-[:ACTED_IN {roles:['Dr. Robert Langdon']}]->(TheDaVinciCode),
  310.   (IanM)-[:ACTED_IN {roles:['Sir Leight Teabing']}]->(TheDaVinciCode),
  311.   (AudreyT)-[:ACTED_IN {roles:['Sophie Neveu']}]->(TheDaVinciCode),
  312.   (PaulB)-[:ACTED_IN {roles:['Silas']}]->(TheDaVinciCode),
  313.   (RonH)-[:DIRECTED]->(TheDaVinciCode)
  315. CREATE (VforVendetta:Movie {title:'V for Vendetta', released:2006, tagline:'Freedom! Forever!'})
  316. CREATE (NatalieP:Person {name:'Natalie Portman', born:1981})
  317. CREATE (StephenR:Person {name:'Stephen Rea', born:1946})
  318. CREATE (JohnH:Person {name:'John Hurt', born:1940})
  319. CREATE (BenM:Person {name: 'Ben Miles', born:1967})
  320. CREATE
  321.   (Hugo)-[:ACTED_IN {roles:['V']}]->(VforVendetta),
  322.   (NatalieP)-[:ACTED_IN {roles:['Evey Hammond']}]->(VforVendetta),
  323.   (StephenR)-[:ACTED_IN {roles:['Eric Finch']}]->(VforVendetta),
  324.   (JohnH)-[:ACTED_IN {roles:['High Chancellor Adam Sutler']}]->(VforVendetta),
  325.   (BenM)-[:ACTED_IN {roles:['Dascomb']}]->(VforVendetta),
  326.   (JamesM)-[:DIRECTED]->(VforVendetta),
  327.   (LillyW)-[:PRODUCED]->(VforVendetta),
  328.   (LanaW)-[:PRODUCED]->(VforVendetta),
  329.   (JoelS)-[:PRODUCED]->(VforVendetta),
  330.   (LillyW)-[:WROTE]->(VforVendetta),
  331.   (LanaW)-[:WROTE]->(VforVendetta)
  333. CREATE (SpeedRacer:Movie {title:'Speed Racer', released:2008, tagline:'Speed has no limits'})
  334. CREATE (EmileH:Person {name:'Emile Hirsch', born:1985})
  335. CREATE (JohnG:Person {name:'John Goodman', born:1960})
  336. CREATE (SusanS:Person {name:'Susan Sarandon', born:1946})
  337. CREATE (MatthewF:Person {name:'Matthew Fox', born:1966})
  338. CREATE (ChristinaR:Person {name:'Christina Ricci', born:1980})
  339. CREATE (Rain:Person {name:'Rain', born:1982})
  340. CREATE
  341.   (EmileH)-[:ACTED_IN {roles:['Speed Racer']}]->(SpeedRacer),
  342.   (JohnG)-[:ACTED_IN {roles:['Pops']}]->(SpeedRacer),
  343.   (SusanS)-[:ACTED_IN {roles:['Mom']}]->(SpeedRacer),
  344.   (MatthewF)-[:ACTED_IN {roles:['Racer X']}]->(SpeedRacer),
  345.   (ChristinaR)-[:ACTED_IN {roles:['Trixie']}]->(SpeedRacer),
  346.   (Rain)-[:ACTED_IN {roles:['Taejo Togokahn']}]->(SpeedRacer),
  347.   (BenM)-[:ACTED_IN {roles:['Cass Jones']}]->(SpeedRacer),
  348.   (LillyW)-[:DIRECTED]->(SpeedRacer),
  349.   (LanaW)-[:DIRECTED]->(SpeedRacer),
  350.   (LillyW)-[:WROTE]->(SpeedRacer),
  351.   (LanaW)-[:WROTE]->(SpeedRacer),
  352.   (JoelS)-[:PRODUCED]->(SpeedRacer)
  354. CREATE (NinjaAssassin:Movie {title:'Ninja Assassin', released:2009, tagline:'Prepare to enter a secret world of assassins'})
  355. CREATE (NaomieH:Person {name:'Naomie Harris'})
  356. CREATE
  357.   (Rain)-[:ACTED_IN {roles:['Raizo']}]->(NinjaAssassin),
  358.   (NaomieH)-[:ACTED_IN {roles:['Mika Coretti']}]->(NinjaAssassin),
  359.   (RickY)-[:ACTED_IN {roles:['Takeshi']}]->(NinjaAssassin),
  360.   (BenM)-[:ACTED_IN {roles:['Ryan Maslow']}]->(NinjaAssassin),
  361.   (JamesM)-[:DIRECTED]->(NinjaAssassin),
  362.   (LillyW)-[:PRODUCED]->(NinjaAssassin),
  363.   (LanaW)-[:PRODUCED]->(NinjaAssassin),
  364.   (JoelS)-[:PRODUCED]->(NinjaAssassin)
  366. CREATE (TheGreenMile:Movie {title:'The Green Mile', released:1999, tagline:"Walk a mile you'll never forget."})
  367. CREATE (MichaelD:Person {name:'Michael Clarke Duncan', born:1957})
  368. CREATE (DavidM:Person {name:'David Morse', born:1953})
  369. CREATE (SamR:Person {name:'Sam Rockwell', born:1968})
  370. CREATE (GaryS:Person {name:'Gary Sinise', born:1955})
  371. CREATE (PatriciaC:Person {name:'Patricia Clarkson', born:1959})
  372. CREATE (FrankD:Person {name:'Frank Darabont', born:1959})
  373. CREATE
  374.   (TomH)-[:ACTED_IN {roles:['Paul Edgecomb']}]->(TheGreenMile),
  375.   (MichaelD)-[:ACTED_IN {roles:['John Coffey']}]->(TheGreenMile),
  376.   (DavidM)-[:ACTED_IN {roles:['Brutus "Brutal" Howell']}]->(TheGreenMile),
  377.   (BonnieH)-[:ACTED_IN {roles:['Jan Edgecomb']}]->(TheGreenMile),
  378.   (JamesC)-[:ACTED_IN {roles:['Warden Hal Moores']}]->(TheGreenMile),
  379.   (SamR)-[:ACTED_IN {roles:['"Wild Bill" Wharton']}]->(TheGreenMile),
  380.   (GaryS)-[:ACTED_IN {roles:['Burt Hammersmith']}]->(TheGreenMile),
  381.   (PatriciaC)-[:ACTED_IN {roles:['Melinda Moores']}]->(TheGreenMile),
  382.   (FrankD)-[:DIRECTED]->(TheGreenMile)
  384. CREATE (FrostNixon:Movie {title:'Frost/Nixon', released:2008, tagline:'400 million people were waiting for the truth.'})
  385. CREATE (FrankL:Person {name:'Frank Langella', born:1938})
  386. CREATE (MichaelS:Person {name:'Michael Sheen', born:1969})
  387. CREATE (OliverP:Person {name:'Oliver Platt', born:1960})
  388. CREATE
  389.   (FrankL)-[:ACTED_IN {roles:['Richard Nixon']}]->(FrostNixon),
  390.   (MichaelS)-[:ACTED_IN {roles:['David Frost']}]->(FrostNixon),
  391.   (KevinB)-[:ACTED_IN {roles:['Jack Brennan']}]->(FrostNixon),
  392.   (OliverP)-[:ACTED_IN {roles:['Bob Zelnick']}]->(FrostNixon),
  393.   (SamR)-[:ACTED_IN {roles:['James Reston, Jr.']}]->(FrostNixon),
  394.   (RonH)-[:DIRECTED]->(FrostNixon)
  396. CREATE (Hoffa:Movie {title:'Hoffa', released:1992, tagline:"He didn't want law. He wanted justice."})
  397. CREATE (DannyD:Person {name:'Danny DeVito', born:1944})
  398. CREATE (JohnR:Person {name:'John C. Reilly', born:1965})
  399. CREATE
  400.   (JackN)-[:ACTED_IN {roles:['Hoffa']}]->(Hoffa),
  401.   (DannyD)-[:ACTED_IN {roles:['Robert "Bobby" Ciaro']}]->(Hoffa),
  402.   (JTW)-[:ACTED_IN {roles:['Frank Fitzsimmons']}]->(Hoffa),
  403.   (JohnR)-[:ACTED_IN {roles:['Peter "Pete" Connelly']}]->(Hoffa),
  404.   (DannyD)-[:DIRECTED]->(Hoffa)
  406. CREATE (Apollo13:Movie {title:'Apollo 13', released:1995, tagline:'Houston, we have a problem.'})
  407. CREATE (EdH:Person {name:'Ed Harris', born:1950})
  408. CREATE (BillPax:Person {name:'Bill Paxton', born:1955})
  409. CREATE
  410.   (TomH)-[:ACTED_IN {roles:['Jim Lovell']}]->(Apollo13),
  411.   (KevinB)-[:ACTED_IN {roles:['Jack Swigert']}]->(Apollo13),
  412.   (EdH)-[:ACTED_IN {roles:['Gene Kranz']}]->(Apollo13),
  413.   (BillPax)-[:ACTED_IN {roles:['Fred Haise']}]->(Apollo13),
  414.   (GaryS)-[:ACTED_IN {roles:['Ken Mattingly']}]->(Apollo13),
  415.   (RonH)-[:DIRECTED]->(Apollo13)
  417. CREATE (Twister:Movie {title:'Twister', released:1996, tagline:"Don't Breathe. Don't Look Back."})
  418. CREATE (PhilipH:Person {name:'Philip Seymour Hoffman', born:1967})
  419. CREATE (JanB:Person {name:'Jan de Bont', born:1943})
  420. CREATE
  421.   (BillPax)-[:ACTED_IN {roles:['Bill Harding']}]->(Twister),
  422.   (HelenH)-[:ACTED_IN {roles:['Dr. Jo Harding']}]->(Twister),
  423.   (ZachG)-[:ACTED_IN {roles:['Eddie']}]->(Twister),
  424.   (PhilipH)-[:ACTED_IN {roles:['Dustin "Dusty" Davis']}]->(Twister),
  425.   (JanB)-[:DIRECTED]->(Twister)
  427. CREATE (CastAway:Movie {title:'Cast Away', released:2000, tagline:'At the edge of the world, his journey begins.'})
  428. CREATE (RobertZ:Person {name:'Robert Zemeckis', born:1951})
  429. CREATE
  430.   (TomH)-[:ACTED_IN {roles:['Chuck Noland']}]->(CastAway),
  431.   (HelenH)-[:ACTED_IN {roles:['Kelly Frears']}]->(CastAway),
  432.   (RobertZ)-[:DIRECTED]->(CastAway)
  434. CREATE (OneFlewOvertheCuckoosNest:Movie {title:"One Flew Over the Cuckoo's Nest", released:1975, tagline:"If he's crazy, what does that make you?"})
  435. CREATE (MilosF:Person {name:'Milos Forman', born:1932})
  436. CREATE
  437.   (JackN)-[:ACTED_IN {roles:['Randle McMurphy']}]->(OneFlewOvertheCuckoosNest),
  438.   (DannyD)-[:ACTED_IN {roles:['Martini']}]->(OneFlewOvertheCuckoosNest),
  439.   (MilosF)-[:DIRECTED]->(OneFlewOvertheCuckoosNest)
  441. CREATE (SomethingsGottaGive:Movie {title:"Something's Gotta Give", released:2003})
  442. CREATE (DianeK:Person {name:'Diane Keaton', born:1946})
  443. CREATE (NancyM:Person {name:'Nancy Meyers', born:1949})
  444. CREATE
  445.   (JackN)-[:ACTED_IN {roles:['Harry Sanborn']}]->(SomethingsGottaGive),
  446.   (DianeK)-[:ACTED_IN {roles:['Erica Barry']}]->(SomethingsGottaGive),
  447.   (Keanu)-[:ACTED_IN {roles:['Julian Mercer']}]->(SomethingsGottaGive),
  448.   (NancyM)-[:DIRECTED]->(SomethingsGottaGive),
  449.   (NancyM)-[:PRODUCED]->(SomethingsGottaGive),
  450.   (NancyM)-[:WROTE]->(SomethingsGottaGive)
  452. CREATE (BicentennialMan:Movie {title:'Bicentennial Man', released:1999, tagline:"One robot's 200 year journey to become an ordinary man."})
  453. CREATE (ChrisC:Person {name:'Chris Columbus', born:1958})
  454. CREATE
  455.   (Robin)-[:ACTED_IN {roles:['Andrew Marin']}]->(BicentennialMan),
  456.   (OliverP)-[:ACTED_IN {roles:['Rupert Burns']}]->(BicentennialMan),
  457.   (ChrisC)-[:DIRECTED]->(BicentennialMan)
  459. CREATE (CharlieWilsonsWar:Movie {title:"Charlie Wilson's War", released:2007, tagline:"A stiff drink. A little mascara. A lot of nerve. Who said they couldn't bring down the Soviet empire."})
  460. CREATE (JuliaR:Person {name:'Julia Roberts', born:1967})
  461. CREATE
  462.   (TomH)-[:ACTED_IN {roles:['Rep. Charlie Wilson']}]->(CharlieWilsonsWar),
  463.   (JuliaR)-[:ACTED_IN {roles:['Joanne Herring']}]->(CharlieWilsonsWar),
  464.   (PhilipH)-[:ACTED_IN {roles:['Gust Avrakotos']}]->(CharlieWilsonsWar),
  465.   (MikeN)-[:DIRECTED]->(CharlieWilsonsWar)
  467. CREATE (ThePolarExpress:Movie {title:'The Polar Express', released:2004, tagline:'This Holiday Season… Believe'})
  468. CREATE
  469.   (TomH)-[:ACTED_IN {roles:['Hero Boy', 'Father', 'Conductor', 'Hobo', 'Scrooge', 'Santa Claus']}]->(ThePolarExpress),
  470.   (RobertZ)-[:DIRECTED]->(ThePolarExpress)
  472. CREATE (ALeagueofTheirOwn:Movie {title:'A League of Their Own', released:1992, tagline:'Once in a lifetime you get a chance to do something different.'})
  473. CREATE (Madonna:Person {name:'Madonna', born:1954})
  474. CREATE (GeenaD:Person {name:'Geena Davis', born:1956})
  475. CREATE (LoriP:Person {name:'Lori Petty', born:1963})
  476. CREATE (PennyM:Person {name:'Penny Marshall', born:1943})
  477. CREATE
  478.   (TomH)-[:ACTED_IN {roles:['Jimmy Dugan']}]->(ALeagueofTheirOwn),
  479.   (GeenaD)-[:ACTED_IN {roles:['Dottie Hinson']}]->(ALeagueofTheirOwn),
  480.   (LoriP)-[:ACTED_IN {roles:['Kit Keller']}]->(ALeagueofTheirOwn),
  481.   (RosieO)-[:ACTED_IN {roles:['Doris Murphy']}]->(ALeagueofTheirOwn),
  482.   (Madonna)-[:ACTED_IN {roles:['"All the Way" Mae Mordabito']}]->(ALeagueofTheirOwn),
  483.   (BillPax)-[:ACTED_IN {roles:['Bob Hinson']}]->(ALeagueofTheirOwn),
  484.   (PennyM)-[:DIRECTED]->(ALeagueofTheirOwn)
  486. CREATE (PaulBlythe:Person {name:'Paul Blythe'})
  487. CREATE (AngelaScope:Person {name:'Angela Scope'})
  488. CREATE (JessicaThompson:Person {name:'Jessica Thompson'})
  489. CREATE (JamesThompson:Person {name:'James Thompson'})
  491. CREATE
  492.   (JamesThompson)-[:FOLLOWS]->(JessicaThompson),
  493.   (AngelaScope)-[:FOLLOWS]->(JessicaThompson),
  494.   (PaulBlythe)-[:FOLLOWS]->(AngelaScope)
  496. CREATE
  497.   (JessicaThompson)-[:REVIEWED {summary:'An amazing journey', rating:95}]->(CloudAtlas),
  498.   (JessicaThompson)-[:REVIEWED {summary:'Silly, but fun', rating:65}]->(TheReplacements),
  499.   (JamesThompson)-[:REVIEWED {summary:'The coolest football movie ever', rating:100}]->(TheReplacements),
  500.   (AngelaScope)-[:REVIEWED {summary:'Pretty funny at times', rating:62}]->(TheReplacements),
  501.   (JessicaThompson)-[:REVIEWED {summary:'Dark, but compelling', rating:85}]->(Unforgiven),
  502.   (JessicaThompson)-[:REVIEWED {summary:"Slapstick redeemed only by the Robin Williams and Gene Hackman's stellar performances", rating:45}]->(TheBirdcage),
  503.   (JessicaThompson)-[:REVIEWED {summary:'A solid romp', rating:68}]->(TheDaVinciCode),
  504.   (JamesThompson)-[:REVIEWED {summary:'Fun, but a little far fetched', rating:65}]->(TheDaVinciCode),
  505.   (JessicaThompson)-[:REVIEWED {summary:'You had me at Jerry', rating:92}]->(JerryMaguire)
  507. WITH TomH as a
  508. MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d) RETURN a,m,d LIMIT 10;
复制代码
1.执行检察效果


二、操作

1.find 单个节点


2.同上，已某个属性去查询


3. 指定查询个数


4.条件查询


5.查询某个人出演的电影汇总


 
6.查询tom出演的电影中，尚有其他演员的信息。



7.查询跟电影(Cloud Atlas)有关的演员，并显示是什么关系。


固然也可以拓扑图显示，但只会显示出节点信息，没有显示出关系。

8.多级关系

2跳关系


    
  查询语句用于查找与名为 "Kevin Bacon" 的人节点通过 1 到 2 步关系连接的全部节点，并返回这些节点（定名为 "hollywood"）以及 Kevin Bacon 的名字。
  查询效果展示了与 Kevin Bacon 直接或通过一个中间节点间接相干的人物和电影信息。
  具体来说，你的查询效果表示以下内容：
  
  这个查询有助于明确不同实体（在这个案例中是演员和电影）之间的关联。例如，它显示了 Kevin Bacon 与其他演员的合作关系，以及他们共同到场的电影项目。
  4跳关系



9.查找 Kevin Bacon 和 Meg Ryan 之间的最短路径，并返回了这条路径上的节点和关系


含义
   从 Kevin Bacon 到 Meg Ryan 的路径是通过电影《义海雄风》(A Few Good Men) 和 汤姆·克鲁斯 (Tom Cruise) 连接的，再由汤姆·克鲁斯通过电影《壮志凌云》(Top Gun) 最终连接到 Meg Ryan。以下是对你提供的查询效果的具体表明：
    具体来说，这条路径可以描述为：
  
  









 


免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。



欢迎光临 qidao123.com技术社区-IT企服评测·应用市场 (https://dis.qidao123.com/) Powered by Discuz! X3.4