Connection conn = DriverManager.getConnection("jdbc:duckdb:local");
PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM table WHERE column = ?");
pstmt.setString(1, "value");
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
}
rs.close();
pstmt.close();
conn.close();
Connection conn = DriverManager.getConnection("jdbc:duckdb:local");
PreparedStatement pstmt = conn.prepareStatement("INSERT INTO table (column1, column2) VALUES (?, ?)");
for (int i = 0; i < 1000; i++) {
pstmt.setString(1, "value1");
pstmt.setString(2, "value2");
pstmt.addBatch();
}
pstmt.executeBatch();
pstmt.close();
conn.close();
