springboot 整合mybatis、jpa（数据库：mysql，Oracle）

已于 2022-02-24 22:11:56 修改
阅读量1.4k 收藏 5
点赞数 1
文章标签： spring boot mysql 数据库
于 2022-02-24 22:09:56 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jian_aidehua/article/details/123122237
版权
本文详细介绍了如何在Spring Boot项目中整合MyBatis与MySQL、Oracle数据库，并利用Druid进行数据源管理。涵盖了从依赖引入、配置到实际操作的全过程，包括实体类、接口、Mapper映射和Service的编写。
摘要由CSDN通过智能技术生成

springBoot整合数据库环境搭建

文章目录

精简版：
1、整合 mybatis + mysql

  1. 导入相关依赖（mybatis ，mysql驱动，pageHelper分页插件）

    			<!-- 重点：       mybatis-spring spring 整合mybatis的包 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
			<!-- 重点：   分页插件-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.13</version>
        </dependency>
			<!--重点    mysql 驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

  2. 配置yml 文件

    spring:
  datasource: #配置数据库信息
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/yf03203?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&&useSSL=false
    username: TR
    password: adminxhb

# mybatis 配置，1.自动扫描mapper 下所有的xml文件；2.取别名
mybatis: 
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.trkj.boot_mybatis.entity

# pageHelper分页插件 配置
pagehelper: 
  helperDialect: mysql
  reasonable: true
  supportMethodsArguments: true
  params: count=countS

# 服务端口及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_jpa_oracle

  3. 写实体类

  4. 写接口 与 mapper映射文件

    @Mapper   // 重电
public interface DeptDao{
    // 查询所有
    List<Dept> findAllByLimit();
}

  5. 写service 分页

     // 查询所有并分页
    public List<Dept> findAll(int page,int size){
        PageHelper.startPage(page,size);  // 分页插件 PageHelper
        return deptDao.findAllByLimit();
    }

  6. 写controller

2、整合 mybatis + oracle

  1. 导入相关依赖（mybatis ，mysql驱动，pageHelper分页插件）

    		<!--        重点4个：-->
				<dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.8</version>
        </dependency>
        <dependency>
            <groupId>cn.easyproject</groupId>
            <artifactId>orai18n</artifactId>
            <version>12.1.0.2.0</version>
        </dependency>
        <dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
            <scope>runtime</scope>
        </dependency>
 				<dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>

  2. 配置yml 文件

    spring:
  datasource: #oracle数据源配置
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@127.0.0.1:1521:orcl
    username: scott
    password: tiger

# mybatis 配置
mybatis:
  type-aliases-package: com.trkj.boot_mybatis_oracle.entity
  mapper-locations: classpath:mapper/*.xml

# pageHelper分页插件 配置
pagehelper:
  helperDialect: oracle
  reasonable: true
  supportMethodsArguments: true
  params: count=countS

# 服务端口及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_jpa_oracle

  3. 写实体类

  4. 写接口 与 mapper映射文件

    @Mapper   // 重电
public interface DeptDao{
    // 查询所有
    List<Dept> findAllByLimit();
}

  5. 写service 分页

     // 查询所有并分页
    public List<Dept> findAll(int page,int size){
        PageHelper.startPage(page,size);  // 分页插件 PageHelper
        return deptDao.findAllByLimit();
    }

  6. 写controller

3、整合 jpa+ mysql

  1. 导入mysql 依赖

    <!--        重点2个：spring-jpa的包， mysql驱动-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

  2. yml配置文件

    spring:
  #jpa 配置
  jpa:
    database: MYSQL
    database-platform: org.hibernate.dialect.MySQL8Dialect
    show-sql: true
    format-sql: true
    hibernate:
      ddl-auto: none

  #配置数据源信息
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/yf03203?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&&useSSL=false
    username: TR
    password: adminxhb

# 服务端口及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_jpa_oracle

    实体类 根据 persistence生成

    3编写接口 DeptDao.java

    public interface DeptDao extends CrudRepository<DeptEntity,Integer> {
    List<DeptEntity> findAll(Pageable pageable);  //Pageable 传入分页对象
}

    4编写service DeptService.java

        // 查询所有并分页
    public List<DeptEntity> findAll(int page,int size){
        Pageable pageable = PageRequest.of(page,size);  // pageable 分页
        return deptDao.findAll(pageable);
    }
4、整合 jpa+ oracle

  1. 导入mysql 依赖

    <!-- 重点3个：Oracle 驱动，jpa -->			
				<dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
            <scope>runtime</scope>
        </dependency> 				
				<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
 				<dependency>
            <groupId>cn.easyproject</groupId>
            <artifactId>orai18n</artifactId>
            <version>12.1.0.2.0</version>
        </dependency>

  2. yml配置文件

    spring:
  # 配置数据源
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@127.0.0.1:1521:orcl
    username: scott
    password: tiger

  #jpa 配置
  jpa:
    database: oracle
    database-platform: org.hibernate.dialect.OracleDialect
    show-sql: true
    format-sql: true
    hibernate:
      ddl-auto: none

# 服务端口及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_jpa_oracle
5、整合 mybatis + mysql + Druid

同上 mybatis + mysql

不同：修改yaml配置文件

spring:
  #数据库配置
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/mybatis?useUnicode=true&characterEncoding=UTF-8&allowPublicKeyRetrieval=true&useSSL=false&serverTimezone=GMT%2B8
    username: TR
    password: adminxhb
    driver-class-name: com.mysql.cj.jdbc.Driver
    # 使用druid数据源 --------------------- 这一句 ---------------------------------
    type: com.alibaba.druid.pool.DruidDataSource
#    druid:   #这里可以写Druid相关的配置信息，但是写在这里太冗余了，就改成java配置类的形式配置数据源了。
#      ...

# mybatis 配置
mybatis:
  type-aliases-package: com.trkj.bootmybatis.pojo
  mapper-locations: classpath:mapper/*.xml
  
# 服务端口及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_jpa_oracle

Druid 数据源配置类

package com.trkj.boot_mybatis_mysql_druid.config;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;
import java.sql.SQLException;

/**
 * @Author: 大熊
 * @Description  数据源配置类
 */
@Configuration
public class DruidConfig {

    /**
     * autowired datasource config
     */
    @Autowired
    private DataSourceProperties dataSourceProperties;

    /**
     * 初始化 durid datasource
     *
     * @Return: druidDataSource  datasource instance
     */
    @Bean
    public DruidDataSource druidDataSource(){
        //https://github.com/alibaba/druid/wiki/DruidDataSource%E9%85%8D%E7%BD%AE%E5%B1%9E%E6%80%A7%E5%88%97%E8%A1%A8
        DruidDataSource druidDataSource = new DruidDataSource();
        druidDataSource.setUrl(dataSourceProperties.getUrl());
        druidDataSource.setUsername(dataSourceProperties.getUsername());
        druidDataSource.setPassword(dataSourceProperties.getPassword());
        druidDataSource.setDriverClassName(dataSourceProperties.getDriverClassName());
        druidDataSource.setInitialSize(0);
        druidDataSource.setMaxActive(180);
        druidDataSource.setMaxWait(60000);
        druidDataSource.setMinIdle(0);
        druidDataSource.setValidationQuery("Select 1 from DUAL");
        druidDataSource.setTestOnBorrow(false);
        druidDataSource.setTestOnReturn(false);
        druidDataSource.setTestWhileIdle(true);
        druidDataSource.setTimeBetweenEvictionRunsMillis(60000);
        druidDataSource.setMinEvictableIdleTimeMillis(180000);
        druidDataSource.setRemoveAbandoned(true);
        druidDataSource.setRemoveAbandonedTimeout(1800);
        druidDataSource.setLogAbandoned(true);
        try {
            druidDataSource.setFilters("stat,wall,stat,log4j2");
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return druidDataSource;
    }

    /**
     * 配置监控服务器
     * @return 返回监控注册的servlet对象
     * @author SimpleWu
     */
    @Bean
    public ServletRegistrationBean statViewServlet() {
        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
        // 添加IP白名单
        servletRegistrationBean.addInitParameter("allow", "127.0.0.1");
        // 添加IP黑名单，当白名单和黑名单重复时，黑名单优先级更高
        //servletRegistrationBean.addInitParameter("deny", "127.0.0.1");
        // 添加控制台管理用户
        servletRegistrationBean.addInitParameter("loginUsername", "root");
        servletRegistrationBean.addInitParameter("loginPassword", "root2020");
        // 是否能够重置数据
        servletRegistrationBean.addInitParameter("resetEnable", "false");
        return servletRegistrationBean;
    }

    /**
     * 配置Druid服务过滤器
     * @return 返回过滤器配置对象
     */
    @Bean
    public FilterRegistrationBean statFilter() {
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
        // 添加过滤规则
        filterRegistrationBean.addUrlPatterns("/*");
        // 忽略过滤格式
        filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*,");
        return filterRegistrationBean;
    }
}
6、整合 mybatis + oracle+ Druid

yml 配置

# 服务端口 及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_mybatis_oracle_druid

spring:
  #数据库配置
  datasource:
    url: jdbc:oracle:thin:@127.0.0.1:1521:orcl
    username: scott
    password: tiger
    driver-class-name: oracle.jdbc.driver.OracleDriver
    # 使用druid数据源
    type: com.alibaba.druid.pool.DruidDataSource
#   druid:   #这里可以写Druid相关的配置信息，但是写在这里太冗余了，就改成java配置类的形式配置数据源了。
#      ...

# mybatis 配置
mybatis:
  type-aliases-package: com.trkj.bootmybatis.pojo
  mapper-locations: classpath:mapper/*.xml

数据源配置文件同 精简版mybatis+mysql+Druid

7、整合 jpa + mysql + Druid

yaml配置

spring:
  #jpa 配置
  jpa:
    database: MYSQL
    database-platform: org.hibernate.dialect.MySQL8Dialect
    show-sql: true
    format-sql: true
    hibernate:
      ddl-auto: none

  #配置数据库信息
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/yf03203?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&&useSSL=false
    username: TR
    password: adminxhb
     # 使用druid数据源
    type: com.alibaba.druid.pool.DruidDataSource
#    druid:   #这里可以写Druid相关的配置信息，但是写在这里太冗余了，就改成java配置类的形式配置数据源了。
#      ...


# 服务端口及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_jpa_mysql

数据源配置文件同 精简版mybatis+mysql+Druid

8、整合 jpa + oracle + Druid

yml配置文件

spring:
  # 配置数据源
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@127.0.0.1:1521:orcl
    username: scott
    password: tiger
       # 使用druid数据源
    type: com.alibaba.druid.pool.DruidDataSource
#    druid:   #这里可以写Druid相关的配置信息，但是写在这里太冗余了，就改成java配置类的形式配置数据源了。
#      ...


  #jpa 配置
  jpa:
    database: oracle
    database-platform: org.hibernate.dialect.OracleDialect
    show-sql: true
    format-sql: true
    hibernate:
      ddl-auto: none

# 服务端口及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_jpa_oracle

数据源配置文件同 精简版mybatis+mysql+Druid

傻瓜版：
1、整合 mybatis + mysql

  1. 导入 mybatis 、mysql 、pagehelper的依赖

     <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
			<!-- 重点：       mybatis-spring spring 整合mybatis的包 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
			<!-- 重点：   分页插件-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.13</version>
        </dependency>
			<!--重点    mysql 驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
				
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-configuration-processor</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

  2. 配置yml 文件

    spring:
  datasource: #配置数据源信息
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/yf03203?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&&useSSL=false
    username: TR
    password: adminxhb

# 服务端口及 项目路径
server: 
  port: 8899
  servlet:
    context-path: /boot_mybatis
    
# mybatis 配置，1.自动扫描mapper 下所有的xml文件；2.取别名
mybatis: 
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.trkj.boot_mybatis.entity

# pageHelper分页插件 配置
pagehelper: 
  helperDialect: mysql
  reasonable: true
  supportMethodsArguments: true
  params: count=countS

    tips：classpath：代表的是resource 目录 :resource/mapper/*.xml

  3. 编写实体类 Dept.java

    @Data
@ToString
public class Dept {
    private int deptno;
    private String dname;
    private String loc;
}

  4. 编写接口 与 mapper 映射文件

    编写接口：DeptDao.java

    @Mapper   // 重点
public interface DeptDao{
    // 根据id查询
    Dept findDeptById(int deptno);

    // 查询所有并分页
    List<Dept> findAllByLimit();
}

    编写mapper映射文件

    <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.trkj.boot_mybatis.dao.DeptDao">

    <select id="findDeptById" resultType="com.trkj.boot_mybatis.entity.Dept">
        select * from dept where deptno = #{deptno}
    </select>
    <select id="findAllByLimit" resultType="com.trkj.boot_mybatis.entity.Dept">
        select * from dept
    </select>
</mapper>

  5. 编写service ：DeptService.java

    package com.trkj.boot_mybatis.service;

import com.github.pagehelper.PageHelper;
import com.trkj.boot_mybatis.dao.DeptDao;
import com.trkj.boot_mybatis.entity.Dept;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;

@Service
public class DeptService {
    @Autowired
    private DeptDao deptDao;
    // 根据id查询
    public Dept findDeptById(int deptno){
        return deptDao.findDeptById(deptno);
    }
    // 查询所有并分页
    public List<Dept> findAll(int page,int size){
        PageHelper.startPage(page,size);  // 分页插件 PageHelper
        return deptDao.findAllByLimit();
    }
}

  6. 编写controller DeptController.java

    package com.trkj.boot_mybatis.controller;

import com.github.pagehelper.PageHelper;
import com.trkj.boot_mybatis.entity.Dept;
import com.trkj.boot_mybatis.service.DeptService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;

@RestController
public class DeptController {
    @Autowired
    private DeptService deptService;
    @RequestMapping("findDept/{deptno}")
    public Dept findDept(@PathVariable("deptno") int deptno){
        Dept dept = deptService.findDeptById(deptno);
        return dept;
    }
    @RequestMapping("findDepts/{page}/{size}")
    public List<Dept> findDepts(@PathVariable("page") int page,@PathVariable("size")int size){
        List<Dept> list = deptService.findAll(page,size);
        return list;
    }
}
2、整合 mybatis + oracle

  1. 导入Oracle依赖

      <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
<!--        重点3个：-->
				<dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.8</version>
        </dependency>
        <dependency>
            <groupId>cn.easyproject</groupId>
            <artifactId>orai18n</artifactId>
            <version>12.1.0.2.0</version>
        </dependency>
        <dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-configuration-processor</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

  2. yml配置文件

    spring:
  datasource: #oracle数据源配置
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@127.0.0.1:1521:orcl
    username: scott
    password: tiger

# mybatis 配置
mybatis:
  type-aliases-package: com.trkj.boot_mybatis_oracle.entity
  mapper-locations: classpath:mapper/*.xml

# 服务器配置
server:
  port: 8899
  servlet:
    context-path: /boot_mybatis_oracle

# pageHelper分页插件 配置
pagehelper:
  helperDialect: oracle
  reasonable: true
  supportMethodsArguments: true
  params: count=countS

  3. 编写实体类 Dept.java

    @Data
@ToString
public class Dept {
    private int deptno;
    private String dname;
    private String loc;
}

  4. 编写接口 与 mapper映射文件

    编写接口：

    import org.apache.ibatis.annotations.Mapper;	
@Mapper 
public interface DeptDao {
    // 根据id 查询
    Dept findDeptById(int deptno);

    //查询所有
    List<Dept> findAll();
}

    编写mapper映射

    <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.trkj.boot_mybatis_oracle.dao.DeptDao">
  
    <select id="findDeptById" resultType="com.trkj.boot_mybatis_oracle.entity.Dept">
        select * from DEPT where DEPTNO = #{deptno}
    </select>
    <select id="findAll" resultType="com.trkj.boot_mybatis_oracle.entity.Dept">
        select * from DEPT
    </select>
</mapper>

  5. 编写service DeptService.java

    @Service
public class DeptService {
    @Autowired
    private DeptDao deptDao;

    public Dept findDeptById(int deptno){
        return deptDao.findDeptById(deptno);
    }

    public List<Dept> findAll(int page,int size){
        PageHelper.startPage(page,size);  // 分页插件 PageHelper
        return deptDao.findAll();
    }
}

  6. 编写controller DeptController.java

    @RestController
public class DeptController {
    @Autowired
    private DeptService deptService;
    @RequestMapping("findDept/{deptno}")
    public Dept findDept(@PathVariable("deptno") int deptno){
        Dept dept = deptService.findDeptById(deptno);
        return dept;
    }
    @RequestMapping("findDepts/{page}/{size}")
    public List<Dept> findDepts(@PathVariable("page") int page,@PathVariable("size")int size){
        List<Dept> list = deptService.findAll(page,size);
        return list;
    }
}

    // todo : 分页效果没出来

3、整合 jpa+ mysql

  1. 导入mysql 依赖

    <!--        重点2个：spring-jap的包， mysql驱动-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>   

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-configuration-processor</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

  2. yml配置文件

    spring:
  #jpa 配置
  jpa:
    database: MYSQL
    database-platform: org.hibernate.dialect.MySQL8Dialect
    show-sql: true
    format-sql: true
    hibernate:
      ddl-auto: none

  #配置数据源信息
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/yf03203?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&&useSSL=false
    username: TR
    password: adminxhb

# 服务端口及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_jpa_mysql

  3. 编写实体类 DeptEntity.java persistence自动生成的

    @Entity
@Table(name = "dept", schema = "yf03203", catalog = "")
public class DeptEntity {
    private Integer deptno;
    private String dname;
    private String loc;

    @Id
    @Column(name = "deptno")
    public Integer getDeptno() {
        return deptno;
    }

    public void setDeptno(Integer deptno) {
        this.deptno = deptno;
    }

    @Basic
    @Column(name = "dname")
    public String getDname() {
        return dname;
    }

    public void setDname(String dname) {
        this.dname = dname;
    }

    @Basic
    @Column(name = "loc")
    public String getLoc() {
        return loc;
    }

    public void setLoc(String loc) {
        this.loc = loc;
    }
}

  4. 编写接口 DeptDao.java

    import org.springframework.data.domain.Pageable;
import org.springframework.data.repository.CrudRepository;

public interface DeptDao extends CrudRepository<DeptEntity,Integer> {
    List<DeptEntity> findAll(Pageable pageable);  //Pageable 传入分页对象
}

  5. 编写service DeptService.java

    @Service
public class DeptService {
    @Autowired
    private DeptDao deptDao;
    // 根据id查询
    public DeptEntity findDeptById(int deptno){
        return deptDao.findById(deptno).orElse(null);
    }

    // 查询所有并分页
    public List<DeptEntity> findAll(int page,int size){
        Pageable pageable = PageRequest.of(page,size);  // pageable 分页
        return deptDao.findAll(pageable);
    }
}

  6. 编写controller DeptController.java

    @RestController
public class DeptController {
    @Autowired
    private DeptService deptService;
    @RequestMapping("findDept/{deptno}")
    public DeptEntity findDept(@PathVariable("deptno") int deptno){
        DeptEntity dept = deptService.findDeptById(deptno);
        return dept;
    }
    @RequestMapping("findDepts/{page}/{size}")
    public List<DeptEntity> findDepts(@PathVariable("page") int page,@PathVariable("size")int size){
        List<DeptEntity> list = deptService.findAll(page,size);
        return list;
    }
}
4、整合 jpa+ oracle

  1. 导入mysql 依赖

    <!-- 重点3个：Oracle 驱动，jpa -->			
				<dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
            <scope>runtime</scope>
        </dependency> 				
				<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
 				<dependency>
            <groupId>cn.easyproject</groupId>
            <artifactId>orai18n</artifactId>
            <version>12.1.0.2.0</version>
        </dependency>
<!-- ---- end------ -->

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-configuration-processor</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

  2. yml配置文件

    spring:
  # 配置数据源
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@127.0.0.1:1521:orcl
    username: scott
    password: tiger

  #jpa 配置
  jpa:
    database: oracle
    database-platform: org.hibernate.dialect.OracleDialect
    show-sql: true
    format-sql: true
    hibernate:
      ddl-auto: none

# 服务端口及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_jpa_oracle

  3. 编写实体类 DeptEntity.java persistence自动生成的

    @Entity
@Table(name = "DEPT", schema = "SCOTT", catalog = "")
public class DeptEntity {
    private long deptno;
    private String dname;
    private String loc;

    @Id
    @Column(name = "DEPTNO")
    public long getDeptno() {
        return deptno;
    }

    public void setDeptno(long deptno) {
        this.deptno = deptno;
    }

    @Basic
    @Column(name = "DNAME")
    public String getDname() {
        return dname;
    }

    public void setDname(String dname) {
        this.dname = dname;
    }

    @Basic
    @Column(name = "LOC")
    public String getLoc() {
        return loc;
    }

    public void setLoc(String loc) {
        this.loc = loc;
    }
}

  4. 编写接口 DeptDao.java

    import org.springframework.data.domain.Pageable;
import org.springframework.data.repository.CrudRepository;

public interface DeptDao extends CrudRepository<DeptEntity,Long> {
    List<DeptEntity> findAll(Pageable pageable);  //Pageable 传入分页对象
}

  5. 编写service DeptService.java

    @Service
public class DeptService {
    @Autowired
    private DeptDao deptDao;
    // 根据id查询
    public DeptEntity findDeptById(long deptno){
        return deptDao.findById(deptno).orElse(null);
    }

    // 查询所有并分页
    public List<DeptEntity> findAll(int page,int size){
        Pageable pageable = PageRequest.of(page,size);  // pageable 分页
        return deptDao.findAll(pageable);
    }
}

  6. 编写controller DeptController.java

    @RestController
public class DeptController {
    @Autowired
    private DeptService deptService;
    @RequestMapping("findDept/{deptno}")
    public DeptEntity findDept(@PathVariable("deptno") int deptno){
        DeptEntity dept = deptService.findDeptById(deptno);
        return dept;
    }
    @RequestMapping("findDepts/{page}/{size}")
    public List<DeptEntity> findDepts(@PathVariable("page") int page,@PathVariable("size")int size){
        List<DeptEntity> list = deptService.findAll(page,size);
        return list;
    }
}
5、整合 mybatis + mysql + Druid

  1. 导入依赖 mybatis-spring，Druid数据源，mysql驱动 ,pageHelper分页插件

    <!--        重要四个：mybatis-spring的包，Druid数据源，mysql驱动,pageHelper分页插件-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.21</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.8</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-configuration-processor</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

  2. yml配置文件

    spring:
  #数据库配置
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/mybatis?useUnicode=true&characterEncoding=UTF-8&allowPublicKeyRetrieval=true&useSSL=false&serverTimezone=GMT%2B8
    username: TR
    password: adminxhb
    driver-class-name: com.mysql.cj.jdbc.Driver
    # 使用druid数据源
    type: com.alibaba.druid.pool.DruidDataSource
#    druid:   #这里可以写Druid相关的配置信息，但是写在这里太冗余了，就改成java配置类的形式配置数据源了。
#      ...

# mybatis 配置
mybatis:
  type-aliases-package: com.trkj.bootmybatis.pojo
  mapper-locations: classpath:mapper/*.xml

  3. 编写 Druid 数据源配置类

    package com.trkj.boot_mybatis_mysql_druid.config;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;
import java.sql.SQLException;

/**
 * @Author: 大熊
 * @Description  数据源配置类
 */
@Configuration
public class DruidConfig {

    /**
     * autowired datasource config
     */
    @Autowired
    private DataSourceProperties dataSourceProperties;

    /**
     * 初始化 durid datasource
     *
     * @Return: druidDataSource  datasource instance
     */
    @Bean
    public DruidDataSource druidDataSource(){
        //https://github.com/alibaba/druid/wiki/DruidDataSource%E9%85%8D%E7%BD%AE%E5%B1%9E%E6%80%A7%E5%88%97%E8%A1%A8
        DruidDataSource druidDataSource = new DruidDataSource();
        druidDataSource.setUrl(dataSourceProperties.getUrl());
        druidDataSource.setUsername(dataSourceProperties.getUsername());
        druidDataSource.setPassword(dataSourceProperties.getPassword());
        druidDataSource.setDriverClassName(dataSourceProperties.getDriverClassName());
        druidDataSource.setInitialSize(0);
        druidDataSource.setMaxActive(180);
        druidDataSource.setMaxWait(60000);
        druidDataSource.setMinIdle(0);
        druidDataSource.setValidationQuery("Select 1 from DUAL");
        druidDataSource.setTestOnBorrow(false);
        druidDataSource.setTestOnReturn(false);
        druidDataSource.setTestWhileIdle(true);
        druidDataSource.setTimeBetweenEvictionRunsMillis(60000);
        druidDataSource.setMinEvictableIdleTimeMillis(180000);
        druidDataSource.setRemoveAbandoned(true);
        druidDataSource.setRemoveAbandonedTimeout(1800);
        druidDataSource.setLogAbandoned(true);
        try {
            druidDataSource.setFilters("stat,wall,stat,log4j2");
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return druidDataSource;
    }

    /**
     * 配置监控服务器
     * @return 返回监控注册的servlet对象
     * @author SimpleWu
     */
    @Bean
    public ServletRegistrationBean statViewServlet() {
        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
        // 添加IP白名单
        servletRegistrationBean.addInitParameter("allow", "127.0.0.1");
        // 添加IP黑名单，当白名单和黑名单重复时，黑名单优先级更高
        //servletRegistrationBean.addInitParameter("deny", "127.0.0.1");
        // 添加控制台管理用户
        servletRegistrationBean.addInitParameter("loginUsername", "root");
        servletRegistrationBean.addInitParameter("loginPassword", "root2020");
        // 是否能够重置数据
        servletRegistrationBean.addInitParameter("resetEnable", "false");
        return servletRegistrationBean;
    }

    /**
     * 配置Druid服务过滤器
     * @return 返回过滤器配置对象
     */
    @Bean
    public FilterRegistrationBean statFilter() {
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
        // 添加过滤规则
        filterRegistrationBean.addUrlPatterns("/*");
        // 忽略过滤格式
        filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*,");
        return filterRegistrationBean;
    }
}

  4. 编写实体类 DeptEntity.java persistence自动生成的

    @Data
@ToString
public class Dept {
    private int deptno;
    private String dname;
    private String loc;
}

  5. 编写接口 与 mapper 映射文件

    接口：DeptDao.java

    @Mapper   // 重点
public interface DeptDao{ 
    Dept findDeptById(int deptno); // 根据id查询
    List<Dept> findAllByLimit();   // 查询所有并分页
}

    编写mapper：DeptMapper.xml

    <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.trkj.boot_mybatis_mysql_druid.dao.DeptDao">

    <select id="findDeptById" resultType="com.trkj.boot_mybatis_mysql_druid.entity.Dept">
        select * from dept where deptno = #{deptno}
    </select>
    <select id="findAllByLimit" resultType="com.trkj.boot_mybatis_mysql_druid.entity.Dept">
        select * from dept
    </select>
</mapper>

  6. 编写service DeptService.java

    @Service
public class DeptService {
    @Autowired
    private DeptDao deptDao;
    // 根据id查询
    public Dept findDeptById(int deptno){
        return deptDao.findDeptById(deptno);
    }
    // 查询所有并分页
    public List<Dept> findAll(int page,int size){
        PageHelper.startPage(page,size);  // 分页插件 PageHelper
        return deptDao.findAllByLimit();
    }
}

  7. 编写controller DeptController.java

    @RestController
public class DeptController {
    @Autowired
    private DeptService deptService;
    @RequestMapping("findDept/{deptno}")
    public Dept findDept(@PathVariable("deptno") int deptno){
        Dept dept = deptService.findDeptById(deptno);
        return dept;
    }
    @RequestMapping("findDepts/{page}/{size}")
    public List<Dept> findDepts(@PathVariable("page") int page,@PathVariable("size")int size){
        List<Dept> list = deptService.findAll(page,size);
        return list;
    }
}
6、整合 mybatis + oracle+ Druid

  1. 导入依赖 mybatis-spring，Druid数据源，mysql驱动 ,pageHelper分页插件

    <!--        重要5个 ：mybatis-spring  oracle两个  Druid  分页插件-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
        <dependency>
            <groupId>cn.easyproject</groupId>
            <artifactId>orai18n</artifactId>
            <version>12.1.0.2.0</version>
        </dependency>
        <dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.21</version>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.8</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>


        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-configuration-processor</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

  2. yml配置文件

    # 服务端口 及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_mybatis_oracle_druid

spring:
  #数据库配置
  datasource:
    url: jdbc:oracle:thin:@127.0.0.1:1521:orcl
    username: scott
    password: tiger
    driver-class-name: oracle.jdbc.driver.OracleDriver
    # 使用druid数据源
    type: com.alibaba.druid.pool.DruidDataSource
#   druid:   #这里可以写Druid相关的配置信息，但是写在这里太冗余了，就改成java配置类的形式配置数据源了。
#      ...

# mybatis 配置
mybatis:
  type-aliases-package: com.trkj.bootmybatis.pojo
  mapper-locations: classpath:mapper/*.xml

#分页插件配置

  3. 编写 Druid 数据源配置类

    package com.trkj.boot_mybatis_mysql_druid.config;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;
import java.sql.SQLException;

/**
 * @Author: 大熊
 * @Description  数据源配置类
 */
@Configuration
public class DruidConfig {

    /**
     * autowired datasource config
     */
    @Autowired
    private DataSourceProperties dataSourceProperties;

    /**
     * 初始化 durid datasource
     *
     * @Return: druidDataSource  datasource instance
     */
    @Bean
    public DruidDataSource druidDataSource(){
        //https://github.com/alibaba/druid/wiki/DruidDataSource%E9%85%8D%E7%BD%AE%E5%B1%9E%E6%80%A7%E5%88%97%E8%A1%A8
        DruidDataSource druidDataSource = new DruidDataSource();
        druidDataSource.setUrl(dataSourceProperties.getUrl());
        druidDataSource.setUsername(dataSourceProperties.getUsername());
        druidDataSource.setPassword(dataSourceProperties.getPassword());
        druidDataSource.setDriverClassName(dataSourceProperties.getDriverClassName());
        druidDataSource.setInitialSize(0);
        druidDataSource.setMaxActive(180);
        druidDataSource.setMaxWait(60000);
        druidDataSource.setMinIdle(0);
        druidDataSource.setValidationQuery("Select 1 from DUAL");
        druidDataSource.setTestOnBorrow(false);
        druidDataSource.setTestOnReturn(false);
        druidDataSource.setTestWhileIdle(true);
        druidDataSource.setTimeBetweenEvictionRunsMillis(60000);
        druidDataSource.setMinEvictableIdleTimeMillis(180000);
        druidDataSource.setRemoveAbandoned(true);
        druidDataSource.setRemoveAbandonedTimeout(1800);
        druidDataSource.setLogAbandoned(true);
        try {
            druidDataSource.setFilters("stat,wall,stat,log4j2");
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return druidDataSource;
    }

    /**
     * 配置监控服务器
     * @return 返回监控注册的servlet对象
     * @author SimpleWu
     */
    @Bean
    public ServletRegistrationBean statViewServlet() {
        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
        // 添加IP白名单
        servletRegistrationBean.addInitParameter("allow", "127.0.0.1");
        // 添加IP黑名单，当白名单和黑名单重复时，黑名单优先级更高
        //servletRegistrationBean.addInitParameter("deny", "127.0.0.1");
        // 添加控制台管理用户
        servletRegistrationBean.addInitParameter("loginUsername", "root");
        servletRegistrationBean.addInitParameter("loginPassword", "root2020");
        // 是否能够重置数据
        servletRegistrationBean.addInitParameter("resetEnable", "false");
        return servletRegistrationBean;
    }

    /**
     * 配置Druid服务过滤器
     * @return 返回过滤器配置对象
     */
    @Bean
    public FilterRegistrationBean statFilter() {
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
        // 添加过滤规则
        filterRegistrationBean.addUrlPatterns("/*");
        // 忽略过滤格式
        filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*,");
        return filterRegistrationBean;
    }
}

  4. 编写实体类 DeptEntity.java persistence自动生成的

    @Data
@ToString
public class Dept {
    private int deptno;
    private String dname;
    private String loc;
}

  5. 编写接口 与 mapper 映射文件

    接口：DeptDao.java

    @Mapper   // 重点
public interface DeptDao{ 
    Dept findDeptById(int deptno); // 根据id查询
    List<Dept> findAllByLimit();   // 查询所有并分页
}

    编写mapper：DeptMapper.xml

    <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.trkj.boot_mybatis_oracle_druid.dao.DeptDao">

    <select id="findDeptById" resultType="com.trkj.boot_mybatis_oracle_druid.entity.Dept">
        select * from dept where deptno = #{deptno}
    </select>
    <select id="findAllByLimit" resultType="com.trkj.boot_mybatis_oracle_druid.entity.Dept">
        select * from dept
    </select>
</mapper>

  6. 编写service DeptService.java

    @Service
public class DeptService {
    @Autowired
    private DeptDao deptDao;
    // 根据id查询
    public Dept findDeptById(int deptno){
        return deptDao.findDeptById(deptno);
    }
    // 查询所有并分页
    public List<Dept> findAll(int page,int size){
        PageHelper.startPage(page,size);  // 分页插件 PageHelper
        return deptDao.findAllByLimit();
    }
}

  7. 编写controller DeptController.java

    @RestController
public class DeptController {
    @Autowired
    private DeptService deptService;
    @RequestMapping("findDept/{deptno}")
    public Dept findDept(@PathVariable("deptno") int deptno){
        Dept dept = deptService.findDeptById(deptno);
        return dept;
    }
    @RequestMapping("findDepts/{page}/{size}")
    public List<Dept> findDepts(@PathVariable("page") int page,@PathVariable("size")int size){
        List<Dept> list = deptService.findAll(page,size);
        return list;
    }
}
7、整合 jpa + mysql + Druid

同 jpa + mysql

需要修改的：

  • yml配置

    spring:
  #jpa 配置
  jpa:
    database: MYSQL
    database-platform: org.hibernate.dialect.MySQL8Dialect
    show-sql: true
    format-sql: true
    hibernate:
      ddl-auto: none

  #配置数据库信息
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/yf03203?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&&useSSL=false
    username: TR
    password: adminxhb
     # 使用druid数据源
    type: com.alibaba.druid.pool.DruidDataSource
#    druid:   #这里可以写Druid相关的配置信息，但是写在这里太冗余了，就改成java配置类的形式配置数据源了。
#      ...


# 服务端口及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_jpa_mysql

  • DruidConfig.java (数据源配置类)

    package com.trkj.boot_mybatis_mysql_druid.config;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;
import java.sql.SQLException;

/**
 * @Author: 大熊
 * @Description  数据源配置类
 */
@Configuration
public class DruidConfig {

    /**
     * autowired datasource config
     */
    @Autowired
    private DataSourceProperties dataSourceProperties;

    /**
     * 初始化 durid datasource
     *
     * @Return: druidDataSource  datasource instance
     */
    @Bean
    public DruidDataSource druidDataSource(){
        //https://github.com/alibaba/druid/wiki/DruidDataSource%E9%85%8D%E7%BD%AE%E5%B1%9E%E6%80%A7%E5%88%97%E8%A1%A8
        DruidDataSource druidDataSource = new DruidDataSource();
        druidDataSource.setUrl(dataSourceProperties.getUrl());
        druidDataSource.setUsername(dataSourceProperties.getUsername());
        druidDataSource.setPassword(dataSourceProperties.getPassword());
        druidDataSource.setDriverClassName(dataSourceProperties.getDriverClassName());
        druidDataSource.setInitialSize(0);
        druidDataSource.setMaxActive(180);
        druidDataSource.setMaxWait(60000);
        druidDataSource.setMinIdle(0);
        druidDataSource.setValidationQuery("Select 1 from DUAL");
        druidDataSource.setTestOnBorrow(false);
        druidDataSource.setTestOnReturn(false);
        druidDataSource.setTestWhileIdle(true);
        druidDataSource.setTimeBetweenEvictionRunsMillis(60000);
        druidDataSource.setMinEvictableIdleTimeMillis(180000);
        druidDataSource.setRemoveAbandoned(true);
        druidDataSource.setRemoveAbandonedTimeout(1800);
        druidDataSource.setLogAbandoned(true);
        try {
            druidDataSource.setFilters("stat,wall,stat,log4j2");
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return druidDataSource;
    }

    /**
     * 配置监控服务器
     * @return 返回监控注册的servlet对象
     * @author SimpleWu
     */
    @Bean
    public ServletRegistrationBean statViewServlet() {
        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
        // 添加IP白名单
        servletRegistrationBean.addInitParameter("allow", "127.0.0.1");
        // 添加IP黑名单，当白名单和黑名单重复时，黑名单优先级更高
        //servletRegistrationBean.addInitParameter("deny", "127.0.0.1");
        // 添加控制台管理用户
        servletRegistrationBean.addInitParameter("loginUsername", "root");
        servletRegistrationBean.addInitParameter("loginPassword", "root2020");
        // 是否能够重置数据
        servletRegistrationBean.addInitParameter("resetEnable", "false");
        return servletRegistrationBean;
    }

    /**
     * 配置Druid服务过滤器
     * @return 返回过滤器配置对象
     */
    @Bean
    public FilterRegistrationBean statFilter() {
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
        // 添加过滤规则
        filterRegistrationBean.addUrlPatterns("/*");
        // 忽略过滤格式
        filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*,");
        return filterRegistrationBean;
    }
}
8、整合 jpa + oracle + Druid

yml 配置

spring:
  # 配置数据源
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@127.0.0.1:1521:orcl
    username: scott
    password: tiger
       # 使用druid数据源
    type: com.alibaba.druid.pool.DruidDataSource
#    druid:   #这里可以写Druid相关的配置信息，但是写在这里太冗余了，就改成java配置类的形式配置数据源了。
#      ...


  #jpa 配置
  jpa:
    database: oracle
    database-platform: org.hibernate.dialect.OracleDialect
    show-sql: true
    format-sql: true
    hibernate:
      ddl-auto: none

# 服务端口及 项目路径
server:
  port: 8899
  servlet:
    context-path: /boot_jpa_oracle

DruidConfig.java (数据源配置类)

package com.trkj.boot_mybatis_mysql_druid.config;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;
import java.sql.SQLException;

/**
 * @Author: 大熊
 * @Description  数据源配置类
 */
@Configuration
public class DruidConfig {

    /**
     * autowired datasource config
     */
    @Autowired
    private DataSourceProperties dataSourceProperties;

    /**
     * 初始化 durid datasource
     *
     * @Return: druidDataSource  datasource instance
     */
    @Bean
    public DruidDataSource druidDataSource(){
        //https://github.com/alibaba/druid/wiki/DruidDataSource%E9%85%8D%E7%BD%AE%E5%B1%9E%E6%80%A7%E5%88%97%E8%A1%A8
        DruidDataSource druidDataSource = new DruidDataSource();
        druidDataSource.setUrl(dataSourceProperties.getUrl());
        druidDataSource.setUsername(dataSourceProperties.getUsername());
        druidDataSource.setPassword(dataSourceProperties.getPassword());
        druidDataSource.setDriverClassName(dataSourceProperties.getDriverClassName());
        druidDataSource.setInitialSize(0);
        druidDataSource.setMaxActive(180);
        druidDataSource.setMaxWait(60000);
        druidDataSource.setMinIdle(0);
        druidDataSource.setValidationQuery("Select 1 from DUAL");
        druidDataSource.setTestOnBorrow(false);
        druidDataSource.setTestOnReturn(false);
        druidDataSource.setTestWhileIdle(true);
        druidDataSource.setTimeBetweenEvictionRunsMillis(60000);
        druidDataSource.setMinEvictableIdleTimeMillis(180000);
        druidDataSource.setRemoveAbandoned(true);
        druidDataSource.setRemoveAbandonedTimeout(1800);
        druidDataSource.setLogAbandoned(true);
        try {
            druidDataSource.setFilters("stat,wall,stat,log4j2");
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return druidDataSource;
    }

    /**
     * 配置监控服务器
     * @return 返回监控注册的servlet对象
     * @author SimpleWu
     */
    @Bean
    public ServletRegistrationBean statViewServlet() {
        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
        // 添加IP白名单
        servletRegistrationBean.addInitParameter("allow", "127.0.0.1");
        // 添加IP黑名单，当白名单和黑名单重复时，黑名单优先级更高
        //servletRegistrationBean.addInitParameter("deny", "127.0.0.1");
        // 添加控制台管理用户
        servletRegistrationBean.addInitParameter("loginUsername", "root");
        servletRegistrationBean.addInitParameter("loginPassword", "root2020");
        // 是否能够重置数据
        servletRegistrationBean.addInitParameter("resetEnable", "false");
        return servletRegistrationBean;
    }

    /**
     * 配置Druid服务过滤器
     * @return 返回过滤器配置对象
     */
    @Bean
    public FilterRegistrationBean statFilter() {
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
        // 添加过滤规则
        filterRegistrationBean.addUrlPatterns("/*");
        // 忽略过滤格式
        filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*,");
        return filterRegistrationBean;
    }
}
jian_aidehua
关注
  • 1
    点赞
  • 踩
  • 5
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Spring完整揭秘（八）：Spring ORM 同时集成JPA与Mybatis
我的博客
08-11 842
文章目录ORMSpring ORMSpring ORM 同时集成JPA与Mybatis一、创建一个SpringBoot项目二、建立用户信息登记表三、Web应用项目集成mysql四、添加Spring Data JPA和Mybatis依赖五、添加数据表映射实体类六、创建数据接口层6.1 声明JPA接口6.2 声明MyBatis接口七、创建业务服务层八、创建控制器九、设计视图模板9.1 设计一个用户列表的视图模板9.2 设计一个提交用户信息的表单模板9.3 设计一个用户模糊查找页面模板十、运行应用10.1用户列表
玩转 Spring Boot 集成篇（MyBatis、JPA、事务支持）
一猿小讲
01-26 2485
在使用 Spring 进行实际项目研发中，Spring 整合 ORM 组件（MyBatis、JPA）是必不可少一个环节，而在整合过程中，往往要进行大量的配置。借助 SpringBoot 可...
Springboot+MyBatis+JPA集成
weixin_30666401的博客
07-03 3705
1.前言 Springboot最近可谓是非常的火，本人也在项目中尝到了甜头。之前一直使用Springboot+JPA，用了一段时间发现JPA不是太灵活，也有可能是我不精通JPA，总之为了多学学Springboot我决定尝试一下Springboot+MyBatis+JPA三项集成，集成过程中遇到了很多问题，但最后总算是集成成功了，现在记录一下方法。 1.1 如何使用M...
Spring Boot如何集成Spring Data JPA？
最新发布
学Java，找哪吒
06-27 701
2024华为OD统一考试题库清单（持续收录中）以及考点说明。
springboot同时整合JPA和mybatis的demo
08-12
这个demo同时整合了springboot+JPA+mybatis这个两个orm框架。
springBoot中整合jpa与mybatis的新思路
Chen_RuiMin的博客
02-02 5532
一、序言 我先提出我对于jpa与mybatis使用后的理解 **mybatis：**半自动化orm框架，所有sql语句均需要开发者把握，我觉得不太喜欢的就是增加类时，有需要去增加它的映射文件，好吧，你说有生成器，但还是难免需要修改实体类，如增加一个属性，那我是不是需要去xml，好好的把属性加上去。就是mybatis的这一点觉得有点小烦 **jpa：**全自动的orm框架，有点是sql语句不用开发者...
springboot整合mybatis
04-18
Spring Boot提供了对多种数据库的支持，如MySQL、Oracle等。以下是一个使用HikariCP连接池和JDBC数据源的示例： ```yaml spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://...
springboot+mysql+oracle+druid 双数据库进行数据同步
08-13
本项目主要探讨了如何使用SpringBoot框架结合MySQL和Oracle两个不同的数据库系统，实现数据的实时或定时同步，尤其是在数据量庞大的情况下（数十万条记录）避免内存溢出（OOM）问题。以下是对这个主题的详细阐述： ...
springboot+mybatis+mysql 项目构建源代码
01-15
1. 创建一个新的SpringBoot项目，引入Spring Web、Spring Data JPA、MyBatis以及MySQL的相关依赖。 2. 配置application.properties文件，包括数据库连接信息（如URL、用户名、密码）、MyBatis的相关配置等。 3. 创建...
SpringBoot+Mybatis项目搭建
07-15
在`pom.xml`或`build.gradle`文件中，还需要添加Mybatis和Mybatis-SpringBoot的依赖，以及数据库驱动（如MySQL、Oracle等），例如： Maven: ```xml <groupId>org.mybatis.spring.boot <artifactId>mybatis-...
springboot + mybatis+mysql+shareding-jdbc分库分表实-shareding.zip
01-29
SpringBoot、MyBatis和MySQL的组合是常见的轻量级Java Web开发框架，而Sharding-JDBC则是阿里巴巴开源的一款分布式数据库中间件，它能帮助我们将单一数据库拆分为多个数据分片，以实现数据库水平扩展。下面将详细...
Spring集成JPA和MyBatis简单例子-20170622
06-22
Spring集成JPA和MyBatis简单例子
springboot+jpa+mybatis使用双数据源整合方法总结及遇到问题解决方案
FANGHAOWEN_的博客
11-25 1260
1、整合基本思路 在项目中的data服务使用的框架是springboot+jpa+mybatis，如果项目中对于数据处理框架只使用了一种的话，整合起来就会相对容易，不会出现一系列问题。 1、如果是使用的mybatis框架，可以参考mybatis双数据源两种整合方法，这可以使用AOP方法和分包的方法进行整理 2、如果使用的是jpa框架，可以参考jpa双数据源整合方法 2、springboot+jpa+mybatis整合问题 项目中因为jpa和mybatis两种框架都使用上了，所以就出现了问题。这里首先对
Spring同时集成JPA与Mybatis
2301_78835635的博客
03-16 1554
本文章向大家介绍Spring同时集成JPA与Mybatis，主要内容包括其使用实例、应用技巧、基本知识点总结和需要注意事项，具有一定的参考价值，需要的朋友可以参考一下。
Springboot集成Mybatis、JPA
微信公众号：大数据从业者
04-27 386
一、Springboot与Mybatis集成 1、思路 一是引入mybatis-starter使springboot与mybatis集成 二是完成连接数据库 (1)pom.xml 主要是引入mybatis-spring-boot-starter <!-- mybatis新增 begin--> <dependency> <groupId>org.spr...
springboot 整合 Mybatis、JPA、Redis
程序员爱酸奶
09-22 1万+
引言 在springboot 项目中，我们是用ORM 框架来操作数据库变的非常方便。下面我们分别整合mysql ,spring data jpa 以及redis 。让我们感受下快车道。 我们首先创建一个springboot 项目，创建好之后，我们来一步步的实践。 使用mybatis 引入依赖： <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis
springboot整合jpa的应用
zmt0104的博客
02-22 178
springboot整合jpa ...
spring boot集成mybatis配置mysql+oracle双数据源
flytalei的博客
08-14 2011
spring boot集成mybatis配置mysql+oracle双数据源 最近公司项目需要用到mysql和oracle数据库，就是固定的有些接口用mysql，有些接口用oracle。参考了网上很多资源，大致确定了方向和实现步骤，最终以github上一个开源实现完成了需求。网址为：https://github.com/djkdeveloper/springboot-mybatis 下面总结一下我的实现步骤 1.application.yml 配置mysql和oracle数据源 spring: .
springboot 连接oracle，使用jpa操作数据库
热门推荐
好家伙，这么多文章
01-13 1万+
1、添加依赖 &lt;parent&gt; &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt; &lt;artifactId&gt;spring-boot-starter-parent&lt;/artifactId&gt; &lt;version&gt;2.0.1.RELEASE&lt;/version&gt; &am
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值