simple example

SqlMap.groovy

import org.apache.commons.lang.StringUtils

class SqlMap {
	
	public static String buildSelectSql(User user) {
		StringBuilder sql = new StringBuilder();
		sql.append("""
			SELECT name, address
			FROM user
			WHERE 1=1
		""")

		isNotEmpty(user.getName(), sql, """
			AND  name = :name
		""");

		isNotEmpty(user.getAddress(), sql, """
			AND  address = :address
		""");

		return sql.toString();
		
	}

	private static isNotEmpty(String param, StringBuilder sql, String part) {
		if(StringUtils.isNotEmpty(param) {
			sql.append(part);
		}
	}
}