1. 数值

<select id="getTotalCount"resultClass="java.lang.Integer" parameterClass="java.util.HashMap">      SELECT count(1) FROM TF_FUND_UNIT </select>

Integer count = (Integer)sqlMapper.queryForObject("getTotalCount",param);

 

2.实体类

<select id="getTfUsedVO" resultClass="com.fundPlan.vo.TfUsedVO" parameterClass="java.util.HashMap"> SELECT T.SUBJECT_ID subjectId, SUM(T.AMOUNT) amount FROM TF_FUND_PLAN_USED_LOG T WHERE 1=1 AND STATUS = '2' </select>

List<TfUsedVO>  list =  List<TfUsedVO>sqlMapper .queryForList( "getTfUsedVO",param);

 

3.Map类

<select id="getApproveList" resultClass="java.util.HashMap" parameterClass="java.util.HashMap" > select t.biz_id as bizId, p.PERIOD_TYPE as periodType, p.PERIOD_NAME as periodName, t.dept_id as initDeptId from ip_process_biz t </select>

List list = sqlMapper.queryForList("getApproveList",param); Map map = (Map) list.get(0);

 

4.金额

<select id="getSum" resultClass="java.math.BigDecimal"> SELECT PLAN_AMOUNT FROM TF_FUND_PLAN_ITEM WHERE 1=1 AND STATUS = '5' </select>

BigDecimal sum = ((BigDecimal))sqlMapper.queryForObject("getSum",param);

 

5.字符串

<select id="getBizId" resultClass="java.lang.String"> select A.BUDGET_ID from tf_item A where rownum=1 </select>

String id = (String)sqlMapper.queryForObject("getBizId",param);

 

SqlMapClient对象

这个对象是iBatis操作数据库的接口（执行CRUD等操作），它也可以执行事务管理等操作

Reader reader = Resources.getResourceAsReader("ibatis-config.xml"); private static SqlMapClient sqlMapper= SqlMapClientBuilder.buildSqlMapClient(reader); reader.close();