springBoot+mybatisPlus+Oracle+Junit4框架整合

springBoot+mybatisPlus+Oracle+Junit4整合

1.工程总结构目录

2.maven依赖(pom.xml)

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
            <version>2.1.4.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <version>2.1.4.RELEASE</version>
        </dependency>
       <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <version>2.1.4.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.10</version>
        </dependency>
        <!-- fastjson -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.48</version>
        </dependency>
        <dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
            <version>12.2.0.1</version>
        </dependency>

        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>1.7.26</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.7.26</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.0.5</version>
        </dependency>
        <!-- junit -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>4.3.24.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-test</artifactId>
            <version>2.1.4.RELEASE</version>
        </dependency>

3.配置文件（AppApplication）

server:
  port: 80
spring:
  datasource:
    driver-class-name: oracle.jdbc.OracleDriver
    url: jdbc:oracle:thin:@192.168.8.222:1521:orcl
    username: data
    password: 123

4.创建entity实体类

package com.somj.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

@Data
@TableName("ms_user")
public class MsUser {
    @TableField("user_id")
    private int userId;
    @TableField("user_name")
    private String userName;
    @TableField("mobile_phone")
    private String mobilePhone;
}

5.创建mapper接口

package com.somj.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.somj.entity.MsUser;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

@Repository
@Mapper
public interface MsUserMapper extends BaseMapper<MsUser> {
}

6.创建junit4测试类

package com.somj.test;

import com.somj.entity.MsUser;
import com.somj.mapper.MsUserMapper;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.List;


@SpringBootTest
//@SpringBootTest
@RunWith(SpringRunner.class)
public class MsUserTest {

    //@Resource(mappedName = "msUserMapper")
    @Autowired(required=true)
    private MsUserMapper msUserMapper;

    @Test
    public void test1(){
        List<MsUser> blUserLists = msUserMapper.selectList(null);
        System.out.println(blUserLists);
    }
}

7.创建controller

package com.somj.controller;

import com.somj.entity.MsUser;
import com.somj.mapper.MsUserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;


import java.util.List;

@RestController
public class ControllerTest {

    @Autowired
    private MsUserMapper msUserMapper;

    @RequestMapping("/test")
    public String getNameById(){
        List<MsUser> msUsers = msUserMapper.selectList(null);
        return msUsers.toString();
    }
}