The content of this article is about using Spring Data JPA to connect to the database in Spring Boot. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.
I used to use Mybatis for database development. Recently, after learning Spring Boot, I found that JPA is more friendly, so let’s learn about the principles of JPA together.
Spring Data JPA
A brief introduction to JPA
Java Persistence API (JPA) is a specification of Java. It is used to save data between Java objects and relational databases.
JPA acts as a bridge between object-oriented domain models and relational database systems. Since JPA is just a specification, it does nothing by itself. It requires an implementation. Therefore, ORM tools like Hibernate, TopLink and iBatis implement the JPA data persistence specification.
Spring Data JPA is a set of JPA application frameworks encapsulated by Spring based on the ORM framework and JPA specifications, which allows developers to access and operate data with minimalist code. It provides common functions including adding, deleting, modifying, checking, etc., and is easy to expand! Learning and using Spring Data JPA can greatly improve development efficiency!
Basic query
Spring Data JPA has implemented some basic database operations, including basic addition, deletion, modification and query.
First, you need to introduce relevant dependencies in pom.xml.
<dependency> <groupid>mysql</groupid> <artifactid>mysql-connector-java</artifactid> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-data-jpa</artifactid> </dependency>
Second, you need to add database-related configuration and jpa-related configuration in the application.properties configuration file
#配置数据源 spring.datasource.driver-class-name=com.mysql.jdbc.Driver spring.datasource.url=jdbc:mysql://localhost:3306/springboot spring.datasource.username=username spring.datasource.password=password #jpa数据库表格创建的方式,和控制台sql的打印 jpa.hibernate.ddl-auto=update jpa.hibernate.show-sql=true
Third, write the entity class.
Under normal circumstances, if we add the annotation @Entity to the entity class, the entity class will be related to the table.If we don’t need to associate one of the attributes with the database and just do calculations during display, we only need to add the @Transient attribute.
@Id identifies the primary key
@GeneratedValue is the auto-increment method of the specified primary key.
Fourth, write the query method.
Just write an interface to implement the JpaRepository interface:You need to add two parameters after JpaRepository, one is the entity class, and the other is the type of the primary key.
After inheriting JpaRepository, you can use the simple addition, deletion, modification and search functions.
@Test public void testBaseQuery() throws Exception { Girl girl=new Girl(); userRepository.findAll(); userRepository.findOne(1); userRepository.save(girl); userRepository.delete(girl); // ... }
Customized simple query
Because this can only satisfy our basic query, if we don’t want to follow the query he gave us, do we need to write our own query statement? ? The answer is definitely no. We can still generate some query statements according to JPA rules.
A custom simple query is to automatically generate SQL based on the method name. The main syntax is findXXBy, readAXXBy, queryXXBy, countXXBy, getXXBy followed by the attribute name:
Complex Query
Here we need to write sql ourselves. Let’s take a look at what needs to be paid attention to.Use the @Query annotation on the SQL query method. If deletion and modification are involved, add @Modifying as needed. You can also add @Transactional support for things, query timeout settings, etc. as needed.
Note: When writing Query, the table name in the HQL statement should be the class name mapped by the ORM.
//传单个值的时候 @Query("select u from User u where u.age = ?#{[0]}") List<user> findUsersByAge(int age); //传多个值的时候 @Query("select u from User u where u.firstname = :#{#customer.firstname}") List<user> findUsersByCustomersFirstname(@Param("customer") Customer customer)</user></user>
The above is the detailed content of Using Spring Data JPA to connect to the database in Spring Boot. For more information, please follow other related articles on the PHP Chinese website!

c盘的users是用户文件夹,主要存放用户的各项配置文件。users文件夹是windows系统的重要文件夹,不能随意删除;它保存了很多用户信息,一旦删除会造成数据丢失,严重的话会导致系统无法启动。

启动任务管理器的三个快捷键是:1、“Ctrl+Shift+Esc”,可直接打开任务管理器;2、“Ctrl+Alt+Delete”,会进入“安全选项”的锁定界面,选择“任务管理器”,即可以打开任务管理器;3、“Win+R”,会打开“运行”窗口,输入“taskmgr”命令,点击“确定”即可调出任务管理器。

PIN码是Windows系统为了方便用户本地登录而独立于window账户密码的快捷登录密码,是Windows系统新添加的一套本地密码策略;在用户登陆了Microsoft账户后就可以设置PIN来代替账户密码,不仅提高安全性,而且也可以让很多和账户相关的操作变得更加方便。PIN码只能通过本机登录,无法远程使用,所以不用担心PIN码被盗。

对于刚刚开始使用PHP的用户来说,如果在Windows操作系统中遇到了“php不是内部或外部命令”的问题,可能会感到困惑。这个错误通常是由于系统无法识别PHP的路径导致的。在本文中,我将为您提供一些可能会导致这个问题的原因和解决方法,以帮助您快速解决这个问题。

win10自带的onenote是UWP版本;onenote是一套用于自由形式的信息获取以及多用户协作工具,而UWP版本是“Universal Windows Platform”的简称,表示windows通用应用平台,不是为特定的终端设计的,而是针对使用windows系统的各种平台。

因为win10系统是不自带扫雷游戏的,需要用户自行手动安装。安装步骤:1、点击打开“开始菜单”;2、在打开的菜单中,找到“Microsoft Store”应用商店,并点击进入;3、在应用商店主页的搜索框中,搜索“minesweeper”;4、在搜索结果中,点击选择需要下载的“扫雷”游戏;5、点击“获取”按钮,等待获取完毕后自动完成安装游戏即可。

windows操作系统的特点包括:1、图形界面;直观高效的面向对象的图形用户界面,易学易用。2、多任务;允许用户同时运行多个应用程序,或在一个程序中同时做几件事情。3、即插即用。4、出色的多媒体功能。5、对内存的自动化管理。

在windows中鼠标指针呈四箭头时一般表示选中对象可以上、下、左、右移动。在Windows中鼠标指针首次用不同的指针来表示不同的状态,如系统忙、移动中、拖放中;在Windows中使用的鼠标指针文件还被称为“光标文件”或“动态光标文件”。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SublimeText3 Linux new version
SublimeText3 Linux latest version

Notepad++7.3.1
Easy-to-use and free code editor

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

Dreamweaver CS6
Visual web development tools
