LambdaTemplate

LambdaTemplate is the core class of dbVisitor's Fluent API, building SQL statements programmatically and automatically handling database dialect differences. Before using it, you need to establish Object Mapping for your database tables.

Entity class mapping
@Table("users")
public class User {
    @Column(name = "id", primary = true, keyType = KeyTypeEnum.Auto)
    private Long id;
    @Column("name")
    private String name;
}

Creation and usage
LambdaTemplate lambda = new LambdaTemplate(dataSource);

// Query example
List<User> users = lambda.query(User.class)
        .eq(User::getName, "alice")
        .queryForList();

Hint

How to obtain a LambdaTemplate depends on your project architecture. See Framework Integration for details.

Principle

Build operations through the insert, update, delete, query, and freedom series of methods. Developers describe SQL logic programmatically; at runtime, dialect-specific SQL is generated automatically and executed via JdbcTemplate.

User Guide

Insert, write data, batch inserts, conflict strategies (Ignore/Update).
Update, three update approaches and unsafe update protection.
Delete, delete data.
Query, query data.
Where Builder, build complex query conditions for Update/Delete/Query.
Group By, GROUP BY grouped queries.
Order By, ORDER BY query sorting.
Map-oriented API, use Map instead of entity objects as data carriers.
Freedom Mode, no object mapping classes, operate directly with table name + Map.

Principle​

User Guide​

Principle

User Guide