package control;
import org.junit.Test;
import java.io.*;
import java.text.ParseException;
import java.text.ParsePosition;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
public class qwe {
public static void main(String[] args) {
String fileName1 = "D:\\dingdingcunchu\\CRM数据.txt";
String fileName2 = "D:\\dingdingcunchu\\CRM数据2.txt";
}
public static void haomiao(String fileName1,String fileName2) throws ParseException, IOException {
BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream(new File(fileName1))));
BufferedWriter bufferedWriter = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(new File(fileName2))));
String str = null;
if (str.isEmpty() == false) {
String[] split = str.split("\t");
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy/MM/dd HH:mm");
Date date = simpleDateFormat.parse(split[1]);
long time = date.getTime();
String s = String.valueOf(time);
bufferedWriter.write("{\"type\":\"profile_set\",\"distinct_id\":\""+split[0]+"\",\"properties\":{\"$is_login_id\":true,\"CrmCreateTime\":"+s+"}}" + "\r\n");
bufferedWriter.flush();
}
}
public static void quanbu(String fileName1,String fileName2) throws IOException {
String str = null;
//int count = 0;
//读文件
BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream(new File(fileName1))));
//写文件
BufferedWriter bufferedWriter = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(new File(fileName2))));
//读每行如果不为null
while ((str = br.readLine()) != null) {
// String replace = str.replace("\"type\":\"profile_set\"", "\"type\":\"profile_delete\"");
// String replace = str.replace("name", "$name");
// String replace = str.replace("signup_time","$signup_time");
// String replace = str.replace("\"properties\":{","\"properties\":{\"$is_login_id\":true,");
if (str.isEmpty() == false) {
String[] split = str.split("\t");
//String replace = str.replace(split[3],"\"time\":\"1628235549\"");
//bufferedWriter.write("UPDATE Group_Department.Name_Group_Department_Five SET staff_department= '" + split[1] + "' and staff_group = '" + split[2] + "' WHERE staff_username = '" + split[0] + "'" + "\r\n");
//bufferedWriter.write(replace + "\r\n");
//刷新
bufferedWriter.flush();
}
// bufferedWriter.write("INSERT INTO Group_Department.Name_Group_Department_Two VALUES ("+split[0]+","+split[1]+","+split[2]+","+split[3]+","+split[4]+");"+"\r\n");
// String replace = str.replace("\"", "");
//写进文件的内容
// bufferedWriter.write(replace + "\r\n");
// 刷新
// bufferedWriter.flush();
}
// while ((str = br.readLine())!=null){
// boolean length = str.isEmpty();
//
// if (length==true){
// count++;
// }
// }
// System.out.println(count);
}
}
版权声明:本文为weixin_44524441原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。