0、创建SpringBoot的web项目
一路next，然后finish
1、添加依赖
<!-- SpringBoot的jpa依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<!-- mysql依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
2、配置文件
application.properties文件
spring.datasource.url=jdbc:mysql://localhost:3306/test01?characterEncoding=UTF-8&serverTimezone=GMT
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
3、建表语句
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`age` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
4、创建一个实体与user表对应
import javax.persistence.*;
//name属性值对应数据库表的名字
@Entity(name = "user")
public class User {
//表示id是主键，增长方式是自增长
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
//表示数据库user表的name列
@Column(name = "name")
private String name;
//表示数据库user表的age列
@Column(name = "age")
private Integer age;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
}
5、创建UserDao
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Component;
//要继承JpaRepository,第一个泛型是对应哪个实体，第二个泛型是主键id的类型
@Component
public interface UserDao extends JpaRepository<User,Long> {
}
6、在user表中随便插几条数据
7、创建UserController，写一个查询所有的方法用于访问
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.List;
@RestController
public class UserController {
@Autowired
private UserDao userDao;
//添加用户
@PostMapping("/addUser")
public String addUser(User user){
userDao.save(user);
return "success";
}
//查询用户
@GetMapping("/queryAllUser")
public List<User> queryAllUser(){
List<User> users = userDao.findAll();
return users;
}
}
8、访问测试
