Spring JPA

最新推荐文章于 2024-03-02 16:06:52 发布

weixin_43985399

最新推荐文章于 2024-03-02 16:06:52 发布

阅读量109

点赞数

分类专栏： springboot

本文链接：https://blog.csdn.net/weixin_43985399/article/details/125372389

版权

spring java servlet

springboot 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

一、导入依赖

        <!-- MySQL:Begin -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
		<!-- MySQL:End -->
		
		<!-- JPA：Begin -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-jpa</artifactId>
		</dependency>
		<!-- JPA：End -->

二、配置文件

server.port = 8080
server.context-path=/
 
#-------------------JPA配置-------------------
spring.datasource.url = jdbc:mysql://10.211.55.4:3306/t_mybatis?characterEncoding=UTF-8&useSSL=false&zeroDateTimeBehavior=convertToNull
spring.datasource.username = root
spring.datasource.password = Aa123123.
spring.datasource.driverClassName = com.mysql.jdbc.Driver
# Specify the DBMS
spring.jpa.database = MYSQL
# Show or not log for each sql query输入sql语句
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

三、mapper类

继承CrudRepository<实体类,主键类型>

四、自定义sql

@Query(value="sql语句",nativeQuery=true)

@Modifying

@Transactional

五、controller类

直接调用方法