POM.xml 依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- Springboot整合JPA -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
实体类:
import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import com.alibaba.fastjson.annotation.JSONField;
@Entity
@Table(name = "vo_user") // 自动生成表,可以指定表明及默认
public class UserVO {
@Id // 指定主键及自增
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
@Column(name = "user_name") // 指定默认表中字段名,不指定默认
private String username;
private String password;
private String nickname;
private String salt;// 盐值
private int age;
private String gender;
private String email;
private String phone;
@JSONField(format = "yyyy-MM-dd HH:mm:ss")
private Date brithday;
@JSONField(format = "yyyy-MM-dd HH:mm:ss")
private Date createTime;
@JSONField(format = "yyyy-MM-dd HH:mm:ss")
private Date modifyTime;
@JSONField(format = "yyyy-MM-dd HH:mm:ss")
private Date lastLoginTime;
//省略getter/setter方法
}
Dao层:
package com.feifan1.jpa;
import org.springframework.data.jpa.repository.JpaRepository;
// JpaRepository<T, ID> //第一个参数为实体类类型,第二个为表主键,复合主键必须实现序列化
public interface UserVoDao extends JpaRepository<UserVO, Integer> {
}
- application.properties
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.username=root
spring.datasource.password=root
#让控制器输出json字符串格式
spring.jackson.serialization.indent-output=true
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true
spring.jpa.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
- 主类
@SpringBootApplication(scanBasePackages = "com.feifan.controller")
@EntityScan("com.feifan.controller")//扫描实体类的包
@EnableJpaRepositories(basePackages = "com.feifan.controller")//扫描dao层接口的包
public class Run {
public static void main(String[] args) {
SpringApplication.run(Run.class, args);
}
}
测试完成。