1.创建maven工程

2.目录结构

3.引入依赖

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>cn.gbase</groupId>
    <artifactId>mybatis-8s-demo</artifactId>
    <version>1.0-SNAPSHOT</version>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.4.RELEASE</version>
    </parent>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--驱动包先install到本地库-->
        <dependency>
            <groupId>cn.gbase.jdbc</groupId>
            <artifactId>gbase8s</artifactId>
            <version>v87</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.5</version>
        </dependency>
    </dependencies>
</project>

4.配置文件application.yml

spring:
  datasource:
    driverClassName: com.gbasedbt.jdbc.Driver    
    url: jdbc:gbasedbt-sqli://localhost:12345/test:gbasedbtserver=ol_gbasedbt1210	
    username: gbasedbt	
    password: *******

5.创建启动类

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

···

二、数据库环境

1.创建学生表

create table student (id integer(10),name varchar2(20),addr varchar2(20));

2.插入测试数据

insert into student values(1,'zs','tj');

三、整合mybatis

1.实体类

public class Student {
    private Integer id;
    private String name;
    private String addr;
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getAddr() {
        return addr;
    }
    public void setAddr(String addr) {
        this.addr = addr;
    }}

2.dao

@Mapperpublic interface StudentDao {
	@Select ( "select id, name, addr from student" )
    List<Student> findAll();}

3.service

public interface StudentService {
    List<Student> findAll();}

@Servicepublic class StudentServiceImpl implements StudentService {
    @Autowired
    private StudentDao studentDao;
    @Override
    public List<Student> findAll() {
        return studentDao.findAll();
    }}

4.controller

@RestController@RequestMapping("/student")public class StudentController {
    @Autowired
    private StudentService studentService;
    @GetMapping("/all")
    public List<Student> findAll(){
        return studentService.findAll();
    }
 }

四、结果

请求 http://localhost:8080/student/all
出现如下结果

五、注意事项

1.注意8s连接串格式
2.注意dao接口@Mapper注解不能忘记，不然注入不了容器
3.8s驱动先install到本地库，再maven依赖
4.本文是@select注解自定义sql的，也可以用xml文件

总结

mybatis整合8s数据库基本和mysql没什么区别，就是驱动和连接串不同。注意整合过程中dao会动态代理@Mapper注入容器，不能忘记添加该注解。