mybatis返回List<Object[]>数据

来源：互联网发布：qq for mac历史版本编辑：程序博客网时间：2024/06/05 11:56

IStatisticMapper.java

<pre name="code" class="java">/** * 很据条件查找对象集合 * liuqi * @param * 返回类型： List<Map<String,Object>> */List<Map<String, Object>> selectSubmitRecordById(Map<String, Object> inMap) throws Exception;

IStatisticMapper.xml

<!-- 很据条件查找对象集合 --><select id="selectSubmitRecordById" parameterType="Map" resultType="java.util.LinkedHashMap">SELECT b.id, b.merchantNo,b.`name`,IF(b.charging=1,'预存','后结') AS charging,b.contactWay,a.price,a.stripNum,a.totalPrice,if(a.isClose=1,'已结','未结') AS isClose FROM smms_submit_record a,smms_merchant b <where>a.merchantId = b.id <if test="startTime != '' and startTime != null">and DATE_FORMAT(a.submitTime,'%Y-%m-%d') >= #{startTime}</if><if test="endTime != '' and endTime != null">and DATE_FORMAT(a.submitTime,'%Y-%m-%d') <= #{endTime}</if><if test="merchantID != '' and merchantID != null">and b.id = #{merchantID}</if><if test="merchantNo != '' and merchantNo != null">and b.merchantNo like CONCAT(CONCAT('%',#{merchantNo}),'%')</if><if test="name != '' and name != null">and b.name like CONCAT(CONCAT('%',#{name}),'%')</if>AND a.isClose = 0 </where><if test=" pageUtil != null">limit #{pageUtil.start},#{pageUtil.numPerPage}</if></select>

StatisticServiceImpl.java

List<Map<String, Object>> mapList = testServiceImpl.selectSubmitRecordList(inMap);List<Object[]> obj = new ArrayList<Object[]>();for (Map<String, Object> map : mapList) {System.out.println(map.values());Collection values = map.values(); List list = new ArrayList(values); obj.add(list.toArray());}

0 0