JQuery中的简单SQL查询生成器[英] Simple SQL Query Builder in JQuery

本文是小编为大家收集整理的关于JQuery中的简单SQL查询生成器的处理/解决方法,可以参考本文帮助大家快速定位并解决问题,中文翻译不准确的可切换到English标签页查看源文。

问题描述

我试图找到一个简单的查询构建器接口,类似于SQL查询构建器插件,http://plugins.jquern.jquery.com/project/project/project/sql_query_builder" plugins.jquery.com/project/sql_query_builder ,但更简单.

我喜欢它的功能,但是我只想定义字段,类型,也许是一些额外的信息(最小值和最大值),并生成了与标准匹配的列表.简单的and和ors.

示例gui将是:

[选择框(和/或)] | [选择框(字段名)] | [选择框(比较)] |值| [按钮添加]

   department = 'SALES'

和名称为'%smith%'

这样的插件是否存在于jQuery或其他JavaScript框架中?

谢谢!

马特

推荐答案

我现在一直在搜索一段时间,因为我需要同样的事情.我发现这个 extbuilder项目这似乎与我们需要的东西非常接近.它不是积极开发的,而且看起来也没有打磨.您可以在这里玩UI .

其他推荐答案

您可以使用jQuery查询构建器, https://github.com/mistic.com/mistic100/jquery-query-query-querybuilder/

本文地址:https://www.itbaoku.cn/post/597559.html

问题描述

I am trying to find a simple query builder interface similar to the SQL Query Builder plugin at http://plugins.jquery.com/project/SQL_QUERY_BUILDER, but simpler.

I like it's functionality, but I just want to define the fields, the types, and perhaps some extra information (min and max value) and have a list generated that match the criteria. Simple ANDs and ORs as well.

Example GUI would be something like:

[SELECT BOX (and/or)] | [SELECT BOX (FIELD NAME)] | [SELECT BOX (Comparison)] | VALUE | [BUTTON ADD]

   department = 'SALES'

AND name like '%SMITH%'

Does a plugin like this exist in JQuery or another Javascript Framework?

Thanks!

Matt

推荐答案

I've been searching for a while myself now, since I need the same thing. I found this expbuilder project that seems to be very close to what we need. It's not actively developed and it doesn't look polished. You can play around with the UI here.

其他推荐答案

u can use jquery query builder , https://github.com/mistic100/jQuery-QueryBuilder/