1. 使用maven构建SpringBoot的名叫spring-boot-jpa项目
2. Spring Data jpa的启动器、mysq数据库和c3p0缓存池的jar
3. pom.xml
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.bjbs</groupId>
<artifactId>spring-boot-jpa</artifactId>
<version>0.0.1-SNAPSHOT</version>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>1.5.13.RELEASE</version>
</parent>
<!-- 修改jdk版本 -->
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<!-- springBoot的启动器 -->
<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>
<!-- mysql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.27</version>
</dependency>
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.2</version>
</dependency>
</dependencies>
</project>
4. 在src/main/resources下, 新建application.properties, 在这里配置数据库信息即可。
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://192.168.25.138:3306/StudyMybatis?useSSL=true&useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=lyw123456
spring.datasource.type=com.mchange.v2.c3p0.ComboPooledDataSource
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true
5. 新建User.java
package com.bjbs.pojo;
import java.io.Serializable;
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 org.springframework.format.annotation.DateTimeFormat;
@Entity//实体类
@Table(name = "user")//指定数据库表名
public class User implements Serializable {
private static final long serialVersionUID = 1L;
@Id//主键
@GeneratedValue(strategy = GenerationType.IDENTITY)// 主键生成策略
@Column(name = "id")//指定表中的列名
private Integer id;
@Column(name = "name")
private String name;
@Column(name = "sex")
private String sex;
@Column(name = "birthday")
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date birthday;
@Column(name = "address")
private String address;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
@Override
public String toString() {
return "User [id=" + id + ", name=" + name + ", sex=" + sex + ", birthday=" + birthday + ", address=" + address
+ "]";
}
}
6. 新建UserRepository.java
package com.bjbs.dao;
import org.springframework.data.jpa.repository.JpaRepository;
import com.bjbs.pojo.User;
/**
* 参数一T: 当前需要映射的实体; 参数二 T: 当前映射的实体中的id的类型
*/
public interface UserRepository extends JpaRepository<User, Integer> {
}
7. 新建UserService.java
package com.bjbs.service;
import com.bjbs.pojo.User;
public interface UserService {
User updateUserById(Integer id);
}
8. 新建UserServiceImpl.java
package com.bjbs.service.impl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.bjbs.dao.UserRepository;
import com.bjbs.pojo.User;
import com.bjbs.service.UserService;
@Service
@Transactional
public class UserServiceImpl implements UserService {
@Autowired
private UserRepository userRepository;
@Override
public User updateUserById(Integer id) {
User userDb = userRepository.findOne(id);
userDb.setAddress("河南省郑州市高新区");
return userRepository.save(userDb);
}
}
9. 新建UserController.java
package com.bjbs.controller;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.bjbs.pojo.User;
import com.bjbs.service.UserService;
@RestController
public class UserController {
@Autowired
private UserService userService;
@RequestMapping("update")
public User update() {
return userService.updateUserById(32);
}
}
10. 新建App.java
package com.bjbs;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
/**
* springBoot启动类
*/
@SpringBootApplication
public class App {
public static void main(String[] args) {
SpringApplication.run(App.class, args);
}
}
11. 数据库user表
12. 运行项目