queryDSL复杂查询的分页和自定义排序实现

使用Spring JPA中Page、Pageable接口和Sort类完成分页排序

Jpa 自动更新表中的创建日期和修改时间

Querydsl无法生成实体对应的查询Q类记录

Spring Data JPA进阶（六）：事务和锁

Hibernate在控制台打印sql语句以及参数

Spring Data JPA中多表联合查询最佳实践

MyBatis为什么在国内相当流行?

spring-data-jpa和mybatis可以整合在一起使用有什么优缺点？

ddl-auto

A persistence context is a set of entity instances in which for any persistent entity identity there is a unique entity instance

you may want to add a mappedBy="addressOwner" attribute to your User to signal to the persistence provider that the join column should be in the ADDRESS table.

SqlResultSetMapping

2.3.2. Mapping native queries You can also map a native query (ie a plain SQL query). To achieve that, you need to describe the SQL resultset structure using @SqlResultSetMapping (or @SqlResultSetMappings if you plan to define several resulset mappings). Like @NamedQuery, a @SqlResultSetMapping can be defined at class level or in a JPA XML file. However its scope is global to the application.

@SqlResultSetMappings( { @SqlResultSetMapping(name = "ProfessorWithAddress", entities = { @EntityResult(entityClass = Professor.class), @EntityResult(entityClass = Address.class) }) })

Use @FieldResult in the SqlResultSetMapping, to link each entity property to its column alias