springboot整合持久層的方法實(shí)現(xiàn)
更新時(shí)間：2021年09月27日 15:20:29 作者：一只y
本文主要介紹了springboot整合持久層的方法實(shí)現(xiàn)，文中通過(guò)示例代碼介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下
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;
}
//插入數(shù)據(jù)，并且回寫(xiě)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 {
//插入數(shù)據(jù)后返回主鍵
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;
}
//這種查詢(xún)比較麻煩，要一個(gè)一個(gè)設(shè)值
@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;
}
//這種方式比較方便，但是有一個(gè)前提：數(shù)據(jù)庫(kù)表的字段和java實(shí)體類(lèi)的屬性名要完全一致
//或者數(shù)據(jù)庫(kù)表的字段下劃線命名方式對(duì)應(yīng)java實(shí)體類(lèi)屬性名的駝峰命名方式
@Override
public List<Student> getAllStudent2() {
List<Student> list = jdbcTemplate.query("select * from student",new BeanPropertyRowMapper<>(Student.class));
return list;
}
}
2. jdbcTemplate配置多數(shù)據(jù)源
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配置多數(shù)據(jù)源 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 實(shí)體類(lèi)
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 數(shù)據(jù)源配置
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 注入模板測(cè)試
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
# 數(shù)據(jù)源配置 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 實(shí)體類(lèi)
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})")
//回寫(xiě)id
@SelectKey(statement = "select last_insert_id()",keyProperty = "id",before = false,resultType = Integer.class)
Integer addStudent(Student student);
//表字段和java實(shí)體屬性映射
@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
3.8 測(cè)試
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
# 數(shù)據(jù)源配置 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 實(shí)體類(lèi)
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>
<!--回寫(xiě)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
5. mybatis整合多數(shù)據(jù)源
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
# 數(shù)據(jù)源配置 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 實(shí)體類(lèi)
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 數(shù)據(jù)源配置
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;
/**
* 多數(shù)據(jù)源配置
*/
@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 項(xiàng)目結(jié)構(gòu)
到此這篇關(guān)于springboot整合持久層的方法實(shí)現(xiàn)的文章就介紹到這了,更多相關(guān)springboot整合持久層內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！
相關(guān)文章
這篇文章主要給大家深入的介紹了Swift中Substring和String的相關(guān)資料，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧。2018-03-03
這篇文章主要介紹了Java數(shù)組索引異常產(chǎn)生及解決方案,文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友可以參考下2020-01-01
Java 線程對(duì)比（Thread,Runnable,Callable）實(shí)例詳解
這篇文章主要介紹了Java 線程（Thread,Runnable,Callable）實(shí)例詳解的相關(guān)資料,這里對(duì)java 線程的三種方法進(jìn)行了對(duì)比，需要的朋友可以參考下2016-12-12
這篇文章主要介紹了java學(xué)習(xí)之SpringBoot框架，文章基于Java的相關(guān)資料展開(kāi)詳細(xì)的內(nèi)容介紹，具有一定的參考價(jià)值，需要的小伙伴可以參考一下2022-04-04
如何使用JDBC實(shí)現(xiàn)工具類(lèi)抽取
這篇文章主要介紹了如何使用JDBC實(shí)現(xiàn)工具類(lèi)抽取,文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友可以參考下2020-02-02
這篇文章主要介紹了Redis中的事務(wù)和Redis樂(lè)觀鎖詳解,Redis事務(wù)是一個(gè)單獨(dú)的隔離操作：事務(wù)中的所有命令都會(huì)序列化、按順序地執(zhí)行,事務(wù)在執(zhí)行的過(guò)程中,不會(huì)被其他客戶(hù)端發(fā)送來(lái)的命令請(qǐng)求所打斷,需要的朋友可以參考下2023-12-12
Java?Thread?類(lèi)和Runnable?接口詳解
這篇文章主要介紹了Java?Thread?類(lèi)和Runnable接口詳解，文章圍繞主題展開(kāi)詳細(xì)的內(nèi)容介紹，具有一定的參考價(jià)值，需要的朋友可以參考一下2022-08-08
EasyExcel實(shí)現(xiàn)導(dǎo)入+各種數(shù)據(jù)校驗(yàn)功能
這篇文章主要介紹了EasyExcel實(shí)現(xiàn)導(dǎo)入+各種數(shù)據(jù)校驗(yàn),本文通過(guò)實(shí)例代碼給大家介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或工作具有一定的參考借鑒價(jià)值，需要的朋友可以參考下2023-05-05
MyBatis中#號(hào)與美元符號(hào)的區(qū)別
#{變量名}可以進(jìn)行預(yù)編譯、類(lèi)型匹配等操作，#{變量名}會(huì)轉(zhuǎn)化為jdbc的類(lèi)型。很多朋友不清楚在mybatis中#號(hào)與美元符號(hào)的不同，接下來(lái)通過(guò)本文給大家介紹兩者的區(qū)別，感興趣的朋友參考下吧2017-01-01
Java實(shí)現(xiàn)SHA-256加密算法的完全解析
SHA-256是一種散列（哈希）算法，用于將任意長(zhǎng)度的數(shù)據(jù)映射為固定長(zhǎng)度的散列值，以保證數(shù)據(jù)完整性。本文將為大家介紹一下SHA-256加密算法的原理與實(shí)現(xiàn)，希望對(duì)大家有所幫助2023-02-02