Spring Boot 使用JPA实现Mysql数据crud

创建一个SpringBoot基础项目

1.pom.xml引入相关依赖

<?xml version="1.0" encoding="UTF-8"?>
<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.example</groupId>
	<artifactId>AccessDataToMySQL</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>AccessDataToMySQL</name>
	<description>Demo project for Spring Boot</description>

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

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<java.version>1.8</java.version>
	</properties>

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

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<!-- jpa data 依赖 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-jpa</artifactId>
		</dependency>
		
		<!-- myssql 驱动 -->
		 <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>


</project>

2.在Mysql中创建user表，配置好配置文件

spring.jpa.hibernate.ddl-auto=create
spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.username=root
spring.datasource.password=root

3.实体层

@Entity
public class User {
	@Id
	@GeneratedValue
	private Long id;
	private String name;

	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;
	}

}

4.数据仓库接口

/**
 * @Description: User 数据仓库接口
 * @author QuiFar
 * @date 2017年9月9日 下午1:26:10
 * @version V1.0
 */
public interface UserRepository extends CrudRepository<User, Long> {

}

5.控制层

/**
 * @Description: 用户的控制层
 * @author QuiFar
 * @date 2017年9月9日 下午1:34:26
 * @version V1.0
 */
@Controller
public class UserController {

	@Autowired
	private UserRepository userRepository;

	@GetMapping(path = "/")
	@ResponseBody
	public String index() {
		return "OK";
	}

	/**
	 * 增加用户信息
	 * 
	 * @return
	 */
	@ResponseBody
	@GetMapping(path = "/add")
	public String addUser(@RequestParam String name) { // @RequestParam注解表示这是来自Get或Post请求的一个参数
		User user = new User();
		user.setName(name);
		userRepository.save(user);
		return "save ok!";
	}

	/**
	 * 获取所有用户信息
	 * 
	 * @return
	 */
	@ResponseBody
	@GetMapping(path = "/all")
	public Iterable<User> getUsers() {
		return userRepository.findAll();
	}

	/**
	 * 删除用户信息
	 * 
	 * @param id
	 * @return
	 */
	@ResponseBody
	@GetMapping(path = "/delete")
	public String delete(@RequestParam Long id) {
		userRepository.delete(id);
		return "delete " + id + " OK!";
	}

}

6.开启项目，访问地址 http://localhost:8080/add?name=quifar，成功增加一条数据

转载于:https://my.oschina.net/quifar/blog/1532315