1.导入相关依赖
<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jdbc</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency>
2.编写配置文件
spring: datasource: url: jdbc:mysql://xxxxx:3306/jpa?useUnicode=true&characterEncoding=utf-8&useSSL=true username: xxx password: xxx driver-class-name: com.mysql.cj.jdbc.Driver type: com.alibaba.druid.pool.DruidDataSource jpa: hibernate: ddl-auto: update #自动创建表 show-sql: true
3.编写实体类
import javax.persistence.*; @Entity @Table(name="user") public class User { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) //主键自增策略 private Integer id; @Column(name="last_name") private String lastName; @Column //默认小写 private String email; public User() { } public User(Integer id, String lastName, String email) { this.id = id; this.lastName = lastName; this.email = email; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getLastName() { return lastName; } public void setLastName(String lastName) { this.lastName = lastName; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } @Override public String toString() { return "User{" + "id=" + id + ", lastName='" + lastName + '\'' + ", email='" + email + '\'' + '}'; } }
4.编写dao层
public interface UserDao extends JpaRepository<实体类名,主键类型> { }
5.编写Controller
@RestController public class UserController { @Autowired UserDao userDao; @RequestMapping("/user") public User insert(User user){ return userDao.save(user); } }
可能遇到的问题:在@Table注解里的值飘红
解决:
1.IDEA连接数据库
2.
3.
4.选中对应的数据库