DAO:
**
* 批量注册 base_user
* @param organList
* @return
*/
public int[] batchRegistOrganUser(ArrayList<ArrayList> organList){
List<MapSqlParameterSource> params = new ArrayList<>();
for (ArrayList<String> item : organList){
params.add(this.constructOrgan(item));
}
String sql = "INSERT INTO base_user (user_name, license_type, license_number, user_type)VALUES(:userName, :licenseType, licenseNumber, 2)";
return this.daoTemplate.batch(sql, params.toArray(new MapSqlParameterSource[params.size()]));
}
/**
* 转换参数
* @param date
* @return
*/
private MapSqlParameterSource constructOrgan(ArrayList<String> date) {
MapSqlParameterSource child = new MapSqlParameterSource();
child.addValue("userName",date.get(0));
child.addValue("licenseType",Integer.valueOf(date.get(2)));
child.addValue("licenseNumber",date.get(3));
return child;
}