mybatis plus 根据model的字段，自动拼生成条件

/**
 * 根据model的字段，自动拼生成条件
 */
public class QueryHelper {

    public static <T> QueryWrapper<T> getQuery(T model) {

        var query = new QueryWrapper<T>();
        Arrays.asList(model.getClass().getDeclaredFields()).forEach(field -> {
            field.setAccessible(true);
            try {
                var value = field.get(model);
                var column = getColumn(field.getName());
                if (value != null) {
                    query.eq(column, value);
                }
            } catch (IllegalAccessException e) {
                e.printStackTrace();
            }
        });

        return query;
    }

    private static String getColumn(String name) {
        var sb = new StringBuffer();
        for (int i = 0; i < name.length(); i++) {
            char chat = name.charAt(i);
            if (chat > 64 && chat < 91) {
                sb.append("_");
                sb.append(String.valueOf(chat).toLowerCase(Locale.ROOT));
            } else {
                sb.append(chat);
            }
        }
        return sb.toString();
    }

    public static void main(String[] args) {
        var model = new Channel();
        model.setCompanyId("123");

        var query = getQuery(model);
        System.out.println(query);
    }
}