使用mybatis-plus整合springboot+oracle的使用

oracle的maven依赖:

 <dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0.3</version>
 </dependency>

项目完整依赖:

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.7.10</version>
</parent>
<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.16.20</version>
        </dependency>
        <!--ojdbc依赖-->
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>11.2.0.3</version>
        </dependency>
            <!--mybatis-plus整合依赖-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.0.5</version>
        </dependency>
    </dependencies>

(1)创建application.yml文件，修改配置:

server:
  port: 8082
spring:
  datasource:
    url: jdbc:oracle:thin:@//自己虚拟机的IP地址:1521/xe
    username: system    #数据库名称
    password: oracle    #数据库密码
    driver-class-name: oracle.jdbc.OracleDriver
logging:
  level:
    root: debug    #日志
mybatis-plus:
  mapper-locations: classpath:mapper/*Mapper.xml

(2)springboot启动类，运行main即可:

@SpringBootApplication
@MapperScan("com.dk.mapper")
public class oracleAppcation {
    public static void main(String[] args) {
        SpringApplication.run(oracleAppcation.class);
    }
}

(3)mybatis-plus三步逆向生成实体类和mapper步骤:

1.连接oracle数据库,找到表右键选中

2.根据自己需求选择要放置位置和定义实体类包名

3.选中这些标方框的,最后点击fianish确定

(3)新建一个controller包，在controller包下新建一个EmpController.java:

@RestController
@RequestMapping("/emp")
public class EmpController {
    @Autowired
    private EmpService empService;
    @GetMapping("/empList")
    public List<Emp> empList() {
        return empService.querAll();
    }
}

(4)创建service接口及其实现类:

public interface EmpService extends IService<Emp> {


    List<Emp> querAll();
}

/**
* @author 18310
* @description 针对表【EMP】的数据库操作Service实现
* @createDate 2024-05-20 20:05:14
*/
@Service
public class EmpServiceImpl extends ServiceImpl<EmpMapper, Emp>
    implements EmpService{
    @Autowired
    private EmpMapper empMapper;

    @Override
    public List<Emp> querAll() {
        return empMapper.selectList(null);
    }
}