Oracle 11g安装使用、备份恢复并与SpringBoot集成

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.oracle.database.nls</groupId>
            <artifactId>orai18n</artifactId>
            <version>21.7.0.0</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.2</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
Note：

<dependency>
            <groupId>com.oracle.database.nls</groupId>
            <artifactId>orai18n</artifactId>
            <version>21.7.0.0</version>
        </dependency>

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

mybatis-plus:
  configuration:
    # 开启下划线转驼峰
    map-underscore-to-camel-case: true
    # 指定默认枚举类型的类型转换器
    default-enum-type-handler: com.baomidou.mybatisplus.extension.handlers.MybatisEnumTypeHandler
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  global-config:
    banner: false
    db-config:
      # 逻辑删除（软删除）
      logic-delete-value: NOW()
      logic-not-delete-value: 'NULL'
  mapper-locations: classpath:mapper/*.xml
spring:
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@192.168.44.153:1521:orcl
    username: "scott"
    password: "Oracle11"

@Data
@TableName("EMP")
public class Employee {
    @TableId
    private Integer empno;
    private String ename;
    private String job;
    private Integer mgr;
    @JsonFormat(pattern = "yyyy/MM/dd")
    @DateTimeFormat(pattern = "yyyy/MM/dd")
    private Date hiredate;
    private Integer sal;
    private Integer comm;
    private Integer deptno;
}

@RestController
public class EmployeeController {
    private final EmployeeService employeeService;
    public EmployeeController(EmployeeService employeeService) {
        this.employeeService = employeeService;
    }
    @GetMapping("list")
    public List<Employee> list(){
        return employeeService.list();
    }
    @PostMapping("save")
    public boolean save(){
        Employee employee = new Employee();
        employee.setEmpno(6666);
        employee.setEname("John");
        employee.setJob("PM");
        employee.setMgr(7782);
        employee.setHiredate(new Date());
        employee.setSal(1000);
        employee.setComm(0);
        employee.setDeptno(10);
        return employeeService.save(employee);
    }
    @PutMapping("update")
    public boolean update(){
        UpdateWrapper<Employee> updateWrapper = new UpdateWrapper<>();
        return employeeService.update(updateWrapper.lambda().set(Employee::getJob, "CTO").eq(Employee::getEmpno, 6666));
    }
    @DeleteMapping("delete/{id}")
    public boolean deleteByCondition(@PathVariable Integer id){
        return employeeService.removeById(id);
    }
    @DeleteMapping("deleteByCondition")
    public boolean deleteByCondition(){
        return employeeService.remove(new QueryWrapper<Employee>().lambda().eq(Employee::getEmpno, 6666));
    }
    @PostMapping("saveTransaction")
    @Transactional
    public boolean saveWithTransaction(){
        Employee employee = new Employee();
        employee.setEmpno(7777);
        employee.setEname("Wick");
        employee.setJob("CEO");
        employee.setMgr(7782);
        employee.setHiredate(new Date());
        employee.setSal(1000);
        employee.setComm(0);
        employee.setDeptno(10);
        employeeService.save(employee);
        // Exception
        int x = 1/0;
        employee.setEmpno(8888);
        employee.setEname("Tada");
        employee.setJob("CFO");
        employee.setMgr(7782);
        employee.setHiredate(new Date());
        employee.setSal(1000);
        employee.setComm(0);
        employee.setDeptno(10);
        return employeeService.save(employee);
    }
}