SpringBoot整合Neo4j(SpringBoot+Mybatis+Druid+Neo4j)

前面几篇文章简单的描述了Neo4j的安装、配置及导数的内容，这篇就来写下实际项目中如何整合应用Neo4j。下面要整合的是SpringBoot+Mybatis+Druid+Neo4j这样的一个框架。废话不多说，直接开始吧（这里我用的是2018.1.8版本的IntelliJ IDEA、jdk1.8）。

第一步：创建一个SpringBoot的WebService项目。

打开IDEA点击Create New Project。

选择Spring Initializr，再点击Next下一步。

填写好项目信息后点Next

选择Web，勾选SpringWebServices，之后点击Next

最后点击Finish，初始的SpringBoot webservice项目就完成了

此后需要等待一小段时间让它构建完成。

完成之后其目录结构如上图所示，java包下有SpringBoot的启动类，resources下有个SpringBoot的application.propertis配置文件，而我喜欢用yml就把它改成了yml，这个视个人喜好而定。

下面可以先完善一下项目的包结构，我的包结构如下所示：

第二步：添加依赖包

需要手动添加的只有三个包，分别是Neo4j 驱动、mybatis还有druid连接池，完整POM如下：

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  4.     <modelVersion>4.0.0</modelVersion>
  5.     <parent>
  6.         <groupId>org.springframework.boot</groupId>
  7.         <artifactId>spring-boot-starter-parent</artifactId>
  8.         <version>2.2.7.RELEASE</version>
  9.         <relativePath/> <!-- lookup parent from repository -->
  10.     </parent>
  11.     <groupId>com.minant</groupId>
  12.     <artifactId>mant</artifactId>
  13.     <version>0.0.1-SNAPSHOT</version>
  14.     <name>minant-service-neo4j</name>
  15.     <description>springBoot+mybatis+druid+neo4j</description>
  16.  
  17.     <properties>
  18.         <java.version>1.8</java.version>
  19.     </properties>
  20.  
  21.     <dependencies>
  22.         <!--构建项目时添加的包-->
  23.         <dependency>
  24.             <groupId>org.springframework.boot</groupId>
  25.             <artifactId>spring-boot-starter-web-services</artifactId>
  26.         </dependency>
  27.         <dependency>
  28.             <groupId>org.springframework.boot</groupId>
  29.             <artifactId>spring-boot-starter-test</artifactId>
  30.             <scope>test</scope>
  31.             <exclusions>
  32.                 <exclusion>
  33.                     <groupId>org.junit.vintage</groupId>
  34.                     <artifactId>junit-vintage-engine</artifactId>
  35.                 </exclusion>
  36.             </exclusions>
  37.         </dependency>
  38.         <!--手动添加-->
  39.         <!--neo4j-jdbc-driver-->
  40.         <dependency>
  41.             <groupId>org.neo4j</groupId>
  42.             <artifactId>neo4j-jdbc-driver</artifactId>
  43.             <version>3.4.0</version> </dependency>
  44.         <!--mybatis-spring-boot-->
  45.         <dependency>
  46.             <groupId>org.mybatis.spring.boot</groupId>
  47.             <artifactId>mybatis-spring-boot-starter</artifactId>
  48.             <version>1.3.2</version>
  49.         </dependency>
  50.         <!--  连接池-->
  51.         <dependency>
  52.             <groupId>com.alibaba</groupId>
  53.             <artifactId>druid-spring-boot-starter</artifactId>
  54.             <version>1.1.10</version>
  55.         </dependency>
  56.     </dependencies>
  57.  
  58.     <build>
  59.         <plugins>
  60.             <plugin>
  61.                 <groupId>org.springframework.boot</groupId>
  62.                 <artifactId>spring-boot-maven-plugin</artifactId>
  63.             </plugin>
  64.         </plugins>
  65.     </build>
  66.  
  67. </project>

第三步：yml配置

有服务端口、名称、数据源连接池等，赋上yml文件：

  1. server:
  2.   port: 8081
  3.   servlet:
  4.     context-path: /
  5. spring:
  6.   application:
  7.     name: service-neo4j
  8.   http:
  9.     encoding:
  10.       charset: UTF-8
  11.       enabled: true
  12.       force: true
  13.   datasource:
  14.     type: com.alibaba.druid.pool.DruidDataSource
  15.     driverClassName: org.neo4j.jdbc.bolt.BoltDriver
  16.     url: jdbc:neo4j:bolt://localhost:7687
  17.     username: neo4j
  18.     password: root
  19. #   数据源其他配置
  20.     initialSize: 5
  21.     minIdle: 5
  22.     maxActive: 20
  23.     maxWait: 60000
  24.     timeBetweenEvictionRunsMillis: 60000
  25.     minEvictableIdleTimeMillis: 300000
  26. #    validation-query: match (n) return id(n) limit 2
  27.     testWhileIdle: false
  28.     testOnBorrow: false
  29.     testOnReturn: false
  30.     poolPreparedStatements: true
  31.     filters: stat,wall,log4j
  32.     maxPoolPreparedStatementPerConnectionSize: 20
  33.     useGlobalDataSourceStat: true
  34.     connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
  35. mybatis:
  36.   mapper-locations: classpath*:/mapper/*.xml
  37.   config-location: classpath:mybatis-config.xml

第四步：编写代码

这里编写代码就与一般SMM项目的编写大同小异了，只不过XML中的SQL要写成查询Neo4j用的Cypher语句就行了。如下：

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="com.minant.mant.mapper.MyNeo4jMapper">
  4.     <select id="getAll" resultType="com.minant.mant.model.MovieInfoModel">
  5.         MATCH (people:Movie)
  6.         RETURN
  7.           id(people) as id,
  8.           people.title as title,
  9.           people.tagline as tagline,
  10.           people.released as released LIMIT 10
  11. 	</select>
  12.  
  13.     <insert id="addMovie" parameterType="com.minant.mant.form.MovieInfoForm">
  14.         create(people:Movie{title:#{title},tagline:#{tagline},released:#{released}})
  15.     </insert>
  16.  
  17.     <update id="updateMovie" parameterType="com.minant.mant.form.MovieInfoForm">
  18.         match (people:Movie)
  19.         where people.title = #{title}
  20.         set people.tagline=#{tagline},people.released=#{released}
  21.     </update>
  22.  
  23.     <delete id="delMovie" parameterType="com.minant.mant.form.MovieInfoForm">
  24.         match (people:Movie)
  25.         where people.title = #{title} delete people
  26.     </delete>
  27. </mapper>

第五步：接口验证

本DEMO中的测试数据为Neo4j Cypher学习中的 Movie Graph数据：

接口定义如下：

  1. package com.minant.mant.controller;
  2.  
  3. import com.minant.mant.form.MovieInfoForm;
  4. import com.minant.mant.model.MovieInfoModel;
  5. import com.minant.mant.service.neo4j.Neo4jService;
  6. import org.springframework.beans.factory.annotation.Autowired;
  7. import org.springframework.web.bind.annotation.PostMapping;
  8. import org.springframework.web.bind.annotation.RequestBody;
  9. import org.springframework.web.bind.annotation.RequestMapping;
  10. import org.springframework.web.bind.annotation.RestController;
  11.  
  12. import java.util.List;
  13. /**
  14.  * @author : MinAnt
  15.  * @ClassName : MyNeo4jController
  16.  * @Description :
  17.  * @date : 2020/5/14
  18.  **/
  19.  
  20. @RestController
  21. public class MyNeo4jController {
  22.  
  23.     @Autowired
  24.     private Neo4jService neo4jService;
  25.  
  26.     /**
  27.      * 查询所有电影节点信息
  28.      * */
  29.     @RequestMapping("/getAll")
  30.     public List<MovieInfoModel> getAll() {
  31.         List<MovieInfoModel> models = neo4jService.getAll();
  32.         return models;
  33.     }
  34.  
  35.     /**
  36.      * 新增电影节点
  37.      * */
  38.     @RequestMapping("/add")
  39.     public int add(MovieInfoForm form) {
  40.         form = new MovieInfoForm();
  41.         form.setTitle("MinAntMovie");
  42.         form.setReleased("2020");
  43.         form.setTagline("my test add");
  44.         int i = neo4jService.addMovie(form);
  45.         return i;
  46.     }
  47.  
  48.     /**
  49.      * 修改电影节点
  50.      * */
  51.     @RequestMapping("/update")
  52.     public int update(MovieInfoForm form) {
  53.         form = new MovieInfoForm();
  54.         form.setTitle("MinAntMovie");
  55.         form.setReleased("2050");
  56.         form.setTagline("my test update");
  57.         int i = neo4jService.updateMovie(form);
  58.         return i;
  59.     }
  60.     /**
  61.      * 删除电影节点
  62.      * */
  63.     @RequestMapping("/delMovie")
  64.     public int delMovie(MovieInfoForm form) {
  65.         form = new MovieInfoForm();
  66.         form.setTitle("MinAntMovie");
  67.         int i = neo4jService.delMovie(form);
  68.         return i;
  69.     }
  70.  
  71. }
  72.

调用接口结果如下：

至此项目整合完成！

 

源码链接：https://github.com/AntMxs/MyNeo4j

posted @ 2020-10-22 09:42  百丈山居客  阅读(1944)  评论(0)    收藏  举报