Java ibatis批量insert_java Ibatis批量插入数据

java 业务类代码实现

/**

* 将队列中的数据插入到数据库

*/

public void insertGpsInfo(List dataList){

try {

//保存总数据

List> paramList=new ArrayList>();

for(int i=0;i

Map paramMap=new HashMap();

paramMap.put("CommonNO", dataList.get(i).split(",")[0]); //通过截取字符得到通讯号

paramMap.put("VehicleState", dataList.get(i).substring(dataList.get(i).indexOf(",")+1, dataList.get(i).lastIndexOf(",")));

//this.ibatisSearchRepository.insertIbatisObject("INSERTGPSINFO", param);

paramList.add(paramMap);

}

//执行批量插入数据

this.ibatisSearchRepository.batchInsertIbatisObject("INSERTGPSINFO", paramList);

} catch (Exception e) {

// TODO: handle exception

this.logger.error("数据入库失败！"+e);

}

}

INSERT INTO BS_Forword_SK_Vehicle_Result(

CommonNO,

VehicleState)

VALUES(#CommonNO#,#VehicleState#)

1

顶

3

踩

分享到：

2010-12-23 18:44

浏览 6840

评论