🗃️JDBC Database

Class Features

• Support for all JDBC compliant databases

• Support for dynamic and precompiled SQL statements

• Retrieve data in Java format (rows as ArraryList, columns as Java Objects) or as a JSON, YAML, XML, CSV or tabular string

• Convenient shortcuts for major JDBC class names

Prerequisites

• JDBC driver

Example H2 Database

try (KDB db = new KDB(KDB.JDBC_H2, "jdbc:h2:mem:mydb", "", "")) {
   KLog.abort(!db.isConnected(), "Error: " + db.getErrorMessage());

   db.exec("CREATE TABLE addresses (sequence INT AUTO_INCREMENT, lastname VARCHAR(20), firstname VARCHAR(20))");
   
   db.prepare("INSERT INTO addresses (lastname, firstname) VALUES (?, ?)");
   db.execPrepare("Smith", "Joe");
   db.execPrepare("Miller", "Bob");
   db.execPrepare("Johnson", "Evelyn");

   db.exec("SELECT * FROM addresses");

   System.out.println(db.getDataAsJSON());
}

Output

{
  "ADDRESSES": [
    {
      "SEQUENCE": 1,
      "LASTNAME": "Smith",
      "FIRSTNAME": "John"
    },
    {
      "SEQUENCE": 2,
      "LASTNAME": "Miller",
      "FIRSTNAME": "Bob"
    },
    {
      "SEQUENCE": 3,
      "LASTNAME": "Johnson",
      "FIRSTNAME": "Eve"
    }
  ]
}