Utils/SQL statement builder

https://gyazo.com/ef3581a9274ef54ee348bedb5afd59d7 #Utilities

Select SQL statement builder

Sorm4j provides simple select string builder.

code:java

String sql = SelectSql.builder().where("name=? and address=?").addParameter("Alice", "Kyoto").build();

select: sets column names. The default value is *.

from: sets the table name. The value automatically sets based on the given class.

where: sets the where clause.

addParameter: sets ordered parameters.

Join SQL statement builder

code:java

String sql = JoinSql.builder(sorm.getTableMetaData(Customer.class))

.joinOn(sorm.getTableMetaData(Address.class),"customer.address=address.name")

.where("customer.id=?").limit(1);

List<Tuple2<Customer,Address>> result = sorm.join(Customer.class, Address.class, sql, 2);