# sqlFilter-tool **Repository Path**: egzosn/sqlFilter-tool ## Basic Information - **Project Name**: sqlFilter-tool - **Description**: According to certain rules to generate SQL or HQL.The rapid development of plug-in - **Primary Language**: Java - **License**: Apache-2.0 - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 11 - **Forks**: 4 - **Created**: 2017-03-10 - **Last Updated**: 2021-07-03 ## Categories & Tags **Categories**: database-dev **Tags**: None ## README # sqlFilter The rapid development of plug-in According to certain rules to generate SQL or HQL ### page test ```html
Dynamically generated sql
name(and ; right like):
age(and ; >=):
sex(or ; =):
``` ###Effect of the page ![image](https://github.com/cnzzs/sqlFilter-tool/blob/master/demo/src/main/resources/pageTest.png?raw=true) ###The results ```html ------? Instead of the form ------ sql: from test t where t.age>= ? or t.sex= ? and t.name like ? P1:15P2:maleP3:Minna% ------The key, the value form ------ sql:from test t where t.age>= :age or t.sex= :sex and t.name like :name key:sex; value:male key:name; value:Minna% key:age; value:15 ```