Spring Boot 与Hibernate Jpa的快速集成

Spring Boot与MySQL集成实战

最新推荐文章于 2025-06-17 09:11:16 发布

我会有你不放弃

最新推荐文章于 2025-06-17 09:11:16 发布

阅读量155

点赞数

CC 4.0 BY-SA版权

分类专栏： java技术文章标签： java

本文链接：https://blog.youkuaiyun.com/weixin_41025381/article/details/80137988

java技术专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍了一个基于Spring Boot框架的简易应用搭建过程，重点介绍了如何整合MySQL数据库，包括pom.xml依赖配置、数据库连接配置、实体类定义、Repository层接口、Service层实现及Controller层接口等关键步骤。

1.pom依赖

  <parent>  
        <groupId>org.springframework.boot</groupId>  
        <artifactId>spring-boot-starter-parent</artifactId>  
        <version>1.3.0.RELEASE</version>  
        <relativePath />  
   </parent>  
   <dependencies>
   	 <dependency>  
        <groupId>org.springframework.boot</groupId>  
        <artifactId>spring-boot-starter-web</artifactId>  
    </dependency>  
    <!-- spring boot核心,包括自动配置支持，日志和YAML -->  
    <dependency>  
        <groupId>org.springframework.boot</groupId>  
        <artifactId>spring-boot-starter</artifactId>  
    </dependency>  
    <dependency>  
        <groupId>org.springframework.boot</groupId>  
        <artifactId>spring-boot-starter-test</artifactId>  
    </dependency>  
    <!-- DevTools in Spring Boot 项目热部署 -->  
    <dependency>  
        <groupId>org.springframework.boot</groupId>  
        <artifactId>spring-boot-devtools</artifactId>  
    </dependency>
    <!-- hibernate 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>
   </dependencies>

2.包结构

3.配置文件

### 数据库连接
spring.jpa.hibernate.ddl-auto=update
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mytest?characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=root

# 自动更新表
spring.jpa.properties.hibernate.hbm2ddl.auto=update
# 使用MYSQL5作为数据库访问方言
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
#显示sql语句
spring.jpa.properties.hibernate.show_sql=true

##tomcat##
server.tomcat.uri-encoding=UTF-8

4.启动类

@SpringBootApplication
public class Application {
	public static void main(String[] args) {
		 SpringApplication.run(Application.class, args);  
	}
}

5.Controller层

@Controller
public class TestController {
	
	@Autowired
	private UserService userService;
	
	@RequestMapping(value = "save")
	public void save(){
		User user = new User();
		user.setName("name");
		user.setId(1);
		userService.saveUser(user);
	}
}

6.service层

@Service
public class UserService {

	@Autowired
	private UserRepository userRepository ;
	
	public void saveUser(User user){
		userRepository.save(user);
	}
}

7.Repository层

public interface UserRepository extends JpaRepository<User, Integer>{

}

8.实体类

@Entity
@Table(name="t_user")
public class User {

	@Id
	@GeneratedValue(strategy=GenerationType.IDENTITY)
	private Integer id;
	
	private String name;
	
	private Integer age;
	
	private String address;
	
	....