新手也可以快速整合springboot+JPA框架

最新推荐文章于 2024-02-20 09:52:51 发布

bingbingYang_88

最新推荐文章于 2024-02-20 09:52:51 发布

阅读量242

点赞数

CC 4.0 BY-SA版权

分类专栏：分布式文章标签： springboot JPA

本文链接：https://blog.youkuaiyun.com/weixin_30409927/article/details/99762608

分布式专栏收录该内容

17 篇文章

订阅专栏

本文介绍如何在Spring Boot项目中使用JPA进行数据库操作，包括pom文件配置依赖、application.yml配置数据库连接、创建User实体类、定义UserDao接口以及实现Controller层的增删改查操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

pom文件引入依赖

	<parent>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-parent</artifactId>
			<version>2.0.1.RELEASE</version>
	</parent>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-jpa</artifactId>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.21</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
	</dependencies>

配置文件引入

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/test
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver

创建User实体类

package com.evan.model;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;

/**
 * @author evanYang
 * @version 1.0
 * @date 2019/08/15 10:00
 */
@Entity(name = "user")
public class User {

    @Id
    @GeneratedValue
    private Integer id;

    @Column(name = "user_name")
    private String userName;

    @Column(name = "user_phone")
    private String userPhone;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getUserPhone() {
        return userPhone;
    }

    public void setUserPhone(String userPhone) {
        this.userPhone = userPhone;
    }
}

创建数据库

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(50) DEFAULT NULL,
  `user_phone` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_name_index` (`user_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;


INSERT INTO `test`.`user` (`id`, `user_name`, `user_phone`) VALUES ('1', 'evan', '26');
INSERT INTO `test`.`user` (`id`, `user_name`, `user_phone`) VALUES ('2', 'evan11', '26');

创建UserDao

public interface UserDao extends JpaRepository<User, Integer> {
}

创建Controller

@RestController
public class IndexController {
	@Autowired
	private UserDao userDao;
	 @GetMapping("/index")
    public List<User> index(Integer id){
        List<User> all = userDao.findAll();
        return userDao.findAll();
    }
}

测试

在这里插入图片描述返回结果