Quickstart

https://scrapbox.io/files/6041d594011751001c4ca2c1.png #Quickstart

Install

You can get the binary from Maven Central Repository You add maven dependency or download the jar file to add build path. ! Sorm4j requires Java 17 (or above) after version 2.0.0 (Sorm4j version 1.4.16).

Source code are available GitHub.

code:pom.xml

<groupId>org.nkjmlab</groupId>

</dependency>

Create a container class matching a table name:

code:java

public record Customer (int id, String name){}

Create an entry point:

The org.nkjmlab.sorm4j.Sorm class is the first entry point into the library. org.nkjmlab.sorm4j.Sorm holds JDBC javax.sql.DataSource and configures. You can create Sorm instance with (1) JDBC URL, username, password, or (2) DataSource instance.

code:create1.java

// (1) H2 in-memory database with DriverManager

Sorm sorm = Sorm.create("jdbc:h2:mem:sormtest;DB_CLOSE_DELAY=-1");

code:create2.java

//(2) H2 connection Pool

DataSouce dataSource = org.h2.jdbcx.JdbcConnectionPool.create("jdbc:h2:mem:sormtest;DB_CLOSE_DELAY=-1", "username","password");

Srom sorm = Sorm.create(dataSource);

Read Table

You can use Object Relational Mapping function via org.nkjmlab.sorm4j.Sorm instance. Sorm gets a JDBC connection and executes task after that closes the connection immediately.

Reads matching rows from table:

code:java

List<Customer> list = sorm.readList(Customer.class, "select * from customer where id>?", 5);

Write into table

Inserts new rows (the table name is guessed from the class name):

code:java

sorm.insert(new Customer(1, "Alice", "Tokyo"), new Customer(2, "Bob", "Tokyo"));

/yuunkjm/--.icon

please see Core , Customization and Utilities page.