SpringBoot 工程目录整合mybatis-neo4j(注解类型)

迷南。 2022-10-26 04:59 240阅读 0赞

# 工程结构 #

├─java
    │  └─com
    │      └─claroja
    │          │  App.java
    │          │
    │          ├─controller
    │          │      Neo4jController.java
    │          │
    │          ├─dao
    │          │      UserMapper.java
    │          │
    │          └─model
    │                  User.java
    │
    └─resources
            application.yml

# 数据准备 #

create (n:Person{ name:"wang",title:"manager"})

# resources #

`resources/application.yml`

spring:
      datasource:
        driver-class-name: org.neo4j.jdbc.http.HttpDriver
        url: jdbc:neo4j:http://192.168.2.222:7474
        username: neo4j
        password: 123456

# java.com.claroja #

`java/com/claroja/App.java`

package com.claroja;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    @MapperScan(basePackages = "com.claroja.dao") //开启注解
    public class App { 
        public static void main(String[] args) { 
            SpringApplication.run(App.class, args);
        }
    }

`java/com/claroja/controller/Neo4jController.java`

package com.claroja.controller;
    
    import com.claroja.dao.UserMapper;
    import com.claroja.model.User;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import java.util.List;
    
    @Controller
    public class Neo4jController { 
    
        @Autowired
        private UserMapper userMapper;
    
        @RequestMapping("/query")
        @ResponseBody
        public List<User> queryUserList(){ 
            List<User> users = userMapper.queryUserList();
            return users;
        }
    }

`java/com/claroja/dao/UserMapper.java`

package com.claroja.dao;
    
    import com.claroja.model.User;
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Select;
    
    import java.util.List;
    
    @Mapper
    public interface UserMapper { 
        @Select("match(n:Person) return n.title as title,n.name as name")
        public List<User> queryUserList();
    }

`java/com/claroja/model/User.java`

package com.claroja.model;
    
    public class User { 
    
        private String name;
        private String title;
    
        public String getName() { 
            return name;
        }
    
        public void setName(String name) { 
            this.name = name;
        }
    
        public String getTitle() { 
            return title;
        }
    
        public void setTitle(String title) { 
            this.title = title;
        }
    
        @Override
        public String toString() { 
            return "User{" +
                    "name='" + name + '\'' +
                    ", title='" + title + '\'' +
                    '}';
        }
    }

# POM #

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.4.2</version>
            <relativePath/> 
        </parent>
        <groupId>com.claroja</groupId>
        <artifactId>springboot-mybatis</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>springboot-mybatis</name>
        <description>Demo project for Spring Boot</description>
        <properties>
            <java.version>1.8</java.version>
        </properties>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-devtools</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.3</version>
            </dependency>
            <dependency>
                <groupId>org.neo4j</groupId>
                <artifactId>neo4j-jdbc-driver</artifactId>
                <version>4.0.1</version>
            </dependency>
    
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

# 测试编写 #

`com.claroja.controller.Neo4jControllerTest.java`

package com.claroja.controller;
    
    import com.claroja.dao.UserMapper;
    import com.claroja.model.User;
    import org.junit.jupiter.api.Test;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    
    import java.util.List;
    
    @SpringBootTest
    class Neo4jControllerTest { 
        @Autowired
        private UserMapper userMapper;
        @Test
        void queryUserList() { 
            List<User> users = userMapper.queryUserList();
            System.out.println(users);
    
        }
    }