DAY45–SpringBoot–整合jpa
springboot集成jpa
- (1) 添加SpringData JPA的起步依赖
- (2) 添加数据库驱动依赖
- (3) 在application.properties中配置数据库和jpa的相关属性
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: root
url: jdbc:mysql://localhost:3306/wang?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8
# 配置jpa PhysicalNamingStrategyStandardImpl小驼峰 xx_yy_xx
jpa:
show-sql: true
hibernate:
ddl-auto: update
naming:
physical-strategy: org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy
database: mysql
UserDao
UserDao中需要继承一个接口,也不需要些SQL语句,就可以完成增删改查功能
//继承通用的接口,即可完成增删改查
public interface UserDao extends JpaRepository<User,Integer> {
}
User
如果,我们没有在数据库中创建表,那么程序会自动给我们在数据库中创建相关表
import javax.persistence.*;
@Entity //表示当前类,在数据库有表与它对应
@Table(name = "user")
public class User {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY) //主键自动增长
private int id;
private String username;
private String password;
private String girlFriend;
private String name;
测试
@SpringBootTest
class Demo9JpaApplicationTests {
@Autowired
UserDao userDao;
@Test
void contextLoads() {
User user = new User();
user.setGirlFriend("rose");
user.setUsername("jack!xx.com");
user.setName("jack");
userDao.save(user);
}
}