Mybatis的resultMap返回map问题

目录

resultmap返回map问题

<resultmap type="map" id="bankmaintainmap">      <result column="bank_name" property="bankname"/>      <result column="maintain_time_interval" property="maintaintimeinterval"/>  </resultmap>  <lect id="getmaintainnotice" parametertype="map" resultmap="bankmaintainmap">      lect           bank_name,          maintain_time_interval      from          fp_channel_prd_bank      where           channel_prd_id=7       and               maintain_time_interval  </lect>

简单封装resultmap返回对象为map

public class dbutils {    private static string host = "47.93.******";    private static string port = "3306";    private static string urname = "*****";    private static string password = "******";    private static string databa = "******";    static {        try {            class.forname("com.mysql.jdbc.driver");        } catch (exception e) {        }    }    private static connection getconn() {        connection conn = null;        try {            string url = "jdbc:mysql://" + host + ":" + port + "/" + databa;            conn = drivermanager.getconnection(url, urname, password);        } catch (exception e) {            e.printstacktrace();        }        return conn;    }    public static list<map<string, object>> execquery(string sql, object[] args) throws exception {        connection conn = getconn();        preparedstatement ps = conn.库存产品preparecall(sql);        resultt rs = null;        int count = stringutils.countmatches(sql, "?");        //变量赋值。。。。。。        for (int i = 0; i < count; i++) {            ps.tobject(i, args[i]);        }        list<map<string, object>> list = new arraylist<map<string, object>>();        rs = ps.executequery();        resulttmetadata metadata = rs.getmetadata();　　　　　　//注意。。metadata.getcolumnname 获取字段名，rs.getobject 获取属性 是从 1 开始的，而不是从0 开始        while (rs.next()) {            int rowsize = metadata.getcolumncount();            map<string, object> map = new hashmap&l极限推理t;>();            for (int i = 1; i <= rowsize; i++) {                string labelname = metadata.getcolumnname(i);                object obj = rs.getobject(labelname);                map.put(labelname, obj);            }            list.add(map);        }        clo(conn, ps, rs);        ret物管法urn list;    }    /**     * @param conn     * @param ps     * @param rs     * @throws exception     */    private static void clo(connection conn, preparedstatement ps, resultt rs) throws exce冬至祝福语简短ption {     体面歌词   rs.clo();        ps.clo();        conn.clo();    }

以上为个人经验，希望能给大家一个参考，也希望大家多多支持www.887551.com。