eclipse中搭建springboot学习（6）--连接oracle

在pom.xml中添加依赖的包，依赖ojdbc报错时，请看之前的解决报错的博客。

<!-- Mybatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        
        <!-- oracle -->
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>11.2.0.1.0</version>
        </dependency> 
 

application.properties中配置连接数据库

spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.url= jdbc:oracle:thin:@192.168.200.61:1521:XXX
spring.datasource.username=XXX
spring.datasource.password=XXX
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true

//sql存放的路径
mybatis.mapper-locations=classpath:mapper/*.xml 

 新建TestDTO类

package com.example.demo1018.dto;

public class TestDTO {
    private String id_;
    private String rev_;
    public String getId_() {
        return id_;
    }
    public void setId_(String id_) {
        this.id_ = id_;
    }
    public String getRev_() {
        return rev_;
    }
    public void setRev_(String rev_) {
        this.rev_ = rev_;
    }
}
 

新建TestDao类

 

package com.example.demo1018.dao;

import java.util.ArrayList;

import com.example.demo1018.dto.TestDTO;

public interface TestDao {
    public ArrayList<TestDTO> TestGetList();
}
 

新建TestService类

package com.example.demo1018.service;

import java.util.ArrayList;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.example.demo1018.dao.TestDao;
import com.example.demo1018.dto.TestDTO;

@Service
public class TestService {
    @Autowired
    private TestDao dao;
    
    public ArrayList<TestDTO> getList() {
        return dao.TestGetList();
    }
}
 

 

新建TestController类

package com.example.demo1018.controller;

import java.util.ArrayList;

import javax.annotation.Resource;

import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.example.demo1018.dto.TestDTO;
import com.example.demo1018.service.TestService;

@RestController
public class TestController {
    @Resource
    private TestService service;
    
    @RequestMapping("/getList")
    public ArrayList<TestDTO> GetIndoorCheckItemEntities(){
        return service.getList();
    }
}
 

 

在启动类中添加扫描dao的注解@MapperScan 

@MapperScan扫描多个文件时可以用“,”分割多个文件，例如@MapperScan({"第一个文件","第二个文件"})，扫描demo1018的文件夹@MapperScan("com.example.demo1018.*")

package com.example.demo1018;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.web.servlet.ServletComponentScan;

在启动类中添加扫描注解  ，注意将之前过滤器暂时注释掉，运行查看是否成功

@SpringBootApplication
@ServletComponentScan 
@MapperScan("com.example.demo1018.dao")
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }
    
}

 

项目路径如下：