ibatis实现结果集map封装(Demo下载)
package com.ist;import java.io.IOException;import java.io.Reader;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.HashMap;import java.util.Iterator;import java.util.List;import java.util.Set;import com.ibatis.common.resources.Resources;import com.ibatis.sqlmap.client.SqlMapClient;import com.ibatis.sqlmap.client.SqlMapClientBuilder;import com.ibatis.sqlmap.client.SqlMapSession;import com.ist.domain.Employee;public class Test {public static void main(String[] args) throws SQLException {String resource = "SqlMapConfig.xml";Reader reader = null;try {reader = Resources.getResourceAsReader(resource);} catch (IOException e) {e.printStackTrace();}SqlMapClient client = SqlMapClientBuilder.buildSqlMapClient(reader);ArrayList list = (ArrayList) client.queryForList("getAllEmployee", null);StringBuffer sb1=new StringBuffer();StringBuffer sb2=new StringBuffer();Iterator it = list.iterator();while (it.hasNext()) {HashMap map = (HashMap) it.next(); //强转成HashMap哦Set set = map.keySet();Iterator setit=set.iterator();while(setit.hasNext()){String colname=(String) setit.next();sb1.append(colname+"\t");sb2.append(map.get(colname)+"\t");}System.out.println(sb1.toString());System.out.println(sb2.toString());sb1.setLength(0);sb2.setLength(0);}}}?
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd"><!-- resultClass 是HashMap --><sqlMap namespace="T12_category"><statement id="getAllEmployee" parameterresultname="code">COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNOnull201980-12-17 00:00:00.07902800SMITHCLERK7369COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNO300301981-02-20 00:00:00.076981600ALLENSALESMAN7499COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNO500301981-02-22 00:00:00.076981250WARDSALESMAN7521COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNOnull201981-04-02 00:00:00.078392975JONESMANAGER7566COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNO1400301981-09-28 00:00:00.076981250MARTINSALESMAN7654COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNOnull301981-05-01 00:00:00.078392850BLAKEMANAGER7698COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNOnull101981-06-09 00:00:00.078392450CLARKMANAGER7782COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNOnull201987-04-19 00:00:00.075663000SCOTTANALYST7788COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNOnull101981-11-17 00:00:00.0null5000KINGPRESIDENT7839COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNO0301981-09-08 00:00:00.076981500TURNERSALESMAN7844COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNOnull201987-05-23 00:00:00.077881100ADAMSCLERK7876COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNOnull301981-12-03 00:00:00.07698950JAMESCLERK7900COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNOnull201981-12-03 00:00:00.075663000FORDANALYST7902COMMDEPTNOHIREDATEMGRSALENAMEJOBEMPNOnull101982-01-23 00:00:00.077821300MILLERCLERK7934
?