fork download
copy 
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.Statement;
  4. import java.sql.ResultSet;
  5. import java.sql.SQLException;
  6.  
  7. public class Main {
  8.     public static void main(String[] args) {
  9.  
  10.         String URL = "jdbc:h2:mem:testdb"; // Temporary in-memory DB
  11.         String USER = "sa";
  12.         String PASSWORD = "";
  13.  
  14.         String createTableSQL = "CREATE TABLE products2025 (" +
  15.                 "id INT AUTO_INCREMENT PRIMARY KEY, " +
  16.                 "name VARCHAR(50))";
  17.  
  18.         String insertSQL1 = "INSERT INTO products2025(name) VALUES('Product1')";
  19.         String insertSQL2 = "INSERT INTO products2025(name) VALUES('Product2')";
  20.         String selectSQL = "SELECT * FROM products2025";
  21.  
  22.         try (
  23.             Connection connection = DriverManager.getConnection(URL, USER, PASSWORD);
  24.             Statement stmt = connection.createStatement()
  25.         ) {
  26.  
  27.             // Create table
  28.             stmt.execute(createTableSQL);
  29.  
  30.             // Insert data
  31.             stmt.execute(insertSQL1);
  32.             stmt.execute(insertSQL2);
  33.  
  34.             // Fetch data
  35.             ResultSet rs = stmt.executeQuery(selectSQL);
  36.  
  37.             System.out.println("ID | Name");
  38.             while (rs.next()) {
  39.                 System.out.println(rs.getInt("id") + " | " + rs.getString("name"));
  40.             }
  41.  
  42.         } catch (SQLException e) {
  43.             e.printStackTrace();
  44.         }
  45.     }
  46. }
Success #stdin #stdout #stderr 0.22s 58600KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
java.sql.SQLException: No suitable driver found for jdbc:h2:mem:testdb
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
	at Main.main(Main.java:23)
https://ideone.com/DnFJik
language:
Java (HotSpot 12)
created:
16 hours ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!