一区二区三区在线-一区二区三区亚洲视频-一区二区三区亚洲-一区二区三区午夜-一区二区三区四区在线视频-一区二区三区四区在线免费观看

服務器之家：專注于服務器技術及軟件下載分享
分類導航

PHP教程|ASP.NET教程|Java教程|ASP教程|編程技術|正則表達式|C/C++|IOS|C#|Swift|Android|VB|R語言|JavaScript|易語言|vb.net|

服務器之家 - 編程語言 - Java教程 - springboot整合持久層的方法實現

springboot整合持久層的方法實現

2022-01-20 11:52一只y Java教程

本文主要介紹了springboot整合持久層的方法實現，文中通過示例代碼介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們可以參考一下

1. springboot整合jdbcTemplate

1.1 pom.xml

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <parent>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-parent</artifactId>
      <version>2.5.5</version>
      <relativePath/> <!-- lookup parent from repository -->
  </parent>
  <groupId>com.yl</groupId>
  <artifactId>jdbctemplate</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <name>jdbctemplate</name>
  <description>Demo project for Spring Boot</description>
  <properties>
      <java.version>1.8</java.version>
  </properties>
  <dependencies>
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-jdbc</artifactId>
      </dependency>
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-web</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-test</artifactId>
          <scope>test</scope>
      </dependency>
  </dependencies>

  <build>
      <plugins>
          <plugin>
              <groupId>org.springframework.boot</groupId>
              <artifactId>spring-boot-maven-plugin</artifactId>
          </plugin>
      </plugins>
  </build>

</project>

1.2 application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/demo?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=root

1.3 model

package com.yl.jdbctemplate.model;

import java.io.Serializable;

public class Student implements Serializable {
  private Integer id;
  private String stuName;
  private String stuNo;
  private Integer age;
  private String stuMessage;

  @Override
  public String toString() {
      return "Student{" +
              "id=" + id +
              ", stuName='" + stuName + '\'' +
              ", stuNo='" + stuNo + '\'' +
              ", age=" + age +
              ", stuMessage='" + stuMessage + '\'' +
              '}';
  }

  public Integer getId() {
      return id;
  }

  public void setId(Integer id) {
      this.id = id;
  }

  public String getStuName() {
      return stuName;
  }

  public void setStuName(String stuName) {
      this.stuName = stuName;
  }

  public String getStuNo() {
      return stuNo;
  }

  public void setStuNo(String stuNo) {
      this.stuNo = stuNo;
  }

  public Integer getAge() {
      return age;
  }

  public void setAge(Integer age) {
      this.age = age;
  }

  public String getStuMessage() {
      return stuMessage;
  }

  public void setStuMessage(String stuMessage) {
      this.stuMessage = stuMessage;
  }
}

1.4 service

package com.yl.jdbctemplate.service;

import com.yl.jdbctemplate.model.Student;

import java.util.List;

public interface StudentService {

  int addStudent(Student student);

  int addStudent2(Student student);

  int updateStudent(Student student);

  int deleteStudentById(Integer id);

  List<Student> getAllStudent();

  List<Student> getAllStudent2();
}

1.5 serviceImpl,crud案例

package com.yl.jdbctemplate.service.impl;

import com.yl.jdbctemplate.model.Student;
import com.yl.jdbctemplate.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.stereotype.Service;

import java.sql.*;
import java.util.List;

@Service
public class StudentServiceImpl implements StudentService {
  @Autowired
  JdbcTemplate jdbcTemplate;

  @Override
  public int addStudent(Student student) {
      int result = jdbcTemplate.update("insert into student(stu_name,stu_no,age,stu_message) values(?,?,?,?) "
              ,student.getStuName(),student.getStuNo(),student.getAge(),student.getStuMessage());
      return result;
  }

  //插入數據，并且回寫id
  @Override
  public int addStudent2(Student student) {
      GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
      int result = jdbcTemplate.update(new PreparedStatementCreator() {
          @Override
          public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
              //插入數據后返回主鍵
              PreparedStatement ps = con.prepareStatement("insert into student(stu_name,stu_no,age,stu_message) values(?,?,?,?)"
                      , Statement.RETURN_GENERATED_KEYS);
              ps.setString(1,student.getStuName());
              ps.setString(2,student.getStuNo());
              ps.setInt(3,student.getAge());
              ps.setString(4,student.getStuMessage());
              return ps;
          }
      },keyHolder);
      student.setId(keyHolder.getKey().intValue());
      return result;
  }

  @Override
  public int updateStudent(Student student) {
      int result = jdbcTemplate.update("update student set stu_name=?,stu_no=?,age=?,stu_message=? where id = ?",
              student.getStuName(),student.getStuNo(),student.getAge(),student.getStuMessage(),student.getId());
      return result;
  }

  @Override
  public int deleteStudentById(Integer id) {
      int result = jdbcTemplate.update("delete from student where id = ?", id);
      return result;
  }

  //這種查詢比較麻煩，要一個一個設值
  @Override
  public List<Student> getAllStudent() {
      List<Student> list = jdbcTemplate.query("select * from student", new RowMapper<Student>() {
          @Override
          public Student mapRow(ResultSet rs, int rowNum) throws SQLException {
              int id = rs.getInt("id");
              String stuName = rs.getString("stu_name");
              String stuNo = rs.getString("stu_no");
              int age = rs.getInt("age");
              String stuMessage = rs.getString("stu_message");
              Student student = new Student();
              student.setId(id);
              student.setStuName(stuName);
              student.setStuNo(stuNo);
              student.setAge(age);
              student.setStuMessage(stuMessage);
              return student;
          }
      });
      return list;
  }

  //這種方式比較方便，但是有一個前提：數據庫表的字段和java實體類的屬性名要完全一致
  //或者數據庫表的字段下劃線命名方式對應java實體類屬性名的駝峰命名方式
  @Override
  public List<Student> getAllStudent2() {
      List<Student> list = jdbcTemplate.query("select * from student",new BeanPropertyRowMapper<>(Student.class));
      return list;
  }
}

 

2. jdbcTemplate配置多數據源

2.1 pom.xml

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <parent>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-parent</artifactId>
      <version>2.5.5</version>
      <relativePath/> <!-- lookup parent from repository -->
  </parent>
  <groupId>com.yl</groupId>
  <artifactId>jdbctemplateutil</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <name>jdbctemplateutil</name>
  <description>Demo project for Spring Boot</description>
  <properties>
      <java.version>1.8</java.version>
  </properties>
  <dependencies>
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-jdbc</artifactId>
      </dependency>
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-web</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-test</artifactId>
          <scope>test</scope>
      </dependency>
  </dependencies>

  <build>
      <plugins>
          <plugin>
              <groupId>org.springframework.boot</groupId>
              <artifactId>spring-boot-maven-plugin</artifactId>
          </plugin>
      </plugins>
  </build>

</project>

2.2 application.properties

# springboot配置多數據源

spring.datasource.one.username=root
spring.datasource.one.password=root
spring.datasource.one.jdbcurl=jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai

spring.datasource.two.username=root
spring.datasource.two.password=root
spring.datasource.two.jdbcurl=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai

2.3 實體類

package com.yl.jdbctemplateutil.model;

import java.io.Serializable;

public class Student implements Serializable {
  private Integer id;
  private String stuName;
  private String stuNo;
  private Integer age;
  private String stuMessage;

  @Override
  public String toString() {
      return "Student{" +
              "id=" + id +
              ", stuName='" + stuName + '\'' +
              ", stuNo='" + stuNo + '\'' +
              ", age=" + age +
              ", stuMessage='" + stuMessage + '\'' +
              '}';
  }

  public Integer getId() {
      return id;
  }

  public void setId(Integer id) {
      this.id = id;
  }

  public String getStuName() {
      return stuName;
  }

  public void setStuName(String stuName) {
      this.stuName = stuName;
  }

  public String getStuNo() {
      return stuNo;
  }

  public void setStuNo(String stuNo) {
      this.stuNo = stuNo;
  }

  public Integer getAge() {
      return age;
  }

  public void setAge(Integer age) {
      this.age = age;
  }

  public String getStuMessage() {
      return stuMessage;
  }

  public void setStuMessage(String stuMessage) {
      this.stuMessage = stuMessage;
  }
}

2.4 數據源配置

package com.yl.jdbctemplateutil.config;

import com.zaxxer.hikari.HikariDataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

@Configuration
public class DatasourceConfig {

  @Bean
  @ConfigurationProperties(prefix = "spring.datasource.one")
  DataSource dsOne() {
      return new HikariDataSource();
  }

  @Bean
  @ConfigurationProperties(prefix = "spring.datasource.two")
  DataSource dsTwo() {
      return new HikariDataSource();
  }
}

2.5 jdbctemplate配置

package com.yl.jdbctemplateutil.config;

import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.core.JdbcTemplate;

import javax.sql.DataSource;

@Configuration
public class JdbcTemplateConfig {
  @Bean
  JdbcTemplate jdbcTemplateOne(@Qualifier("dsOne")DataSource dataSource) {
      return new JdbcTemplate(dataSource);
  }

  @Bean
  JdbcTemplate jdbcTemplateTwo(@Qualifier("dsTwo")DataSource dataSource) {
      return new JdbcTemplate(dataSource);
  }
}

2.6 注入模板測試

springboot整合持久層的方法實現

 

3. springboot整合mybatis(注解方式)

3.1 pom.xml

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <parent>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-parent</artifactId>
      <version>2.5.5</version>
      <relativePath/> <!-- lookup parent from repository -->
  </parent>
  <groupId>com.yl</groupId>
  <artifactId>mybatis</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <name>mybatis</name>
  <description>Demo project for Spring Boot</description>
  <properties>
      <java.version>1.8</java.version>
  </properties>
  <dependencies>
      <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.2.0</version>
      </dependency>

      <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <scope>runtime</scope>
      </dependency>
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-test</artifactId>
          <scope>test</scope>
      </dependency>
  </dependencies>

  <build>
      <plugins>
          <plugin>
              <groupId>org.springframework.boot</groupId>
              <artifactId>spring-boot-maven-plugin</artifactId>
          </plugin>
      </plugins>
  </build>

</project>

3.2 application.properties

# 數據源配置
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai

3.3 實體類

package com.yl.mybatis.model;

import java.io.Serializable;

public class Student implements Serializable {
  private Integer id;
  private String stuName;
  private String stuNo;
  private Integer age;
  private String stuMessage;

  @Override
  public String toString() {
      return "Student{" +
              "id=" + id +
              ", stuName='" + stuName + '\'' +
              ", stuNo='" + stuNo + '\'' +
              ", age=" + age +
              ", stuMessage='" + stuMessage + '\'' +
              '}';
  }

  public Integer getId() {
      return id;
  }

  public void setId(Integer id) {
      this.id = id;
  }

  public String getStuName() {
      return stuName;
  }

  public void setStuName(String stuName) {
      this.stuName = stuName;
  }

  public String getStuNo() {
      return stuNo;
  }

  public void setStuNo(String stuNo) {
      this.stuNo = stuNo;
  }

  public Integer getAge() {
      return age;
  }

  public void setAge(Integer age) {
      this.age = age;
  }

  public String getStuMessage() {
      return stuMessage;
  }

  public void setStuMessage(String stuMessage) {
      this.stuMessage = stuMessage;
  }
}

3.4 mapper

package com.yl.mybatis.mapper;

import com.yl.mybatis.model.Student;
import org.apache.ibatis.annotations.*;

import java.util.List;

public interface StudentMapper {
  @Select("select * from student where id = #{id}")
  Student getStudentById(Integer id);

  @Insert("insert into student(stu_name,stu_no,age,stu_message) values(#{stuName},#{stuNo},#{age},#{stuMessage})")
  //回寫id
  @SelectKey(statement = "select last_insert_id()",keyProperty = "id",before = false,resultType = Integer.class)
  Integer addStudent(Student student);

  //表字段和java實體屬性映射
  @Results({
          @Result(property = "stuName",column = "stu_name"),
          @Result(property = "stuNo",column = "stu_no"),
          @Result(property = "stuMessage",column = "stu_message")
  })
  @Select("select * from student")
  List<Student> getAllStudent();

  @Delete("delete from student where id = #{id}")
  Integer deleteById(Integer id);

  @Update("update student set stu_name = #{stuName},stu_no = #{stuNo},age = #{age},stu_message = #{stuMessage} where id = #{id}")
  Integer updateByStudent(Student student);
}

3.5 service

package com.yl.mybatis.service;

import com.yl.mybatis.model.Student;

import java.util.List;

public interface StudentService {
  Student getStudentById(Integer id);

  Integer addStudent(Student student);

  List<Student> getAllStudent();

  Integer deleteById(Integer id);

  Integer updateById(Student student);
}

3.6 srviceImpl

package com.yl.mybatis.service.impl;

import com.yl.mybatis.mapper.StudentMapper;
import com.yl.mybatis.model.Student;
import com.yl.mybatis.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class StudentServiceImpl implements StudentService {
  @Autowired
  private StudentMapper studentMapper;

  @Override
  public Student getStudentById(Integer id) {
      return studentMapper.getStudentById(id);
  }

  @Override
  public Integer addStudent(Student student) {
      return studentMapper.addStudent(student);
  }

  @Override
  public List<Student> getAllStudent() {
      return studentMapper.getAllStudent();
  }

  @Override
  public Integer deleteById(Integer id) {
      return studentMapper.deleteById(id);
  }

  @Override
  public Integer updateById(Student student) {
      return studentMapper.updateByStudent(student);
  }
}

3.7 掃描mapper

springboot整合持久層的方法實現

3.8 測試

springboot整合持久層的方法實現

 

4. springboot整合mybatis(xml方式)

4.1 pom.xml

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <parent>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-parent</artifactId>
      <version>2.5.5</version>
      <relativePath/> <!-- lookup parent from repository -->
  </parent>
  <groupId>com.yl</groupId>
  <artifactId>mybatis</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <name>mybatis</name>
  <description>Demo project for Spring Boot</description>
  <properties>
      <java.version>1.8</java.version>
  </properties>
  <dependencies>
      <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.2.0</version>
      </dependency>

      <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <scope>runtime</scope>
      </dependency>
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-test</artifactId>
          <scope>test</scope>
      </dependency>
  </dependencies>

  <build>
      <plugins>
          <plugin>
              <groupId>org.springframework.boot</groupId>
              <artifactId>spring-boot-maven-plugin</artifactId>
          </plugin>
      </plugins>
  </build>

</project>

4.2 application.xml

# 數據源配置
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai

# mybatis配置
# 掃描xml文件
mybatis.mapper-locations=classpath:mapper/*.xml

4.3 實體類

package com.yl.mybatis.model;

import java.io.Serializable;

public class Student implements Serializable {
  private Integer id;
  private String stuName;
  private String stuNo;
  private Integer age;
  private String stuMessage;

  @Override
  public String toString() {
      return "Student{" +
              "id=" + id +
              ", stuName='" + stuName + '\'' +
              ", stuNo='" + stuNo + '\'' +
              ", age=" + age +
              ", stuMessage='" + stuMessage + '\'' +
              '}';
  }

  public Integer getId() {
      return id;
  }

  public void setId(Integer id) {
      this.id = id;
  }

  public String getStuName() {
      return stuName;
  }

  public void setStuName(String stuName) {
      this.stuName = stuName;
  }

  public String getStuNo() {
      return stuNo;
  }

  public void setStuNo(String stuNo) {
      this.stuNo = stuNo;
  }

  public Integer getAge() {
      return age;
  }

  public void setAge(Integer age) {
      this.age = age;
  }

  public String getStuMessage() {
      return stuMessage;
  }

  public void setStuMessage(String stuMessage) {
      this.stuMessage = stuMessage;
  }
}

4.4 mapper

package com.yl.mybatis.mapper;

import com.yl.mybatis.model.Student;
import java.util.List;

public interface StudentMapper {

  Student getStudentById(Integer id);

  Integer addStudent(Student student);

  List<Student> getAllStudent();

  Integer deleteById(Integer id);

  Integer updateById(Student student);
}

4.5 mapper.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.yl.mybatis.mapper.StudentMapper">

  <resultMap id="BaseResultMap" type="com.yl.mybatis.model.Student">
      <id property="id" column="id"/>
      <result property="stuName" column="stu_name"/>
      <result property="stuNo" column="stu_no"/>
      <result property="age" column="age"/>
      <result property="stuMessage" column="stu_message"/>
  </resultMap>

  <select id="getStudentById" resultMap="BaseResultMap">
      select * from student where id = #{id}
  </select>

  <select id="getAllStudent" resultMap="BaseResultMap">
      select * from student
  </select>

  <!--回寫id-->
  <insert id="addStudent" useGeneratedKeys="true" keyProperty="id">
      insert into student(stu_name,stu_no,age,stu_message) values(#{stuName},#{stuNo},#{age},#{stuMessage})
  </insert>

  <delete id="deleteById" parameterType="java.lang.Integer">
      delete from student where id = #{id}
  </delete>

  <update id="updateById" parameterType="com.yl.mybatis.model.Student">
      update student set stu_name=#{stuName},stu_no=#{stuNo},age=#{age},stu_message=#{stuMessage} where id = #{id}
  </update>
</mapper>

4.6 service

package com.yl.mybatis.service;

import com.yl.mybatis.model.Student;

import java.util.List;

public interface StudentService {
  Student getStudentById(Integer id);

  Integer addStudent(Student student);

  List<Student> getAllStudent();

  Integer deleteById(Integer id);

  Integer updateById(Student student);
}

4.7 serviceImpl

package com.yl.mybatis.service.impl;

import com.yl.mybatis.mapper.StudentMapper;
import com.yl.mybatis.model.Student;
import com.yl.mybatis.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class StudentServiceImpl implements StudentService {
  @Autowired
  private StudentMapper studentMapper;

  @Override
  public Student getStudentById(Integer id) {
      return studentMapper.getStudentById(id);
  }

  @Override
  public Integer addStudent(Student student) {
      return studentMapper.addStudent(student);
  }

  @Override
  public List<Student> getAllStudent() {
      return studentMapper.getAllStudent();
  }

  @Override
  public Integer deleteById(Integer id) {
      return studentMapper.deleteById(id);
  }

  @Override
  public Integer updateById(Student student) {
      return studentMapper.updateById(student);
  }
}

4.8 掃描mapper

springboot整合持久層的方法實現

 

5. mybatis整合多數據源

5.1 pom.xml

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <parent>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-parent</artifactId>
      <version>2.5.5</version>
      <relativePath/> <!-- lookup parent from repository -->
  </parent>
  <groupId>com.yl</groupId>
  <artifactId>mybatisutil</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <name>mybatisutil</name>
  <description>Demo project for Spring Boot</description>
  <properties>
      <java.version>1.8</java.version>
  </properties>
  <dependencies>
      <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.2.0</version>
      </dependency>

      <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <scope>runtime</scope>
      </dependency>
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-test</artifactId>
          <scope>test</scope>
      </dependency>
  </dependencies>

  <build>
      <resources>
          <resource>
              <directory>src/main/java</directory>
              <includes>
                  <include>**/*.xml</include>
              </includes>
          </resource>
          <resource>
              <directory>src/main/resources</directory>
          </resource>
      </resources>
      <plugins>
          <plugin>
              <groupId>org.springframework.boot</groupId>
              <artifactId>spring-boot-maven-plugin</artifactId>
          </plugin>
      </plugins>
  </build>

</project>

5.2 application.properties

# 數據源配置
spring.datasource.one.username=root
spring.datasource.one.password=root
spring.datasource.one.jdbcurl=jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai

spring.datasource.two.username=root
spring.datasource.two.password=root
spring.datasource.two.jdbcurl=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai

5.3 實體類

package com.yl.mybatisutil.model;

import java.io.Serializable;

public class Student implements Serializable {
  private Integer id;
  private String stuName;
  private String stuNo;
  private Integer age;
  private String stuMessage;

  @Override
  public String toString() {
      return "Student{" +
              "id=" + id +
              ", stuName='" + stuName + '\'' +
              ", stuNo='" + stuNo + '\'' +
              ", age=" + age +
              ", stuMessage='" + stuMessage + '\'' +
              '}';
  }

  public Integer getId() {
      return id;
  }

  public void setId(Integer id) {
      this.id = id;
  }

  public String getStuName() {
      return stuName;
  }

  public void setStuName(String stuName) {
      this.stuName = stuName;
  }

  public String getStuNo() {
      return stuNo;
  }

  public void setStuNo(String stuNo) {
      this.stuNo = stuNo;
  }

  public Integer getAge() {
      return age;
  }

  public void setAge(Integer age) {
      this.age = age;
  }

  public String getStuMessage() {
      return stuMessage;
  }

  public void setStuMessage(String stuMessage) {
      this.stuMessage = stuMessage;
  }
}

5.4 mapper1

package com.yl.mybatisutil.mapper1;

import com.yl.mybatisutil.model.Student;

import java.util.List;

public interface StudentMapper1 {
  List<Student> getAllStudent();
}

5.5 mapper2

package com.yl.mybatisutil.mapper2;

import com.yl.mybatisutil.model.Student;

import java.util.List;

public interface StudentMapper2 {
  List<Student> getAllStudent();
}

5.6 mapper1.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.yl.mybatisutil.mapper1.StudentMapper1">
  <select id="getAllStudent" resultType="com.yl.mybatisutil.model.Student">
      select * from student
  </select>
</mapper>

5.7 mapper2.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.yl.mybatisutil.mapper2.StudentMapper2">
  <select id="getAllStudent" resultType="com.yl.mybatisutil.model.Student">
      select * from student
  </select>
</mapper>

5.8 數據源配置

package com.yl.mybatisutil.config;

import com.zaxxer.hikari.HikariDataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

/**
* 多數據源配置
*/
@Configuration
public class DataSourceConfig {

  @Bean
  @ConfigurationProperties(prefix = "spring.datasource.one")
  DataSource dsOne() {
      return new HikariDataSource();
  }
  @Bean
  @ConfigurationProperties(prefix = "spring.datasource.two")
  DataSource dsTwo() {
      return new HikariDataSource();
  }
}

5.9 mybatis配置1

package com.yl.mybatisutil.config;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

/**
*  mybatis的配置
*/
@Configuration
@MapperScan(basePackages = "com.yl.mybatisutil.mapper1",sqlSessionFactoryRef = "sqlSessionFactory1",sqlSessionTemplateRef = "sqlSessionTemplate1")
public class MyBatisConfigOne {
  @Qualifier("dsOne")
  @Autowired
  DataSource dataSource;

  @Bean
  SqlSessionFactory sqlSessionFactory1() {
      try {
          SqlSessionFactory sqlSessionFactory = null;
          SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
          sqlSessionFactoryBean.setDataSource(dataSource);
          sqlSessionFactory = sqlSessionFactoryBean.getObject();
          return sqlSessionFactory;
      } catch (Exception e) {
          e.printStackTrace();
          return null;
      }
  }

  @Bean
  SqlSessionTemplate sqlSessionTemplate1() {
      return new SqlSessionTemplate(sqlSessionFactory1());
  }

}

5.10 mybatis配置2

package com.yl.mybatisutil.config;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

/**
*  mybatis的配置
*/
@Configuration
@MapperScan(basePackages = "com.yl.mybatisutil.mapper2",sqlSessionFactoryRef = "sqlSessionFactory2",sqlSessionTemplateRef = "sqlSessionTemplate2")
public class MyBatisConfigTwo {
  @Qualifier("dsTwo")
  @Autowired
  DataSource dataSource;

  @Bean
  SqlSessionFactory sqlSessionFactory2() {
      try {
          SqlSessionFactory sqlSessionFactory = null;
          SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
          sqlSessionFactoryBean.setDataSource(dataSource);
          sqlSessionFactory = sqlSessionFactoryBean.getObject();
          return sqlSessionFactory;
      } catch (Exception e) {
          e.printStackTrace();
          return null;
      }
  }

  @Bean
  SqlSessionTemplate sqlSessionTemplate2() {
      return new SqlSessionTemplate(sqlSessionFactory2());
  }

}

5.11 項目結構

springboot整合持久層的方法實現

到此這篇關于springboot整合持久層的方法實現的文章就介紹到這了,更多相關springboot整合持久層內容請搜索服務器之家以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持服務器之家！

原文鏈接：https://blog.csdn.net/weixin_41359273/article/details/120465426

延伸 · 閱讀

精彩推薦
  • Java教程Java實現搶紅包功能

    Java實現搶紅包功能

    這篇文章主要為大家詳細介紹了Java實現搶紅包功能，采用多線程模擬多人同時搶紅包，文中示例代碼介紹的非常詳細，具有一定的參考價值，感興趣的小伙...

    littleschemer13532021-05-16
  • Java教程20個非常實用的Java程序代碼片段

    20個非常實用的Java程序代碼片段

    這篇文章主要為大家分享了20個非常實用的Java程序片段，對java開發項目有所幫助，感興趣的小伙伴們可以參考一下 ...

    lijiao5352020-04-06
  • Java教程Java8中Stream使用的一個注意事項

    Java8中Stream使用的一個注意事項

    最近在工作中發現了對于集合操作轉換的神器，java8新特性 stream，但在使用中遇到了一個非常重要的注意點，所以這篇文章主要給大家介紹了關于Java8中S...

    阿杜7482021-02-04
  • Java教程Java BufferWriter寫文件寫不進去或缺失數據的解決

    Java BufferWriter寫文件寫不進去或缺失數據的解決

    這篇文章主要介紹了Java BufferWriter寫文件寫不進去或缺失數據的解決方案，具有很好的參考價值，希望對大家有所幫助。如有錯誤或未考慮完全的地方，望...

    spcoder14552021-10-18
  • Java教程小米推送Java代碼

    小米推送Java代碼

    今天小編就為大家分享一篇關于小米推送Java代碼，小編覺得內容挺不錯的，現在分享給大家，具有很好的參考價值，需要的朋友一起跟隨小編來看看吧...

    富貴穩中求8032021-07-12
  • Java教程升級IDEA后Lombok不能使用的解決方法

    升級IDEA后Lombok不能使用的解決方法

    最近看到提示IDEA提示升級，尋思已經有好久沒有升過級了。升級完畢重啟之后，突然發現好多錯誤，本文就來介紹一下如何解決，感興趣的可以了解一下...

    程序猿DD9332021-10-08
  • Java教程xml與Java對象的轉換詳解

    xml與Java對象的轉換詳解

    這篇文章主要介紹了xml與Java對象的轉換詳解的相關資料,需要的朋友可以參考下...

    Java教程網2942020-09-17
  • Java教程Java使用SAX解析xml的示例

    Java使用SAX解析xml的示例

    這篇文章主要介紹了Java使用SAX解析xml的示例，幫助大家更好的理解和學習使用Java，感興趣的朋友可以了解下...

    大行者10067412021-08-30
主站蜘蛛池模板： 喷潮女王cytherea全部视频 | 热九九精品 | 欧美日韩综合一区 | 欧美a级v片不卡在线观看 | 被教官揉了一晚上的奶小说 | 99在线视频免费 | 国产黄频在线观看高清免费 | 亚洲123区 | 俄罗斯一级在线播放 | 日韩伦理在线观看 | 亚洲大爷操 | 国产欧美日韩专区 | 五月婷婷在线播放 | 亚洲福利一区二区 | 韩国伊人 | 99视频一区| 国产91影院 | 奇米影视小说 | 国产夜趣福利第一视频 | 97爱干| 国内精品视频一区二区三区八戒 | 韩国久播影院理论片不卡影院 | xxxxx性欧美| 99色在线观看 | 免费观看无人区完整版 | 久久机热视频 这里只有精品首页 | 成人a级特黄毛片 | 91久久偷偷做嫩草影院免费看 | 扒开老师挠尿口到崩溃刑罚 | 亚洲精品国产精品麻豆99 | 欧美日韩在线一区二区三区 | 国产一页 | 国产高清经典露脸3p | 天天狠天天天天透在线 | 日本一二线不卡在线观看 | 99热久久这里只有精品6国产网 | wwwav在线 | 啾咪成人漫画免费 | 成人精品视频 成人影院 | 国产成人高清视频 | 亚洲精品国产福利片 |