用 Form-Sql-Builder-mysql 将用户提交的表单自动转化成sql

最新推荐文章于 2025-01-09 15:58:50 发布

原创最新推荐文章于 2025-01-09 15:58:50 发布 · 1.7k 阅读

0 ·

CC 4.0 BY-SA版权

java技术专栏收录该内容

63 篇文章

订阅专栏

本文介绍了如何利用 Form-Sql-Builder-mysql 库，根据用户提交的表单数据自动生成相应的SQL语句，包括设置maven依赖、创建规则文件、配置各种查询条件如范围查询、分组、排序和IN查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

用 Form-Sql-Builder-mysql 将用户提交的表单自动转化成sql

maven依赖

<dependency>
  <groupId>org.crazycake</groupId>
  <artifactId>form-sql-builder-mysql</artifactId>
  <version>1.0.0-RELEASE</version>
</dependency>

快速开始

STEP 1. 创建一个规则文件

在classpath下建立一个文件夹叫 formSqlRules ，在这个文件夹下创建global.json

{
	"global":[
		{
			"field":"String:*",
			"op":"like",
			"rel":"and"
		},{
			"field":"*:*",
			"op":"=",
			"rel":"and"
		}
	]
}

STEP 2. 创建一个测试用PO类

public class Person {
	
	private Integer activeStatus;
	private String name;
	private Integer age;
	private String city;
	
	public Person(String name, Integer age, String city, Integer activeStatus){
		this.name = name;
		this.age = age;
		this.city = city;
		this.activeStatus = activeStatus;
	}

	public Integer getActiveStatus() {
		return activeStatus;
	}

	public void setActiveStatus(Integer activeStatus) {
		this.activeStatus = activeStatus;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public Integer getAge() {
		return age;
	}

	public void setAge(Integer age) {
		this.age = age;
	}

	public String getCity() {
		return city;
	}

	public void setCity(String city) {
		this.city = city;
	}
}

STEP 3. 调用 FormSqlBuilder

Person form = new Person("jack", 36, "ny", 1);
FormSqlBuilder b = new FormSqlBuilder(form, "global");
b.addLimit(1, 20);
SqlAndParams s = b.build();
System.out.println(s.getSql());
for(Object v:s.getParams()){
	System.out.println(v);
}

控制台输出

SELECT * FROM person WHERE name like ? AND city like ? AND active_status = ? AND age = ?  LIMIT 0,20
jack
ny
1
36

更具体的关于

参见github官网