开源软件名称：

sqlFilter-tool

开源软件地址：

https://gitee.com/egzosn/sqlFilter-tool

开源软件介绍：

sqlFilter

The rapid development of plug-inAccording to certain rules to generate SQL or HQL

page test

<html>  <head>    <title></title>  </head>  <style type="text/css">      .top{          width: 100%;          height: 50px;          text-align: center;      }      .content{          border: 1px solid #666;          width: 100%;          height: 600px;      }  </style>  <body><div class="top">Dynamically generated sql</div> <div class="content">        <div class="column">            <form action="/testServlet" method="post">            name(and ; right like):<input name="QUERY^t#name^!|^RLK"/><br/>            age(and ; >=):<input name="QUERY^t#age^!|^GE"/><br/>            sex(or ; =):<input name="QUERY^t#sex^|^EQ"/><br/>                <input type="submit" value="generated">            </form>        </div> </div>  </body></html>

###Effect of the page

###The results

------? 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 :namekey:sex; value:malekey:name; value:Minna%key:age; value:15