G
Guest
Gast
Gibt es eine Möglichkeit, eine csv-Datei in eine H2-Datenbank zu importieren?
package org.h2.tools;
import java.sql.*;
public class Test
{
public static Connection connection;
public static String lese, schreibe;
public static Statement stmt;
public static ResultSet result;
public static void main(String[] a) throws Exception
//public static void verbindung() throws Exception
{
Class.forName("org.h2.Driver");
connection = DriverManager.
getConnection("jdbc:h2:tcp:localhost/test", "sa", "");
System.out.println("Verbindung hergestellt");
// add application code here
ResultSet rs = Csv.read("test.csv", null, null);
ResultSetMetaData meta = rs.getMetaData();
while(rs.next())
{
for(int i=0; i<meta.getColumnCount(); i++)
{
System.out.println(meta.getColumnLabel(i+1) + ": " + rs.getString(i+1));
}
System.out.println();
}
rs.close();
lese = "Select * from test";
stmt = connection.createStatement();
result = stmt.executeQuery(lese);
System.out.println(result);
StartFrame frm = new StartFrame("Hauptseite");
frm.setVisible(true);
frm.setSize(400,400);
frm.setLocation(0, 0);
frm.pack();
}
}
non-static method read(java.lang.String,java.lang.String[],java.lang.String) cannot be referenced from a static context
ResultSet rs = Csv.read("icd_2008.csv", null, null);
Reading a CSV File from a Java Application
It is possible to read a CSV file without opening a database. Example:
ResultSet rs = Csv.read("test.csv", null, null);
ResultSetMetaData meta = rs.getMetaData();
while(rs.next()) {
for(int i=0; i<meta.getColumnCount(); i++) {
System.out.println(meta.getColumnLabel(i+1) + ": " + rs.getString(i+1));
}
System.out.println();
}
rs.close();
public ResultSet read(String fileName, String colNames[], String charset)
throws SQLException