经验之说:项目整合jdbc框架、jpa、mybatis不会有冲突。
spring jpa实则是对hibernate的封装,但是jpa都是以注解的形式
jpa框架的使用(使用方法同hibernate):实体类,dao层、service层、service实现层,控制层
dao层继承JpaRepository
添加依赖:
<!--集成jpa-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
实体类:
package com.mybatis.pojo;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
//Jpa框架集成的实体类
@Entity(name="t_user") //此处的name对应数据库中的表名
public class User {
@Id
@GeneratedValue
private Integer userId;
@Column
private String name;
@Column
private String password;
@Column
private String phone;
public Integer getUserId() {
return userId;
}
public void setUserId(Integer userId) {
this.userId = userId;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
}
dao层,只需要实现这个jpa接口就好:
package com.mybatis.dao;
import com.mybatis.pojo.User;
import org.springframework.data.jpa.repository.JpaRepository;
//jpa实现接口
public interface UserDao extends JpaRepository<User,Integer> {
}
做个简单的查询,在这里又遇到了一个万年的老梗,我想我以后这辈子都不会出错了,我的springboot版本是2.1,但是在2.1中并不支持findOne()方法,在1.54的版本是可以的,2.1版本中查单条:userDao.findById(id).orElse(null);,不然会报错哦
package com.mybatis.controller;
import com.mybatis.dao.UserDao;
import com.mybatis.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
@RestController
public class UserController {
@Autowired
private UserDao userDao;
@RequestMapping("/getUser")
public User getUser(Integer id){
return userDao.findById(id).orElse(null);
}
}
启动类:
package com.mybatis;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.domain.EntityScan;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.scheduling.annotation.EnableAsync;
import org.springframework.scheduling.annotation.EnableScheduling;
@SpringBootApplication
@ComponentScan(basePackages={"com.mybatis"})
//定时任务开关
@EnableScheduling
//开启异步调用方法
@EnableAsync
//Jpa的扫包范围
@EnableJpaRepositories("com.mybatis.dao")
//jpa扫描实体类
@EntityScan("com.mybatis.pojo")
public class MybatisApplication {
public static void main(String[] args) {
SpringApplication.run(MybatisApplication.class, args);
}
}
启动项目: