sql2o

This example demonstrates how to initialize a Sql2o instance, open a Connection, execute an update (DDL/DML), and fetch a single object using named parameters and POJO mapping.

Key steps:

1. Instantiate Sql2o with the JDBC URL, username, and password.
2. Open a Connection using a try-with-resources block.
3. Use createQuery(sql) to prepare statements.
4. Use .addParameter(name, value) to bind named parameters (e.g., :id).
5. Use .executeUpdate() for changes or .executeAndFetchFirst(Class) to map a single result to a POJO.

import org.sql2o.*;

public class Main {
    public static void main(String[] args) {
        String url = "jdbc:h2:mem:test"; // Example using H2 in-memory database
        try (Sql2o sql2o = new Sql2o(url, "username", "password");
             Connection con = sql2o.open()) {
            
            con.createQuery("CREATE TABLE users (id INTEGER PRIMARY KEY, name VARCHAR(50))").executeUpdate();
            con.createQuery("INSERT INTO users (id, name) VALUES (:id, :name)")
                .addParameter("id", 1)
                .addParameter("name", "Alice")
                .executeUpdate();
            
            User user = con.createQuery("SELECT * FROM users WHERE id = :id")
                            .addParameter("id", 1)
                            .executeAndFetchFirst(User.class);
            
            System.out.println("User: " + user.name);
        }
    }
}

class User {
    public int id;
    public String name;
}