packagecom.mysql;importjava.io.BufferedReader;importjava.io.File;importjava.io.FileInputStream;importjava.io.InputStreamReader;importjava.text.SimpleDateFormat;importjava.util.ArrayList;importjava.util.Date;importjava.util.List;importjava.util.Locale;importcom.service.MessageService;importcom.sun.org.apache.xerces.internal.impl.xpath.regex.ParseException;public classtestmysql {public static ArrayListgetfile(String filepath){try{
String temp= null;
File f= newFile(filepath);//指定读取编码用于读取中文
InputStreamReader read = new InputStreamReader(new FileInputStream(f),"utf-8");
ArrayList readList = new ArrayList();
BufferedReader reader=newBufferedReader(read);//bufReader = new BufferedReader(new FileReader(filepath));
while((temp=reader.readLine())!=null &&!"".equals(temp)){
readList.add(temp);
}
read.close();returnreadList;
}catch(Exception e) {
e.printStackTrace();
}return null;
}//改变时间的格式
public static String parseDate(String dateStr) throwsjava.text.ParseException{
SimpleDateFormat input_date= new SimpleDateFormat("dd/MMM/yyyy:HH:mm:ss Z", Locale.ENGLISH);
SimpleDateFormat output_date= new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String finalDate= "";try{
Date parse_date=input_date.parse(dateStr);
finalDate=output_date.format(parse_date);
}catch(ParseException e) {
e.printStackTrace();
}returnfinalDate;
}public static void main(String[] args) throwsjava.text.ParseException {//txt文件读取
ArrayList list=getfile("D:\\result.txt");//List list1=new ArrayList();
int num=list.size();for (int i = 0; i < num; i++) {//System.out.println(list.get(i));
if (list.get(i)!=null) {
String[] s=list.get(i).split(",");
String data=parseDate(s[1]);//txt每行可以分割成6个字符串存到是s[],
String sql = "insert into detailresult(ip,time,day,traffic,type,id) values('" + s[0] + "','" +data+ "','" +s[2] + "','" + s[3] +"','" + s[4] +"','" + s[5] + "')";
MessageService.add(sql);
}
}
System.out.println("添加成功");
}
}