这两天写的mybatis配置文件，主要是有输出和输入的存储过程

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
 3     "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 4     
 5 <mapper  namespace="com.neusoft.www.competition.mapper.CompetitionMapper">
 6 
 7 <!--  <select id="getCmptList"  statementType="CALLABLE"> -->
 8 <!--    { -->
 9 <!--       call pgetCmptList( -->
10 <!--       #{cityCode,  jdbcType=VARCHAR,javaType=java.lang.String,mode=IN}, -->
11 <!--       #{cityType,  jdbcType=VARCHAR,javaType=java.lang.String,mode=IN}, -->
12 <!--       #{sortby,    jdbcType=VARCHAR,javaType=java.lang.String,mode=IN}, -->
13 <!--       #{sortMethod,jdbcType=VARCHAR,javaType=java.lang.String,mode=IN}, -->
14 <!--       #{itemIndex, jdbcType=VARCHAR,javaType=java.lang.String,mode=IN}, -->
15 <!--       #{pageSize,  jdbcType=VARCHAR,javaType=java.lang.String,mode=IN},  -->
16 <!--       #{userId,    jdbcType=VARCHAR,javaType=java.lang.String,mode=IN}, -->
17 <!--       ) -->
18 <!--    } -->
19   
20 <!--  </select> -->
21  
22  <select id="getCmptList" resultType="com.neusoft.www.competition.controller.CompetitionController" statementType="CALLABLE">
23   {
24       call pgetCmptList(
25       #{cityCode,  jdbcType=VARCHAR,javaType=java.lang.String,mode=IN},
26       #{sortby,    jdbcType=VARCHAR,javaType=java.lang.String,mode=IN},
27       #{sortMethod,jdbcType=VARCHAR,javaType=java.lang.String,mode=IN},
28       #{itemIndex, jdbcType=VARCHAR,javaType=java.lang.String,mode=IN},
29       #{pageSize,  jdbcType=VARCHAR,javaType=java.lang.String,mode=IN}
30       )
31    }
32  </select>
33  
34  <select id="getCmptList" parameterType="Map" resultType="com.neusoft.www.competition.controller.CompetitionController">
35     
36        SELECT `cmptId`
37      , `cmptName`
38      , `duration`
39      , `cmptStarLevel`
40      , `cmptCapacity`
41      , `cmptLength`
42      , `imgId`
43      , vcityCode
44 
45 FROM
46   v_getcmtlist2
47 WHERE
48     vcityCode = #{cityCode}
49 GROUP BY
50   cmptId
51 ORDER BY 
52 <!--   <![CDATA[ cmptCapacity ]]> -->
53 
54     ${sortby} ${sortMethod}
55     
56  </select>
57 </mapper>
View Code
其中设计到order by的使用和排序
posted on 2014-04-11 13:24 和硕亲王阅读(375) 评论(0) 编辑收藏举报