<dependency>
<groupId>org.duckdb</groupId>
<artifactId>duckdb-jdbc</artifactId>
<version>0.2.5</version>
</dependency>
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class DataLoadingExample {
public static void main(String[] args) {
try {
String jdbcUrl = "jdbc:duckdb:";
Connection connection = DriverManager.getConnection(jdbcUrl);
Statement statement = connection.createStatement();
String loadDataSQL = "COPY INTO table_name FROM 'path/to/file.csv' WITH (header=TRUE);";
statement.executeUpdate(loadDataSQL);
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class DataStorageExample {
public static void main(String[] args) {
try {
String jdbcUrl = "jdbc:duckdb:";
Connection connection = DriverManager.getConnection(jdbcUrl);
Statement statement = connection.createStatement();
String storeDataSQL = "COPY table_name TO 'path/to/file.csv' WITH (header=TRUE);";
statement.executeUpdate(storeDataSQL);
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
