Spring Boot实战之Rest接口开发及数据库基本操作

最新推荐文章于 2025-06-19 11:26:45 发布

sun_t89

最新推荐文章于 2025-06-19 11:26:45 发布

阅读量3.7w

点赞数 11

CC 4.0 BY-SA版权

分类专栏： Spring-Boot实战 spring boot实战开发文章标签： spring mysql rest spring-boot JPA

本文链接：https://blog.youkuaiyun.com/sun_t89/article/details/51912905

Spring Boot实战之Rest接口开发及数据库基本操作

本文源码下载：

http://download.youkuaiyun.com/detail/sun_t89/9576427

1、修改pom.xml，添加依赖库,本文使用的是mysql

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

2、修改配置文件application.properties，配置数据源及java持久层API相关信息

spring.datasource.url = jdbc:mysql://127.0.0.1:3306/springlearn
spring.datasource.username = root
spring.datasource.password = root
spring.datasource.driverClassName = com.mysql.jdbc.Driver


# 配置数据库
spring.jpa.database = MYSQL
# 查询时是否显示日志
spring.jpa.show-sql = true
# Hibernate ddl auto (create, create-drop, update)
spring.jpa.hibernate.ddl-auto = update
# Naming strategy
spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy
# stripped before adding them to the entity manager)
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

3、添加数据模型 UserInfo.java

package com.xiaofangtech.sunt.bean;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.validation.constraints.NotNull;

@Entity
@Table(name="t_user")
public class UserInfo {
	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	private int id;
	@NotNull
	private String name;
	
	private String password;
	
	private String salt;
	
	private String role;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public vo