A dynamic SQL builder for Java language.
QueryBuilder query = new QueryBuilder().select()
.column("s.name")
.column("count(s.impediments) AS total_impediments")
.from()
.table("sprint s")
.groupBy()
.column("s.name")
.having()
.column("total_impediments > 5")The output is:
SELECT
s.name,
count(s.impediments) AS total_impediemnts
FROM
sprint s
GROUP BY
s.name
HAVING
total_impediemnts > 5DeleteQuery query = new DeleteQuery("account a").addWhere("a.id > 666")
.addWhere("a.creation_date > '2013-01-01'");The output is:
DELETE
FROM
account a
WHERE
a.id > 666
AND a.creation_date > '2013-01-01'UpdateQuery query = new UpdateQuery("employee e").set("e.salary", "50000")
.addWhere("e.age > 40")
.addWhere("e.genre = 'female'");The output is:
UPDATE
employee e
SET
e.salary = '50000'
WHERE
e.age > 40
AND e.genre = 'female'InsertQuery query = new InsertQuery("persons").columns("id", "name", "age")
.values(1, "foo", 30)
.values(2, "bar", 23)
.values(3, "hello", 54)
.values(4, "world", 19);The output is:
INSERT INTO
persons (id, name, age)
VALUES
(1, 'foo', 30),
(2, 'bar', 23),
(3, 'hello', 54),
(4, 'world', 19)To use this library, add this dependency on your pom.xml:
<dependency>
<groupId>com.github.jonathanhds</groupId>
<artifactId>sql-builder</artifactId>
<version>1.1</version>
</dependency>![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot]")
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent