简单使用spring data jpa实例及maven引用

准备阶段

首先介绍一下我的项目框架以及jdk使用等：
1、jdk使用：jdk1.8
2、框架:spring Boot
3、连接数据库：mysql
4、pom文件可能引用了项目用到的别的东西，具体本示例需要用到的有：
spring boot相关：

<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>1.4.1.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
<dependencies>
	<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
	<!--aop依赖-->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-aop</artifactId>
		</dependency>
		
      </dependencies>

spring data jpa相关：

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

mysql相关：

  <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

表模型：

operation表

-- auto-generated definition
create table operation
(
  OPERATION_ID   int auto_increment
    primary key,
  OPERATION_NAME varchar(60) not null,
  OPERATION_CODE varchar(30) not null,
  STS            char        not null,
  STS_DATE       datetime    not null,
  CREATE_DATE    datetime    not null
);

代码实操

首先需要在配置文件中声明自己得数据库连接地址及用户名密码等:
spring.yml文件：

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/demo?useSSL=true
    username: root
    password: root
  jpa:
    hibernate:
      naming:
        physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
      ddl-auto: update
    show-sql: true
    database-platform: org.hibernate.dialect.MySQLDialect

创建实体类：

package  **.**
@Entity
public class Operation {

    public Operation() {
    }

    public Integer getOperationId() {
        return operationId;
    }

    public void setOperationId(Integer operationId) {
        this.operationId = operationId;
    }

    @Id//代表是主键
    @GeneratedValue//代表是生成唯一主键
    private  Integer operationId;

    @NotBlank(message = "这个字段必传")
    private String operationName;

    @NotBlank(message = "这个字段必传")
    private String operationCode ;

    @NotBlank(message = "这个字段必传")
    private String sts;

    @NotBlank(message = "这个字段必传")
    private String stsDate;

    @NotBlank(message = "这个字段必传")
    private String createDate;



    public String getOperationName() {
        return operationName;
    }

    public void setOperationName(String operationName) {
        this.operationName = operationName;
    }

    public String getOperationCode() {
        return operationCode;
    }

    public void setOperationCode(String operationCode) {
        this.operationCode = operationCode;
    }

    public String getSts() {
        return sts;
    }

    public void setSts(String sts) {
        this.sts = sts;
    }

    public String getStsDate() {
        return stsDate;
    }

    public void setStsDate(String stsDate) {
        this.stsDate = stsDate;
    }

    public String getCreateDate() {
        return createDate;
    }

    public void setCreateDate(String createDate) {
        this.createDate = createDate;
    }
}

创建继承jpaRepository得类。

public interface OperationRepository extends JpaRepository<Operation, Integer> {
}

使用

使用junit测试——获取主键为1得数据库值。：

@RunWith(SpringRunner.class)
@SpringBootTest
public class Demo1ApplicationTests {

    @Autowired
    OperationRepository operationRepository;

	@Test
	public  void contextLoads() {
        System.out.println("获取operation表得值");
        Operation operation =operationRepository.findOne(1);
	}

}