记一次list事故,add不同对象最后显示的却是同一条数据重复了很多遍.

最新推荐文章于 2021-03-17 15:22:22 发布

bahukai7558

最新推荐文章于 2021-03-17 15:22:22 发布

阅读量233

点赞数

原文链接：http://www.cnblogs.com/onewild/p/9848652.html

版权

List<MemberMsg> memberList = new LinkedList<MemberMsg>();
MemberMsg memberMsg = new MemberMsg();
try {
BufferedInputStream in = new BufferedInputStream(new FileInputStream(file));
POIFSFileSystem fs = new POIFSFileSystem(in);
HSSFWorkbook wb = new HSSFWorkbook(fs);//xslx
HSSFSheet sheet= wb.getSheetAt(0);
int rowNum = sheet.getLastRowNum() + 1;
for (int i = 1; i < rowNum; i++) {
HSSFRow row = sheet.getRow(i);
int cellNum = row.getLastCellNum();
for (int j = 0; j < cellNum; j++) {
HSSFCell cell = row.getCell(j);
String cellValue = null;
if(CellType.NUMERIC==(cell.getCellTypeEnum())){
if(DateUtil.isCellDateFormatted(cell)){
Date d = cell.getDateCellValue();
DateFormat formater = new SimpleDateFormat("yyyy-MM-dd");
cellValue = formater.format(d);
}
}else {
cell.setCellType(CellType.STRING);
cellValue = cell.getStringCellValue();
}
switch (j%6) {
case 0:
memberMsg.setCustId(cellValue);
break;
case 1:
memberMsg.setCustName(cellValue);
break;
case 2:
memberMsg.setCustGender(cellValue);
break;
case 3:
memberMsg.setCustPhone(cellValue);
break;
case 4:
memberMsg.setCustBirthday(cellValue);
break;
case 5:
memberMsg.setCustAddress(cellValue);
break;
}
}
System.out.println(memberMsg);
memberList.add(i-1,memberMsg);
}
System.out.println(memberList);