The primary goal of the Spring Data project is to make it easier to build Spring-powered applications that use new data access technologies such as non-relational databases, map-reduce frameworks, and cloud based data services.
Spring Data JDBC, part of the larger Spring Data family, makes it easy to implement JDBC based repositories. This module deals with enhanced support for JDBC based data access layers. It makes it easier to build Spring powered applications that use data access technologies.
It aims at being conceptually easy. In order to achieve this it does NOT offer caching, lazy loading, write behind or many other features of JPA. This makes Spring Data JDBC a simple, limited, opinionated ORM.
Implementation of CRUD methods for Aggregates.
@Query
annotation
Support for transparent auditing (created, last changed)
Events for persistence events
Possibility to integrate custom repository code
JavaConfig based repository configuration by introducing EnableJdbcRepository
Integration with MyBatis
This project is governed by the Spring Code of Conduct. By participating, you are expected to uphold this code of conduct. Please report unacceptable behavior to spring-code-of-conduct@pivotal.io.
Here is a quick teaser of an application using Spring Data Repositories in Java:
public interface PersonRepository extends CrudRepository<Person, Long> {
@Query("SELECT * FROM person WHERE lastname = :lastname")
List<Person> findByLastname(String lastname);
@Query("SELECT * FROM person WHERE firstname LIKE :firstname")
List<Person> findByFirstnameLike(String firstname);
}
@Service
public class MyService {
private final PersonRepository repository;
public MyService(PersonRepository repository) {
this.repository = repository;
}
public void doWork() {
repository.deleteAll();
Person person = new Person();
person.setFirstname("Jens");
person.setLastname("Schauder");
repository.save(person);
List<Person> lastNameResults = repository.findByLastname("Schauder");
List<Person> firstNameResults = repository.findByFirstnameLike("Je%");
}
}
@Configuration
@EnableJdbcRepositories
class ApplicationConfig extends AbstractJdbcConfiguration {
@Bean
public DataSource dataSource() {
return …;
}
@Bean
public NamedParameterJdbcTemplate namedParameterJdbcTemplate(DataSource dataSource) {
return new NamedParameterJdbcTemplate(dataSource);
}
}
Add the Maven dependency:
<dependency>
<groupId>org.springframework.data</groupId>
<artifactId>spring-data-jdbc</artifactId>
<version>${version}.RELEASE</version>
</dependency>
If you’d rather like the latest snapshots of the upcoming major version, use our Maven snapshot repository and declare the appropriate dependency version.
<dependency>
<groupId>org.springframework.data</groupId>
<artifactId>spring-data-jdbc</artifactId>
<version>${version}.BUILD-SNAPSHOT</version>
</dependency>
<repository>
<id>spring-libs-snapshot</id>
<name>Spring Snapshot Repository</name>
<url>https://repo.spring.io/libs-snapshot</url>
</repository>
Having trouble with Spring Data? We’d love to help!
If you are new to Spring Data JDBC read the following two articles "Introducing Spring Data JDBC" and "Spring Data JDBC, References, and Aggregates".
Check the reference documentation, and Javadocs.
Learn the Spring basics – Spring Data builds on Spring Framework, check the spring.io web-site for a wealth of reference documentation. If you are just starting out with Spring, try one of the guides.
If you are upgrading, check out the changelog for “new and noteworthy” features.
Ask a question - we monitor stackoverflow.com for questions tagged with spring-data-jdbc
.
You can also chat with the community on Gitter.
Report bugs with Spring Data JDBC at Spring Data issue].
Spring Data uses GitHub as issue tracking system to record bugs and feature requests. If you want to raise an issue, please follow the recommendations below:
Before you log a bug, please search the Spring Data issue[issue tracker] to see if someone has already reported the problem.
If the issue doesn’t already exist, Spring Data issue[create a new issue].
Please provide as much information as possible with the issue report, we like to know the version of Spring Data that you are using and JVM version. Please include full stack traces when applicable.
If you need to paste code, or include a stack trace use triple backticks before and after your text.
If possible try to create a test-case or project that replicates the issue. Attach a link to your code or a compressed file containing your code. Use an in-memory database when possible. If you need a different database include the setup using Testcontainers in your test.
You don’t need to build from source to use Spring Data (binaries in repo.spring.io), but if you want to try out the latest and greatest, Spring Data can be easily built with the maven wrapper. You also need JDK 1.8.
$ ./mvnw clean install
If you want to build with the regular mvn
command, you will need Maven v3.5.0 or above.
Also see CONTRIBUTING.adoc if you wish to submit pull requests, and in particular please sign the Contributor’s Agreement before your first non-trivial change.
$ ./mvnw clean install
Runs integration test against a single in memory database.
To run integration tests against all supported databases specify the Maven Profile all-dbs
.
./mvnw clean install -Pall-dbs
This requires an appropriate container-license-acceptance.txt
to be on the classpath, signaling that you accept the license of the databases used.
If you don’t want to accept these licences you may add the Maven Profile ignore-missing-license
.
This will ignore the tests that require an explicit license acceptance.
./mvnw clean install -Pall-dbs,ignore-missing-license
If you want to run an integration tests against a different database you can do so by activating an apropriate Spring Profile. Available are the following Spring Profiles:
db2
, h2
, hsql
(default), mariadb
, mssql
, mysql
, oracle
, postgres
There are a number of modules in this project, here is a quick overview:
Spring Data Relational: Common infrastructure abstracting general aspects of relational database access.
Spring Data JDBC: Repository support for JDBC-based datasources.
Spring Data Examples contains example projects that explain specific features in more detail.
Spring Data JDBC is Open Source software released under the Apache 2.0 license.
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。