Skip to main content
Hint

This article is generated by AI translation.

Call Fluent API

Through the parameterless insert, update, delete, query of the BaseMapper interface, you can directly use the Fluent API for database operations without data preparation.

Tip

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

Example: Insert
User user = ...

BaseMapper<User> mapper = session.createBaseMapper(User.class);
mapper.insert().applyEntity(user)
               .executeSumResult();
Example: Update
BaseMapper<User> mapper = session.createBaseMapper(User.class);
mapper.update().eq(User::getId, 1)              // Matching condition
               .updateTo(User::getName, "Mary") // Update field, using Lambda
               .updateTo(User::getStatus, 2)    // Multiple fields can be updated via method chaining
               .doUpdate();
Example: Delete
BaseMapper<User> mapper = session.createBaseMapper(User.class);
mapper.delete().eq(User::getId, 1) // Matching condition
               .doDelete();
Example: Query
BaseMapper<User> mapper = session.createBaseMapper(User.class);
List<User> result = null;
result = mapper.query().le(User::getId, 100)   // Match ID less than or equal to 100
                       .queryForList();        // Map result set to entity type
For detailed usage of Fluent API, please refer to: