public Object searchBy(Integer id, String name, Integer type) throws Exception {
    DbTableQuery qr = db.table("user").whereTrue();
    if (id != null) {
        qr.and("id=?", id);
    }

    if (name != null) {
        qr.and("name=?", name);
    }

    if (type != null && type > 2) {
        qr.and("type=?", type);
    }

    return qr.limit(50).select("*").getMapList();
}

public Object searchBy(Integer id, String name, Integer type) throws Exception {
    return db.table("user")
            .whereTrue()
            .andIf(id != null, "id=?", id)
            .andIf(name != null, "name=?", name)
            .andIf(type != null && type > 2, "type=?", type)
            .limit(50)
            .select("*")
            .getMapList()
}

public void insertUser(Map<String, Object> map) throws Exception {
    DbTableQuery qr = db.table("user");
    map.forEach((k, v) -> {
        if (v != null) {
            qr.set(k, v);
        }
    });
    qr.insert();
}

public void insertUser(Map<String, Object> map) throws Exception {
    db.table("user").setMapIf(map, (k, v) -> v != null).insert();
}