|
1
5 package org.h2.samples;
6
7 import java.sql.ResultSet  ;
8 import java.sql.ResultSetMetaData ;
9 import java.sql.Types ;
10
11 import org.h2.tools.Csv;
12 import org.h2.tools.SimpleResultSet;
13
14 public class CsvSample {
15 public static void main(String [] args) throws Exception {
16 CsvSample.write();
17 CsvSample.read();
18 }
19
20 static void write() throws Exception {
21 SimpleResultSet rs = new SimpleResultSet();
22 rs.addColumn("NAME", Types.VARCHAR, 255, 0);
23 rs.addColumn("EMAIL", Types.VARCHAR, 255, 0);
24 rs.addColumn("PHONE", Types.VARCHAR, 255, 0);
25 rs.addRow(new String [] { "Bob Meier", "bob.meier@abcde.fgh", "+41123456789" });
26 rs.addRow(new String [] { "John Jones", "johnjones@abcde.fgh", "+41976543210" });
27 Csv.getInstance().write("data/test.csv", rs, null);
28 }
29
30 static void read() throws Exception {
31 ResultSet rs = Csv.getInstance().read("data/test.csv", null, null);
32 ResultSetMetaData meta = rs.getMetaData();
33 while (rs.next()) {
34 for (int i = 0; i < meta.getColumnCount(); i++) {
35 System.out.println(meta.getColumnLabel(i + 1) + ": " + rs.getString(i + 1));
36 }
37 System.out.println();
38 }
39 rs.close();
40 }
41 }
42 |
Popular Tags |
Java API By Example, From Geeks To Geeks.