~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
这是我写的个类 你参考下 其实那个引号是不用管的public class CsvUtil1 {
private String filename = null
private BufferedReader bufferedreader = null
private List list = new ArrayList()
public CsvUtil1() {
}
public CsvUtil1(String filename) throws IOException {
this.filename = filename
bufferedreader = new BufferedReader(new FileReader(filename))
String stemp
while ((stemp = bufferedreader.readLine()) != null) {
list.add(stemp)
}
}
public List getList() throws IOException {
return list
}
public int getRowNum() {
return list.size()
}
public int getColNum() {
if (!list.toString().equals("[]")) {
if (list.get(0).toString().contains(",")) {
return list.get(0).toString().split(",").length
} else if (list.get(0).toString().trim().length() != 0) {
return 1
} else {
return 0
}
} else {
return 0
}
}
public String getRow(int index) {
if (this.list.size() != 0)
return (String) list.get(index)
else
return null
}
public String getCol(int index) {
if (this.getColNum() == 0) {
return null
}
StringBuffer scol = new StringBuffer()
String temp = null
int colnum = this.getColNum()
if (colnum >1) {
for (Iterator it = list.iterator()it.hasNext()) {
temp = it.next().toString()
scol = scol.append(temp.split(",")[index] + ",")
}
} else {
for (Iterator it = list.iterator()it.hasNext()) {
temp = it.next().toString()
scol = scol.append(temp + ",")
}
}
String str = new String(scol.toString())
str = str.substring(0, str.length() - 1)
return str
}
public String getString(int row, int col) {
String temp = null
int colnum = this.getColNum()
if (colnum >1) {
temp = list.get(row).toString().split(",")[col]
} else if (colnum == 1) {
temp = list.get(row).toString()
} else {
temp = null
}
return temp
}
public void CsvClose() throws IOException {
this.bufferedreader.close()
}
public void test() throws IOException {
CsvUtil1 cu = new CsvUtil1("D:/学习/00dw.csv")
List tt = cu.getList()
for (Iterator itt = tt.iterator()itt.hasNext()) {
System.out.println(itt.next().toString()+"||")
}
// System.out.println(cu.getRowNum())
// System.out.println(cu.getColNum())
// System.out.println(cu.getRow(0))
// System.out.println(cu.getCol(0))
// System.out.println(cu.getString(0, 0))
cu.CsvClose()
}
public void createCsvTest1(HttpServletResponse Response) throws IOException {
CsvUtil1 cu = new CsvUtil1("D:/学习/00dw.csv")
List tt = cu.getList()
String data = ""
SimpleDateFormat dataFormat = new SimpleDateFormat("yyyyMMddHHmm")
Date today = new Date()
String dateToday = dataFormat.format(today)
File file=new File("D:/学习/001dw.csv")
if(!file.exists())
file.createNewFile()
// else
// file.delete()
String str[]
StringBuilder sb = new StringBuilder("")
BufferedWriter output=new BufferedWriter(new FileWriter(file,true))
for (Iterator itt = tt.iterator()itt.hasNext()) {
String fileStr = itt.next().toString()
str = fileStr.split(",")
for(int i=0i<=str.length-1i++){ //拆分成数组 用于插入数据库中
System.out.print("str["+i+"]="+str[i]+" ")
}
System.out.println("")
sb.append(fileStr+"\r\n")
}
//System.out.println(sb.toString())
output.write(sb.toString())
output.flush()
output.close()
cu.CsvClose()
}
public static void main(String[] args) throws IOException {
CsvUtil1 test = new CsvUtil1()
//test.test()
HttpServletResponse response = null
test.createCsvTest1(response)
}
}
![这句C语言语句怎么解释strl = strlen(xx[i])；](/aiimages/%E8%BF%99%E5%8F%A5C%E8%AF%AD%E8%A8%80%E8%AF%AD%E5%8F%A5%E6%80%8E%E4%B9%88%E8%A7%A3%E9%87%8Astrl+%3D+strlen%28xx%5Bi%5D%29%EF%BC%9B.png)
