Platform-Independent Zip
import java.sql.*;
import org.h2.tools.Csv;
import org.h2.tools.SimpleResultSet;
public class TestCsv {
public static void main(String[] args) throws Exception {
SimpleResultSet rs = new SimpleResultSet();
rs.addColumn("NAME", Types.VARCHAR, 255, 0);
rs.addColumn("EMAIL", Types.VARCHAR, 255, 0);
rs.addRow("Bob Meier", "bob.meier@abcde.abc");
rs.addRow("John Jones", "john.jones@abcde.abc");
Csv.getInstance().write("data/test.csv", rs, null);
}
}
-classpath
Java Build Path
Add external Jar
Class.forName("org.h2.Driver");
JdbcConnectionPool connectionPool = JdbcConnectionPool.create(dbUrl, userName, password);
jdbc:h2:pfad/zur/db/databaseName
con = connectionPool.getConnection();
PreparedStatement stmt = con.prepareStatement("SELECT * FROM Noten;");
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
int wert = rs.getInt("wert");
System.out.println(wert);
}
Noten
wert