1
<!--
2
查询得到男性或女性的数量, 如果传入的是0就女性否则是男性
3
-->
4
<
select
id
="getUserCount"
parameterMap
="getUserCountMap"
statementType
="CALLABLE"
>
5
CALL mybatis.ges_user_count(?,?)
6
</
select
>
7
8
<!--
9
parameterMap.put("sexid", 0);
10
parameterMap.put("usercount", -1);
11
-->
12
<
parameterMap
type
="java.util.Map"
id
="getUserCountMap"
>
13
<
parameter
property
="sexid"
mode
="IN"
jdbcType
="INTEGER"
/>
14
<
parameter
property
="usercount"
mode
="OUT"
jdbcType
="INTEGER"
/>
15
</
parameterMap
>
|
调用
SqlSession sqlSession =
MyBatisUtil.getSqlSession();
22
/**
23
* 映射sql的标识字符串,
24
* me.gacl.mapping.userMapper是userMapper.xml文件中mapper标签的namespace属性的值,
25
* getUserCount是select标签的id属性值,通过select标签的id属性值就可以找到要执行的SQL
26
*/
27
String statement = "me.gacl.mapping.userMapper.getUserCount";
//
映射sql的标识字符串
28
Map<String, Integer> parameterMap =
new
HashMap<String, Integer>
();
29
parameterMap.put("sexid", 1
);
30
parameterMap.put("usercount", -1
);
31
sqlSession.selectOne(statement, parameterMap);
32
Integer result = parameterMap.get("usercount"
);
33
System.out.println(result);
34
sqlSession.close();
|