Class.forName("org.duckdb.jdbc.DuckDBDriver"); String url = "jdbc:duckdb:database.db"; String username = "myusername"; String password = "mypassword"; Connection connection = DriverManager.getConnection(url, username, password); Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery("SELECT * FROM mytable"); while (resultSet.next()) { String column1 = resultSet.getString("column1"); int column2 = resultSet.getInt("column2"); } connection.close();