# jpa

**Repository Path**: Yangzhixue/jpa

## Basic Information

- **Project Name**: jpa
- **Description**: springdata JPA的简单入门
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2019-08-03
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# jpa

#### 介绍
springdata JPA的简单入门

#### 软件架构

```
@Repository
public interface UserDao extends JpaRepository<UserDO, Long> {
   //多属性查询接口
    UserDO findByAccount(String account);

    //自定义属性查询接口
    @Query("SELECT O FROM UserDO O WHERE O.name = :name1  OR O.name = :name2 ")
    List<UserDO> findTwoName(@Param("name1") String name1, @Param("name2") String name2);

    //原生sql语句查询
    @Query(nativeQuery = true, value = "SELECT * FROM AUTH_USER WHERE name = :name1  OR name = :name2 ")
    List<UserDO> findSQL(@Param("name1") String name1, @Param("name2") String name2);
}
```

#### test

```
package com.yzx.springbootjpa;

import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.data.domain.Sort;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.List;

@RunWith(SpringRunner.class)
@SpringBootTest
public class Test {
    @Autowired
    private UserDao userDao;
    @org.junit.Test
    public void test1(){
        UserDO userDO = new UserDO();
        userDO.setId(2L);
        userDO.setName("任我行");
        userDO.setAccount("renwox");
        userDO.setPwd("123456");
        userDao.save(userDO);
        userDO = new UserDO();
        userDO.setId(4L);
        userDO.setName("令狐冲");
        userDO.setAccount("linghuc");
        userDO.setPwd("123456");
        userDao.save(userDO);
    }
    @org.junit.Test
    public void test(){
        List<UserDO> userDOList = userDao.findAll(new Sort(Sort.Direction.DESC,"account"));
        for (UserDO userDO :userDOList) {
            System.out.println("name = " + userDO.getName());
            System.out.println("account = " + userDO.getAccount());
        }
    }

    @org.junit.Test
    public void test3(){
        UserDO userDO = userDao.findByAccount("renwox");
        if (userDO != null) {
            System.out.println("name = " + userDO.getName());
            System.out.println("account = " + userDO.getAccount());
        }
    }
}
```