SND - API

最新推荐文章于 2023-10-14 20:40:11 发布

转载最新推荐文章于 2023-10-14 20:40:11 发布 · 161 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/u/2552286/blog/3073018

本文详细介绍了使用Spring Boot和Neo4j进行图数据库操作的方法，包括节点的增删改查、关系的添加和更新，以及事务处理和分页查询等高级功能。

package org.canaan.neo4j.graph;

import org.canaan.neo4j.graph.entity.UserNode;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.Date;
import java.util.Optional;

/**
 * @author Canaan
 * @date 2019/7/11 10:31
 */
@RunWith(SpringRunner.class)
@SpringBootTest
public class UserNeo4jDaoTest {
    private static final Logger LOGGER = LoggerFactory.getLogger(UserNeo4jDaoTest.class);

    @Autowired
    private UserNeo4jDao userNeo4jDao;

    @Test
    public void queryUser() {
        Optional<UserNode> userNode = userNeo4jDao.findByUserId(4L);
        System.out.println(userNode);
    }

    /**
     * 如果不存在就创建，存在就更新属性，不会更新【标签】
     *
     * @author Canaan
     * @date 2019/7/11 12:59
     */
    @Test
    public void addOrUpdateUser() {
        UserNode user1 = new UserNode();
        user1.setUserId(1L);
        user1.setUserName("晃盖");
        //user1.setLabels(Collections.singleton(UserNode.LABEL_FOUNDER));
        user1.setCreateTime(new Date());
        user1 = userNeo4jDao.save(user1);
        LOGGER.info("{}", user1);

        //----
        UserNode user2 = new UserNode();
        user2.setUserId(2L);
        user2.setUserName("宋江");
        //user2.setLabels(Collections.singleton(UserNode.LABEL_PLOUGH));
        user2.setCreateTime(new Date());
        user2 = userNeo4jDao.save(user2);
        LOGGER.info("{}", user2);
    }


    /**
     * 获取已经存在的节点， 创建新的节点并关系
     *
     * @author Canaan
     * @date 2019/7/11 14:16
     */
    @Test
    public void addNodeAdnRelation() {

        UserNode boss = this.userNeo4jDao.findById(2L).orElseThrow(RuntimeException::new);

        UserNode subUser1 = new UserNode();
        subUser1.setUserId(3L);
        subUser1.setUserName("卢俊义");
        //subUser1.setLabels(Collections.singleton(UserNode.LABEL_PLOUGH));
        subUser1.setCreateTime(new Date());

        UserNode subUser2 = new UserNode();
        subUser2.setUserId(4L);
        subUser2.setUserName("吴用");
        //subUser2.setLabels(Collections.singleton(UserNode.LABEL_PLOUGH));
        subUser2.setCreateTime(new Date());

        subUser2.setParentNode(boss);
        subUser1.setParentNode(boss);

        userNeo4jDao.save(subUser2);
        userNeo4jDao.save(subUser1);

    }

    /**
     * 如果节点不存在就创建，如果关系不存在就创建。否则只更新节点
     *
     * @author Canaan
     * @date 2019/7/11 14:35
     */
    @Test
    public void addNodeAdnRelation2() {
        UserNode subUser1 = new UserNode();
        subUser1.setUserId(4L);
        subUser1.setUserName("吴用");
        //subUser1.setLabels(Collections.singleton(UserNode.LABEL_PLOUGH));
        subUser1.setCreateTime(new Date());

        UserNode subUser2 = new UserNode();
        subUser2.setUserId(6L);
        subUser2.setUserName("燕青");
        //subUser2.setLabels(Collections.singleton(UserNode.LABEL_SONUZ));
        subUser2.setCreateTime(new Date());

        subUser2.setParentNode(subUser1);

        userNeo4jDao.save(subUser2);
    }


    /**
     * 更新关系
     *
     * @author Canaan
     * @date 2019/7/11 14:47
     */
    @Test
    public void updateRelation() {
        //userNeo4jDao.save(node);  或 userNeo4jDao.save(node,-1);  //关系不限制的添加
        //userNeo4jDao.save(node,0);   //更新节点时，不更新关系
        //userNeo4jDao.save(node, 1);  //更新节点时，关系只维护1级

    }

    /**
     * 在已经存在的两个节点中添加关系。如果关系存在就不处理，不存在就添加
     *
     * @author Canaan
     * @date 2019/7/11 13:08
     */
    @Test
    public void addRelation1() {
        UserNode u1 = this.userNeo4jDao.findById(1L).orElseThrow(RuntimeException::new);
        UserNode u2 = this.userNeo4jDao.findById(2L).orElseThrow(RuntimeException::new);
        u2.setParentNode(u1);
        this.userNeo4jDao.save(u2);
    }


    /**
     * 删除节点，如果节点有关系的话，那么同时删除关系
     *
     * @author Canaan
     * @date 2019/7/11 13:08
     */
    @Test
    public void deleteNodeAndRelation() {
        this.userNeo4jDao.deleteById(6L);
    }


    /**
     * 删除关系
     *
     * @author Canaan
     * @date 2019/7/11 14:37
     */
    @Test
    public void getNode() {

        Optional<UserNode> userNode;

        // 查询指定节点
        userNode = this.userNeo4jDao.findById(6L, 0);

        //查询指定节点，及1跳关系
        //userNode = this.userNeo4jDao.findById(6L);
        //userNode = this.userNeo4jDao.findById(6L, 1);

        // 注意： depth 必须大于 1 才会级联查询

        System.out.println(userNode.orElse(null));
    }


}

分页查询：

https://docs.spring.io/spring-data/neo4j/docs/5.1.3.RELEASE/reference/html/#reference_programming-model_sorting_and_paging

事务：

https://docs.spring.io/spring-data/neo4j/docs/5.1.3.RELEASE/reference/html/#reference_programming-model_transactions

转载于:https://my.oschina.net/u/2552286/blog/3073018