H2实现cvs数据表文件读取写入

1、将数据写入文件

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();
	}

}

2、读取文件数据

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();
	}

}