Mongodb与spring集成（3）------MongoRepository实现增删改查和 - Linux安全网

与HibernateRepository类似，通过继承MongoRepository接口，我们可以非常方便地实现对一个对象的增删改查，要使用Repository的功能，先继承MongoRepository<T, TD>接口，其中T为仓库保存的bean类，TD为该bean的唯一标识的类型，一般为ObjectId。之后在service中注入该接口就可以使用，无需实现里面的方法，spring会根据定义的规则自动生成。
例：
public interface PersonRepository <a href='http://www.linuxso.com/command/ex.html' target='_blank'><u>ex</u></a>tends 

MongoRepository<Person, ObjectId>{
//这里可以添加额外的查询方法
｝

</pre></blockquote>
<p><br>
但是MongoRepository实现了的只是最基本的增删改查的功能，要想增加额外的查询方法，可以按照以下规则定义接口的方法。自定义查询方法，格式为“<a href='http://www.linuxso.com/command/find.html' target='_blank'><u>find</u></a>By+字段名+方法后缀”，方法传进的参数即字段的值，此外还支持分页查询，通过传进一个Pageable对象，返回Page集合。</p>
<p>例：</p>
<textarea readonly name="code"class="java" >public interface PersonRepository extends 

MongoRepository<Person, ObjectId>{
 //查询大于age的数据 
       public Page<Pro<a href='http://www.linuxso.com/command/du.html' target='_blank'><u>du</u></a>ct> findByAgeGreaterThan(int age,Pageable page) ;
｝

</pre></blockquote>
<p><br>
<br>
下面是支持的查询类型，每三条数据分别对应：（方法后缀，方法例子，mongodb原生查询语句）</p>
<p>GreaterThan(大于) <br>
findByAgeGreaterThan(int age) <br>
{"age" : {"$gt" : age}} </p>
<p>LessThan（小于） <br>
findByAgeLessThan(int age) <br>
{"age" : {"$lt" : age}} </p>
<p>Between（在...之间） <br>
findByAgeBetween(int from, int to) <br>
{"age" : {"$gt" : from, "$lt" : to}} </p>
<p>IsNotNull, NotNull（是否非空） <br>
findByFirstnameNotNull() <br>
{"age" : {"$ne" : null}} </p>
<p>IsNull, Null（是否为空） <br>
findByFirstnameNull() <br>
{"age" : null} </p>
<p>Like（模糊查询） <br>
findByFirstnameLike(S<a href='http://www.linuxso.com/command/tr.html' target='_blank'><u>tr</u></a>ing name) <br>
{"age" : age} ( age as regex) </p>
<p>(No keyword) findByFirstname(String name) <br>
{"age" : name} </p>
<p>Not（不包含） <br>
findByFirstnameNot(String name) <br>
{"age" : {"$ne" : name}} </p>
<p>Near（查询地理位置相近的） <br>
findByLo<a href='http://www.linuxso.com/command/cat.html' target='_blank'><u>cat</u></a>ionNear(Point point) <br>
{"location" : {"$near" : [x,y]}} </p>
<p>Within（在地理位置范围内的） <br>
findByLocationWithin(Circle circle) <br>
{"location" : {"$within" : {"$center" : [ [x, y], dista<a href='http://www.linuxso.com/command/nc.html' target='_blank'><u>nc</u></a>e]}}} </p>
<p>Within（在地理位置范围内的） <br>
findByLocationWithin(Box box) <br>
{"location" : {"$within" : {"$box" : [ [x1, y1], x2, y2]}}} </p>
<p>尽管以上查询功能已经很丰富，但如果还不能满足使用情况的话可以用一下方法---基于mongodb原本查询语句的查询方式。<br>
例：在原接口中加入</p>
<textarea readonly name="code"class="plain" >@Query("{ 'name':{'$regex':'^.*?2.*}, sales': {'$gte':?1,'$lte':?2}}")
public Page<Product> findByNameAndAgeRange(String name,double ageFrom,double ageTo,Pageable page);</pre></blockquote>
<p>注释Query里面的就是mongodb原来的查询语法，我们可以定义传进来的查询参数，通过坐标定义方法的参数。</p>
<p>还可以在后面指定要返回的数据字段，如上面的例子修改如下，则只通过person表里面的name和age字段构建person对象。 </p>
<textarea readonly name="code"class="plain" >@Query(value="{ 'name':{'$regex':'^.*?2.*}, sales':{'$gte':?1,'$lte':?2}}",fields="{ 'name' : 1, 'age' : 1}") 
public Page<Product> findByNameAndAgeRange(String name,double ageFrom,double ageTo,Pageable page);

</pre></blockquote><br>
                
               <span class="contenttop" style=" width:682px;float:left; text-align:center">
<script type="text/javascript"><!--
google_ad_client = "ca-pub-4510523863108853";
/* 300x250, 创建于 11-4-9 */
google_ad_slot = "4993518163";
google_ad_width = 300;
google_ad_height = 250;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<script type="text/javascript">/*336*280，用于并排和google*/ var cpro_id = 'u658144';</script><script src="http://cpro.baidu.com/cpro/ui/c.js" type="text/javascript"></script>
  </span>             

            </div>

            

            <div class="dede_pages">

				<ul class="pagelist">

          

				</ul>
            
			</div> <br>



            <div class="text_tag">



                        <h5>Tags： </h5>



<span class="jiathiswidget" id="ckepop">

                <span class="label">分享至:</span>

                <a class="jiathis_button_tsina"></a>

                <a class="jiathis_button_tqq"></a>

                <a class="jiathis_button_qzone"></a>

                <a class="jiathis_button_baidu"></a>

                <a class="jiathis_button_renren"></a>

                <a class="jiathis_button_kaixin001"></a>

                <a class="jiathis_button_douban"></a>

                <a class="jiathis_button_xiaoyou"></a>

                <a href="http://www.jiathis.com/share?uid=1536270" class="jiathis jiathis_txt jtico jtico_jiathis" target="_blank"></a>

            </span>



            </div>



            



<div class="box_xgimg"> 



<script type="text/javascript">



    var t_u = null;



    var t_u_old = null;



    var maxPic = 6;



    var showPic = 0;







    function switchPic(curPic){ 



        if(curPic == maxPic){ 



            showPic = 1;



        }else{ 



            showPic = showPic + 1;



        }



        for(i=1; i <= maxPic; i++){ 



            if(i == showPic){ 



                document.getElementById("picA"+i).className = "currON";



                document.getElementById("picUL"+i).style.display = "";



            }else{ 



                document.getElementById("picA"+i).className = "";



                document.getElementById("picUL"+i).style.display = "none";



            }



        }



    }



    function reSwitchPic() { 



        clearTimeout(t_u);



        switchPic(showPic);



        t_u = setTimeout('reSwitchPic();', 5000);



    }



    function pauseSwitch() { 



        clearTimeout(t_u);



        t_u_old = t_u;



    }



    function selectSwitch(num) { 



        showPic = num;



        for(i=1; i <= maxPic; i++){ 



            if(i == num){ 



                document.getElementById("picA"+i).className = "currON";



                document.getElementById("picUL"+i).style.display = "";



            }else{ 



                document.getElementById("picA"+i).className = "";



                document.getElementById("picUL"+i).style.display = "none";



            }



        }



    }



    function goonSwitch() {



        clearTimeout(t_u);



        t_u = setTimeout('reSwitchPic();', 5000);



    }   



</script>



<div class="title_xg">



    <div style="float:left;padding-left:-10px;text-align:left;"><b>最新图文资讯</b></div>



    <span style="float:right;padding-right:10px;font-size:12px;font-weight:normal;">



        <a href="javascript://" class="currON" id="picA1" onclick="selectSwitch(1)" onmouseover="pauseSwitch()" onmouseout="goonSwitch()">1</a>



        <a href="javascript://"  id="picA2"  onclick="selectSwitch(2)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">2</a>



        <a href="javascript://"  id="picA3"  onclick="selectSwitch(3)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">3</a>



        <a href="javascript://"  id="picA4"  onclick="selectSwitch(4)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">4</a>



        <a href="javascript://"  id="picA5"  onclick="selectSwitch(5)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">5</a>



        <a href="javascript://"  id="picA6"  onclick="selectSwitch(6)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">6</a>



    </span>



</div>



<div class="roll" id="roll" style="margin-left:0px;padding-left:0px;">



    <ul id="picUL1" onmouseover="pauseSwitch()" onmouseout="goonSwitch()">

		<li>

			<div><a href="/sql/13469.html"><img src='/uploads/allimg/111217/09111M624-0-lp.gif' border='0' width='121' height='91' alt='Oracle AWR 报告中 No data exists for this section of the rep'></a></div>

			<p><a  href="/sql/13469.html">Oracle AWR 报告中 No data exists for this section of the rep</a></p>

			</li>
<li>

			<div><a href="/sql/13461.html"><img src='/uploads/allimg/111217/09105SA5-0-lp.gif' border='0' width='121' height='91' alt='SQLserver数据库中的文件和文件组'></a></div>

			<p><a  href="/sql/13461.html">SQLserver数据库中的文件和文件组</a></p>

			</li>
<li>

			<div><a href="/sql/13324.html"><img src='/uploads/allimg/111216/110933DN-0-lp.gif' border='0' width='121' height='91' alt='Oracle JOB异常ORA-06512'></a></div>

			<p><a  href="/sql/13324.html">Oracle JOB异常ORA-06512</a></p>

			</li>
<li>

			<div><a href="/sql/13170.html"><img src='/uploads/allimg/111215/11463U139-0-lp.jpg' border='0' width='121' height='91' alt='PostgreSQL之精妙的数据库导入导出工具架构 （十）'></a></div>

			<p><a  href="/sql/13170.html">PostgreSQL之精妙的数据库导入导出工具架构 （十）</a></p>

			</li>


	</ul>



    <ul id="picUL2" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">

		<li>

			<div><a href="/sql/13089.html"><img src='/uploads/allimg/111214/221T12129-0-lp.gif' border='0' width='121' height='91' alt='vi/vim学习的必备键盘图'></a></div>

			<p><a  href="/sql/13089.html">vi/vim学习的必备键盘图</a></p>

			</li>
<li>

			<div><a href="/sql/13079.html"><img src='/uploads/allimg/111214/221R43Q6-0-lp.gif' border='0' width='121' height='91' alt='Oracle DBCA 命令 进行实例 复制 说明'></a></div>

			<p><a  href="/sql/13079.html">Oracle DBCA 命令 进行实例 复制 说明</a></p>

			</li>
<li>

			<div><a href="/sql/12915.html"><img src='/uploads/allimg/111214/1253332536-0-lp.gif' border='0' width='121' height='91' alt='sql server:sql动态行转列(pivot) 例子'></a></div>

			<p><a  href="/sql/12915.html">sql server:sql动态行转列(pivot) 例子</a></p>

			</li>
<li>

			<div><a href="/sql/12907.html"><img src='/uploads/allimg/111214/12531VW8-0-lp.gif' border='0' width='121' height='91' alt='sqlserver2000 导出数据至 oracle'></a></div>

			<p><a  href="/sql/12907.html">sqlserver2000 导出数据至 oracle</a></p>

			</li>


    </ul>



    <ul id="picUL3" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">

		<li>

			<div><a href="/sql/12797.html"><img src='/uploads/allimg/111213/1006364624-0-lp.gif' border='0' width='121' height='91' alt='看Sybase官方手册学索引工作原理'></a></div>

			<p><a  href="/sql/12797.html">看Sybase官方手册学索引工作原理</a></p>

			</li>
<li>

			<div><a href="/sql/12667.html"><img src='/uploads/allimg/111212/164J341U-0-lp.gif' border='0' width='121' height='91' alt='mysql 实现时统计 hql'></a></div>

			<p><a  href="/sql/12667.html">mysql 实现时统计 hql</a></p>

			</li>
<li>

			<div><a href="/sql/12625.html"><img src='/uploads/allimg/111212/0Z21W561-0-lp.JPG' border='0' width='121' height='91' alt='SQL Server死锁总结'></a></div>

			<p><a  href="/sql/12625.html">SQL Server死锁总结</a></p>

			</li>
<li>

			<div><a href="/sql/12603.html"><img src='/uploads/allimg/111211/1J6024292-0-lp.gif' border='0' width='121' height='91' alt='Oracle 11g R2 RAC 安装时 系统用户组 配置 说明'></a></div>

			<p><a  href="/sql/12603.html">Oracle 11g R2 RAC 安装时 系统用户组 配置 说明</a></p>

			</li>


    </ul>



    <ul id="picUL4" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">

		<li>

			<div><a href="/sql/12528.html"><img src='/uploads/allimg/111211/12395Q635-0-lp.gif' border='0' width='121' height='91' alt='Oracle 11g 行列互换  pivot 和 unpivot 说明'></a></div>

			<p><a  href="/sql/12528.html">Oracle 11g 行列互换  pivot 和 unpivot 说明</a></p>

			</li>
<li>

			<div><a href="/sql/12499.html"><img src='/uploads/allimg/111210/2009143A9-0-lp.gif' border='0' width='121' height='91' alt='我的2011：个人职业发展的三个里程碑'></a></div>

			<p><a  href="/sql/12499.html">我的2011：个人职业发展的三个里程碑</a></p>

			</li>
<li>

			<div><a href="/sql/12497.html"><img src='/uploads/allimg/111210/200Z55494-0-lp.gif' border='0' width='121' height='91' alt='SQL SERVER2008日常自动化备份'></a></div>

			<p><a  href="/sql/12497.html">SQL SERVER2008日常自动化备份</a></p>

			</li>
<li>

			<div><a href="/sql/12332.html"><img src='/uploads/allimg/111210/00132G959-0-lp.png' border='0' width='121' height='91' alt='pg启动过程中的那些事三：加载GUC参数'></a></div>

			<p><a  href="/sql/12332.html">pg启动过程中的那些事三：加载GUC参数</a></p>

			</li>


    </ul>



    <ul id="picUL5" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">

		<li>

			<div><a href="/sql/12331.html"><img src='/uploads/allimg/111210/0013233229-0-lp.gif' border='0' width='121' height='91' alt='SQL Server 2008开启sa账户以及如何用JDBC进行连接 .'></a></div>

			<p><a  href="/sql/12331.html">SQL Server 2008开启sa账户以及如何用JDBC进行连接 .</a></p>

			</li>
<li>

			<div><a href="/sql/12329.html"><img src='/uploads/allimg/111210/00131T355-0-lp.png' border='0' width='121' height='91' alt='pg的内存管理机制二：AllocSet/MemoryContext的内存回收'></a></div>

			<p><a  href="/sql/12329.html">pg的内存管理机制二：AllocSet/MemoryContext的内存回收</a></p>

			</li>
<li>

			<div><a href="/sql/12164.html"><img src='/uploads/allimg/111209/115Z33Z2-0-lp.gif' border='0' width='121' height='91' alt='ASE12.5.4  Error: 2823接着报current process infected with 11'></a></div>

			<p><a  href="/sql/12164.html">ASE12.5.4  Error: 2823接着报current process infected with 11</a></p>

			</li>
<li>

			<div><a href="/sql/12066.html"><img src='/uploads/allimg/111209/0ZA01206-0-lp.gif' border='0' width='121' height='91' alt='latch:library cache 引起的数据库短暂hang（BUG 7122093）'></a></div>

			<p><a  href="/sql/12066.html">latch:library cache 引起的数据库短暂hang（BUG 7122093）</a></p>

			</li>


    </ul>



    <ul id="picUL6" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">

		<li>

			<div><a href="/sql/12081.html"><img src='/uploads/allimg/111209/0ZH1IT-0-lp.gif' border='0' width='121' height='91' alt='Navicat8.0 for mysql 安装包和注册码'></a></div>

			<p><a  href="/sql/12081.html">Navicat8.0 for mysql 安装包和注册码</a></p>

			</li>
<li>

			<div><a href="/sql/12113.html"><img src='/uploads/allimg/111209/0ZQKY9-0-lp.gif' border='0' width='121' height='91' alt='Hibernate笔记'></a></div>

			<p><a  href="/sql/12113.html">Hibernate笔记</a></p>

			</li>
<li>

			<div><a href="/sql/12106.html"><img src='/uploads/allimg/111209/0ZP4I26-0-lp.gif' border='0' width='121' height='91' alt='sql server 2005 windows身份登陆 错误：18456'></a></div>

			<p><a  href="/sql/12106.html">sql server 2005 windows身份登陆 错误：18456</a></p>

			</li>
<li>

			<div><a href="/sql/12067.html"><img src='/uploads/allimg/111209/0ZA01392-0-lp.gif' border='0' width='121' height='91' alt='二进制排序规则下-汉字字典排序'></a></div>

			<p><a  href="/sql/12067.html">二进制排序规则下-汉字字典排序</a></p>

			</li>


    </ul>



    <script type="text/javascript">



    reSwitchPic();



    </script>



</div>



</div>   







                        <div class="box_xg">



                <div class="title_xg">相关文章列表:</div>



                <ul>

					<li><a href='/architecture/13503.html'>Spring 自动定时任务配置</a></li>
<li><a href='/shell/13441.html'>mongodb实践 2</a></li>
<li><a href='/architecture/13425.html'>spring3.1有了缓存，还需要ehcache-spring-annotation</a></li>
<li><a href='/architecture/13407.html'>Spring IoC</a></li>
<li><a href='/architecture/13221.html'>一、Spring Security基础了解</a></li>
<li><a href='/architecture/13219.html'>二、Spring Security应用</a></li>
<li><a href='/architecture/13135.html'>Web架构学习(4)添加spring应用</a></li>
<li><a href='/architecture/13132.html'>Web架构学习(5)添加springsecurity应用</a></li>


				</ul>



            </div>





<!-- //评论内容区 -->







<div id="pllshow">

          <form action="#" method="post" name="feedback">

          <input type="hidden" name="dopost" value="send" />

          <input type="hidden" name="comtype" value="comments">

          <input type="hidden" name="aid" value="3023" />

          <input type="hidden" name="fid" id='feedbackfid' value="0" />



验证码:<input type='text' name='validate' size='4' /><img src="/include/vdimgck.php" alt="点击我更换图片" id="validateimg"  style="height:15px;" title="点击我更换图片" onclick="this.src=this.src+'?'" />





<span class="float_right">理智评论文明上网，拒绝恶意谩骂</span>

<span id="userinfo">

用户名：<b id="nickname"></b>

<span id="anonymous"><label><input type="checkbox" name="notuser"  checked="checked" /> 匿名发表</label></span>

<input type="button" onClick='PostComment()' value="发表评论" class="btn" />				

</span> 

<!--<span style="display:none;" id="fastLoginDiv" value="0">

	<label class="cor-ccc">用户名：</label>

	<input type="text" class="input-text bor-gray"  name="username" id="loginUsername" value="" />

	<label>密码：</label>

	<input type="password" class="input-text bor-gray" name="password" id="loginPassword" />

	<input type="button" class="btn" onclick="login(); return false;" value="登录" />

</span>	 -->

<div class="bor">

<textarea name="msg" rows="6" cols="94" class="rev_textarea">