Spring Boot连接数据库入门
首先创建Spring Boot项目
使用 start.spring.io,选择:Spring Web ,Spring Data JPA,MySQL Driver。
首先在application.properties中添加如下:
spring.datasource.url=jdbc:mysql://localhost:3306/库名
spring.datasource.username=用户名
spring.datasource.password=密码
创建实体与Repository:
@Entity
public class User {
@Id
@GeneratedValue
private Long id;
private String name;
// getters/setters
}
public interface UserRepository extends JpaRepository<User, Long> {
}
验证连接:
@SpringBootTest
public class DatabaseTest {
@Autowired
private UserRepository userRepository;
@Test
void testSaveUser() {
User user = new User();
user.setName("Spring");
userRepository.save(user);
assertNotNull(user.getId());
}
}