这一章将继续上一章没有写完的java操作Neo4j数据库的修改,删除,查询api实现,如果有需要对neo4j的新增功能请到Neo4j(CQL)学习记录-04(Cypher Query Language)查看,
这一章我们通过java操作neo4j的driver来对数据库进行节点关系的修改和删除的操作,以及修改关系,节点的属性。
删除指定属性的节点
回顾一下CQL怎么写的:MATCH(n:label{}) delete n;可以传入指定属性,节点名来删除,不传入属性名会全部删除,谨慎使用!
/**
* 功能描述:MATCH(n:label{})
*
* @param label 标签
* @param properties 指定属性
* @author zhongzy
* @date 2024/05/16
*/
public void deleteNode(String label, Map<String,Object> properties){
try(Session session = driver.session()){
StringBuilder sb = new StringBuilder("MATCH (n:" + label);
appendDeleteProperties(sb, properties);
sb.append(") DELETE n");
session.run(sb.toString(), Values.value(properties));
}
}
/**
* 功能描述:
*
* @param sb CQL字符串
* @param properties 性能
* @author zhongzy
* @date 2024/05/16
*/
private void appendDeleteProperties(StringBuilder sb, Map<String, Object> properties) {
if (properties != null && !properties.isEmpty()) {
sb.append(" {");
for (Map.Entry<String, Object> entry : properties.entrySet()) {
sb.append(entry.getKey()).append(":'").append(entry.getValue()).append("', ");
}
sb.setLength(sb.length() - 2);
sb.append("}");
}
}
删除指定关系
删除关系CQL回顾:MATCH (a:person {name: ""}-[r]->(b:person {name: ""}) DELETE r),
只删除关系,如果不传入关系属性和节点属性,所有关系均会被删除,在使用时需要判断。
/**
* 功能描述:删除指定关系
*
* @param fromLabel 起始节点
* @param fromProperties 起始节点属性
* @param toLabel 目标节点标签
* @param toProperties 目标节点属性
* @param relationshipType 关系类型
* @param relationshipProperties 关系属性
* @author zhongzy
* @date 2024/05/16
*/
public void deleteRelationShip(String fromLabel, Map<String, Object> fromProperties, String toLabel, Map<String, Object> toProperties, String relationshipType, Map<String, Object> relationshipProperties) {
try (Session session = driver.session()) {
StringBuilder sb = new StringBuilder("MATCH (a:" + fromLabel);
appendProperties(sb, "a", fromProperties);
sb.append(") MATCH (b:" + toLabel);
appendProperties(sb, "b", toProperties);
sb.append(") MATCH (a)-[r:" + relationshipType);
appendProperties(sb, "r", relationshipProperties);
sb.append("]->(b) DELETE r");
Map<String, Object> parameters = new HashMap<>();
addPropertiesToParameters(parameters, addPrefixToProperties(fromProperties,"a_"));
addPropertiesToParameters(parameters, addPrefixToProperties(toProperties,"b_"));
addPropertiesToParameters(parameters, addPrefixToProperties(relationshipProperties,"r_"));
session.run(sb.toString(), Values.value(parameters));
}
}
删除指定节点和关系
删除指定节点和关系的CQL:MATCH (n:person {name: "沙僧"})-[r]-(m:person {name: "猪八戒"}) DELETE n, r, m;需要配合业务判断使用,避免造成所有数据被删除
/**
* 功能描述:删除节点和关系
* MATCH (n:person {name: "沙僧"})-[r]-(m:person {name: "猪八戒"})
* DELETE n, r, m
*
* @param fromLabel 起始节点
* @param fromProperties 起始节点属性
* @param toLabel 目标节点
* @param toProperties 目标节点属性
* @param relationshipType 关系类型
* @param relationshipProperties 关系属性
* @author zhongzy
* @date 2024/05/17
*/
public void deleteNodeAndRelationShip(String fromLabel, Map<String, Object> fromProperties, String toLabel, Map<String, Object> toProperties, String relationshipType, Map<String, Object> relationshipProperties) {
try(Session session = driver.session()) {
StringBuilder sb = new StringBuilder("MATCH (a:" + fromLabel);
appendProperties(sb, "a", fromProperties);
sb.append(") MATCH (b:" + toLabel);
appendProperties(sb, "b", toProperties);
sb.append(") MATCH (a)-[r:" + relationshipType);
appendProperties(sb, "r", relationshipProperties);
sb.append("]->(b) DELETE r,a,b");
Map<String, Object> parameters = new HashMap<>();
addPropertiesToParameters(parameters, addPrefixToProperties(fromProperties,"a_"));
addPropertiesToParameters(parameters, addPrefixToProperties(toProperties,"b_"));
addPropertiesToParameters(parameters, addPrefixToProperties(relationshipProperties,"r_"));
session.run(sb.toString(), Values.value(parameters));
}
}
更新节点属性,添加节点属性
更新节点属性,添加节点属性CQL : Match(n:label{}) set n += $properties,需要配合业务判断使用,避免造成所有数据被更新
/**
* 功能描述:更新节点属性,或者新增属性 Match(n:label{}) set n += $properties
*
* @param label 标签
* @param properties 性能
* @param upDateProperties UpDate 属性
* @author zhongzy
* @date 2024/05/17
*/
public void upDateNode(String label, Map<String, Object> properties, Map<String, Object> upDateProperties) {
try (Session session = driver.session()) {
StringBuilder sb = new StringBuilder("MATCH (n:" + label);
appendProperties(sb, "n", properties);
sb.append(") SET n += $properties");
Map<String, Object> parameters = new HashMap<>();
addPropertiesToParameters(parameters, addPrefixToProperties(properties, "n_"));
parameters.put("properties", upDateProperties);
session.run(sb.toString(), Values.value(parameters));
}
}
更新关系属性
更新关系的属性 Match(n:label{})-[r]-(m:label{}) set r += $properties,需要配合业务判断使用,避免造成所有数据被更新
/**
* 功能描述:更新关系的属性 Match(n:label{})-[r]-(m:label{}) set r += $properties
*
* @param fromLabel 从标签
* @param fromProperties 从属性
* @param toLabel 到标签
* @param toProperties 前往房产
* @param relationshipType 关系类型
* @param relationshipProperties 关系属性
* @param upDateProperties Up Date 属性
* @author zhongzy
* @date 2024/05/17
*/
public void updateRelationShip(String fromLabel, Map<String, Object> fromProperties, String toLabel, Map<String, Object> toProperties, String relationshipType, Map<String, Object> relationshipProperties, Map<String, Object> upDateProperties) {
try(Session session = driver.session()){
StringBuilder sb = new StringBuilder("MATCH (a:" + fromLabel);
appendProperties(sb, "a", fromProperties);
sb.append(") MATCH (b:" + toLabel);
appendProperties(sb, "b", toProperties);
sb.append(") MATCH (a)-[r:" + relationshipType);
appendProperties(sb, "r", relationshipProperties);
sb.append("]->(b) SET r += $properties");
Map<String, Object> parameters = new HashMap<>();
addPropertiesToParameters(parameters, addPrefixToProperties(fromProperties, "a_"));
addPropertiesToParameters(parameters, addPrefixToProperties(toProperties, "b_"));
addPropertiesToParameters(parameters, addPrefixToProperties(relationshipProperties, "r_"));
parameters.put("properties", upDateProperties);
session.run(sb.toString(), Values.value(parameters));
}
}
我将在下一章内容中来主要提到在java中使用复杂的Neo4j查询api的编写~