Mybatis如何从数据库中获取数据存为List类型(存为model)

目录

从数据库中获取数据存为list类型(存为model)

从数据库中获取的数据，存到一个model中，需要注意两点。孔子英语

//dao @override public arraylist<yourmodel> getmaininfo(int id) {什么是磁通量     // todo auto-generated method stub     list<yourmodel> result = null;     try{         sqlssion = this.getsqlssion();     }catch (exception e){         e.printstacktrace();         yourmodel yourmodel = new yourmodel();         try{           /**             * 很奇怪，在这里不能直接强转类型为arraylist<gradecheck>             * 只能在下面return的时候强转类型.....             * */             result = sqlssion.lectlist(this.namespace.concat("getmaininfo"), yourmode我战胜了什么作文l);     }catch (exception e){     return null;     }     return (arraylist<yourmodel>)result; }//mapperlist<model> findbyids(long... ids); <lect id="findbyids" resultmap="baresultmap">     lect <include refid="ba_column_list" /> from model(tablename)     where id in     <foreach item="item" index="index" collection="array" open="(" paraotr="," clo=")">     #{item}     </foreach> </lect>

mybatis存储list类型数据

dao层

void inrtlist(list<tzpcjsj> list);

*mapper

<!--批量 插入记录 -->  <inrt id="inrtlist" >    inrt into t_zpcjsj(nian_fen,hang_hao,belong_to_account,zhong_ming,lai_yuan,chang_du,bi_qiang,ma_zhi,ling_zhong,yi_fen,chu_miao_qi,kai_hua_qi,tu_xu_qi,szs_miao_qi,szs_hua_qi,zqd_miao_qi,zqd_hua_qi,shou_huo_zhu_shu,zytx_zhu_xing,zytx_ye_xing,zytx_ling_xing,zytx_zhu_gao,zytx_jie_ling_xing,zytx_ye_xu_xing,ku_wei_数学资料bing家庭美容_zhi,huang_wei_bing_zhi,tian_jian_jue_xuan,mark)values    <foreach collection="list" item="item" index="index" parator=','>        (#{item.nianfen},#{item.hanghao},#{item.belongtoaccount},#{item.zhongming},#{item.laiyuan},#{item.changdu},#{item.biqiang},#{item.mazhi},#{item.lingzhong},#{item.yifen},#{item.chumiaoqi},#{item.kaihuaqi},#{item.tuxuqi},#{item.szsmiaoqi},#{item.szshuaqi},#{item.zqdmiaoqi},#{item.zqdhuaqi},#{item.shouhuozhushu},#{item.zytxzhuxing},#{item.zytxyexing},#{item.zytxlingxing},#{item.zytxzhugao},#{item.zytxjielingxing},#{item.zytxyexuxing},#{item.kuweibingzhi},#{item.huangweibingzhi},#{item.tianjianjuexuan},#{item.mark})    </foreach>  </inrt>

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