Spring Boot之集成Jdbc Template、MyBatis、Spring Data JPA

Spring Boot之集成Jdbc Template、MyBatis、Spring Data JPA

• 一、Spring Boot集成Jdbc Template
• • 1.引入依赖
  • 2.添加application.properties配置
  • 3.接口及其实现
  • 4.执行测试
• 二、Spring Boot集成MyBatis
• • 1.引入依赖
  • 2.配置数据源
  • 3.加入MyBatis配置
  • 4.创建Mapper接口
  • • 1.使用xml方式
    • 2.使用注解方式
  • 5.配置Mapper映射文件
  • 6.引导类加上包扫描
  • 7.创建UserController
  • 8.执行测试
  • 9.集成mybatis-pagehelper分页插件
• 三、Spring Boot集成Spring Data JPA
• • 1.添加依赖
  • 2.配置数据库
  • 3.配置Jpa
  • 4.创建实体并配置实体
  • 5.编写UserRepository
  • 6.执行测试

一、Spring Boot集成Jdbc Template

官方文档:
https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/jdbc/core/JdbcTemplate.html

1.引入依赖

	
		org.springframework.boot
		spring-boot-starter-parent
		2.3.4.RELEASE
	
	
		
			org.springframework.boot
			spring-boot-starter-jdbc
		
		
			mysql
			mysql-connector-java
			5.1.49
		
		
			org.springframework.boot
			spring-boot-starter-test
			test
		
	

2.添加application.properties配置

spring.datasource.url=jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

3.接口及其实现

public interface UserService {
	public void insertUser();
}

@Service
public class UserServiceImpl implements UserService {
	
	@Autowired
	private JdbcTemplate jdbcTemplate;

	@Override
	public void insertUser() {
		jdbcTemplate.update("insert into user values(null,?,?);","小白",20);
	}
}

4.执行测试

@RunWith(SpringRunner.class)
@SpringBootTest(classes = App.class)
public class Test {

    @Autowired
    private  UserService userService;

    @org.junit.Test
    public void test(){
        userService.insertUser("小白",20);
    }
}

二、Spring Boot集成MyBatis 1.引入依赖

	 
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            1.2.2
        

        
        
            mysql
            mysql-connector-java
            runtime
        

2.配置数据源

在application.properties中加入如下配置

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/demo?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456

3.加入MyBatis配置

在application.properties中加入如下配置：

#加载Mybatis映射文件
mybatis.mapper-locations=classpath:cn/ybzy/mapper
        PageHelper.startPage(page, pageSize);

        List list = UserMapper.getAll();
        
        PageInfo pageInfo = new PageInfo<>(list);
        PageResult pageResult = new PageResult();
        pageResult.setPage(page);
        pageResult.setRows(list);
        pageResult.setTotal(pageInfo.getPages());
        pageResult.setRecords(pageInfo.getTotal());
        return pageResult;

三、Spring Boot集成Spring Data JPA 1.添加依赖

	org.springframework.boot
	spring-boot-starter-data-jpa




	mysql
	mysql-connector-java

2.配置数据库

#MYSQL配置:
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/demo?useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=123456

3.配置Jpa

#JPA配置:
spring.jpa.database=MySQL
spring.jpa.show-sql=true
spring.jpa.generate-ddl=true
spring.jpa.hibernate.ddl-auto=update
spring.jpa.hibernate.naming_strategy=org.hibernate.cfg.ImprovedNamingStrategy

4.创建实体并配置实体

@Entity(name = "tb_user"))
public class User{

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String username;
    private String password;
    private String name;
}

5.编写UserRepository

public interface UserRepository extends JpaRepository{

    public List getAll();

}

6.执行测试

@RunWith(SpringRunner.class)
@SpringBootTest(classes = Application .class)
public class JpaTest {

    @Autowired
    private UserRepository userRepository;

    @Test
    public void test() {
        List userList = userRepository.getAll();
        for (User user : userList) {
            System.out.println("user = " + user);
        }
    }
}