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

问题描述

我想在 http：//上找到类似于SQL查询生成器插件的简单查询生成器界面plugins.jquery.com/project/SQL_QUERY_BUILDER ，但更简单。

我喜欢它的功能，但我只想定义字段，类型和也许一些额外的信息（最小和最大值），并生成一个匹配标准的列表。简单的ANDs和ORs。

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.

示例GUI将像这样：

[SELECT BOX或）] [选择框（字段名称）] | [SELECT BOX（Comparison）] | VALUE | [BUTTON ADD]

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

   department = 'SALES'

并且名称如％SMITH％

AND name like '%SMITH%'

这样的插件是否存在于JQuery或其他Javascript框架中？

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

谢谢！

Matt

推荐答案

我一直在寻找一个自己现在，因为我需要同样的事情。我发现此 expbuilder项目似乎非常接近我们所需要的。它不积极开发，它不看起来抛光。您可以使用此处的UI进行操作。

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.

这篇关于JQuery中的简单SQL查询生成器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！