//---传参数------------------------------------------------------------//参数可以用 Values.parameters("aid", 25，"person_name", person, "company_name", company)， 也可以是Map//需要用到参数的地方// 1) where 语句中的比对条件 = >< != $p// 2) where id(a) in [1,2,3,4] 如何设置参数？// 3) 字段 CREATE (:Company {name: $name})// 4） set b+={....} 如何设置参数？@Testpublic void TestUseProps() {String cql = "match (a:User)-[r]-(b) where id(a)=$aid return a,b,r";try (Session session = GraphDb.newSession()) {List<Record> list = session.run(cql, Values.parameters("aid", 25)).list();System.out.println(list.size());}}@Testpublic void TestUseProps2() {String cql = "match (a:User)-[r]-(b) where id(a)=$aid return a,b,r";try (Session session = GraphDb.newSession()) {Map<String, Object> pp = new HashMap<>();pp.put("aid", 25);List<Record> list = session.run(cql, pp).list();System.out.println(list.size());}}// in@Testpublic void TestUseProps3() {String cql = "match (a) where id(a) in $ids return a";try (Session session = GraphDb.newSession()) {Map<String, Object> pp = new HashMap<>();pp.put("ids", new int[]{5, 74});List<Record> list = session.run(cql, pp).list();System.out.println(list.size());}}/*2.6.5. Create node with propertiesParameters.{"props" : {"name" : "Andy","position" : "Developer"}}Query.CREATE ($props)*/@Testpublic void TestUseProps4() {String cql = "CREATE ($props) ";try (Session session = GraphDb.newSession()) {String json="{\n" +" \"props\" : {\n" +" \"name\" : \"Andy\",\n" +" \"position\" : \"Developer\"\n" +" }\n" +" }";Map map = js.toMap(json);session.run(cql, map).list();System.out.println("ok");}}@Test // set n={...}public void TestUseProps5() {String cql = "UNWIND $props AS properties\n" +"CREATE (n:Person)\n" +"SET n = properties\n" +"RETURN n";try (Session session = GraphDb.newSession()) {String json="{\n" +" \"props\" : {\n" +" \"name\" : \"Andy1\",\n" +" \"position\" : \"Developer1\"\n" +" }\n" +" }";Map map = js.toMap(json);List<Record> list = session.run(cql, map).list();System.out.println(list.size());}}@Test // set n+={...}public void TestUseProps6() {String cql = "UNWIND $props AS properties\n" +"match (n) where id(n)=25 \n" +"SET n += properties\n" +"RETURN n";try (Session session = GraphDb.newSession()) {String json="{\n" +" \"props\" : {\n" +" \"sex\" : \"男\",\n" +" \"position\" : \"Developer\"\n" +" }\n" +" }";Map map = js.toMap(json);List<Record> list = session.run(cql, map).list();System.out.println(list.size());}}@Test // set n={...} 一次创建多个节点public void TestUseProps7() {String cql = "UNWIND $props AS properties\n" +"CREATE (n:Person)\n" +"SET n = properties\n" +"RETURN n";try (Session session = GraphDb.newSession()) {String json="{\n" +" \"props\" : [ {\n" +" \"awesome\" : true,\n" +" \"name\" : \"Andy3\",\n" +" \"position\" : \"Developer\"\n" +" }, {\n" +" \"children\" : 3,\n" +" \"name\" : \"Michael\",\n" +" \"position\" : \"Developer\"\n" +" } ]\n" +"}";Map map = js.toMap(json);List<Record> list = session.run(cql, map).list();System.out.println(list.size());}}/*2.6.3. Regular expressionParameters.{"regex" : ".*h.*"}Query.MATCH (n:Person)WHERE n.name =~ $regexRETURN n.name*/@Test // 使用正则表达式public void TestUseProps8() {String cql = "MATCH (n:Person)\n" +" WHERE n.name =~ $regex\n" +" RETURN n.name";try (Session session = GraphDb.newSession()) {String json="{\n" +" \"regex\" : \".*h.*\"\n" +" }";Map map = js.toMap(json);List<Record> list = session.run(cql, map).list();System.out.println(list.size());}}/*2.6.4. Case-sensitive string pattern matchingParameters.{"name" : "Michael"}Query.MATCH (n:Person)WHERE n.name STARTS WITH $nameRETURN n.name*/@Test public void TestUseProps9() {String cql = "MATCH (n:Person)\n" +" WHERE n.name STARTS WITH $name\n" +" RETURN n.name";try (Session session = GraphDb.newSession()) {String json="{\n" +" \"name\" : \"Michael\"\n" +" }";Map map = js.toMap(json);List<Record> list = session.run(cql, map).list();System.out.println(list.size());}}
js.toMap 是将 json 转成Map的工具类