springboot连接jpa

1.导包

        <!--jpa-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>

2.配置数据库

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/db
spring.datasource.username=root
spring.datasource.password=123
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

 3.实体类

@Entity(name = "user") //指定数据库类
public class User {
    @Id
    @GeneratedValue
    private int id;
    @Column
    private String username;
    @Column
    private String password;
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
}

4.dao

public interface UserDao extends JpaRepository<User,Integer> {
    //自带：增删改查
}

5.service

@Service
public class UserService {
    @Autowired
    private UserDao userDao;

    public User addUser(User user){
        User count = userDao.save(user);
        return count;
    }

    public List<User> queryUser(){
        List<User> all = userDao.findAll();
        return all;
    }
}

6.controller

@RestController
public class UserController {
    @Autowired
    private UserService userService;

    @RequestMapping("/queryAllUser")
    public List<User> queryAllUser(){
        return userService.queryUser();
    }
    @RequestMapping("/addUser")
    public User addUser(@RequestBody User user){
        return userService.addUser(user);
    }
}

7.启动类配置

@EnableAutoConfiguration
@ComponentScan(basePackages = {"com.syf.study.controller","com.syf.study.service","com.syf.study.dao"})
@EntityScan //开启实体类注解
@SpringBootApplication //开启此注解时上面第一个注解和第二个注解可不写
public class SpringbootagainApplication {

	public static void main(String[] args) {
		SpringApplication.run(SpringbootagainApplication.class, args);
	}
}