崛起于Springboot2.X + Jpa（61）

《SpringBoot2.X心法总纲》

项目Git地址：https://gitee.com/mdxl/blog.git

1、pom依赖

      勾选lombok、web、jpa、jdbc、mysql依赖

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <optional>true</optional>
</dependency>

2、application.properties

server.port=8082
# Mysql
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/shiro?useUnicode=true&characterEncoding=utf-8&useSSL=false
spring.datasource.username=root
spring.datasource.password=root
# none, update, create, or create-drop
spring.jpa.hibernate.ddl-auto=update
# sql日志上输出到文件中
spring.jpa.show-sql=true
# 设置方言+引擎
spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect
# 命名策略
spring.jpa.hibernate.naming.physical-strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy

3、实体类

一定要有注解@Entity和@Table

import javax.persistence.*;

@Table(name = "osc_user")
@Data
@ToString
@Entity
public class UserEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private int id;
    private String name;
    private int age;
    private String address;
    private String hobby;
}

4、Mapper

public interface UserMapper extends JpaRepository<UserEntity,Integer> {
}

5、Controller

@RestController
@RequestMapping(value = "/jpa")
@Slf4j
public class UserController {

    @Autowired
    UserMapper userMapper;

    @GetMapping(value = "/getUser")
    public void getUser(int id){
        UserEntity userEntity = userMapper.getOne(id);
        log.info(userEntity.toString());
    }
}

6、表结构

CREATE TABLE `osc_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT "主键",
  `name` varchar(32) NOT NULL COMMENT "姓名",
  `age` int(10) NOT NULL COMMENT "年龄",
  `address` varchar(64) NOT NULL COMMENT "地址",
  `hobby` varchar(32) NOT NULL COMMENT "爱好",
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT="用户描述表"

7、启动

启动成功截图：

调用接口，如图：

成功。