1.背景:公司需要对拿到的数据进行转换。拿到的为标准的csv格式的文件,公司需要txt格式的文件数据。于是写了一个java程序,将拿到的文件数据放到jar文件目录下,运行jar文件,在jar文件目录下生成需要的txt格式文件。
2,获取当前jar文件的目录 读取csv文件,这里有个小工具类
package com.pats.file.change;
import java.io.File;
public class JarToolUtil {
/**
* 获取jar绝对路径
*
* @return
*/
public static String getJarPath()
{
File file = getFile();
if (file == null)
return null;
return file.getAbsolutePath();
}
/**
* 获取jar目录
*
* @return
*/
public static String getJarDir()
{
File file = getFile();
if (file == null)
return null;
return getFile().getParent();
}
/**
* 获取jar包名
*
* @return
*/
public static String getJarName()
{
File file = getFile();
if (file == null)
return null;
return getFile().getName();
}
/**
* 获取当前Jar文件
*
* @return
*/
private static File getFile()
{
// 关键是这行...
String path = JarToolUtil.class.getProtectionDomain().getCodeSource().getLocation().getFile();
try
{
path = java.net.URLDecoder.decode(path, "UTF-8"); // 转换处理中文及空格
}
catch (java.io.UnsupportedEncodingException e)
{
return null;
}
return new File(path);
}
/**
* 获取当前目录下的文件
*/
public static List<String> getFile(String path) {
File file = new File(path);
File[] fileList = file.listFiles();
List<String> list = new ArrayList<String>();
for (int i = 0; i < fileList.length; i++) {
if (fileList[i].isFile()) {
String fileName = fileList[i].getName();
list.add(fileName);
}
/*if (fileList[i].isDirectory()) {
String fileName = fileList[i].getName();
System.out.println("目录:" + fileName);
}*/
}
return list;
}
}
3.下面时读csv 文件 写入txt文件的代码,共有两个方法 read() 和 write();
package com.pats.file.change;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.util.List;
public class Change {
public static void read() {
try {
String filePath = JarToolUtil.getJarDir();
List<String> pathList = JarToolUtil.getFile(filePath);
BufferedReader reader = null;
for (String list : pathList) { // 遍历目录下的文件名 找到需要的csv文件
if (list.endsWith("csv")) {
reader = new BufferedReader(new FileReader(filePath + "\\" + list));
reader.readLine();// 第一行信息,为标题信息,不用,如果需要,注释掉
String line = null;
while ((line = reader.readLine()) != null) {
String[] item = line.split(",");// CSV格式文件为逗号分隔符文件,这里根据逗号切分
String writePath = filePath + "\\" + list.replace(".csv", ".txt"); // 为了写入相同的文件名
write(item, "USD/CNY", writePath);
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
@SuppressWarnings("resource")
public static void write(String[] str, String symbol, String writePath) throws IOException {
String text = null;
String timestamp = str[0] + "," + str[1];
File txt = new File(writePath);
if (!txt.exists()) {
txt.createNewFile();
}
BufferedWriter bw = null;
bw = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(txt, true), "UTF-8"));
// TODO Auto-generated catch block
// TODO Auto-generated catch block
if (str.length == 22) {
for (int i = 2; i <= 6; i++) {
text = "{\"CONN_NAME\":\"TR_CONN1\",\"INSTRUMENT_CODE\":\"CNY=\",\"BIDPRICE\":" +"\""+ str[i + 15]+"\""
+ ",\"ASKPRICE\":" +"\""+ str[i + 10]+"\"" + ",\"BIDVOLUME\":" +"\""+ str[i + 5]+"\"" + ",\"ASKVOLUME\":" +"\""+ str[i]+"\""
+ ",\"IS_LINE_PRICE\":\"0\",\"IS_CROSS\":\"DIRECT\",\"CREATE_TIME\":" + timestamp
+ ",\"SIDE_ASK\":\"\",\"CODE_SET\":\"\",\"MODEL_ID\":\"\",\"SOURCE\":\"\",\"TRADESESSION\":\"\",\"PRICE_ID\":\"TR_CNY=_f2fc80dfc86d\",\"SIDE_BID\":\"\",\"RUNG\":\"\",\"TENOR\":\"\",\"TYPE\":\"\",\"FWD_SKEW_VALUE\":\"\",\"DATE_TIME\":\"2018-06-13 11:03:37,249\",\"IS_POLISH\":\"0\",\"BID_H\":\"\",\"SYMBOL_NAME\":\"\",\"VALUEDATE\":\"\",\"IS_REVERSE\":\"\",\"SKEW\":\"\",\"BID_N\":\"\",\"CHANNEL\":\"\",\"BID_V\":\"\",\"ISPANIC\":\"\",\"IS_USE\":\"\",\"IS_MANUAL\":\"\",\"BASIS_POINT\":\"\",\"TRADE_METHOD\":\"\",\"PRODUCT_ID\":\"\",\"VENUE\":\"TR\",\"OPERATOR\":\"\",\"BID_IS_VALID\":\"\",\"STATUS\":\"\",\"MARKET\":\"\",\"IS_VALID\":\"\",\"TEXT\":\"\",\"SPREAD\":\"\",\"MSGTYPE\":\"SINGLEFXPRICE\",\"VOLATILITY\":\"0\",\"ASKMOVE\":\"1\",\"BIG_NUM\":\"\",\"DAYS\":\"\",\"DEFAULT_LEVEL\":\"\",\"ASK_N\":\"\",\"SIDE\":\"BOTH\",\"BIDMOVE\":\"1\",\"ASK_H\":\"\",\"MODEL_NAME\":\"\",\"USER\":\"\",\"ASK_VOLATILITY\":\"0\",\"ASK_IS_VALID\":\"\",\"SYMBOL_ID\":\"\",\"SOURCE_NAME\":\"\",\"PRICE_TYPE\":\"SOURCE\",\"USER_NAME\":\"\",\"SETTLEMENTPRICE\":\"0\",\"ASK_V\":\"\",\"QUOTE_ID\":\"\",\"BASE_CURRENCY\":\"\",\"BID_VOLATILITY\":\"0\"}";
bw.write(text);
// TODO Auto-generated catch block
bw.newLine();
// TODO Auto-generated catch block
}
bw.close();
}
}
}