解决selectAll不支持@orderby注解的问题。

abel533 · abel533 · commit bee665f6f7bd · 2015-10-28T20:53:19.000+08:00
diff --git a/src/main/java/tk/mybatis/mapper/provider/base/BaseSelectProvider.java b/src/main/java/tk/mybatis/mapper/provider/base/BaseSelectProvider.java
@@ -162,6 +162,11 @@ public String selectAll(MappedStatement ms) {
         StringBuilder sql = new StringBuilder();
         sql.append("select ").append(EntityHelper.getSelectColumns(entityClass)).append(" from ");
         sql.append(tableName(entityClass));
+
+        String orderByClause = EntityHelper.getOrderByClause(entityClass);
+        if (orderByClause.length() > 0) {
+            sql.append(" ORDER BY ").append(orderByClause);
+        }
         return sql.toString();
     }
 }
diff --git a/src/test/java/tk/mybatis/mapper/model/Country.java b/src/test/java/tk/mybatis/mapper/model/Country.java
@@ -2,6 +2,7 @@
 
 import javax.persistence.Column;
 import javax.persistence.Id;
+import javax.persistence.OrderBy;
 import java.io.Serializable;
 
 /**
@@ -11,8 +12,11 @@
  */
 public class Country implements Serializable {
     private static final long serialVersionUID = -1626761012846137805L;
+
     @Id
+    @OrderBy("desc")
     private Integer id;
+
     @Column
     private String countryname;
     private String countrycode;
diff --git a/src/test/java/tk/mybatis/mapper/test/country/TestSelectAll.java b/src/test/java/tk/mybatis/mapper/test/country/TestSelectAll.java
@@ -32,4 +32,23 @@ public void testDynamicSelectPage() {
             sqlSession.close();
         }
     }
+
+    /**
+     * 查询全部
+     */
+    @Test
+    public void testDynamicSelectPage2() {
+        SqlSession sqlSession = MybatisHelper.getSqlSession();
+        try {
+            CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
+
+            List<Country> countryList = mapper.selectAll();
+            //查询总数
+            Assert.assertEquals(183, countryList.size());
+            //selectAll有排序
+            Assert.assertEquals(183, (int) countryList.get(0).getId());
+        } finally {
+            sqlSession.close();
+        }
+    }
 }

Original file line number	Diff line number	Diff line change
`@@ -162,6 +162,11 @@ public String selectAll(MappedStatement ms) {`
`162`	`162`	`StringBuilder sql = new StringBuilder();`
`163`	`163`	`sql.append("select ").append(EntityHelper.getSelectColumns(entityClass)).append(" from ");`
`164`	`164`	`sql.append(tableName(entityClass));`
	`165`	`+`
	`166`	`+ String orderByClause = EntityHelper.getOrderByClause(entityClass);`
	`167`	`+ if (orderByClause.length() > 0) {`
	`168`	`+ sql.append(" ORDER BY ").append(orderByClause);`
	`169`	`+ }`
`165`	`170`	`return sql.toString();`
`166`	`171`	`}`
`167`	`172`	`}`