Connection conn = DriverManager.getConnection("jdbc:crate://localhost:4200/"); Statement stmt = conn.createStatement(); stmt.executeUpdate("CREATE TABLE users (id INT PRIMARY KEY, name STRING)"); stmt.executeUpdate("INSERT INTO users (id, name) VALUES (1, 'Alice')"); stmt.executeUpdate("INSERT INTO users (id, name) VALUES (2, 'Bob')"); ResultSet rs = stmt.executeQuery("SELECT * FROM users"); while (rs.next()) { System.out.println(rs.getInt("id") + " " + rs.getString("name")); }