// 使用 with 方法构建 Context（从 3.6.2 开始支持）
Context context = new Context()
        .withParam("user_code", userCode)
        .withParam("user_name", userName)
        .withBeanParam(user) // 使用 JavaBean 构建 Context 参数
        .withMapParam(map) // 使用 Map 构建 Context 参数
        .withPageStart(start) // 设置分页参数 start
        .withPageLimit(limit); // 设置分页参数 limit
return modelExecutor.query(context, "user", "");


// 从当前请求的 Context 中获取参数
Object userId = context.getData("param.user_id");
// 使用 getInt 转换类型
Integer userId = context.getInt("param.user_id");

// 设置参数到 paramDatas 中
context.setData("param.user_id", userId);
// 或
context.setParamData("user_id", userId);

// 设置返回参数，适合需要额外返回业务字段的场景
context.setOutParamData("trace_id", traceId);

// 返回内容为 Map 的 Response（数据 + 总行数）
QueryResponseObject<Map<String,Object>> r1 = ModelEngine.query(context, "user", "");
// 返回内容为 User 对象的 Response（数据 + 总行数）
QueryResponseObject<User> r2 = ModelEngine.query(context, "user", "", User.class);

// 以 Map 格式返回一行记录
Map<String,Object> map = ModelEngine.queryOne(context, "user", "");
// 以 User 对象返回一行记录
User user = ModelEngine.queryOne(context, "user", "",User.class);

// 以 List<Map> 格式返回数据
List<Map<String,Object>> list = ModelEngine.queryList(context, "user", "");
// 以 List<User> 对象返回数据
List<User> users = ModelEngine.queryList(context, "user", "",User.class);

// 修改数据
ResponseObject responseObject = ModelEngine.execute(context, "user", "update");

// 返回内容为 Map 的 Response（数据 + 总行数）
QueryResponseObject<Map<String,Object>> r1 = modelExecutor.query(context, "user", "");
// 返回内容为 User 对象的 Response（数据 + 总行数）
QueryResponseObject<User> r2 = modelExecutor.query(context, "user", "", User.class);

// 以 Map 格式返回一行记录
Map<String,Object> map = modelExecutor.queryOne(context, "user", "");
// 以 User 对象返回一行记录
User user = modelExecutor.queryOne(context, "user", "",User.class);

// 以 List<Map> 格式返回数据
List<Map<String,Object>> list = modelExecutor.queryList(context, "user", "");
// 以 List<User> 对象返回数据
List<User> users = modelExecutor.queryList(context, "user", "",User.class);

// 修改数据
ResponseObject responseObject = modelExecutor.execute(context, "user", "update");

ResponseObject response = modelExecutor.execute(context, "user", "update");
Object id = response.getOutParam().get("id");

QueryResponseObject<Map<String, Object>> response = modelExecutor.query(context, "user", "");

// 获取第一条记录
Map<String, Object> firstUser = response.get();

// 提取所有用户 ID
List<Integer> userIds = response.getIntList("user_id");

// 按 user_id 转换为 Map，便于后续快速查找
Map<String, Map<String, Object>> userMap = response.getMap("user_id");

public class CountAdapter implements MapQueryAdapter {
 
    @Override
    public void beforeCount(Context context, Map<String, Param> params, Count count) {
        // 获取当前的 count SQL
        String countSql = count.getCountSql();
        // ... 优化 count SQL ...
        // 优化后设置新的 count SQL
        count.setCountSql(newCountSql);
    }
}

@Component
public class UserQueryAdapter implements MapQueryAdapter {
 
    @Autowired
    private ModelExecutor modelExecutor;
 
 
    @Override
    public void beforeQuery(Context context, Map<String, Param> params) {
        if (params.get("type").getIntValue() == 1) {
            params.get("country").setValue("CN");
        }
    }
 
    @Override
    public void afterQuery(Context context, Map<String, Param> params, QueryResponseObject<Map<String, Object>> responseObject) {
        if (responseObject.getDatas().size() < 1) {
            return;
        }
        List<Integer> userIds = responseObject.getIntList("user_id");
        Context queryContext = new Context();
        queryContext.setParamData("userIds", userIds);
        QueryResponseObject<Map<String, Object>> userDevice = modelExecutor.query(queryContext, "user/user_device", "findByUserIds");
        responseObject.join(userDevice, "user_id");
    }
 
}

@Component
public class ConfigUpdateAdapter implements ExecuteAdapter {
 
    @Autowired
    private ModelExecutor modelExecutor;
 
    @Override
    public void beforeExecute(Context context, Map<String, Param> params) {
        GuildConfig query = modelExecutor.query("/user/guild", "findByUserId", ImmutableMap.of("user_id", params.get("user_id").getValue()), GuildConfig.class).get();
        context.request.setAttribute("oldEnableValue", query.getEnable());
    }
    @Override
    public void afterExecute(Context context, Map<String, Param> params) {
        Integer userId = params.get("user_id").getIntValue();
        GuildConfig query = modelExecutor.query("/user/guild", "findByUserId", ImmutableMap.of("user_id", userId), GuildConfig.class).get();
        Boolean enable = query.getEnable();
        Object oldEnableValue = context.request.getAttribute("oldEnableValue");
        if (enable && Objects.equals(oldEnableValue, false)) {
            // 由禁用改为启用
            // ...
        } else if (!enable && Objects.equals(oldEnableValue, true)) {
            // 由启用改为禁用
            // ...
        }
    }
}

static final ExcelColumn COLUMN1 = new ExcelColumn("user_id", "用户ID", 180);
static final ExcelColumn COLUMN2 = new ExcelColumn("name", "用户名", 180);
static final ExcelColumn COLUMN3 = new ExcelColumn("status", "用户状态", 160);
static final ExcelColumn COLUMN4 = new ExcelColumn("create_time", "创建时间", 180);
static final List<ExcelColumn> EXCEL_COLUMNS = Lists.newArrayList(COLUMN1, COLUMN2, COLUMN3, COLUMN4);
 
static {
    // 字段映射
    COLUMN3.setMapper(ImmutableMap.of("1", "正常", "0", "注销"));
    // 设置格式
    COLUMN4.setFormat("yyyy-MM-dd");
}
 
public void export(Context context) throws Exception {
    ExcelWriter.setExportFilename(context, "用户列表.xlsx");
    List<Map<String, Object>> result = ModelEngine.query(context, "user/user", "excel", false).getDatas();
    ExcelWriter.excelExport(context, result, EXCEL_COLUMNS);
}

    // 3.6.3 后支持定义 columns 配置，避免 SQL 中需要写中文。
    // 不配置 column 时，需要写成 ${@用户账号} 获取参数；配置后可写成 ${@user_code}。
    public ResponseObject importData(FilePart filePart) {
        List<ExcelColumn> columns = Lists.newArrayList(
                new ExcelColumn("user_code", "用户账号"),
                new ExcelColumn("user_name", "用户昵称")
        );
        List<List<Map<String, Object>>> datas = ExcelReader.readExcel(filePart, columns);
        Context context = new Context().withParam("userList", datas.get(0));
        return modelExecutor.execute(context, "userExcel", "");
    }

TransactionUtil.executeWithoutResult(context, () -> {
    ResponseObject res = ModelEngine.execute(context, "table/table_1", "add");
    // 获取自增 ID
    Integer id = Integer.parseInt(res.getOutParam().get("id").toString());
    Table2Entity entity = new Table2Entity(id);
    ModelEngine.execute("table/table_2", "add", entity);
});