mybatis物理分页的实现(转)

于 2013-11-15 09:58:00 发布
阅读量56 收藏
点赞数
文章标签： java 数据库 测试
本文介绍了一个基于MyBatis的物理分页实现方案，包括实体类定义、DAO接口、映射文件、主配置文件等内容，并提供了一个测试类用于验证分页功能。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >


转：http://dove19900520.iteye.com/blog/1724414

最近两周一直在学习mybatis，昨天经理让我将mybatis的物理分页整理一下，打成一个jar包供以后调用。结果昨天我整了一天，也没整出个1、2、3来。现在终于写出来了，先记录下来再说，哈哈。

下面是所有的代码：

Java代码 收藏代码
  1. packagecom.xxyd.mybatis.pojo;
  3. importjava.io.Serializable;
  4. /**
  5. *实体类
  6. *@authordove
  7. *
  8. */
  9. publicclassTestEntityimplementsSerializable{
  11. privatestaticfinallongserialVersionUID=-5849200248418883686L;
  12. privateintid;
  13. privateStringname;
  14. privateintno;
  15. privateintsex;
  16. privateintage;
  17. privateStringcount;
  18. privateStringschool;
  19. privateintweight;
  20. privateintheight;
  21. privateStringhabbit;
  22. privateStringmemo;
  23. publicintgetId(){
  24. returnid;
  25. }
  26. publicvoidsetId(intid){
  27. this.id=id;
  28. }
  29. publicStringgetName(){
  30. returnname;
  31. }
  32. publicvoidsetName(Stringname){
  33. this.name=name;
  34. }
  35. publicintgetNo(){
  36. returnno;
  37. }
  38. publicvoidsetNo(intno){
  39. this.no=no;
  40. }
  41. publicintgetSex(){
  42. returnsex;
  43. }
  44. publicvoidsetSex(intsex){
  45. this.sex=sex;
  46. }
  47. publicintgetAge(){
  48. returnage;
  49. }
  50. publicvoidsetAge(intage){
  51. this.age=age;
  52. }
  53. publicStringgetCount(){
  54. returncount;
  55. }
  56. publicvoidsetCount(Stringcount){
  57. this.count=count;
  58. }
  59. publicStringgetSchool(){
  60. returnschool;
  61. }
  62. publicvoidsetSchool(Stringschool){
  63. this.school=school;
  64. }
  65. publicintgetWeight(){
  66. returnweight;
  67. }
  68. publicvoidsetWeight(intweight){
  69. this.weight=weight;
  70. }
  71. publicintgetHeight(){
  72. returnheight;
  73. }
  74. publicvoidsetHeight(intheight){
  75. this.height=height;
  76. }
  77. publicStringgetHabbit(){
  78. returnhabbit;
  79. }
  80. publicvoidsetHabbit(Stringhabbit){
  81. this.habbit=habbit;
  82. }
  83. publicStringgetMemo(){
  84. returnmemo;
  85. }
  86. publicvoidsetMemo(Stringmemo){
  87. this.memo=memo;
  88. }
  89. @Override
  90. publicStringtoString(){
  91. return"TestEntity[id="+id+",name="+name+",no="+no
  92. +",sex="+sex+",age="+age+",count="+count
  93. +",school="+school+",weight="+weight+",height="
  94. +height+",habbit="+habbit+",memo="+memo+"]";
  95. }
  97. }

2、DAO接口

Java代码 收藏代码
  1. packagecom.xxyd.mybatis.dao;
  3. importjava.util.List;
  5. importorg.apache.ibatis.annotations.Param;
  7. importcom.xxyd.mybatis.pojo.TestEntity;
  8. /**
  9. *dao接口
  10. *@authordove
  11. *
  12. */
  13. publicinterfaceTestMapper{
  14. publicvoidcreateTestEntity(TestEntityentity);
  15. publicList<TestEntity>getTestEntityByPager(@Param("pageNo")intpageNo,@Param("pageSize")intpageSize);
  16. publicList<TestEntity>getListTestEntity();
  17. publicintgetTotalCount(@Param("pageNo")intpageNo,@Param("pageSize")intpageSize);
  18. publicvoidupdateTestEntity(TestEntityentity);
  19. publicvoiddeleteTestEntityById(@Param("id")intid);
  20. }

3、映射文件TestMapper.xml

Xml代码 收藏代码
  1. <?xmlversion="1.0"encoding="UTF-8"?>
  2. <!DOCTYPEmapperSYSTEM"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mappernamespace="com.xxyd.mybatis.dao.TestMapper">
  5. <resultMaptype="com.xxyd.mybatis.pojo.TestEntity"id="test_test">
  6. <idproperty="id"column="id"javaType="int"jdbcType="INTEGER"/>
  7. <resultproperty="name"column="name"javaType="String"jdbcType="VARCHAR"/>
  8. <resultproperty="no"column="no"javaType="int"jdbcType="INTEGER"/>
  9. <resultproperty="sex"column="sex"javaType="int"jdbcType="INTEGER"/>
  10. <resultproperty="age"column="age"javaType="int"jdbcType="INTEGER"/>
  11. <resultproperty="count"column="count"javaType="String"jdbcType="VARCHAR"/>
  12. <resultproperty="school"column="school"javaType="String"jdbcType="VARCHAR"/>
  13. <resultproperty="weight"column="weight"javaType="int"jdbcType="INTEGER"/>
  14. <resultproperty="height"column="height"javaType="int"jdbcType="INTEGER"/>
  15. <resultproperty="habbit"column="habbit"javaType="String"jdbcType="VARCHAR"/>
  16. <resultproperty="memo"column="memo"javaType="String"jdbcType="VARCHAR"/>
  17. </resultMap>
  19. <insertid="createTestEntity"useGeneratedKeys="true"parameterType="com.xxyd.mybatis.pojo.TestEntity">
  20. insertintotest_test(name,no,sex,age,count,school,weight,height,habbit,memo)
  21. values(#{name},#{no},#{sex},#{age},#{count},#{school},#{weight},#{height},#{habbit},#{memo});
  22. </insert>
  24. <selectid="getTestEntityByPager"resultMap="test_test">
  25. selectid,name,no,sex,age,count,school,weight,height,habbit,memo
  26. fromtest_test
  27. limit#{pageNo,jdbcType=INTEGER},#{pageSize,jdbcType=INTEGER}
  28. </select>
  30. <selectid="getListTestEntity"resultMap="test_test">
  31. selectid,name,no,sex,age,count,school,weight,height,habbit,memo
  32. fromtest_test
  33. </select>
  35. <selectid="getTotalCount"resultType="int">
  36. selectcount(sub.id)from
  37. (selecttest.idasidfromtest_testtest
  38. limit#{pageNo,jdbcType=INTEGER},#{pageSize,jdbcType=INTEGER})assub
  39. </select>
  41. <updateid="updateTestEntity"parameterType="com.xxyd.mybatis.pojo.TestEntity">
  42. updatetest_test
  43. <set>
  44. <iftest="name!=nullandname!=''">
  45. name=#{name,jdbcType=VARCHAR},
  46. </if>
  47. <iftest="no!=nullandno!=''">
  48. no=#{no,jdbcType=INTEGER},
  49. </if>
  50. <iftest="sex!=nullandsex!=''">
  51. sex=#{sex,jdbcType=INTEGER},
  52. </if>
  53. <iftest="age!=nullandage!=''">
  54. age=#{age,jdbcType=INTEGER},
  55. </if>
  56. <iftest="count!=nullandcount!=''">
  57. count=#{count,jdbcType=VARCHAR},
  58. </if>
  59. <iftest="school!=nullandschool!=''">
  60. school=#{school,jdbcType=VARCHAR},
  61. </if>
  62. <iftest="weight!=nullandweight!=''">
  63. weight=#{weight,jdbcType=INTEGER},
  64. </if>
  65. <iftest="height!=nullandheight!=''">
  66. height=#{height,jdbcType=INTEGER},
  67. </if>
  68. <iftest="habbit!=nullandhabbit!=''">
  69. habbit=#{habbit,jdbcType=VARCHAR},
  70. </if>
  71. <iftest="memo!=nullandmemo!=''">
  72. memo=#{memo,jdbcType=VARCHAR},
  73. </if>
  74. </set>
  75. whereid=#{id,jdbcType=INTEGER}
  76. </update>
  78. <deleteid="deleteTestEntityById"parameterType="int">
  79. deletefromtest_testwhereid=#{id}
  80. </delete>
  82. </mapper>

4、mybatis主配置文件mybatis-config.xml

Xml代码 收藏代码
  1. <?xmlversion="1.0"encoding="UTF-8"?>
  2. <!DOCTYPEconfigurationPUBLIC"-//mybatis.org//DTDConfig3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd">
  3. <configuration>
  4. <!--配置数据库方言目前只有mysql和oracle两种-->
  5. <properties>
  6. <propertyname="dialect"value="mysql"/>
  7. </properties>
  9. <!--配置mysql分页拦截器start-->
  10. <!--com.xxyd.mybatis.interceptor.PaginationInterceptor来自于jar包mybatis-pager-1.0.0.jar-->
  11. <plugins>
  12. <plugininterceptor="com.xxyd.mybatis.interceptor.PaginationInterceptor"></plugin>
  13. </plugins>
  15. <!--映射文件-->
  16. <mappers>
  17. <mapperresource="com/xxyd/mybatis/mapper/TestMapper.xml"/>
  18. </mappers>
  19. </configuration>

6、jdbc.properties文件

Xml代码 收藏代码
  1. driverClass=com.mysql.jdbc.Driver
  2. url=jdbc\:mysql\://127.0.0.1\:3306/student_manager
  3. username=root
  4. password=123456

7、spring配置文件部分配置

Xml代码 收藏代码
  1. <?xmlversion="1.0"encoding="UTF-8"?>
  2. <beansxmlns="http://www.springframework.org/schema/beans"
  3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:aop="http://www.springframework.org/schema/aop"
  4. xmlns:p="http://www.springframework.org/schema/p"xmlns:tx="http://www.springframework.org/schema/tx"
  5. xmlns:context="http://www.springframework.org/schema/context"
  6. xsi:schemaLocation="
  7. http://www.springframework.org/schema/beans
  8. http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
  9. http://www.springframework.org/schema/aop
  10. http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
  11. http://www.springframework.org/schema/tx
  12. http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
  13. http://www.springframework.org/schema/context
  14. http://www.springframework.org/schema/context/spring-context.xsd">
  16. <!--Properties文件读取配置，base的properties-->
  17. <context:property-placeholderlocation="classpath:jdbc.properties"/>
  19. <beanid="dataSource"
  20. class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  21. <propertyname="driverClassName"value="${driverClass}"/>
  22. <propertyname="url"value="${url}"/>
  23. <propertyname="username"value="${username}"></property>
  24. <propertyname="password"value="${password}"></property>
  25. </bean>
  27. <beanid="transactionManager"
  28. class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  29. <propertyname="dataSource"ref="dataSource"/>
  30. </bean>
  32. <beanid="sqlSessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean">
  33. <propertyname="configLocation"value="classpath:mybatis-config.xml"/>
  34. <propertyname="dataSource"ref="dataSource"/>
  35. </bean>
  37. <!--测试用例start-->
  38. <beanid="TestMapperTest"class="com.xxyd.mybatis.test.TestMapperTest">
  39. <propertyname="sessionFactory"ref="sqlSessionFactory"/>
  40. </bean>
  41. <!--测试用例end-->
  44. <!--mapperbean-->
  45. <beanid="TestMapper"class="org.mybatis.spring.mapper.MapperFactoryBean">
  46. <propertyname="mapperInterface"value="com.xxyd.mybatis.dao.TestMapper"/>
  47. <propertyname="sqlSessionFactory"ref="sqlSessionFactory"/>
  48. </bean>
  50. </beans>

7、最后，测试类：

Java代码 收藏代码
  1. packagecom.xxyd.mybatis.test;
  3. importjava.util.List;
  5. importorg.apache.ibatis.session.RowBounds;
  6. importorg.apache.ibatis.session.SqlSession;
  7. importorg.apache.ibatis.session.SqlSessionFactory;
  8. importorg.apache.ibatis.session.SqlSessionFactoryBuilder;
  9. importorg.junit.Test;
  10. importorg.springframework.context.support.ClassPathXmlApplicationContext;
  12. importcom.xxyd.mybatis.pojo.TestEntity;
  14. publicclassTestMapperTest{
  16. //privateSqlSessionFactorysessionFactory;
  17. privatestaticSqlSessionFactoryBuilderbuilder;
  18. privatestaticSqlSessionFactorysessionFactory;
  19. static{
  20. builder=newSqlSessionFactoryBuilder();
  21. sessionFactory=builder.build(Thread.currentThread()
  22. .getContextClassLoader()
  23. .getResourceAsStream("mybatis-config.xml"));
  24. }
  25. /**
  26. *@paramargs
  27. */
  28. publicstaticvoidmain(String[]args){
  29. ClassPathXmlApplicationContextctx=newClassPathXmlApplicationContext("applicationContext.xml");
  30. TestMapperTestTestMapperTest=(TestMapperTest)ctx.getBean("TestMapperTest");
  31. TestMapperTest.getList();
  33. }
  35. @Test
  36. publicvoidgetList(){
  37. SqlSessionsqlSession=sessionFactory.openSession();
  38. //TestEntityentity=newTestEntity();
  39. List<TestEntity>list=sqlSession.selectList("com.xxyd.mybatis.dao.TestMapper.getListTestEntity",TestEntity.class,newRowBounds(0,200));
  40. sqlSession.commit();
  41. sqlSession.close();
  42. for(TestEntitytestEntity:list){
  43. System.out.println(testEntity.toString());
  44. }
  45. }
  47. //publicSqlSessionFactorygetSessionFactory(){
  48. //returnsessionFactory;
  49. //}
  50. //publicvoidsetSessionFactory(SqlSessionFactorysessionFactory){
  51. //this.sessionFactory=sessionFactory;
  52. //}
  53. }

能够成功运行的前提是，你已经将mybatis+spring的运行环境搭建好了，并且将mybatis-pager-1.0.0.jar也放置到classpath下。之后，直接运行测试类就可以了。

注意1：mybatis-pager-1.0.0.jar该包就是浪费我昨天一整天也没整出来的分页jar包，里面目前只适用于mysql和oracle两种数据库使用，其他的数据库还在研究中。

注意2：List<TestEntity> list = sqlSession.selectList("com.xxyd.mybatis.dao.TestMapper.getListTestEntity", TestEntity.class, new RowBounds(0, 200));
第一个参数标准写法是TestMapper.xml的名称空间+select的对应id（建议sql映射文件中的sql语句结尾不要有分号）；第二个参数是：实体类，当然也可以使字符串，只有是Object类型的就可以，目前还没发现什么异常，或许我研究的较为浅显的原因；第三个参数则是需要分页的数据。

iteye_4639
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值