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