当前位置: 代码迷 >> 综合 >> spring批量新增mysql数据
  详细解决方案

spring批量新增mysql数据

热度:60   发布时间:2023-11-01 03:46:54.0
	public void create(List<WfCountHoursFansNum> list) {String sql =	new WfCountHoursFansNum().getCreateObjSql() ;//暂时未优化// logger.debug("create(String sql, T t)====" + sql);BeanPropertySqlParameterSource[] arr = null;Object[] arrObj = null;if (list != null) {arrObj = list.toArray();}if (arrObj != null && arrObj.length > 0) {arr = new BeanPropertySqlParameterSource[arrObj.length];for (int i = 0; i < arrObj.length; i++) {
//				if (i % 100 == 0){
//					log.info((i + 1) + "/" + arrObj.length);
//				}arr[i] = new BeanPropertySqlParameterSource(arrObj[i]);}getSimpleJdbcTemplate().batchUpdate(sql, arr);
//			log.info("finish,共计:" + objList.size());}}

  相关解决方案