springboot mysql项目搭建
时间: 2023-11-21 11:57:29 浏览: 38
以下是使用SpringBoot和MySQL搭建项目的步骤:
1.在pom.xml文件中添加MySQL依赖项:
```xml
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
```
2.在application.properties文件中配置MySQL数据库连接信息:
```properties
spring.datasource.url=jdbc:mysql://localhost:3306/db_name
spring.datasource.username=username
spring.datasource.password=password
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
```
3.创建一个实体类,用于映射数据库表:
```java
@Entity
@Table(name = "user")
public class User {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
private String name;
private Integer age;
// 省略getter和setter方法
}
```
4.创建一个Repository接口,用于操作数据库:
```java
@Repository
public interface UserRepository extends JpaRepository<User, Long> {
}
```
5.创建一个Controller类,用于处理HTTP请求:
```java
@RestController
@RequestMapping("/users")
public class UserController {
@Autowired
private UserRepository userRepository;
@GetMapping("")
public List<User> getAllUsers() {
return userRepository.findAll();
}
@PostMapping("")
public User createUser(@RequestBody User user) {
return userRepository.save(user);
}
}
```
6.启动应用程序并访问http://localhost:8080/users即可查看所有用户。