ArcGIS API for JavaScript 图层服务查询where条件构造器

最新推荐文章于 2024-05-17 14:25:28 发布

一个不称职的程序猿

最新推荐文章于 2024-05-17 14:25:28 发布

阅读量1k

点赞数

分类专栏：实用小工具 GIS 文章标签： gis 前端 javascript es6 js

本文链接：https://blog.youkuaiyun.com/qq_39035773/article/details/123257221

版权

实用小工具同时被 2 个专栏收录

18 篇文章

订阅专栏

GIS

6 篇文章

订阅专栏

本文介绍了一个用于创建SQL where条件的类，支持eq, ne, gt, ge, lt, le, like, in, notIn等操作，适用于前端和后端开发中的高效查询构建。测试用例展示了如何灵活组合条件进行数据库筛选。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

/**
 * SQL where 条件构建器
 */
export default class CreateSqlWhere {
    /**
     * where 条件 sql
     */
    whereSql: string;

    getSql() {
        return this.whereSql;
    }

    eq(field?: string, value?: string) {
        this.defConnect();
        this.whereSql += `${field} = '${value}'`;
        return this;
    }

    ne(field?: string, value?: string) {
        this.defConnect();
        this.whereSql += `${field} != '${value}'`;
        return this;
    }

    gt(field?: string, value?: string) {
        this.defConnect();
        this.whereSql += `${field} > '${value}'`;
        return this;
    }

    ge(field?: string, value?: string) {
        this.defConnect();
        this.whereSql += `${field} >= '${value}'`;
        return this;
    }

    lt(field?: string, value?: string) {
        this.defConnect();
        this.whereSql += `${field} < '${value}'`;
        return this;
    }

    le(field?: string, value?: string) {
        this.defConnect();
        this.whereSql += `${field} <= '${value}'`;
        return this;
    }

    like(field?: string, value?: string) {
        this.defConnect();
        this.whereSql += `${field} like '%${value}'%`;
        return this;
    }

    likeLeft(field?: string, value?: string) {
        this.defConnect();
        this.whereSql += `${field} like '%${value}'`;
        return this;
    }

    likeRight(field?: string, value?: string) {
        this.defConnect();
        this.whereSql += `${field} like '${value}'%`;
        return this;
    }

    in(field?: string, values?: Array<any>) {
        if (values.length > 0) {
            this.defConnect();
            let sql = `${field} in (`;
            for (let i = 0; i < values.length; i++) {
                if (i === values.length - 1) {
                    sql += `'${values[i]}'`;
                } else {
                    sql += `'${values[i]}', `;
                }
            }
            sql += ')';
            this.whereSql += sql;
        }
        return this;
    }

    notIn(field?: string, values?: Array<any>) {
        if (values.length > 0) {
            this.defConnect();
            let sql = `${field} not in (`;
            for (let i = 0; i < values.length; i++) {
                if (i === values.length - 1) {
                    sql += `'${values[i]}'`;
                } else {
                    sql += `'${values[i]}', `;
                }
            }
            sql += ')';
            this.whereSql += sql;
        }
        return this;
    }

    or() {
        if (this.whereSql) {
            this.whereSql += ' or ';
        } else {
            this.whereSql = '';
        }
        return this;
    }

    private defConnect() {
        if (this.whereSql) {
            if (!this.whereSql.endsWith('and ') && !this.whereSql.endsWith('or ')) {
                this.whereSql += ' and ';
            }
        } else {
            this.whereSql = '';
        }
    }
}

测试用例

const where = new CreateSqlWhere().eq('test', '001')
            .in('test1', [1001, 1002, 1003])
            .eq('test2', '001')
            .or()
            .in('test3', [1001, 1002, 1003])
            .getSql();