注解配置 mysql_java使用JPA和mysql配置注解方式

创建项目

首先我使用的是Intellij IDEA，在idea中使用spring boot，spring boot版本选择了1.5.7。

创建完项目并且导入依赖后创建jpa的config

jpaconfig

package com.tal.demoes1.config;

import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;

import org.springframework.boot.context.properties.ConfigurationProperties;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import org.springframework.data.jpa.repository.config.EnableJpaRepositories;

import org.springframework.orm.jpa.JpaTransactionManager;

import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;

import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;

import org.springframework.transaction.PlatformTransactionManager;

import org.springframework.transaction.annotation.EnableTransactionManagement;

import javax.persistence.EntityManagerFactory;

import javax.sql.DataSource;

import java.lang.management.PlatformLoggingMXBean;

@Configuration

@EnableJpaRepositories(basePackages = "com.tal.demoes1.repository")

@EnableTransactionManagement

public class JPAConfig {

//建立数据源

@Bean

@ConfigurationProperties(prefix = "spring.datasource")

public DataSource dataSource() {

return DataSourceBuilder.create().build();

}

//实体类的管理工厂

@Bean

public LocalContainerEntityManagerFactoryBean entityManagerFactory() {

//实例化jpa适配器，由于使用的是hibernate所以用hibernatejpavendor

HibernateJpaVendorAdapter japVendor = new HibernateJpaVendorAdapter();

//不生成sql

japVendor.setGenerateDdl(false);

//实例化管理工厂

LocalContainerEntityManagerFactoryBean entityManagerFactory = new LocalContainerEntityManagerFactoryBean();

entityManagerFactory.setDataSource(dataSource());

entityManagerFactory.setJpaVendorAdapter(japVendor);

//设置扫描包名

entityManagerFactory.setPackagesToScan("com.tal.demoes1.entity");

return entityManagerFactory;

}

//事务管理

@Bean

public PlatformTransactionManager transactionManager(EntityManagerFactory entityManagerFactory) {

//实例化

JpaTransactionManager transactionManager = new JpaTransactionManager();

transactionManager.setEntityManagerFactory(entityManagerFactory);

return transactionManager;

}

}

先注解这是一个configuration，然后配置JPA的自动扫描基础包为(“你的就构的包名”)，最后是自动事务管理注解

关于事务管理器，不管是JPA还是JDBC等都实现自接口 PlatformTransactionManager 如果你添加的是 spring-boot-starter-jdbc 依赖，框架会默认注入 DataSourceTransactionManager 实例。如果你添加的是 spring-boot-starter-data-jpa 依赖，框架会默认注入 JpaTransactionManager 实例。

yml配置

application.yml

spring:

profiles:

# active: prod

active: dev

#active: test

dev

server:

port: 8880

spring:

session:

store-type: hash_map

jpa:

#database-platform: org.hibernate.dialect.My5SQL5Dialect

hibernate:

ddl-auto: create

show-sql: true

database: mysql

# properties:

# hibernate.dialect: org.hibernate.dialect.My5SQL5Dialect

datasource:

driver-class-name: com.mysql.jdbc.Driver

url: jdbc:mysql://localhost:3306/xunwu

username: root

password: root

logging:

level:

root: debug

security:

basic:

enabled: false

然后实现一个jpa的接口继承jpa

此时的结构

package com.tal.demoes1.repository;

import com.tal.demoes1.entity.User;

import org.springframework.data.repository.CrudRepository;

public interface UserRepository extends CrudRepository{

}

然后我们在entity写一个实体类User

package com.tal.demoes1.entity;

import org.springframework.security.core.GrantedAuthority;

import org.springframework.security.core.userdetails.UserDetails;

import javax.persistence.*;

import java.util.Collection;

import java.util.Date;

import java.util.List;

@Entity

@Table(name = "user")

public class User {

@Id

@GeneratedValue(strategy = GenerationType.IDENTITY)

private Long id;

private String name;

private String password;

private String email;

@Column(name = "phone_number")

private String phoneNumber;

private int status;

@Column(name = "create_time")

private Date createTime;

@Column(name = "last_login_time")

private Date lastLoginName;

@Column(name = "last_update_time")

private Date lastUpdateTime;

private String avatar;

public Long getId() {

return id;

}

public void setId(Long id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public void setPassword(String password) {

this.password = password;

}

public String getEmail() {

return email;

}

public void setEmail(String email) {

this.email = email;

}

public String getPhoneNumber() {

return phoneNumber;

}

public void setPhoneNumber(String phoneNumber) {

this.phoneNumber = phoneNumber;

}

public int getStatus() {

return status;

}

public void setStatus(int status) {

this.status = status;

}

public Date getCreateTime() {

return createTime;

}

public void setCreateTime(Date createTime) {

this.createTime = createTime;

}

public Date getLastLoginName() {

return lastLoginName;

}

public void setLastLoginName(Date lastLoginName) {

this.lastLoginName = lastLoginName;

}

public Date getLastUpdateTime() {

return lastUpdateTime;

}

public void setLastUpdateTime(Date lastUpdateTime) {

this.lastUpdateTime = lastUpdateTime;

}

public String getAvatar() {

return avatar;

}

public void setAvatar(String avatar) {

this.avatar = avatar;

}

}

然后写一个单元测试类来测试

`package com.tal.demoes1.entity;

import com.tal.demoes1.ApplicationTests;

import com.tal.demoes1.repository.UserRepository;

import org.junit.Assert;

import org.junit.Test;

import org.springframework.beans.factory.annotation.Autowired;

public class UserRepositoryTest extends ApplicationTests {

@Autowired

private UserRepository userRepository;

@Test

public void testFindOne(){

User user = userRepository.findOne(1L);

Assert.assertEquals("waliwali",user.getName());

}

}

`