[b]1、将数据写入文件[/b]
[b]2、读取文件数据[/b]
package com.boonya.h2.csv;
import java.sql.SQLException;
import java.sql.Types;
import org.h2.tools.Csv;
import org.h2.tools.SimpleResultSet;
/**
* CsvWrite.java
* 功能:测试H2提供cvs数据写入文件
* @author boonya
* @version 1.0 2013-03-11
*/
public class CsvWrite {
public void write(){
SimpleResultSet srs=new SimpleResultSet();
srs.addColumn("ID", Types.INTEGER, 255, 0);
srs.addColumn("NAME", Types.VARCHAR, 255, 0);
srs.addRow(1,"boonya");
srs.addRow(2,"boonyafun");
try {
new Csv().write("D:/SpringSource/DBH2/data/mytest.csv", srs,null);
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
new CsvWrite().write();
}
}
[b]2、读取文件数据[/b]
package com.boonya.h2.csv;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import org.h2.tools.Csv;
/**
* CsvRead.java
* 功能:测试H2提供cvs数据文件读取
* @author boonya
* @version 1.0 2013-03-11
*/
public class CsvRead {
public void read(){
ResultSet rs=null;
try {
rs = new Csv().read("D:/SpringSource/DBH2/data/mytest.csv", null, null);
try {
ResultSetMetaData meta=rs.getMetaData();
while (rs.next()) {
for (int i = 0,j=meta.getColumnCount(); i <j; i++) {
System.out.println(meta.getColumnLabel(i+1)+" : "+rs.getString(i+1));
}
}
} catch (SQLException e) {
e.printStackTrace();
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
if(rs!=null)rs.close();
rs=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/**
* 读取文件结果:
* ID : 1
* NAME : boonya
* ID : 2
* NAME : boonyafun
* @param args
*/
public static void main(String[] args) {
new CsvRead().read();
}
}