spring data JPA的使用

    <div id="post_detail">

spring boot(五):spring data jpa的使用

在上篇文章springboot(二):web综合开发中简单介绍了一下spring data jpa的基础性使用,这篇文章将更加全面的介绍spring data jpa 常见用法以及注意事项

使用spring data jpa 开发时,发现国内对spring boot jpa全面介绍的文章比较少案例也比较零碎,因此写文章总结一下。本人也正在翻译Spring Data JPA 参考指南,有兴趣的同学欢迎联系我,一起加入翻译中!


spring data jpa介绍

首先了解JPA是什么?

JPA(Java Persistence API)是Sun官方提出的Java持久化规范。它为Java开发人员提供了一种对象/关联映射工具来管理Java应用中的关系数据。他的出现主要是为了简化现有的持久化开发工作和整合ORM技术,结束现在Hibernate,TopLink,JDO等ORM框架各自为营的局面。值得注意的是,JPA是在充分吸收了现有Hibernate,TopLink,JDO等ORM框架的基础上发展而来的,具有易于使用,伸缩性强等优点。从目前的开发社区的反应上看,JPA受到了极大的支持和赞扬,其中就包括了Spring与EJB3.0的开发团队。

注意:JPA是一套规范,不是一套产品,那么像Hibernate,TopLink,JDO他们是一套产品,如果说这些产品实现了这个JPA规范,那么我们就可以叫他们为JPA的实现产品。

spring data jpa

Spring Data JPA 是 Spring 基于 ORM 框架、JPA 规范的基础上封装的一套JPA应用框架,可使开发者用极简的代码即可实现对数据的访问和操作。它提供了包括增删改查等在内的常用功能,且易于扩展!学习并使用 Spring Data JPA 可以极大提高开发效率!

spring data jpa让我们解脱了DAO层的操作,基本上所有CRUD都可以依赖于它来实现


基本查询

基本查询也分为两种,一种是spring data默认已经实现,一种是根据查询的方法来自动解析成SQL。

预先生成方法

spring data jpa 默认预先生成了一些基本的CURD的方法,例如:增、删、改等等

1 继承JpaRepository

public interface UserRepository extends JpaRepository<User, Long> {
}

2 使用默认方法

@Test
public void testBaseQuery() throws Exception {
    User user=new User();
    userRepository.findAll();
    userRepository.findOne(1l);
    userRepository.save(user);
    userRepository.delete(user);
    userRepository.count();
    userRepository.exists(1l);
    // ...
}

就不解释了根据方法名就看出意思来

自定义简单查询

自定义的简单查询就是根据方法名来自动生成SQL,主要的语法是findXXBy,readAXXBy,queryXXBy,countXXBy, getXXBy后面跟属性名称:

User findByUserName(String userName);

也使用一些加一些关键字AndOr

User findByUserNameOrEmail(String username, String email);

修改、删除、统计也是类似语法

Long deleteById(Long id);

Long countByUserName(String userName)

基本上SQL体系中的关键词都可以使用,例如:LIKEIgnoreCaseOrderBy

List<User> findByEmailLike(String email);

User findByUserNameIgnoreCase(String userName);

List<User> findByUserNameOrderByEmailDesc(String email);

具体的关键字,使用方法和生产成SQL如下表所示

KeywordSampleJPQL snippet
AndfindByLastnameAndFirstname… where x.lastname = ?1 and x.firstname = ?2
OrfindByLastnameOrFirstname… where x.lastname = ?1 or x.firstname = ?2
Is,EqualsfindByFirstnameIs,findByFirstnameEquals… where x.firstname = ?1
BetweenfindByStartDateBetween… where x.startDate between ?1 and ?2
LessThanfindByAgeLessThan… where x.age < ?1
LessThanEqualfindByAgeLessThanEqual… where x.age ⇐ ?1
GreaterThanfindByAgeGreaterThan… where x.age > ?1
GreaterThanEqualfindByAgeGreaterThanEqual… where x.age >= ?1
AfterfindByStartDateAfter… where x.startDate > ?1
BeforefindByStartDateBefore… where x.startDate < ?1
IsNullfindByAgeIsNull… where x.age is null
IsNotNull,NotNullfindByAge(Is)NotNull… where x.age not null
LikefindByFirstnameLike… where x.firstname like ?1
NotLikefindByFirstnameNotLike… where x.firstname not like ?1
StartingWithfindByFirstnameStartingWith… where x.firstname like ?1 (parameter bound with appended %)
EndingWithfindByFirstnameEndingWith… where x.firstname like ?1 (parameter bound with prepended %)
ContainingfindByFirstnameContaining… where x.firstname like ?1 (parameter bound wrapped in %)
OrderByfindByAgeOrderByLastnameDesc… where x.age = ?1 order by x.lastname desc
NotfindByLastnameNot… where x.lastname <> ?1
InfindByAgeIn(Collection ages)… where x.age in ?1
NotInfindByAgeNotIn(Collection age)… where x.age not in ?1
TRUEfindByActiveTrue()… where x.active = true
FALSEfindByActiveFalse()… where x.active = false
IgnoreCasefindByFirstnameIgnoreCase… where UPPER(x.firstame) = UPPER(?1)


复杂查询

在实际的开发中我们需要用到分页、删选、连表等查询的时候就需要特殊的方法或者自定义SQL

分页查询

分页查询在实际使用中非常普遍了,spring data jpa已经帮我们实现了分页的功能,在查询的方法中,需要传入参数Pageable
,当查询中有多个参数的时候Pageable建议做为最后一个参数传入

Page<User> findALL(Pageable pageable);

Page<User> findByUserName(String userName,Pageable pageable);

Pageable 是spring封装的分页实现类,使用的时候需要传入页数、每页条数和排序规则

@Test
public void testPageQuery() throws Exception {
    int page=1,size=10;
    Sort sort = new Sort(Direction.DESC, "id");
    Pageable pageable = new PageRequest(page, size, sort);
    userRepository.findALL(pageable);
    userRepository.findByUserName("testName", pageable);
}

限制查询

有时候我们只需要查询前N个元素,或者支取前一个实体。

ser findFirstByOrderByLastnameAsc();

User findTopByOrderByAgeDesc();

Page<User> queryFirst10ByLastname(String lastname, Pageable pageable);

List<User> findFirst10ByLastname(String lastname, Sort sort);

List<User> findTop10ByLastname(String lastname, Pageable pageable);

自定义SQL查询

其实Spring data 觉大部分的SQL都可以根据方法名定义的方式来实现,但是由于某些原因我们想使用自定义的SQL来查询,spring data也是完美支持的;在SQL的查询方法上面使用@Query注解,如涉及到删除和修改在需要加上@Modifying.也可以根据需要添加 @Transactional 对事物的支持,查询超时的设置等

@Modifying
@Query("update User u set u.userName = ?1 where c.id = ?2")
int modifyByIdAndUserId(String  userName, Long id);

@Transactional
@Modifying
@Query(“delete from User where id = ?1”)
void deleteByUserId(Long id);

@Transactional(timeout = 10)
@Query(“select u from User u where u.emailAddress = ?1”)
User findByEmailAddress(String emailAddress);

多表查询

多表查询在spring data jpa中有两种实现方式,第一种是利用hibernate的级联查询来实现,第二种是创建一个结果集的接口来接收连表查询后的结果,这里主要第二种方式。

首先需要定义一个结果集的接口类。

public interface HotelSummary {
<span class="hljs-function">City <span class="hljs-title">getCity</span><span class="hljs-params">()</span></span>;

<span class="hljs-function">String <span class="hljs-title">getName</span><span class="hljs-params">()</span></span>;

<span class="hljs-function">Double <span class="hljs-title">getAverageRating</span><span class="hljs-params">()</span></span>;

<span class="hljs-function"><span class="hljs-keyword">default</span> Integer <span class="hljs-title">getAverageRatingRounded</span><span class="hljs-params">()</span> </span>{
    <span class="hljs-keyword">return</span> getAverageRating() == <span class="hljs-keyword">null</span> ? <span class="hljs-keyword">null</span> : (<span class="hljs-keyword">int</span>) Math.round(getAverageRating());
}

}

查询的方法返回类型设置为新创建的接口

@Query("select h.city as city, h.name as name, avg(r.rating) as averageRating "
        - "from Hotel h left outer join h.reviews r where h.city = ?1 group by h")
Page<HotelSummary> findByCity(City city, Pageable pageable);

@Query("select h.name as name, avg(r.rating) as averageRating "
- “from Hotel h left outer join h.reviews r group by h”)
Page<HotelSummary> findByCity(Pageable pageable);

使用

Page<HotelSummary> hotels = this.hotelRepository.findByCity(new PageRequest(0, 10, Direction.ASC, "name"));
for(HotelSummary summay:hotels){
        System.out.println("Name" +summay.getName());
    }

在运行中Spring会给接口(HotelSummary)自动生产一个代理类来接收返回的结果,代码汇总使用getXX的形式来获取


多数据源的支持

同源数据库的多源支持

日常项目中因为使用的分布式开发模式,不同的服务有不同的数据源,常常需要在一个项目中使用多个数据源,因此需要配置sping data jpa对多数据源的使用,一般分一下为三步:

  • 1 配置多数据源
  • 2 不同源的实体类放入不同包路径
  • 3 声明不同的包路径下使用不同的数据源、事务支持

这里有一篇文章写的很清楚:Spring Boot多数据源配置与使用

异构数据库多源支持

比如我们的项目中,即需要对mysql的支持,也需要对mongodb的查询等。

实体类声明@Entity 关系型数据库支持类型、声明@Document 为mongodb支持类型,不同的数据源使用不同的实体就可以了

interface PersonRepository extends Repository<Person, Long> {
 …
}

@Entity
public class Person {

}

interface UserRepository extends Repository<User, Long> {

}

@Document
public class User {

}

但是,如果User用户既使用mysql也使用mongodb呢,也可以做混合使用

interface JpaPersonRepository extends Repository<Person, Long> {
 …
}

interface MongoDBPersonRepository extends Repository<Person, Long> {

}

@Entity
@Document
public class Person {

}

也可以通过对不同的包路径进行声明,比如A包路径下使用mysql,B包路径下使用mongoDB

@EnableJpaRepositories(basePackages = "com.neo.repositories.jpa")
@EnableMongoRepositories(basePackages = "com.neo.repositories.mongo")
interface Configuration { }


其它

使用枚举

使用枚举的时候,我们希望数据库中存储的是枚举对应的String类型,而不是枚举的索引值,需要在属性上面添加@Enumerated(EnumType.STRING) 注解

@Enumerated(EnumType.STRING) 
@Column(nullable = true)
private UserType type;

不需要和数据库映射的属性

正常情况下我们在实体类上加入注解@Entity,就会让实体类和表相关连如果其中某个属性我们不需要和数据库来关联只是在展示的时候做计算,只需要加上@Transient属性既可。

@Transient
private String  userName;

源码案例

这里有一个开源项目几乎使用了这里介绍的所有标签和布局,大家可以参考:
cloudfavorites

参考

Spring Data JPA - Reference Documentation

Spring Data JPA——参考文档 中文版


作者:纯洁的微笑
出处:http://www.ityouknow.com/
版权所有,欢迎保留原文链接进行转载:)


作者:纯洁的微笑
出处:www.ityouknow.com
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。

本文如对您有帮助,还请多帮 【推荐】 下此文。
如果喜欢我的文章,请关注我的公众号

分类: springboot
标签: springboot jpa
41
0
« 上一篇: spring boot(四):thymeleaf使用详解
» 下一篇: spring boot 实战:我们的第一款开源软件
	</div>
	<div class="postDesc">posted @ <span id="post-date">2016-09-21 09:36</span> <a href="https://www.cnblogs.com/ityouknow/">纯洁的微笑</a> 阅读(<span id="post_view_count">111283</span>) 评论(<span id="post_comment_count">18</span>)  <a href="https://i.cnblogs.com/EditPosts.aspx?postid=5891443" rel="nofollow">编辑</a> <a href="#" onclick="AddToWz(5891443);return false;">收藏</a></div>
</div>
<script src="//common.cnblogs.com/highlight/9.12.0/highlight.min.js"></script><script>markdown_highlight();</script><script type="text/javascript">var allowComments=true,cb_blogId=96952,cb_entryId=5891443,cb_blogApp=currentBlogApp,cb_blogUserGuid='44ce118c-0edc-e011-8ee0-842b2b196315',cb_entryCreatedDate='2016/9/21 9:36:00';loadViewCount(cb_entryId);var cb_postType=1;var isMarkdown=true;</script>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3515759" class="layer">#1楼</a><a name="3515759" id="comment_anchor_3515759"></a>  <span class="comment_date">2016-09-21 09:57</span> <a id="a_comment_author_3515759" href="https://www.cnblogs.com/hyhnet/" target="_blank">千万之路刚开始</a> <a href="http://msg.cnblogs.com/send/%E5%8D%83%E4%B8%87%E4%B9%8B%E8%B7%AF%E5%88%9A%E5%BC%80%E5%A7%8B" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3515759" class="blog_comment_body">mark</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(3515759,'Digg',this)">支持(0)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(3515759,'Bury',this)">反对(0)</a></div><span id="comment_3515759_avatar" style="display:none;">http://pic.cnblogs.com/face/884303/20180508222805.png</span>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3515779" class="layer">#2楼</a><a name="3515779" id="comment_anchor_3515779"></a>  <span class="comment_date">2016-09-21 10:16</span> <a id="a_comment_author_3515779" href="https://www.cnblogs.com/Romantic/" target="_blank">Jared.Nie</a> <a href="http://msg.cnblogs.com/send/Jared.Nie" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3515779" class="blog_comment_body">我个人觉得内容还是有些浅显,很多都是大路边的东西,如果再能够深入一些就好了。</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(3515779,'Digg',this)">支持(2)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(3515779,'Bury',this)">反对(0)</a></div><span id="comment_3515779_avatar" style="display:none;">http://pic.cnblogs.com/face/31975/20160304111908.png</span>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3515837" class="layer">#3楼</a><a name="3515837" id="comment_anchor_3515837"></a>[<span class="louzhu">楼主</span>]  <span class="comment_date">2016-09-21 10:50</span> <a id="a_comment_author_3515837" href="https://www.cnblogs.com/ityouknow/" target="_blank">纯洁的微笑</a> <a href="http://msg.cnblogs.com/send/%E7%BA%AF%E6%B4%81%E7%9A%84%E5%BE%AE%E7%AC%91" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3515837" class="blog_comment_body"><a href="#3515779" title="查看所回复的评论" onclick="commentManager.renderComments(0,50,3515779);">@</a>

Jared.Nie
主要是介绍使用部分,您的是意思是探讨一下 jpa的实现原理。

http://pic.cnblogs.com/face/331425/20130328094900.png

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3515853" class="layer">#4楼</a><a name="3515853" id="comment_anchor_3515853"></a>  <span class="comment_date">2016-09-21 10:55</span> <a id="a_comment_author_3515853" href="https://www.cnblogs.com/jiwuyf/" target="_blank">姜师爷闯世界</a> <a href="http://msg.cnblogs.com/send/%E5%A7%9C%E5%B8%88%E7%88%B7%E9%97%AF%E4%B8%96%E7%95%8C" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3515853" class="blog_comment_body">实际情况下,业务查询都是非常复杂的查询,</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(3515853,'Digg',this)">支持(0)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(3515853,'Bury',this)">反对(0)</a></div><span id="comment_3515853_avatar" style="display:none;">http://pic.cnblogs.com/face/639788/20160516144826.png</span>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3515913" class="layer">#5楼</a><a name="3515913" id="comment_anchor_3515913"></a>[<span class="louzhu">楼主</span>]  <span class="comment_date">2016-09-21 11:25</span> <a id="a_comment_author_3515913" href="https://www.cnblogs.com/ityouknow/" target="_blank">纯洁的微笑</a> <a href="http://msg.cnblogs.com/send/%E7%BA%AF%E6%B4%81%E7%9A%84%E5%BE%AE%E7%AC%91" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3515913" class="blog_comment_body"><a href="#3515853" title="查看所回复的评论" onclick="commentManager.renderComments(0,50,3515853);">@</a>

姜师爷闯世界
如果系统中大部分查询都是复杂的建议还是用mybaits更灵活一些。JPA的特点是快速、方便。

http://pic.cnblogs.com/face/331425/20130328094900.png

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3515955" class="layer">#6楼</a><a name="3515955" id="comment_anchor_3515955"></a>  <span class="comment_date">2016-09-21 11:58</span> <a id="a_comment_author_3515955" href="http://home.cnblogs.com/u/157387/" target="_blank">福爷</a> <a href="http://msg.cnblogs.com/send/%E7%A6%8F%E7%88%B7" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3515955" class="blog_comment_body">“当查询中有多个参数的时候Pageable建议做为最后一个参数传入” 为什么这么建议</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(3515955,'Digg',this)">支持(0)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(3515955,'Bury',this)">反对(0)</a></div>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3515961" class="layer">#7楼</a><a name="3515961" id="comment_anchor_3515961"></a>[<span class="louzhu">楼主</span>]  <span class="comment_date">2016-09-21 12:05</span> <a id="a_comment_author_3515961" href="https://www.cnblogs.com/ityouknow/" target="_blank">纯洁的微笑</a> <a href="http://msg.cnblogs.com/send/%E7%BA%AF%E6%B4%81%E7%9A%84%E5%BE%AE%E7%AC%91" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3515961" class="blog_comment_body"><a href="#3515955" title="查看所回复的评论" onclick="commentManager.renderComments(0,50,3515955);">@</a>

福爷
其实不用作为最后一个参数也没有问题,这就是一个规范问题;

http://pic.cnblogs.com/face/331425/20130328094900.png

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3796110" class="layer">#8楼</a><a name="3796110" id="comment_anchor_3796110"></a>  <span class="comment_date">2017-09-25 17:34</span> <a id="a_comment_author_3796110" href="https://www.cnblogs.com/anpingsheng/" target="_blank">anbokeyuan</a> <a href="http://msg.cnblogs.com/send/anbokeyuan" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3796110" class="blog_comment_body">路过,zw?</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(3796110,'Digg',this)">支持(0)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(3796110,'Bury',this)">反对(0)</a></div>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3895166" class="layer">#9楼</a><a name="3895166" id="comment_anchor_3895166"></a>  <span class="comment_date">2018-01-22 17:06</span> <a id="a_comment_author_3895166" href="https://www.cnblogs.com/slowcity/" target="_blank">慢城</a> <a href="http://msg.cnblogs.com/send/%E6%85%A2%E5%9F%8E" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3895166" class="blog_comment_body">收益良多</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(3895166,'Digg',this)">支持(0)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(3895166,'Bury',this)">反对(0)</a></div><span id="comment_3895166_avatar" style="display:none;">http://pic.cnblogs.com/face/1160748/20180405000715.png</span>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3916402" class="layer">#10楼</a><a name="3916402" id="comment_anchor_3916402"></a>  <span class="comment_date">2018-03-06 17:20</span> <a id="a_comment_author_3916402" href="https://www.cnblogs.com/ShunQing/" target="_blank">A0_0A</a> <a href="http://msg.cnblogs.com/send/A0_0A" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3916402" class="blog_comment_body">多表查询的代码没有看懂,<br><div class="cnblogs_Highlighter sh-gutter"><div><div id="highlighter_477042" class="syntaxhighlighter  java"><div class="toolbar"><span><a href="#" class="toolbar_item command_help help">?</a></span></div><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2">1</div><div class="line number2 index1 alt1">2</div><div class="line number3 index2 alt2">3</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="java color1">@Query</code><code class="java plain">(</code><code class="java string">"select h.city as city, h.name as name, avg(r.rating) as averageRating "</code></div><div class="line number2 index1 alt1"><code class="java spaces">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><code class="java plain">- </code><code class="java string">"from Hotel h left outer join h.reviews r where h.city = ?1 group by h"</code><code class="java plain">)</code></div><div class="line number3 index2 alt2"><code class="java plain">Page&lt;HotelSummary&gt; findByCity(City city, Pageable pageable);</code></div></div></td></tr></tbody></table></div></div></div><br>left outer join 没有on,h.reviews r之后,上面又有r.rating,还有没有看到?2</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(3916402,'Digg',this)">支持(1)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(3916402,'Bury',this)">反对(0)</a></div>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3925970" class="layer">#11楼</a><a name="3925970" id="comment_anchor_3925970"></a>  <span class="comment_date">2018-03-17 21:39</span> <a id="a_comment_author_3925970" href="https://www.cnblogs.com/witpool/" target="_blank">千里驹</a> <a href="http://msg.cnblogs.com/send/%E5%8D%83%E9%87%8C%E9%A9%B9" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3925970" class="blog_comment_body">跟Hibernate比起来,发现JPA是非常好用的,简单几行代码就能搞定数据库的各种操作。<br>很有帮助,写了几个增删查改的API接口用Wisdom RESTClient顺利测通<br><a href="https://github.com/Wisdom-Projects/rest-client" target="_blank">https://github.com/Wisdom-Projects/rest-client</a><br><br>感谢作者的分享,非常有帮助!赞!</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(3925970,'Digg',this)">支持(0)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(3925970,'Bury',this)">反对(0)</a></div><span id="comment_3925970_avatar" style="display:none;">http://pic.cnblogs.com/face/1290665/20181114214505.png</span>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3930407" class="layer">#12楼</a><a name="3930407" id="comment_anchor_3930407"></a>  <span class="comment_date">2018-03-22 16:56</span> <a id="a_comment_author_3930407" href="https://www.cnblogs.com/bert-hu/" target="_blank">胡浪</a> <a href="http://msg.cnblogs.com/send/%E8%83%A1%E6%B5%AA" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3930407" class="blog_comment_body">博主好,使用JPA查询的时候想带库名应该怎么写啊,例如:select * from db.table</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(3930407,'Digg',this)">支持(0)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(3930407,'Bury',this)">反对(0)</a></div>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3969993" class="layer">#13楼</a><a name="3969993" id="comment_anchor_3969993"></a>  <span class="comment_date">2018-05-08 14:01</span> <a id="a_comment_author_3969993" href="http://home.cnblogs.com/u/1357301/" target="_blank">永不止步丿</a> <a href="http://msg.cnblogs.com/send/%E6%B0%B8%E4%B8%8D%E6%AD%A2%E6%AD%A5%E4%B8%BF" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3969993" class="blog_comment_body">可以根据员工对象 查员工对象的集合吗?   <br>就是解决多条件查询,我前端传过来的不一定是哪些条件</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(3969993,'Digg',this)">支持(1)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(3969993,'Bury',this)">反对(0)</a></div>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3990861" class="layer">#14楼</a><a name="3990861" id="comment_anchor_3990861"></a>  <span class="comment_date">2018-06-05 15:35</span> <a id="a_comment_author_3990861" href="http://home.cnblogs.com/u/1410379/" target="_blank">symiracle</a> <a href="http://msg.cnblogs.com/send/symiracle" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3990861" class="blog_comment_body">博主,你好,我想问一下,这个继承jpa respositorry后面泛型里的User long 什么意识,,还有里面应该写些什么,有要求吗,这块不太懂,啊,底下没法看。。方法能看懂,,根据什么写出来的啊。能详细说一下嘛,,谢谢了</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(3990861,'Digg',this)">支持(0)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(3990861,'Bury',this)">反对(0)</a></div>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#3990863" class="layer">#15楼</a><a name="3990863" id="comment_anchor_3990863"></a>  <span class="comment_date">2018-06-05 15:37</span> <a id="a_comment_author_3990863" href="http://home.cnblogs.com/u/1410379/" target="_blank">symiracle</a> <a href="http://msg.cnblogs.com/send/symiracle" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_3990863" class="blog_comment_body">为什么继承里面就写了两个   <br> User findById(long id);<br><br>    Long deleteById(Long id);<br><br><br>然后  他俩是什么意识啊,<br><br>后面就有了一大堆的方法   <br>public interface UserService {<br><br>    public List&lt;User&gt; getUserList();<br><br>    public User findUserById(long id);<br><br>    public void save(User user);<br><br>    public void edit(User user);<br><br>    public void delete(long id);<br><br><br>}<br><br>还有里面的好多注解,也帮忙解释下呗 ,辛苦了</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(3990863,'Digg',this)">支持(0)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(3990863,'Bury',this)">反对(0)</a></div>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#4055068" class="layer">#16楼</a><a name="4055068" id="comment_anchor_4055068"></a>  <span class="comment_date">2018-08-31 13:55</span> <a id="a_comment_author_4055068" href="https://www.cnblogs.com/yueshutong/" target="_blank">像风一样i</a> <a href="http://msg.cnblogs.com/send/%E5%83%8F%E9%A3%8E%E4%B8%80%E6%A0%B7i" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_4055068" class="blog_comment_body">如何更新呢?</div><div class="comment_vote"><a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(4055068,'Digg',this)">支持(0)</a><a href="javascript:void(0);" class="comment_bury" onclick="return voteComment(4055068,'Bury',this)">反对(0)</a></div><span id="comment_4055068_avatar" style="display:none;">http://pic.cnblogs.com/face/1136672/20180826164359.png</span>
		</div>
	</div>

	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#4097156" class="layer">#17楼</a><a name="4097156" id="comment_anchor_4097156"></a>  <span class="comment_date">2018-10-23 23:04</span> <a id="a_comment_author_4097156" href="https://www.cnblogs.com/leosoul/" target="_blank">leosoul</a> <a href="http://msg.cnblogs.com/send/leosoul" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_4097156" class="blog_comment_body"><a href="#3916402" title="查看所回复的评论" onclick="commentManager.renderComments(0,50,3916402);">@</a>

A0_0A
直接用@Query()写的查询,用的是JPA语句,里边的名称,都是实体类名称和属性,JPA针对的是实体类的操作,并不是原生sql。



	<div class="feedbackItem">
		<div class="feedbackListSubtitle">
			<div class="feedbackManage">
				&nbsp;&nbsp;<span class="comment_actions"></span>
			</div>
			<a href="#4097157" class="layer">#18楼</a><a name="4097157" id="comment_anchor_4097157"></a><span id="comment-maxId" style="display:none;">4097157</span><span id="comment-maxDate" style="display:none;">2018/10/23 23:09:25</span>  <span class="comment_date">2018-10-23 23:09</span> <a id="a_comment_author_4097157" href="https://www.cnblogs.com/leosoul/" target="_blank">leosoul</a> <a href="http://msg.cnblogs.com/send/leosoul" title="发送站内短消息" class="sendMsg2This">&nbsp;</a>
		</div>
		<div class="feedbackCon">
			<div id="comment_body_4097157" class="blog_comment_body"><a href="#3930407" title="查看所回复的评论" onclick="commentManager.renderComments(0,50,3930407);">@</a>

胡浪
引用
博主好,使用JPA查询的时候想带库名应该怎么写啊,例如:select * from db.table

JPA语句操作的是实体类,而不是数据库中的表和字段,你想直接操作表和字段,需要用@Query()里写原生sql,例如@Query(value = “select * from user u where u.name=?1”, nativeQuery = true)。不过既然都用JPA了,就不要轻易写原生sql了,你就想象成你用了一个“约定俗成版”的Hibernate。




</div><!--end: forFlow -->
</div><!--end: mainContent 主体内容容器-->

<div id="sideBar">
	<div id="sideBarMain">

公告

Go to my github

微信公众号:纯洁的微笑

导航:

   关于我

   文章索引

   我的知乎

   获取十套精选1000G架构师资料

   我的微信:puresmileit(备注:博客园)

   交流群:200596287

昵称: 纯洁的微笑
园龄: 7年5个月
荣誉: 推荐博客
粉丝: 3947
关注: 0
+加关注
		<div id="blog-calendar" style="display:none"></div><script type="text/javascript">loadBlogDefaultCalendar();</script>
		
		<div id="leftcontentcontainer">
			<div id="blog-sidecolumn"><div id="sidebar_search" class="sidebar-block"></div><div id="sidebar_categories">
    评论
    添加红包

    请填写红包祝福语或标题

    红包个数最小为10个

    红包金额最低5元

    当前余额3.43前往充值 >
    需支付:10.00
    成就一亿技术人!
    领取后你会自动成为博主和红包主的粉丝 规则
    hope_wisdom
    发出的红包
    实付
    使用余额支付
    点击重新获取
    扫码支付
    钱包余额 0

    抵扣说明:

    1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
    2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

    余额充值