SqlMap2.groovy

import static 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
		""");

		if (isNotEmpty(user.getName())) {
			sql.append("""
				AND  name = :name
			""");
		}
	
		if (isNotEmpty(user.getAddress())) {
			sql.append("""
				AND  address = :address
			""");
		}
		
		return sql.toString();
	}
}