您能否推荐一个JQuery插件来组成一组可映射到SQL查询的条件? [英] Could you recommend a JQuery plugin to compose a set of conditions mappable to a SQL query?

问题描述

我找到了 http://redquerybuilder.appspot.com/，但是它会生成SQL客户端我想避免.在帽子页面上，有指向JQuery Query Builder插件的链接，但该链接转到jquery主页.似乎此插件不再存在(另请参见 JQuery中的简单SQL查询生成器表示相同的链接.

我发现 http://kindohm.com/posts/2013/09/25/knockout-query-builder/看起来很像我想要的，除了我不想添加另一个JavaScript库.

最后还有 http://devtools.korzh. com/easyquery/javascript/docs/javascript-query-builder-php 看起来非常不错.但是他们使用Web服务来生成SQL，并且您必须获得API密钥才能使其运行.现在它是免费的...但是看起来像是一个吸引用户的诱人陷阱，然后当他们无法轻松离开时，它将开始为Web服务收费，或者可以在他们想要的任何时间将其关闭. >

因此，在我构建定制的定制查询表单之前，是否会存在这样的查询生成器?

解决方案

我需要一个查询生成器，该生成器会生成一个不错的JSON，可用于创建Java POJO并编写此代码:
http://mistic100.github.io/jQuery-QueryBuilder

编写一个创建SQL查询的解析器会很容易.

I've found http://redquerybuilder.appspot.com/ but that generates SQL client side which I want to avoid. On hat page there is a link to JQuery Query Builder plugin but that link goes to jquery home page. Seems that this plugin does nto exist anymore (also see Simple SQL Query Builder in JQuery for same link).

I found http://kindohm.com/posts/2013/09/25/knockout-query-builder/ which looks pretty much what I want except I do not want to add yet another JavaScript library.

Last there is http://devtools.korzh.com/easyquery/javascript/docs/javascript-query-builder-php which looks very nice. But they use a web service to generate SQL and you have to get an API key for it to work. For now it's free...but looks like a nice trap to lure in users and then when they can't easily get away, the will probably start to charge for the web service or can shut it down any time they want.

So before I just build a custom tailored query form, does such a query builder exist at all?

解决方案

I needed a query builder which generates a nice JSON I could use to create Java POJO and wrote this :
http://mistic100.github.io/jQuery-QueryBuilder

It would be easy to write a parser which create SQL queries.

这篇关于您能否推荐一个JQuery插件来组成一组可映射到SQL查询的条件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！