JAVA学习(一)__操作FTP(二)
return null;
}
}
/**
* 利用javacsv解析csv文件
* @param file
* @return
*/
private List javaCsv(String file){
try{
List omnitureList = new ArrayList();
CsvReader reader = new CsvReader(file, ',', Charset.forName("UTF-8"));
int i = 0;
while (reader.readRecord())
{
//跳过没用的行数。
if(i++ <= 15){
String[] str = reader.getValues();
System.out.println("数字编号："+ (i-1) + str[0]);
continue;
}
//读取每行数据以数组形式返回
String[] str = reader.getValues();
OmnitureReportBean omniture = new OmnitureReportBean();
String timeStr = file.trim().substring(21, 28);
Date date = smipleDateFormat.parse(timeStr);
omniture.setStartTime(date);
omniture.setEndTime(date);
omniture.setBrowsers(str[0]);
omniture.setVisits(new Integer(str[1].replace(",", "").trim()));
omniture.setSearches(new Integer(str[2].replace(",", "").trim()));
omniture.setCardAdd(new Integer(str[3].replace(",", "").trim()));
omniture.setCheckOuts(new Integer(str[4].replace(",", "").trim()));
omniture.setPament(new Integer(str[5].replace(",", "").trim()));
omniture.setOrders(new Integer(str[6].replace(",", "").trim()));
omniture.setType(2);
omnitureList.add(omniture);
List list = this.omnitureDao.findOmnitureMonthList(omniture.getStartTime(),omniture.getBrowsers());
//若表里面已有该时间段的数据，则不重复插入本次csv中的数据
if(list!=null&&list.size()>0){
continue;
}else{
omnitureDao.saveOmniture(omniture);
}
}
return omnitureList;
}catch(Exception e){
e.printStackTrace();
return null;
}
}
/**
* 与当前日期比较。如早于当前时间返回true.否而返回false
* @param endDate
* @return
*/
public static boolean compareToDate(Date date){
Calendar cal1 = Calendar.getInstance();
Calendar cal2 = Calendar.getInstance();
Date nowDate = new Date();
cal1.setTime(date);
cal1.add(Calendar.HOUR_OF_DAY, 00);
cal1.add(Calendar.MINUTE, 00);
cal1.add(Calendar.SECOND, 00);
cal2.setTime(nowDate);
cal2.add(Calendar.HOUR_OF_DAY, 00);
cal2.add(Calendar.MINUTE, 00);
cal2.add(Calendar.SECOND, 00);
boolean flag = cal1.before(cal2);
if(flag){
//早于当前
系统时间
return true;
}else{
//晚于当前系统时间
return false;
}
}
/**
* 删除服务器上的文件
* @param path
* @return
* @throws IOException
*/
public boolean delFile(String path) throws IOException {
boolean flag = false;
FTPClient client = new FTPClient();
Date currentTime = new Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyMMdd");
String dateString = formatter.format(currentTime);
String fi