SpringBoot-Mabatis&JPA

Mybatis- 基本配置

1. pom.xml

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.2</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.13</version>
    <scope>runtime</scope>
</dependency>

2. application.yml

spring:
  datasource:
    username: root
    password: 932567
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://192.168.199.131:3307/123?useSSL=FALSE&&serverTimezone=GMT&&characterEncoding=utf-8

# 整合mybatis
mybatis:
  type-aliases-package: springboot.entity
  mapper-locations: classpath:mybatis/mapper/**/*.xml

3. mapper包下的UserMapper接口

@Mapper //这个注解表示了这是一个mybatis的mapper类
@Repository
public interface UserMapper {

    // int age = 18
    // public static final int age =18

    List<User> queryUserList();

    User queryUserById(int id);
    ...

4. mapper.xml

<!-- 命名空间是接口的全类名 -->
<mapper namespace="springboot.mapper.UserMapper">
    <!-- id是方法名 -->
    <select id="queryUserList" resultType="User">
        select * from user
    </select>

5. 可直接使用

@Autowired
private UserMapper userMapper;
@GetMapping("/queryUserList")
public List<User> queryUserList(){
    List<User> list = userMapper.queryUserList();
    return list;
}

JPA - 基本配置

1. pom.xml

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

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.13</version>
    <scope>runtime</scope>
</dependency>

2. 配置文件

spring:
  datasource:
    url: jdbc:mysql://192.168.199.131:3307/123?useSSL=false&servertimeZone=GMT&characterEncoding=utf-8
    username: root
    password: 932567
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource

  jpa:
    hibernate:
      ddl-auto: update
    show-sql: true

3. 编写实体类

@Entity
@Table(name = "user")
public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;

    @Column(name = "name")
    private String name;
    @Column //默认列名就是属性名
    private String pwd;
    @Column
    private String perms;
}

4. 在dao包下定义实现JpaRepository<T, ID>的接口
   具体api可看

//继承JpaRepository<T, ID>来完成对数据库的操作，其中T表示实体类，ID表示主键类型
public interface UserDao extends JpaRepository<User,Integer> {
}

5. 使用

@Autowired
UserDao userDao;

@Test
void test(){
    User one = userDao.findById(1).get();
    System.out.println(one);
}