Programmatic Database Access

npm install sqlite3

In your pom.xml add:

        <!-- JDBI database connectivity -->
        <!-- JDBI is build on top of JDBC
        and provides a simpler interface -->
        <dependency>
            <groupId>org.jdbi</groupId>
            <artifactId>jdbi3-core</artifactId>
            <version>3.1.0</version>
        </dependency>
        <!-- SQLite database -->
        <dependency>
            <groupId>org.xerial</groupId>
            <artifactId>sqlite-jdbc</artifactId>
            <version>3.36.0.3</version>
        </dependency>

    const sqlite3 = require('sqlite3').verbose();

    // create an in-memory database
    const db = new sqlite3.Database(':memory:', (err) => {
        if (err) {
           return console.error(err.message);
        }
        console.log('Connected to the in-memory SQlite database.');
    });

    // close the database connection
    db.close((err) => {
        if (err) {
        return console.error(err.message);
        }
        console.log('Close the database connection.');
    });

Jdbi jdbi = Jdbi.create("jdbc:sqlite::memory:");
System.out.println('Connected to the in-memory SQlite database.');
// note that JDBI automatically takes care of releasing any connections after use

const sqlite3 = require('sqlite3').verbose();

function initialise() {
    // if the specified database exists, connect to it else create the database
    const db = new sqlite3.Database('./restaurants.sqlite');

    try {
        db.serialize(function () { 
            db.run("CREATE TABLE RESTAURANTS (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, imagelink TEXT)");

            let stmt;

            try {
                stmt = db.prepare(`INSERT INTO RESTAURANTS (name, imagelink) VALUES (?, ?)`);
                stmt.run('Bayroot', 'https://www.telegraph.co.uk/content/dam/Travel/Destinations/Europe/England/Brighton/brighton-restaurants-hotel-du-vin-bistro.jpg');
            } finally {
                // release resources 
                stmt.finalize();
            }
        
            // check the row was inserted ok
            db.each("SELECT * FROM Restaurants",
                function (err, rows) {  
                    console.log(rows);  
                }
            );
        });
    } finally { 
        // very important to always close database connections
        // else could lead to memory leaks
        db.close();
    }
}

        // if the specified database exists, connect to it else create the database
        Jdbi jdbi = Jdbi.create("jdbc:sqlite:restaurants.sqlite");

        // using withHandle will auto close the db connection
        List<Map<String, Object>> restaurants = jdbi.withHandle(handle -> {
            handle.execute("CREATE TABLE RESTAURANTS (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, imagelink TEXT)");
            handle.execute("INSERT INTO RESTAURANTS (name, imagelink) VALUES (?, ?)", "Bayroot", "https://www.telegraph.co.uk/content/dam/Travel/Destinations/Europe/England/Brighton/brighton-restaurants-hotel-du-vin-bistro.jpg");

            return handle.createQuery("SELECT * FROM RESTAURANTS")
                    .mapToMap()
                    .list();
        });

        System.out.println(restaurants);
    }