Topic: 请教:怎么用JAVA读取CSV文件!!!

  Print this page

1.请教:怎么用JAVA读取CSV文件!!! Copy to clipboard
Posted by: super12
Posted on: 2003-07-24 13:54

怎么用JAVA读取CSV文件!!!

2.Re:请教:怎么用JAVA读取CSV文件!!! [Re: super12] Copy to clipboard
Posted by: zhongyijie
Posted on: 2003-07-24 14:22

package Test;

import java.io.*;
import java.util.*;

public class CsvFileImport
{
private static String line = null;
BufferedReader in = null;

/**
* CsvFileImport constructor comment.
*/
public CsvFileImport() {
super();
}

public static void main(String args[]){

try
{

String fileName = "C:\\javatest\\CSVImport.csv";
BufferedReader in = new BufferedReader(new FileReader(fileName));
while((line = in.readLine()) != null){
StringTokenizer st=new StringTokenizer(line,",");
int tokenCount=0;
while(st.hasMoreTokens()){
tokenCount++;
String token=st.nextToken();
if(token.indexOf("\"")!=-1){
//this token contains a " , so we should read the next one too
String next;
while((next=st.nextToken()).indexOf("\"")==-1)
token+=next;//ugly,might use a stringbuffer
//it might also break if csv incorrectly formed
}
System.out.println(token);//you now have your token here, do extra processing with it
if(tokenCount==3){//this is the salary
try{
double value=Double.parseDouble(token);
value+=1000;
token=String.valueOf(value);
}catch(NumberFormatException e) {}
}
//now put the token in another file...
//TODO Wink
}
}

}

catch (IOException e)
{
System.err.printlnEnvelope;
}

}
}


   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923